Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

If needed, you can manually allocate specific costs by creating Manual Cost Allocations. You must perform manual cost allocations before you run the period closing process. The accounts involved in manual allocations, will not be processed by the automatic allocations. 

...

If you need to estimate costs during the current month, you can select the Calculate Costs in Credit Notes, or Show Costs in Sales Documents, or both options on the Administration > Settings > Sales form. Then, for particular items listed in a document (Credit Note, Invoice) the average weighted costs will be calculated based on the data available on the date of the document, that is, beginning costs and purchases of this item incurred before the transaction date.

Direct Cost Calculation

The period closing process performs calculation of direct costs if the Calculate Direct Costs option is selected on the Month-End Closing form. The process includes calculation of the average costs for inventory for sale and cost calculation for finished goods produced during this financial period.

Inventory for saleSale

When ordering goods and materials from different suppliers, the company receives the same items with different costs. Sometimes, items are packed differently and measured in different UOMs. The weighted average cost method assigns the same unit cost to items from different supplies, with larger or smaller quantities, with higher or lower prices, and originally measured in different UOMs.

The cost calculation is performed for the base UOM of the item with specific characteristic or included in a specific batch, recorded to a specific GL account, stored in a specific warehouse, owned by specific entity, that is, for a unique set of the following parameters: Item / Characteristic / Batch / Warehouse / Entity.

Using this method, to find the average cost of specific item, you need to calculate the sum of all costs (including the additional expenses) and divide by the quantity of base units available for sale. The weighted average method is also used as a method for inventory valuation, see Inventory Valuation.

Each item with a serial number may have unique cost based on purchase price with additional expenses (if specified so) allocated in the basis invoice and history of transactions.

Once the average cost are calculated, the application adjusts the costs of sold goods for each transaction recorded and posted during the period including customer returns.

Finished Goods

If the Production module is enabled (on the Administration > Settings > Production form), the average costs of finished goods are also calculated. Generally, direct costs of finished goods are recorded by using the following documents:

...