Select this to maintain the integrity of data held in your Inventory module.

You use the Balance function to perform the following tasks:

Select this to perform the final month end of the year and start a new financial year in the Inventory module.

	If your inventory files are shared and you are not in the shared company, then you cannot run the year end function.

Select this to reset journal, GIT in transit and stock take confirmation flags.

Refer to the Reset options section for details.

Select this to review lot quantity adjustments recommended by the system, before allowing the system to update your live system.

Typically, when you run the Balance function and discrepancies are detected between quantities across lots, warehouses, multiple bins or FIFO buckets, the lot quantities are assumed to be correct and the other records are adjusted accordingly.

This function, however, enables you to view a report of the proposed changes before actually implementing them.

Select this to locate the earliest Inventory and GRN journals that have not been posted.

The Inventory GL Integration program creates and/or posts General Ledger journals from Inventory transaction journals according to your General Ledger Integration settings. The Inventory GL Integration program uses the lowest unprocessed Inventory journal number as a starting point to create/post these General Ledger journals.

Similarly, the GRN GL Integration program creates and/or posts General Ledger journals from GRN transaction journals according to your General Ledger Integration settings. The GRN GL Integration program uses the lowest unprocessed GRN journal number as a starting point to create/post these General Ledger journals.

Selecting this option therefore ensures that no Inventory and/or GRN journals are skipped when the General Ledger journals are created/posted for Inventory and GRNs.

This option is only available when you select to process a Balance function.

	This function can also be performed using the GL Integration Utility program.

Select this to restore in-process journals to a status that enables you to print them.

You typically use this function if a power failure occurred during the processing of your inventory journals. This would cause the journals to be placed in an in-process status(*) and prevent you from printing them. The Reset in-process journals function effectively resets these in-process journals to a status of 0, allowing you to print them.

This is automatically done as part of the Balance function and is therefore not available when you select to process a Balance function.

Select this to reset Goods in Transit flags.

If the GIT Structure Change flag is set to 'P' (in process), then it is reset to 'Y' (structure validation required).

If your inventory is shared (Company Maintenance - Options tab), then this flag is only checked when the Inventory Period End program is run from the company that owns the inventory table/files.

This is automatically done as part of the Balance function and is therefore not available when you select to process a Balance function.

The stock take confirmation in process flag is set when the Stock Take Confirmation program is used to confirm a stock take for a warehouse. This prevents multiple operators simultaneously confirming a stock take for the same warehouse. If the Stock Take Confirmation program is not successfully completed, it is possible that this flag is not reset. This prevents various other stock take functions from being performed for the warehouse.

This is automatically done as part of the Balance function and is therefore not available when you select to process a Balance function.

Select this to recalculate FIFO costs. The cost is recalculated by taking the total value of stock at FIFO value and dividing this by the total quantity. The result is used to update the Unit cost field on the stock warehouse record. This does not affect the General Ledger.

Select this option only if you indicated that FIFO costing is required in at least one warehouse (Inventory Setup or Browse on Warehouses) and the option: Recalculate current cost from FIFO buckets (Inventory Setup) is selected. If you only selected the option: FIFO valuation (Inventory Setup), but no warehouse is set to use FIFO costing, then selecting this option does nothing.

	You need to select this option before switching from FIFO to average costing (Inventory Setup).

This option only affects the value of the current cost field on the inventory warehouse record (UnitCost on InvWarehouse) for a warehouse with FIFO costing.

The unit cost field on the warehouse where FIFO costing is in use is the average cost (i.e. it is calculated for a FIFO warehouse as if the warehouse was using average costing). It is recalculated each time a receipt is processed for an item, but not when the item is issued.

The value of the inventory is based on the FIFO buckets, not the current unit cost held in the warehouse. If you want to get an indication of the value of the warehouse from the unit cost, then you need to select this option. This option allows you to recalculate the unit cost field on the warehouse based on the actual buckets you have in your FIFO warehouse.

For example:

Unit cost is calculated using the average costing method.

Say you have the following quantities on hand at the unit costs shown:

1 at 10 = 10

2 at 15 = 30

3 at 16 = 48

Total FIFO cost is 88 and quantity 6. Therefore the average cost is 14.66667.

You sell 2, so you now have:

1 at 15 = 15

3 at 16 = 48

Average cost is not recalculated on a sale or issue, so you now have a total cost of 63 for 4 items, with an average of 15.75.

Therefore, your average cost in the warehouse does not reflect the average of the actual FIFO buckets you have. To adjust this, you select this option to recalculate your warehouse cost based on buckets.

You cannot select this option if you are denied access to the activity: Inventory recalc current cost (FIFO) (Operator Maintenance).

Select this to recalculate the warehouse cost for each actual costing item by adding up all FIFO costs and dividing by the quantity on hand in the warehouse. The result is used to update the Unit cost field on the stock warehouse record. This does not affect the General Ledger.

This option only applies if you are using Actual costing (Inventory Setup - General tab) and works in a similar fashion to the Recalc. current cost from FIFO buckets option. It therefore only affects the value of the current cost field on the inventory warehouse record (UnitCost on InvWarehouse) for a stock item which uses Actual costing.

Select this to recalculate and adjust the actual cost bucket original receipt quantities for all Adjustment transactions previously processed in the Inventory Movements program.

Select this to delete bins containing a zero quantity.

A bin is only removed if the bin quantity was zero for the past three months. The warehouse default bins created by the system are never removed.

You can only access this field if the option: Multiple bins in use is selected against the warehouse(s) selected (Browse on Warehouses).

This option is never enabled when you select the Balance function.

Select this to delete temporary stock codes that meet all criteria for deletion (see Purge).

This option is only enabled when you select the Purge function.

This option is available only if the full goods in transit system is installed (Inventory Setup and you are running a Balance function.

This enables you to indicate whether to include the goods in transit details in the balancing routine.

Selecting this resets GIT transactions which are flagged as being In process and ensures they are displayed in the Inventory Movements program. This is useful if an operator experienced a system problem whilst processing a GIT and the GIT is still flagged as being 'In process.'

This option is selected automatically when running the month end or year end functions, but is deselected automatically if you also select the Ignore balance function option.

Select this to bypass the balance function that is normally run when performing a month end or year end.

When you select this option, the Balance goods in transit option is deselected automatically.

	Because the balance function is used to correct an out-of-balance condition detected by the system, bypassing this function may result in inaccurate inventory values being printed on the month end and year end reports.

This only applies if you selected the option: Ignore balance function.

Select this to not calculate the inventory value and hash quantity for each warehouse you selected to process.

Selecting this option reduces the time to process the month or year end, but the warehouse totals are not printed on the report.

Refer to Purge for additional information.