Skip to main content
Question

Inventory Part in Stock movements vs GL values

  • September 19, 2022
  • 1 reply
  • 243 views

Forum|alt.badge.img+7

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

Ralph Gericke
Hero (Employee)
Forum|alt.badge.img+11
  • Hero (Employee)
  • 201 replies
  • September 19, 2022

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings