Purchase Invoice API Issue: Total Amounts Zero with G/L Account

(1) Share

Report

Posted on by BS-27061404-0

Hi Community,

I'm facing an issue while creating a purchase invoice with a G/L Account selected in the purchase invoice line. When I use the GET API for the purchase invoice, the following properties return a value of 0:

totalAmountExcludingTax
totalTaxAmount
totalAmountIncludingTax

Could you please let me know if I need to set up any changes or if there is another way to get the correct values for these properties through the API?

Thank you!

PurchaseInvoiceAP...

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Mohana Yadav 61,208 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Are you using standard API or custom?

I could not see your attachment for some reason, Please paste directly in the chat.

Was this reply helpful? Yes No
Gerardo Rentería Ga... 26,091 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi

Do you have amounts in the document lines?

BR

GR

Was this reply helpful? Yes No
CU25061419-0 on at

Like (1)

Report
Copy link

Link copied!

This value might be calculated at runtime, which is why it is showing up zero.

Can you run RecordName.CalcFields('field name') and see if it populates the value.

Sources: Record.CalcFields(Any [, Any,...]) Method - Business Central | Microsoft Learn

Was this reply helpful? Yes No
BS-27061404-0 7 on at

Like (1)

Report
Copy link

Link copied!

I'm using the standard API: https://{businesscentralPrefix}/api/v2.0/companies({id})/purchaseInvoices({id}).

My purchase invoice line contains values. The API returns the accurate value when the purchase invoice line is an item. However, when the purchase invoice line is a G/L Account, it returns 0.

Was this reply helpful? Yes No