IM2700 Inventory Management Set Trx Audit File Beginning Balances
Set Trx Audit File Beginning Balances
Application Overview
The Set Trx Audit File Beg. Balances application should be run at the very end of every period to set a beginning balance for all stocked items for the next period. This balance will be printed when the Inventory Trx Audit Trail Report is run and will provide a starting point from which to measure all transactions for that period. The beginning balance will be set to the current quantity on-hand for all locations where the item is stocked.
Note: This application will only be used if I/M is set up for batch type inventory transaction processing. For the system to allow access to this application, the Online Update Inventory Trx? flag must be set to N and the Audit Trail On Inv Transaction ? flag must be set to Y in I/M Setup.
Depending on the size of inventory transaction audit trail database, running this application can take significantly amount of time (like over an hour on very large database.) So it had been asked if this step is necessary. In our opinion, I would say this is in an “Elective” category. When you want to run a inventory trx audit trail report starting from say 05/01/18 to 5/31/18. In order for the report to give you the beginning balance of quantity for each item on 5/1/18 to show on this report, you will need this step to create that “beginning balance” record. Some people don’t care about this, then they don’t need to run this procedure. If you like to see the beginning balance quantity when run this report, then you should run this function.
Also, if this report is taking a long time to run, you should consider running in on the PSQL server directly.
Run Instructions
Select Set Trx Audit File Beg. Balances from the pull down I/M Processing window. The following screen will then be displayed:
Set Trx Audit File Beg. Balances Entry Screen
The following options are available:
- Select the desired mode from the Set Trx Audit File Beg. Balances menu bar.
- Enter the data requested on the screen.
To return to the menu bar, press the ESC or F10 key. To leave this application, press X for EXIT when positioned at the menu bar.
Entry Field Descriptions
Name | Type and Description |
Previous Beginning Balance Date | A date in the standard date format. Display only. |
Enter Beginning Balance Date | A date in the standard date format. Enter the date on which the beginning balance should be set. Normally it should be the first day of the new period. |
Set Trx Audit File Beg. Balances
Related Articles
Feature - Added Report to "Set TRX Audit File Beginning Balances"
Release date: 8/27/2018 We have added a report to the "Set TRX Audit File Beginning Balances" application under I/M -> Processing. This function used to be a processing-only application. By making this process also a report, users now have the ...ARSETBAL Accounts Receivable Set Customer Account Balances
Set Customer Account Balances Application Overview Part of bringing the Accounts Receivable package up to its full capability when you first receive it is the process of loading the A/R Open Item File with the initial contents of your customers' ...IM04S2 Inventory Management Inventory Transaction Audit Report
Inventory Transaction Audit Trail Report Application Overview The Inventory Transaction Audit Trail Report provides a complete history of transactions affecting on-hand levels of an item or range of items. The report is generated two different ways ...AP01S4 Accounts Payable Vendor Audit Trail Report
Vendor Audit Trail Report Application Overview The Vendor Audit Trail Report shows any additions, changes, and deletions made to the Vendor File. When you are in A/P Setup, you can choose to keep an "audit trail" on the Vendor File. Additions to the ...AP0100 Accounts Payable Vendor File Maintenance
Maintenance Vendor File Maintenance Application Overview The Vendor File is used to store information on all companies and individuals from whom materials, supplies, and services are purchased. This application allows entry of information into this ...