Cost price calculation queue

Cost price calculation queue

Revision History

Abstract

TfmStoreEngineDocumentQueue

When processing documents in the storekeeping system, the total quantities of outgoing stock (stock deducted from store, or 'stock-out') must be fully compensated for by the total quantities of incoming stock (stock-in). The outgoings of a stock item in one document may be compensated for by incomings recorded in one or more stock-in documents.

The cost price of an outgoing stock item equals the sum of the cost prices of items in all stock-in documents used to compensate for the outgoing item.

For example, a production record documents the usage of 1.2 kg of carrots. This was offset by:

  • 0.8 kg of carrots added to the store on a stock-in record at 60p per kilo,

  • 0.4 kg of carrots added to the store on a stocktaking record at 50p per kilo.

The calculated cost price will be:

(0.8*60+0.4*50)/1.2=56.7p

Cost prices are calculated on the basis of documents created in stores within the same store group.

The cost price calculation process can take a long time. The Cost price calculation queue operational report allows you to see how many documents are currently being processed and how many are queued for processing.