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)

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

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... 25,236 Most Valuable Professional on at

Like (0)

Report

Hi

Do you have amounts in the document lines?

BR

GR

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

Like (1)

Report

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

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