Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

Receivings Transaction Inquiry Zoom - no line item details

Posted on by 727

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 133 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 727 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 727 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!

Helpful resources

Quick Links

First Dynamics 365 Community Call (CRM Edition)

Don't miss the first D365 Community Call on 7/10!

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 286,384 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,485 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans