Cost price calculation queue

Cost price calculation queue

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.