Applies to Product - Dynamics 365 Supply Chain Management
What’s happening?
The customer is experiencing an issue where the financial dimensions from the source line document are not being appended to the base account in the TMS Freight Reconciliation Reason code setup table. This results in only the Main Account being included in the Accounts Payable (AP) Journal when matching freight bills and using Reconciliation Reason codes.
Reason:
The underlying cause of this is that the system allows defining the Reconciliation Reason Codes with the entire General Ledger (GL) account string, which includes the Main Account and all financial dimensions. This violates the structure defined by the accounting team, as the financial dimensions should be determined by the source document lines, similar to the logic used for Charges Codes.
Resolution:
- Follow the Microsoft guide for the setup of Charges Codes and Reconciliation Reason Codes to ensure that only the Main Account is defined in the setup tables.
- Ensure that all financial dimensions are sourced from the relevant source documents, such as Purchase Orders (PO) or Sales Orders (SO), rather than being manually defined in the Reconciliation Reason Code entries.