Sales Cash Drawer Balance Report modified to close all batch journals

Batch journals are used in Distribution SX.e to maintain a single GL journal for each post date. These are used for high-volume transactions such as those that are initiated from third-party retail management, shipping, or point of sale (POS) systems. The specific batch name distinguishes the journal from journals opened for typical transaction updates to GL, such as during order entry or cash receipts entry. Normally, these batch journals remain open until a new transaction is created the next day, or if business is closed over a weekend, days later. For some distributors, these open batch journals may cause problems with balancing their control accounts, especially during month end.

The Sales Cash Drawer Balance Report is updated to now close all open batch journals. This report is usually run nightly after all processing is complete. It can also be scheduled to run at month end, to ensure all transactions are posted to the general ledger. These batch journals are closed for these processes:

Receipt of payments through ION API: oeetapi
Cash drawer management by third-party retail management system (such as Infor Rhythm for Commerce): oeedapi
Third-party AR journal transactions: aretapi
Third-party shipping: 3pship

Feature activation

To ensure your batch journals are closed each night, set up the Sales Cash Drawer Balance Report as a stored report to run nightly after all other scheduled processes are complete. To ensure all batch journals are closed before month-end processing, run the Sales Cash Drawer Balance Report as a one-time report.