Kamstrup make operation report for every 3 pcs.(PCB’s) with 500 components on a shop order with lot size 3.000 = 3.000/3*500 =500.000 backflush transactions on one PCB order.
PCB production line: On daily basis 3 lines runs with a speed of 140 pcs per hour = 140*3/3*500 = 70.000 per hour, 24 hours per day = 1.680.000 backflush transactions
First day we had 1.7 mill.
When we run full scale (PCB/EL, Water and Heat/Cooling) approx. 25 lines will be up running.
Three tables that involves:
MPCCOM_ACCOUNTING_TAB (here you will have the transactions times 4 due to nonstandard cost)
INVENTORY_TRANSACTION_COST(here you will have the transactions times 2)
Q1: First of all we need to find out if there are any other IFS customers running production with that many backflush transactions and if that’s a problem other than it takes out some space on the server and the processing of daily finance transactions will take hours.
Q2: How can we fix that ?
Suggested solution (Modification):
When a backflush operation happens and an existing identical inventory transaction exists and if it has not been transferred to finance (Status code != 3) it should just add the transaction to the exiting record.
Example of identical transactions: