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 :
Microsoft Dynamics GP (Archived)

Commitments for purchase Order

(0) ShareShare
ReportReport
Posted on by

Hello,

Something happen with our system and the commitments disappear, it seen that something was turn of.

since the option Allow Document  commit is gray out.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    28,058 Moderator on at

    Hi Pat,

    Please check the settings under :  Purchasing >> Setup >> Purchase Order Enhancements

    Someone may have unchecked the box 'Activate Commitments'

  • Community Member Profile Picture
    on at

    Is checked, and the Approval as well, I think this is the problem but I am not sure, any suggestion,

    Thank you Beat !!

  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    28,058 Moderator on at

    OK,

    So when you say :

    [quote] ...  and the commitments disappear.. [/quote]

    What do you actually mean ?

    Did you lost the commitment completely or just the fact that some PO's are not showing the committed amounts ?

    Have you tried to run the POE Reconcile ?

    Microsoft Dynamics GP menu >> Maintenance >> Purchase Order Enhancements

    From the user guide :

      1. Select Reconcile and then Process.

    Reconcile compares data in the Purchase Order Approval (POA) or Purchase Order Commitments (POC) tables (or both) to data in the Purchase Order Processing (POP) table and identifies discrepancies.

    Discrepancies are corrected by changing the POA or POC tables (or both) to match the POP table. Lone, or orphan records, found in POA or POC tables are removed. Approvals and authorizations are updated appropriately.

     

    Alternatively, you can try disable both options in the setup and then re-check them.. it's not going to destroy any data, only re-validate the open PO's against the actual budget.

  • Community Member Profile Picture
    on at

    Hi Breat

    Yes, the commitment are gone for 2010,2011 ... but 2017 2018 are there...

    I did run the POE Reconcile and it didn't work, also I notice that the process run faster than before..

    Thanks

  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    28,058 Moderator on at

    It looks like someone wipe out your budgets in GP for the past years.. that's why it's taking much less time to run the POE reconcile..  Or someone recently moved a whole bunch of closed PO's to the historical tables in the POP module..

    Please check both :

    Financial >> Cards >> Financial >> Budgets

    Purchasing >> Inquiry >> Budget vs Actual & Committed

  • Community Member Profile Picture
    on at

    HI Beat,

    The only I can see is the Budget bit not the commit

    How we can solve ... can I bring from the backups

    Which tables are involve so I can see id there is info I can bring in  

    Thank you

  • Verified answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    28,058 Moderator on at

    The table you'd have to check from your backup would be CPO10110 & CPO10111. . There should also be some data in CPO40001 & CPO40002..

    It's been a while I've used it, as we disabled it when we implemented an external requisition system with it's own Budget control.

    EDIT:  below is a table list I found from a reference sheet for the POE. Can't guarantee it's including all..

    CPO10110 CPOP_Line_Ctrl
    CPO10111 CPOP_Alloc_Line_Ctrl
    CPO10113 POE Unposted GL Transaction
    CPO10114 POE Period Actual
    CPO40001 CPOP_Setup_HDR
    CPO40002 CPOP_Setup_LINE
    CPO40003 CPOP_Setup_LINE_TEMP
    CPOP_Exc CPOP_Exceptions_TEMP

    PS: as always, you should take a full backup of your live data before applying anything like partial or full restore, and whenever possible, try this out in a TEST company first to see if the outcome is what you expect.

  • Community Member Profile Picture
    on at

    Beat,

    Yes, I am planning to do it in the test environment, I will keep you posted to let you know.

    Thank you so much!!

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 > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans