We have a client running Sage 300 Cloud and they are experiencing imbalance aged payable with GL
Any guide on how to get it resolved would be highly appreciated.
Regards.
We have a client running Sage 300 Cloud and they are experiencing imbalance aged payable with GL
Any guide on how to get it resolved would be highly appreciated.
Regards.
1. Ensure the report is running with a Fiscal Year / Period cut off
2. Ensure that all G/L batches are posted
3. Review transaction detail for the control account(s) and period and ensure that source codes are as expected (ie. AP-IN, AP-PY etc - there shouldn't be transactions from other modules)
4. Review the A/P Account Sets to determine if pre-payments are mapped to the A/P control or not - run the aged payables accordingly
The above are the "easy" items to assist in reconciling. Beyond that, you enter the realm of looking for deleted G/L batches, G/L batches being modified to post to a different period etc.
*Community Hub is the new name for Sage City