Inventory Transactions by Account

Form ID: (IN403000)

Note:

This form is available only if the Inventory feature is enabled on the Enable/Disable Features (CS100000) form.

On this form, you can view detailed information about a selected account within a selected period, including the account balance and all related transactions.

Form Toolbar

The form toolbar includes standard and form-specific buttons and commands. For the list of standard buttons, see Form Toolbar and More Menu. The form-specific commands are listed in the following table.


Button	Description
Inventory Summary	Navigates to the Inventory Summary (IN401000) form, from which you can view the availability data of the inventory item.
Allocation Details	Navigates to the Inventory Allocation Details (IN402000) form, from which you can view information about how the selected inventory item is currently distributed among warehouses and locations.

Selection Area

By using the elements in this area, you can view in the table the data that is most relevant to your information needs.

Table 1. Selection Elements
Element	Description
Company/Branch	The company, branch, or company group for which you want to view information. By default, the current company or branch is selected. You can select another branch, company, or company group to which you have access. This setting is required if the Multiple Base Currencies feature is enabled on the Enable/Disable Features (CS100000) form.
Inventory Account	The inventory account for which you want to view the posted inventory transactions.
Subaccount	The subaccount for which you want to view the posted inventory transactions.
Period	The financial period for which you want to view the posted inventory transactions.
By Financial Period	A check box that you select to view the inventory transactions grouped by financial period. Selection of the check box disables boxes in the Date Range section.
Inventory ID	The inventory item for which data will be displayed.
Warehouse	The warehouse for which data will be displayed. This box appears only if the Multiple Warehouses feature is enabled on the Enable/Disable Features (CS100000) form.

Table 2. Date Range SectionBoxes in the section are available for editing if the By Financial Period check box is cleared.
Element	Description
Start Date	The start date of the date range for the inventory transactions to be displayed.
End Date	The end date of the date range for the inventory transactions to be displayed.
Summary By Day	A check box that you select to display only summary values for each day in the table. Clear this check box to display detailed information for each day within the selected period.
Period Start Date	A read-only value displaying the start date of the selected financial period.
Period End Date	A read-only value that shows the end date of the selected financial period.

Table

In this area, you can view the details of transactions that meet the criteria you have specified in the Selection area.

Table 3. Table Columns
Column	Description
Account	The account used to post the inventory transaction.
Subaccount	The subaccount used to post the inventory transaction.
Tran. Type	The inventory transaction type, which can be a transaction type related to an inventory operation (Receipt, Issue, Transfer, or Adjustment) or a transaction type (such as Invoice, Credit Memo, or Return) used in another system module if the account was shared by both that module and the Inventory module.
Reference Nbr.	The reference number of the transaction.
Inventory ID	The inventory item used in this inventory transaction.
Cost Subitem	The subitem of the inventory item if item cost is split by subitem segment values. This column is available only if the Inventory Subitems feature is enabled on the Enable/Disable Features (CS100000) form. Important: The Inventory Subitems check box has been removed from the Enable/Disable Features (CS100000) form because the functionality associated with the Inventory Subitems feature will be phased out. If you have this feature enabled in your system, the associated functionality remains available. To disable the feature, contact your MYOB support provider.
Warehouse	The warehouse where the transaction was performed. This column appears only if the Multiple Warehouses feature is enabled on the Enable/Disable Features (CS100000) form.
Location (if costed)	The location where the transaction was performed; here you can select only locations with the Cost Separately check box selected on the Locations Table tab of the Warehouses (IN204000) form. This column appears only if the Multiple Warehouse Locations feature is enabled on the Enable/Disable Features (CS100000) form.
Cost Adjustment	A read-only check box which (if selected) indicates that cost adjustment was generated for the transaction.
Date	The transaction date.
Beginning Balance	The account beginning balance (before the transaction). The column is hidden if the By Financial Period check box in the selection area is cleared.
Debit	The debit amount related to the transaction.
Credit	The credit amount related to the transaction.
Ending Balance	The account's ending balance (after the transaction). The column is hidden if the By Financial Period check box in the selection area is cleared.
Fin. Period	The financial period to which the transaction was posted.
Tran. Period	The financial period when the transaction was created.
Qty.	The quantity of the inventory item involved in the transaction.
Unit Cost	The unit cost of the inventory item used in this transaction.
Description	The transaction description.
SO Order Type	The type of order for items sold or to be sold.
SO Order Nbr.	The number of the sales order for items sold or to be sold.
PO Receipt Nbr.	The number of the purchase receipt for items purchased.