All inventory transactions are stored in the Inventory transactions file. The Inventory transactions enquiry allows you to view all transactions and to narrow down to display detailed information about, for example, an inventory event or a specific item. If an inventory event is linked to an accounting transaction, you will be able to view the details for that inventory transaction per accounting period.
- Select the Inventory transactions enquiry menu item.
- You access Inventory transaction enquiry, Selections, which is the first of three panels allowing you to define your selections and sequencing parameters. (Click Next to access the additional selection and sequencing panels). The last template you used will be the one defaulted if you are re-entering this program. If this is the first time you are accessing the program, the common system template will be displayed, meaning there are different values for sequencing and selecting on this panel than a user-defined template. Enter the applicable template in the Template field and click OK.
- You remain on the Inventory transaction enquiry, Selections panel, listing the values retrieved from the entered template.
- You access the next Inventory transaction enquiry panel, listing all transactions that have been selected, sorted in ascending order.
- You access the next Inventory transaction enquiry panel, displaying the details of the selected inventory transaction. The following fields are of interest for this particular example:
- Inventory event
- The inventory event that affected the cost value, which created a G/L posting in DC1 Financials.
- Transaction type
- The transaction type of the event.
- Accounting period
- The accounting period in which the inventory transaction was posted in the G/L.
- Cost value
- The total cost value of the inventory transaction retrieved to DC1 Financials.
- You access the second Inventory transaction enquiry detail panel. The following fields are of interest for this particular example:
- Stock acc trans type
- The transaction type that updated the relevant stock account in the G/L.
- Reconciliation ref
- The reconciliation reference number that points to the transaction created in the G/L for this inventory transaction.
You can add, change or delete selection and sequence values. (Click Next to access the additional selection and sequencing panels). If you want to save your changes, click Save as template. You are also able to add new or change existing templates by clicking Maintain template.
Note: You can click Print to print the transactions that you have entered in the selection without viewing them first.
Click OK.
Tip: Click Shift info to switch between viewing different information for the records.
Tip: Click More selections to change your selections or add more parameters.
Select the applicable record and click Display.
Click Next to view additional information.
Exit the routine.