Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Receivings Transaction Inquiry Zoom - no line item details

(0) ShareShare
ReportReport
Posted on by

Receipt for purchase order not showing line item.  The Receivings Transaction Inquiry Zoom window does not have the line item displayed that was received, but the totals and the distributions are correct.

How does one correct this issue?

pastedimage1627484239021v1.png

Categories:
  • BJ-09051414-0 Profile Picture
    BJ-09051414-0 268 on at
    Receivings Transaction Inquiry Zoom - no line item details
    Hey Mohammed,
     
    The problem is bad data. You will need to review the data to determine where the problem is. Once the problem has been identified, then a solution can be determined.
     
    If you are not familiar with SQL and the SOP/Inventory flow, i would suggest contacting your partner or create a case with Microsoft as the PO will need to be reviewed to determine the problem and solution.
     
    I hope this helps!
     
    Thank you!
     
    Brandon.
    Functional Consultant.
  • CU02070516-0 Profile Picture
    CU02070516-0 4 on at
    Receivings Transaction Inquiry Zoom - no line item details
    Hello,
     
    Does anyone have solution for this fix? Currently I am facing similar issue.
     
    Thanks Mohammed!.
  • Josh Page Profile Picture
    Josh Page on at
    RE: Receivings Transaction Inquiry Zoom - no line item details

    in that case I would recommend opening a case with GP support so they can review in detail. Interruptions involving IV can be a bit tricky.

  • wperkinson3 Profile Picture
    wperkinson3 on at
    RE: Receivings Transaction Inquiry Zoom - no line item details

    Wish checklinks would fix issues like this one.

    I have found that there are records on iv30400 for the item and serial numbers in question.

  • Suggested answer
    Josh Page Profile Picture
    Josh Page on at
    RE: Receivings Transaction Inquiry Zoom - no line item details

    Looks like there was most likely an interruption then. The reason its not showing any lines is because there are no lines to show. If you need assistance in reviewing in detail I would recommend opening a support case to see where the IV\GL sides are at in regards to the document.

  • wperkinson3 Profile Picture
    wperkinson3 on at
    RE: Receivings Transaction Inquiry Zoom - no line item details

    Thank you for the response.  Using your query, only one record is found on the POP30300.  No records found on other tables.

  • Suggested answer
    Josh Page Profile Picture
    Josh Page on at
    RE: Receivings Transaction Inquiry Zoom - no line item details

    Try running the below script. Do you see any results in the POP10310 or POP30310? You noted it was received so you should see the header for the record in the POP30300 and the lines in the POP30310. If the records are "mixed" between work and history than you most likely had an interruption and I would reach out to MS support for assistance.

    declare @POPRCTNM char(17)

    select @POPRCTNM = 'RCT0161772'

    print 'POP10300 - Purchasing Receipt Work'

    select * from POP10300 where POPRCTNM = @POPRCTNM

    print 'POP10310 - Purchasing Receipt Line'

    select * from POP10310 where POPRCTNM = @POPRCTNM

    print 'POP30300 - Purchasing Receipt History'

    select * from POP30300 where POPRCTNM = @POPRCTNM

    print 'POP30310 - Purchasing Receipt Line History'

    select * from POP30310 where POPRCTNM = @POPRCTNM

    Thanks!

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,883 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,569 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans