Print Inventory Balance Listing Tab

This section includes the fields and descriptions for the Print Inventory Balance Listing Tab.

Period Island

Field Description
Month/Yr. Here you specify the month and year of the inventory list. Months are specified by numbers (from “1” to “12”). The inventory value is calculated for the last day of the given period.

Selection Criteria Island

Field Description
Warehouse Here you select one of your warehouses. The printout will only include the specified warehouse.
Company No. In this field, you can enter a range of company numbers. The printout will only include warehouses assigned to companies within the specified range.
Item No. Here you specify a range of item numbers. The inventory list will only include items within the specified range.
Item Group In this field, you can select an item group. The inventory list will then only include items belonging to the specified group.
Item Type In this field, you can select an item type. The inventory list will then only include items of this type.
Statistics 1-4 In these fields, you can specify a range of statistics codes. The inventory list will then only include items with statistic codes within the specified range.

Print Control Island

Field Description
Inventory Method Here you select the inventory method. You can select between the following five: “Average Cost,” “Last Cost,” Standard Cost,” “Item Cost” and “Lowest Cost.” “Item Cost” is the only calculation method which produces the same inventory value as the current value recorded in the G/L module.

If you select “Average Cost,” Maconomy uses the average cost in the individual warehouses for every item, regardless of whether some items are priced according to other methods.

If you select “Last Cost,” Maconomy uses the last cost in the individual warehouses for each item, regardless of whether some items are priced according to other methods.

If you select “Standard Cost,” Maconomy uses the standard cost in the individual warehouses for each item, regardless of whether some items are priced according to other methods.

If you select “Item Cost,” Maconomy uses the current cost in the individual warehouses for each item.

If you select “Lowest Cost,” Maconomy uses the lowest of the three costs recorded for each item in the warehouse in question. For items with a costing method different from FIFO, the lowest among “Standard,” “Average,” and “Last” will be used. For items with the FIFO costing method, the cost of the oldest batch will also be included in the evaluation of the lowest cost.

Layout In this field, you can select which layout to use for the printout. If no additional layouts for the current printout have been added in the window Print Layout in the Set-Up module, “Standard” is the only option.
Include Items not in Stock Here you can specify whether to include items with zero physical inventory. If you leave the field blank, you only include items with a positive stock. And if you mark the field “Incl. Items with Negative Stock,” you also include items with a negative stock.
Incl. Items with Negative Stock Here you can specify whether you wish to include any negative stocks in the inventory count. Unless otherwise specified for the warehouse in question, Maconomy allows a negative item stock if you carry out direct invoicing in the Sales Orders or the Item Purchase modules, despite the fact that the registered current stock is not adequately large to match the invoiced quantity. In certain situations, it may be essential to include such negative stocks to generate an inventory value which is as correct as possible. It is possible to reconcile the inventory with the equivalent inventory account in the G/L module provided that negative stocks are included in the inventory count.
Show FIFO Batches This field applies to items with the FIFO costing method. You can thus indicate whether you wish to include information about the item batches making up the inventory.