Question

Inventory Part in Stock movements vs GL values

  • 19 September 2022
  • 1 reply
  • 178 views

Badge +5

Version: IFS APPS9

Screen:  Inventory > Quantity in Stock > Inventory Part in Stock

Issue: The net change in value on this screen (Qty * Value)  over an accounting period does not match the sum of the value of the MPL vouchers posted during that period.

Has anyone had the same or similar experience?


What is the IFS recommended to best practice to reconcile GL to Inventory subledger ?

 

Naren


1 reply

Userlevel 5
Badge +11

Hi Naren,

Inventory Part in Stock is always showing the actual parts in stock. I would not use it for reconciliation purpose.

I would suggest to use Inventory Value per Period screen.

This one is aggregated by all inventory transactions and fixed for a period. So you can see for each Year Period the valid qty and value of the parts in stock.

To reconcile the value i would add up all M1 Transactions in gl or mpccom_accounting. Besides minor rounding issues the should match.

Kind regards

Ralph

  

Reply