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 :
Small and medium business | Business Central, N...
Answered

Purchase order payment tolerance

(0) ShareShare
ReportReport
Posted on by 241

Hello everyone,

We purchase food so the prices are quite variable. My purchase team creates Purchase Orders with one price, they send it to the vendor and the next day when the vendor delivers the price on their receipt dosen't match the one on my purchase order. The price changed suddlendy overnight

Is there a way to create a tolerance where I can put the price on the vendors recepits and the difference with my pruchase order goes to an specific account?

Thanks for the help. 

I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    133 on at

    If you invoice using the receipts then the variance is posted anyway. That’s just how expected and actual costs are managed. Performing your own posting could be viewed as a duplication.

  • Esteban Navarro  Profile Picture
    241 on at

    Hello Josh,

    Thanks for the answer, could you please elaborate a bit more? I'm quite lost with this issue. Some coworkers insist that this can be done since some SAP ERP's have this functionality. But, I´ve never seen this functionality.

    Thanks.

  • Suggested answer
    YUN ZHU Profile Picture
    95,597 Super User 2025 Season 2 on at

    Hi, do you have to record this difference?

    If you don’t need it, you can create a Purchase Quote first, and then convert it to a Purchase Order after the price is confirmed, and then post it.

    Hope this will help.

    Thanks.

    ZHU

  • Suggested answer
    Community Member Profile Picture
    on at

    Esteban,

    Adding to Josh and Yun's replies... If you are trying to track when a PO price changes between PO and Invoice, you can use the Standard Costing Method which will record the Standard Unit Price of the Item and any differences from Standard Price will book to another GL Account (Purchase Price Variance). This is the only want to break out the difference of the change into a separate GL Account.

    Other than above, I can think of creating a field on the Purchase Line called Original Price and then create a Jet Report to show every Posted Purchase Invoice Original Amount vs. Posted Amount.

    Hope this helps.

    Thanks,

    Steve

  • rpdp Profile Picture
    5 on at

    I want to know where to set up a tolerance of like 2% or $100 or any combination to allow my accounts payable person the permission to pay.  

  • Verified answer
    Esteban Navarro  Profile Picture
    241 on at

    Hello rpdp, 

    We had to create a personalization. The user puts the value in a field that according to predifined tolerance get approved or not. The difference is then added, automatically, as a line in the PO that affects a GL account. 

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 > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,917

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,161 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,025 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans