What happens when a pending transaction is created (Costing)
Symptom Quantity moved into inventory via job transaction, production schedule complete transaction or JIT transaction at zero cost.
Symptom PS Finish, JIT Finish or Job Finish transaction with a Quantity larger than zero but with a Unit Cost and Total Posted equal to zero on a material transaction report.
Symptom When you post a job transaction which moves pieces to inventory and a pending transaction is generated due to an error, what happens in terms of quantities and costs.
Solution ID = KB-706
Goal : What happens when a pending transaction is created (Costing)
Version = All Version
Module : SLMFG
Fact 1 : SFC
Fact 2 : Costing
Symptom 1 : Pending Job Labor Transactions
Symptom 2 : Pending Job Material Transactions
Database : Progress, SQL
Fix
If you have a situation where an item was moved into inventory via a job transaction, production schedule complete transaction or JIT transaction at zero cost and the supporting cost data appears to be in order, it may relate to pending transactions being created when the item was moved into inventory. The symptom will be a PS Finish, JIT Finish or Job Finish transaction with a Quantity larger than zero but with a Unit Cost and Total Posted equal to zero on a material transaction report.This can happen anytime you post a transaction which moves pieces into inventory and which backflushes material. If an error is encountered when the system is trying to backflush a material, the system creates a pending material transaction and a pending job labor transaction which is really more of a pending job completion transaction since there actually was not a labor problem.
In that case, the quantity of parent item is still moved into inventory. However, none of the costing logic is executed for the parent. It moves the quantity into the stock location and creates a material transaction for the quantity but leaves the costs zero. It does not create any journal entries increasing inventory and decreasing WIP. Nor does it decrease the work center WIP buckets in the case of a JIT or PS complete transaction. Also, if the source was a job transaction for an actual costed item, it also does not recalculate the average for an average costed item, update the location cost if Specific, or create the stack record is the item is LIFO or FIFO.
When you then correct and post the pending material and labor transactions, the costing catches up with the quantity. The material transaction cost fields are updated, the work center or job WIP buckets are decreased and the appropriate move-to-inventory journal transactions are created. For actual costed items, it also does the average cost calculation, updates location costs or creates the itemlifo records depending on the method.
Therefore, if you receive a message that a pending transaction was created at the end of the job transaction posting process, it is critical that you correct and post them as soon as possible. This is especially the case if the item is actual costed since the quantity which went into inventory at zero cost may end being shipped or issued to another job at zero cost. If the pending transactions are then posted, the costs will not catch up with the item but rather will be written off to inventory adjustment.
