I’m looking at the Received - Not Yet Invoiced report for multiple sites, with the current date as the To Date and the Part Type equal to Inventory Part.
Can anyone tell me what would cause the Cost and Value columns to be sourced from the part’s estimated material cost for POs that were created up to a certain date and then to be sourced from the PO buy unit price after that date? I’m working in a customer’s development instance and would like to understand what caused the change.
More than likely the inventory valuation method may have changed midway through receiving these parts, and therefore, the cost is taken from a different place (estimated cost versus PO price).
Alternatively, the cost part rollup may not have been executed, but this will depend on how the part cost is made up - do you have specific details of a part that you can review the above mentioned settings?
Nick - I found a particular part that is a good test. I have receipts for the part before and after the date where the RNYI sourcing appears to change.
Inventory Valuation Method is currently “Standard Cost”
Inventory Value/Unit Cost is currently $0.50
Part Cost/Total Cost is currently $0.00 for all cost sets
There are 7 received not yet invoiced receipts on the report
The RNYI report uses the $0.50 for the first receipts, after that it uses the various buy unit prices on the POs.
In the Inventory Transaction History/Accounting tab, there are PRICEDIFF- (Price Difference - Lower Price) and PRICEDIFF+ (Price Difference - Higher Price) for each receipt where the PO buy unit price differs from the Inventory Value/Unit Cost. Posting Types for those are M10 (Receipt with Purchase Order) and M20 (Price diff Purch, Lower[or Higher] Price).
For the record, I was able to get over my immediate need by incorporating the above accounting transactions into my report code - didn’t mention it, but that’s what I was trying to do, write a report.
So all that is left is my curiosity to understand why the change happened.
Hi
I am facing an issue when I am trying to exlude from the report RNIY some purchase orders that I am not going to receive a invoice from the supplier.
So, I have created a invoice with a price ‘0’ matching those old PO receipts, the difference was posted in Account xxx but the problem is when I have checked the Supplain and Distribution posting analysis several cascade of transactions were created on posting M40, M49,M48,M6 updating the “Applied date” for the invoice date.
How to avoid those unnecessary transactions?Regards
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
