Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / PO Receiving Transact...
Microsoft Dynamics GP (Archived)

PO Receiving Transaction Entry - All lines have been received

(0) ShareShare
ReportReport
Posted on by Syrus 4,156

Hello,

A Question

I had a user who was in the middle of receiving PO and GP 2013 system crashed. Assuming it would have been rolled back; the user logs back in and go to receive the PO again and get the message " All lines have been received".

Looking at the PO shows nothing received and status of PO is Released.

While looking into the POP10500, shows a receipt # which does not exist in GP and status is still ZERO but qty. shipped shows data.

I have tried to reconcile the PO but nothing happens.

Any quick tip ?

Regards,

 

 

*This post is locked for comments

  • Suggested answer
    Syrus Profile Picture
    Syrus 4,156 on at
    RE: PO Receiving Transaction Entry - All lines have been received

    Wonderful, it worked and I never thought of it. I appreciate the help and Tips provided by all you folks and thankful.

    Every bit of tip was very helpful.

    Regards

  • Suggested answer
    Thomas Newcomb Profile Picture
    Thomas Newcomb 1,810 on at
    RE: PO Receiving Transaction Entry - All lines have been received

    Hi Syed!

    As you see the a receipt number in the POP10500 try to open the document by manually entering the Receipt number into the Receivings Transactions window, does it allow you to pull it up?

    If it does not allow you to pull up the damaged transaction you may want to submit a case with us here at Microsoft Dynamics GP Support as there could be damaged or stuck records in different POP Tables.

    If you are able to access the damaged transaction you might be able to delete it from the front end of Dynamics GP in which you should be able to receive the purchase order again.

    Hope this helps!

    ~Thomas Newcomb

    ------------------------------------------

    Microsoft Dynamics GP Support

    ------------------------------------------

    This posting is provided "AS IS" with no warranties, and confers no rights

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: PO Receiving Transaction Entry - All lines have been received

    Syed,

    Lyn's advice is really good advice. I would suggest following it. If check links does not fix the status after you've followed Lyn's steps, I have attached some queries you can use to identify the problem and resolve it, using SQL should this prove necessary. As Lyn stated, make sure you have a backup prior to making changes to your database.

    DECLARE @PONumber as VARCHAR(15)
    SET @PONumber = 'XXXX'

    select
    POH.PONUMBER,
    CASE POH.POSTATUS
    WHEN 1 THEN 'New'
    WHEN 2 ThEN 'Released'
    WHEN 3 THEN 'Change Order'
    WHEN 4 THEN 'Received'
    WHEN 5 THEN 'Closed'
    WHEN 6 THEN 'Cancelled'
    ELSE 'ERROR'
    END PO_Status,
    POL.LineNumber,
    CASE POL.POLNESTA
    WHEN 1 THEN 'New'
    WHEN 2 THEN 'Released'
    WHEN 3 THEN 'Change Order'
    WHEN 4 THEN 'Received'
    WHEN 5 THEN 'Closed'
    When 6 THEN 'Cancelled'
    ELSE 'ERROR'
    END PO_Line_Status,
    POH.VENDORID Vendor_ID,
    POH.VENDNAME Vendor_Name,
    POL.ITEMNMBR Item_Number,
    POL.ITEMDESC Item_Description,
    * from POP10100 POH
    Inner Join POP10110 POL on POH.PONUMBER = POL.PONUMBER
    WHERE POH.PONUMBER = @PONumber

    /* Run these queries only to change the PO Header and PO Line Status back to Released
    Change 'XXXX' to the target PO Number prior to running these queries */
    --Update POP10100 set POSTATUS = '2' WHERE PONUMBER = 'XXXX'
    --Update POP10110 set POLNESTA = '2' WHERE PONUMBER = 'XXXX'

  • Syrus Profile Picture
    Syrus 4,156 on at
    RE: PO Receiving Transaction Entry - All lines have been received

    Thanks Lyn,

    I will try that.

    Regards,

  • Lyn Barr Profile Picture
    Lyn Barr on at
    RE: PO Receiving Transaction Entry - All lines have been received

    Did you try Check Links?  Try that first:  Microsoft Dynamics GP >> Maintenance >> Check Links.  Change the series to Purchasing and then select the Purchasing Transactions table, click Insert and then click OK to process.  You can also just insert ALL tables and run check links on the whole series.

    If that doesn't work, I would make a backup of your database, or you can just backup the POP10500:  select * into POP10500_Backup20141104 from POP10500

    Next, delete the specific record in the POP10500:  delete POP10500 where POPRCTNM='xxx'

    Note, replace the 'xxx' with the actual receipt number.  

    Finally, try the Check Links a second time to be sure the deleted record doesn't cause any problems, and then try to receive your PO.

    Good luck, I hope this helps.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans