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