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.

All responses (4)

Answers (0)

BS-27061404-0 7 on at

Like (1)

Report

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

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.
CU25061419-0 on at

Like (1)

Report

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

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
Gerardo Rentería Ga... 20,638 Most Valuable Professional on at

Like (0)

Report

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

Hi

Do you have amounts in the document lines?

BR

GR
Mohana Yadav 60,244 Super User 2025 Season 1 on at

Like (0)

Report

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

Are you using standard API or custom?

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