As per Inventory Value Per period , there are 2 units and value against a part in last period against a site; However; as per Inventory Part stock , there is not stock in hand and no transaction after the period; Aggregate inventory Trans per period was run upto last period. What could be reason for difference/mismatch and any solution is appreciated.
Go to Inventory Transactions History and search for the part number in that site. Review the transactions and you will see the progression of the part.
Inventory Part in Stock is the current state of inventory in actual locations, there can only be value against the part if it is in stock. If not in stock, the value will show as zero.
Inventory Value Per Period will show the accumulation of what happened in the past and can and will show a value for a part whether it is in stock now or not.
Inventory transaction history is the detail for everything that has occurred and is not dependent on running a separate aggregation to get the summary information. It is the step by step detail that feeds into the ledger, to inventory, to/from orders, and to/from projects.
Hi, As per Inventory transaction History , Units to be Nil ie +5 -5 units; also Nil in Inv part in stock in; but Inventory value per period shows yet 2 unit;
HI
Have you check whether all the inventory transactions considered for ‘Aggregate Inventory transactions’ process. You can check this from ‘Inventory transaction history’ window. Refer below screen preview for easy reference.
If it is considered, above 2 fields should have ‘Y’. Also, please check the applied date for all inventory transactions related to mentioned part.
Best Regards
Narmada
all items for "Incl Part Aggr per Period"’ & "’Incl Value Aggr per Period"’ are "Y", applied date are also before statistic period
Hi
You may go to transaction detail for each inventory transaction for the selected part and check whether there are any transactions posted on different voucher period. (Eg: Automatic Revaluation Adjustment)
If you still couldn’t find a clue it is better to create a support case to IFS team.
Best Regards
Narmada
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.