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...

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 53 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
gdrenteria 12,167 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 59,137 Super User 2024 Season 2 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.