1
Customer requires to upload future dated transactions using DMF for BAI2 bank statements (Using records with Found type = V - Value dated).
Currently when a payment is setup for a future date (i.e. 7/31/2021) but submitted today (i.e. 7/22/2021), the bank will return that record in today's BAI2 file (7/22/2021) but the payment is not reflected in the ending balance. The balance will not reflect the transaction until 7/31/2021 when it clears the bank. When the BAI2 is uploaded to D365, the transaction appears in 7/22/2021 with a date of 7/31/2021
Actual results:
1. Ending balance does not match the net transactions
2. The transaction date (7/31/2021) is outside of the Bank Statement date range (7/22/2021).
Expected results:
1. The balance should match the net transaction.
2. Allow the transaction date and the bank statement date range to be within range.
Currently when a payment is setup for a future date (i.e. 7/31/2021) but submitted today (i.e. 7/22/2021), the bank will return that record in today's BAI2 file (7/22/2021) but the payment is not reflected in the ending balance. The balance will not reflect the transaction until 7/31/2021 when it clears the bank. When the BAI2 is uploaded to D365, the transaction appears in 7/22/2021 with a date of 7/31/2021
Actual results:
1. Ending balance does not match the net transactions
2. The transaction date (7/31/2021) is outside of the Bank Statement date range (7/22/2021).
Expected results:
1. The balance should match the net transaction.
2. Allow the transaction date and the bank statement date range to be within range.
STATUS DETAILS
Declined