Small and medium business | Business Central, N...

Incorrect purchase price posted in G/L entries

(6) Share

Report

Posted on by CU01070853-1

Hi all,

Has anyone came across below cases?

Item A cost £10, Purchase invoice amount £15

In the environment A, the payable account is posted at £10, not £15.

However, in another environment, the payable account is posted at £15 which makes sense to me.

Anyone know which configuration makes these difference?

Hence, there are two fields in the item card. Are they related? Both fields are disabled in the item card in the environment B, but are enabled in the environment A.

I'm wondering if they are relevant to above invoice amount difference, however, I can change the parameter in the item card directly. I also don't find the configuration in Inventory Setup.

Have anyone have any idea?

Categories:

Dynamics 365 Business Central

Microsoft Dynamics NAV

I have the same question (0)

All responses (7)

Answers (0)

Greg Kujawa 696 on at

Like (0)

Report
Copy link

Link copied!

For the item that appears to have these options grayed out, what is the Costing Method defined on the Item Card?

Was this reply helpful? Yes No
TAHER Mehdi 431 on at

Like (1)

Report
Copy link

Link copied!

The behavior you’re seeing, where the payable account posts either at item cost (£10) or invoice amount (£15): is driven by Business Central’s costing and posting setup, not those two fields on the Item Card.

Was this reply helpful? Yes No
TAHER Mehdi 431 on at

Like (1)

Report
Copy link

Link copied!
I think the difference comes from two fields “Expected Cost Posting” and “Automatic Cost Posting” settings in Inventory Setup they handle how the purchase invoice is posted:

If Automatic Cost Posting = ON, the system posts cost adjustments automatically to G/L or it is OFF cost adjustments are not posted automatically, so the payable may reflect item cost rather than invoice amount until you run Adjust Cost – Item Entries and Post Inventory Cost to G/L.

If Expected Cost Posting = ON, expected costs are posted at receipt and adjusted later.

Was this reply helpful? Yes No
TAHER Mehdi 431 on at

Like (1)

Report
Copy link

Link copied!
About two fields from your screenshot on item card:

Cost is Adjusted

Indicates whether the item’s cost has been adjusted by the Adjust Cost – Item Entries batch job. This ensures actual cost reflects purchase price, freight, etc.

Cost is Posted to G/L

Indicates whether the cost has been posted to the General Ledger. This is controlled by the Automatic Cost Posting setting in Inventory Setup.

And those two fields are status indicators, not configuration switches. They show what has happened, not what will happen. You cannot toggle them manually—they’re updated by system processes.

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 6,978 on at

Like (1)

Report
Copy link

Link copied!

Hello ,

The difference (£10 vs £15 posted to Payables) is not caused by the Item Card fields (“Cost is Adjusted” / “Cost is Posted to G/L”)—those are read-only system indicators. The real cause is Expected Cost Posting and the posting flow. In the environment posting £10, BC is using expected cost logic (receipt at £10, invoice difference treated as variance and adjusted later). In the environment posting £15, the full invoice amount is posted directly to Payables (most common setup). Check Inventory Setup → Expected Cost Posting to G/L, General Posting Setup, and whether invoices are posted from receipts or directly—that’s what drives the difference.

Regards,

Oussama

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 96,032 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi, Perhaps the settings are different in these two environments?

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Dhiren Nagar 405 on at

Like (0)

Report
Copy link

Link copied!

Hi,

If you are posting Purchase Invoice, by payable account you mean your vendor/creditor ledger as well as Payables Account general ledger.

Well it has nothing to do with costing, costing handles Item posting not the vendor posting. I don't know why everyone here is talking about Item and Inventory setup and so on.

Just check both the Invoice, Amount, Line Amount and Total Amt Incl VAT field in both the Purchase Invoices.

Probably this is because you entered wrong unit amount or there is taxes added in one and not in other.

Check the Invoice and not Item or Inventory setup. You will find your answer.

Regards,

Dhiren.

Was this reply helpful? Yes No