v7 FreeBalance Help

Field

Description

ID

Unique Code that identifies the Inventory Transaction. This is automatically populated by the system.

Reference Document

Reference to the document ID from the original transaction. It can be a Goods Received/Return Notes, Dispatch Order, Transfer, and Adjustment.

Transaction Type

This attribute can take one of the following values, these are Transfer, Dispatch Order, Goods/Services Received/Returned Note, Warehouse Returned Note, and Adjustment.

Item

The value for this attribute are copied from the attribute titled Catalogue Item from the Inventory Item screen.

Warehouse

The value for this attribute are copied from the attribute titled Warehouse from the Inventory Item screen.

Inventory Item

Reference to the Inventory Item.

Quantity In

Copied from the 'Quantity' attribute on the 'Reference Document' related to the Inventory Item. This field is mandatory when the attribute titled 'Quantity Out' does not have a value.

Quantity Out

Copied from the ‘Quantity’ attribute on the 'Reference Document' related to the Inventory Item. This field is mandatory when the attribute titled 'Quantity In' does not have a value.

Unit Cost

Copied from the ‘Unit Cost’ attribute on the 'Reference Document' related to the Inventory Item

Quantity Available

System calculation. Default value is the same as the attribute titled ‘Quantity In’ or the attribute titled ‘Quantity Out’ and it is updated every time that an Inventory Transaction with the attribute titled ‘Quantity Out’ has been registered (in the Inventory Transaction Screen). Mandatory when there is a value in the attribute titled ‘Quantity In’ and when the attribute titled ‘Inventory Item Costing Method’ is set to be either ‘FIFO’ or ‘LIFO’ in the Inventory Item screen

Total Amount

This field is a system calculation. It uses the following two formulas depending on the situation 1) If there is a value in the attribute titled ‘Quantity In’ Quantity in Value X Unit Cost Value and 2) If there is a value in the attribute titled ‘Quantity Out’ Quantity out Value X Unit Cost Value.

AVG Cost After Transaction

Copied from the attribute titled 'Average Unit Cost' from the Inventory Item screen. It is referenced after the process of updating the Inventory Item has been performed and only when the attribute titled ‘Inventory Item Costing Method’ is set equal to ‘Weight Average’.

Qty on Hand before Transaction

The value for this field is copied from the attribute titled 'Quantity On Hand' from the Inventory Item screen. It represents the quantity on hand before the process of Updating the Inventory Item has been performed.

Transaction Details Tab

Applicable when this is an 'OUT' transaction and Catalogue Item Costing Method is 'FIFO' or 'LIFO'. This collection is populated by the system automatically.

Perishable Lot Tab

Collection of zero or more Inventory Transaction Perishable Lots. Applicable when Inventory Item requires Lot Management. This is a copy of the Perishable Lot Quantity specified in the Detail Transaction Entity.