web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Last Receipt Cost on Item Quantities

(0) ShareShare
ReportReport
Posted on by 460

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?

Categories:
I have the same question (0)
  • Angela Eckman Ebensteiner Profile Picture
    1,216 on at

    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

  • Nancy Cohen Profile Picture
    460 on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 663 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 540 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 348 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans