Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Unapproval of already ...
Microsoft Dynamics GP (Archived)

Unapproval of already approved purchase orders

(0) ShareShare
ReportReport
Posted on by albeck 75

Hello,

I'm having an issue with purchased orders being unapproved by the system in the following three scenarios:

  1. PO already approved but rendered unapproved because some items were received on it
  2. PO rendered by the system 'unapproved' because one item was received on it
  3. All items were received on PO using shipment only, at the point of enter match, the system said the invoicing cannot be done on an unapproved purchase order.  Unlike the others, I am not able to re-approve the po because it is already shipped.

We are using Dynamics GP2010

Any assistance given would be appreciated.

Thanks

 

 

*This post is locked for comments

  • George_YYC Profile Picture
    George_YYC 175 on at
    RE: Unapproval of already approved purchase orders

    Hello,

    I ran a wide open trace.    However, if you want to trace certain tables only this might provide you some insight.

    2803 RPC Completed 8/11/2016 2:01:28 PM.610 exec DYNAMICS.dbo.zDP_POA40002SS_1 'user 1234',1  
    2804 RPC Completed 8/11/2016 2:01:28 PM.614 declare @p1 int set @p1=51 exec sp_prepexec @p1 output,N'@P1 smallint,@P2 numeric(19, 5),@P3 char(16),@P4 datetime,@P5 datetime,@P6 smallint,@P7 numeric(19, 5),@P8 char(16),@P9 datetime,@P10 datetime,@P11 char(18)',N'BEGIN UPDATE API.dbo.POA40003 SET POA_PO_Approval_Status = @P1, REMSUBTO = @P2, POA_Approved_By = @P3, APPRVLDT = @P4, POA_Approval_Time = @P5 WHERE POA_PO_Approval_Status = @P6 AND REMSUBTO = @P7 AND POA_Approved_By = @P8 AND APPRVLDT = @P9 AND POA_Approval_Time = @P10 AND PONUMBER = @P11 SELECT @@rowcount END ',1,9999.00000,'                 ','1900-01-01 00:00:00','1900-01-01 00:00:00',9,99900.00000,'user1234           ','2016-07-06 00:00:00','1900-01-01 20:33:52','PO01xxxx         ' select @p1
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Unapproval of already approved purchase orders

    just wondering, which data table you trace to find such an account?

  • Suggested answer
    George_YYC Profile Picture
    George_YYC 175 on at
    RE: Unapproval of already approved purchase orders

    Okay, when I re-created the user that was deleted, we don't have the problem any more.  Hope this helps anyone else with the same issue.

  • George_YYC Profile Picture
    George_YYC 175 on at
    RE: Unapproval of already approved purchase orders

    Hello,

    I ran a few SQL Traces, and for some reason the PO that flips to unapproved is being associated with a user who is no longer in GP.  Their profile has been deleted.  I recreated their profile and I'm going to test again to see if this problem still exists.  Stay tuned!

  • George_YYC Profile Picture
    George_YYC 175 on at
    RE: Unapproval of already approved purchase orders

    Nothing yet - unfortunately I haven't had the bandwidth.  Are you experiencing the same issue?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Unapproval of already approved purchase orders

    Thank you George,

    were you able to come up with some clues?

  • George_YYC Profile Picture
    George_YYC 175 on at
    RE: Unapproval of already approved purchase orders

    Hello,


    I know this post is old, but we are having a similar problem.  It appears that when Purchase Orders are appended, the entire PO becomes unapproved.  I'm running a few SQL traces to find some clues.  I'll let everyone know what I come up with, hopefully something... :)

  • albeck Profile Picture
    albeck 75 on at
    Re: Unapproval of already approved purchase orders

    Hi Tracey,

    Thanks for your response to my query and I apologise for just getting back to you.

    Here's what I've done so far:

    1. Installed GP on a test server

    2. Replicated all three transactions.  

    One and 2 did not give me the reported issues.  I went back to the production machine and replicated the transactions in Fabrikam.  Again the first two transaction did not present the issues.  I therefore regard them as solved

    However, transaction 3 presented the issue initially on my test server using LESSONUSER1.  I went into Fabrikam on the production server and got the issue. I then decided to give the user elevated rights (power user) but they still had no PO approval amount assigned.  The transaction went through ok on both systems.

    I therefore suspect that the issue has to do with the users' access rights in PO, Shipment or Enter/Match.  I will examine the rights assigned  to the users in those areas.

    Regards

    Albert

  • TSteere Profile Picture
    TSteere on at
    Re: Unapproval of already approved purchase orders

    Hi,

    I am currently running SP3 for GP2010  with sa set to unlimited. I have tested all three scenarios above (on the Fabrikam company) from what I understand from your descriptions and was unable to get any of the Purchase Orders to become unapproved.  

    I have checked our database and have found that there is only one BUG due for SP4 release in regards to the Purchase Order Approvals and it is to do with partial receipts. Here is how you would replicate the issue for this BUG.

    "1. Log in as 'sa'. sa is set to unlimited approval

    2. Create PO for 10 qty of 128 SDRAM and SAVE.

    3. Bring PO back up in PO Entry and change to status Approved as the sa user.  Click Save.

    4. Call the PO back up in PO Entry.  Go to Actions – Receive PO Items – Receive and Post a quantity of 3 of the original 10.

    5. Check the PO "

    Regarding your scenarios could you let me know what Service Pack you are on please and maybe selecting one of the above and  list for me the repro steps for me. Things to note is one person doing all of the PO approval and receipts or are there different people involved? can you replicate this on the test company Fabrikam?

    The Purchase Order will become unapproved if you change any of the details on the Purchase Order after Approval, for example the quantity of a line.

    I look forward to your reply.

    Kind Regards

    Tracy

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans