You’re offline. This is a read only version of the page.
450
Does anyone know why the last receipt cost would not be recorded if the last receipt date and last receipt quantity were. And is it expected that the last receipt information should be recorded on the Overall (record type 1) row of item quantities as well as the appropriate site row?
Thank you Angela, your questions prompted me to look in the right place. The field we were looking at was on the Item Quantities smartlist I did assume the column was on the Item Quantity Master but it is not, it is on the Vendor Item Master IV00103 and is only linked to info for the primary vendor which is the issue sometimes, also it is only the cost of the invoice that gets recorded not the shipment so that accounts for other times the cost is 0. It is misleading for the user looking at the smartlist because the Last RCPT Date and Quantity are both there and come directly from the Item Quantity Master. Again thank you for taking the time to respond which helped me figure it out.
Hi Nancy,
Sounds like you are asking about specific fields maybe in the IV00102 table. Is that correct?
- Last Receipt date and Last receipt quantity
And wondering why last receipt cost would not be recorded if the other two fields were.
You are also wondering If you would expect the overall record (RCRDYTPE value of 1) to to be updated if one of the site (RCRDYTPE value of 2) would have been updated. Typically yes if a site gets updated then the overall site gets updated too. I don't know if that's for all fields, but many of them yes.
As far as the Last receipt cost - do you see that in the same table? I guess I'm not seeing that specific field so not 100% sure if that specific field you mentioned is triggered by that?
Could you give me an example of what type of transaction you do that would affect receipt cost and exactly what field in the front end you are talking about. Also - Do you enter transactions through POs/receipts? Inventory adjustment, boms?? I'll do a little testing and verify for you, but I'd like to test based on how you process your transactions.
Warmest Regards,
Angela Ebensteiner
Microsoft Support
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (