Use the inventory transaction report function to report on IVTRANS and IVTRANS_HIST entries. These transaction entries are automatically generated whenever the user makes a change to the inventory systems. The IVTRANS records are posted the the general ledger system for accounting purposes. The inventory ledger is a control ledger meaning that the general ledger stock on hand must equal to the stock revaluation report therefore the user must not journal to the stock on hand ledger.
Enter the first date for the report. The Start date is the date added for most report except for the the movement report where the start date is the REC_DATE in the warehouse trans file. The start date is optional except for the movement report. If not entered then the start date will be ignored.
Similar to the start date rule except this is the last date for the report. The finish date is optional except for the movement report. If not entered then the finish date will be ignored.
Press the drop down or enter a number from 1 to 12. The period is optional
Press the drop down to further select the transactions for those inventory items matching the source code selected.
Press the drop down to change the default sort by from the Entry No to the sort option selected.
Press the drop down to restrict the report to the department selected. If no department is selected then all department transactions will be included in the report.
When pressing a transaction type the report options not required will be disabled. Each of the transaction type report is detailed as follows:
oReceiving are Transaction type "R" and include Purchase order receipts for I type purchase order line items
oMovements are all Transaction types ad are sorted by item No. The start date and end date are required for this report. Each item movement is totaled for the dates selected.
oRevaluation are Transaction type "U"
oTransfers are Transaction type "A"
oStock Take are Transaction type "S" and include warehouse qty on hand changes resulting from stock takes or cycle counts.
oItem are Transaction type "A"
oWO are Transaction type "W" and include inventory transfers to and from the job costing system via a work order.
oWarehouse Movements include transactions details from the warehouse trans file. These transactions are those displayed in the warehouse inquiry movement table.
Select This Month if the report is for the current month otherwise the report will be from the history file.
Select to output option required.Email CSV will automatically attach the CSV file to an email.