Problem: In Invoice and Adjustment Maintenance (BI.BAM.00) the ending date has to be entered one day later than the transaction date for the items to be loaded. Example: To load detail with a date of 11/30/2021, the end date has to be entered as 12/1/2021.
Cause: Probably a customization that is creating pjtran records with a transaction date/time, instead of just a date and no time. Example: Dymamics SL screens and processes might create a pjtran record with a trans_date of 11/30/2021 00:00:00, while the custom process is creating a record with a trans_date of 11/30/2021 08:32:00. The stored proc that populates the grid with detail is looking for records where the source transaction date is less than or equal to 11/30/2021 00:00:00 and so the transaction that includes a ‘time’ is later than that and is not pulled into the grid.
Resolution: Correct the custom process so that transactions are created with a blank ‘time’ portion of the trans_date, or enter the next day as the cutoff date (12/1/2021) in this example, to pull in all transactions that are less than or equal to 12/1/2021 00:00:00.