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.
- 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.