Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Floating amount w/o re...
Microsoft Dynamics GP (Archived)

Floating amount w/o reference trx

(0) ShareShare
ReportReport
Posted on by pjpam 85

Hi Everyone,

We have a floating amount that should be zeroed out in its corresponding account. We have checked with the Committed Detail Inquiry and it shows no data. Also we have checked with floating POs using a Smartlist with Purchase Line Items and also shows no data. We have executed every script/SP reflected in SQL Profiler but same results. Any idea on how to go about this issue will be much appreciated. Attached are the screenshots reflecting the Budget vs. Actual and Committed Inquiry, Committed Detail Inquiry and Purchase Line Items Smartlist. Thank You.

28501.1.png8666.2.png6840.3.png3113.4.png

*This post is locked for comments

  • pjpam Profile Picture
    pjpam 85 on at
    RE: Floating amount w/o reference trx

    Hi Beat,

    You just saved me hours on this! I appreciate your input. It certainly did the trick! Thanks again :) 

  • Verified answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    RE: Floating amount w/o reference trx

    Hi PJPAM,

    it looks like you have the POE Commitment enabled in GP... There is  POE reconcile future in Purchasing that should take care of your issue.. We've run into this several times in the past when using POE.. we've got rid of it by using an external procurement system as this was not reliable. We had to schedule the POE reconcile at least once a week.


    PS; Here is the paragraph from the POE Help :

    Maintaining purchase order commitments data

    Occasionally, hardware failures, power surges, and other problems can damage or destroy your data. To minimize the risk of data loss resulting from table damage, back up your accounting data regularly. If approvals or commitments data is damaged, you can use the PO Enhancements Maintenance window to reconcile data in the purchase order commitments and purchase order approvals tables.

    To maintain purchase order commitments data:

    1. Create a backup copy of your data.
    2. Open the PO Enhancements Maintenance window.
      (Microsoft Dynamics GP menu >> Maintenance >> Purchase Order Enhancements)
    3. 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.

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

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans