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

How to post a journal entry with VAT (taxCode) settings different than the default (via the API)

(0) Share

Report

Posted on by SteveMet

We use the API (v2) to export journal lines to Business Central.

When we post an entry we don't have all the features like when we enter manualy a line, especially concerning taxes.

We only have a field "taxCode". But the system ignores what is set in this field and when we edit the journal on Business Central, it seems settings are still the default for the account.

Does someone has any idea how to correct this behaviour ?

Have a nice day

Steve

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Marco Mels Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello,

Best probably is to post your JSON so anyone can take a look.

Thank you.

Was this reply helpful? Yes No
SteveMet 15 on at

Like (0)

Report
Copy link

Link copied!
POST {{baseUrl}}companies({{companyId}})/journals({{journalId}})/journalLines { "accountNumber": "3203", "postingDate": "2022-10-12", "documentNumber": "1234", "amount": 1300, "description": "test", "comment" : "test comment", "taxCode" : "NORMAL" }

this works to post a new line in a journal. But in the documentation it seems there is no way to fill these fields in

in the documentation, these fields don't seem to appear :

journalLine resource type - Business Central | Microsoft Learn

Seems that these fields are set directly from the config of each account.

Was this reply helpful? Yes No
Suggested answer

Marco Mels Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello,

At my side it works fine:

api.businesscentral.dynamics.com/.../{{TENANTAADID}}/{{PRODUCTION}}/api/v2.0/companies({{COMPANY}})/journals({{JournalID}})/journalLines

{

  "Description": "Test1",

  "accountNumber" "10000",

  "taxCode": "FULL RED"

}

This is tested in BC21 SaaS. What release are you testing with?

Thanks.

Was this reply helpful? Yes No
SteveMet 15 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the suggestion, unfortunately, how to specify "VAT Bus. Posting Group", if we can only set "taxCode", which I guess is "VAT Prod. Posting Group". Here is the table of my customer (VAT posting setup) :

if I post "NORMAL" in the taxcode, how or where to post "NATIONAL" or "EXPORT" ?

Was this reply helpful? Yes No
SteveMet 15 on at

Like (0)

Report
Copy link

Link copied!

I use BC online, I don't know where to find the version ? I tried to find "version" in the search menu, without success.

Was this reply helpful? Yes No
Suggested answer

Marco Mels Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hello,

Thank you for the message. Now I see what you mean. The field taxCode is linked to VAT Prod. Posting Group. You want to populate data in field VAT Bus. Posting Group. I assume that these have been been populated in the API, so you need to create a custom API for t his where you expose these yourself.

Hope it helps.

Was this reply helpful? Yes No
SteveMet 15 on at

Like (0)

Report
Copy link

Link copied!

thanks for the answer...

I am little bit disappointed that the standard API doesn't allow to post standard bookkeeping entries :(

Was this reply helpful? Yes No
Suggested answer

Marco Mels Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello,

You can of course raise a feature suggestion via https://aka.ms/bcideas . We are open for suggestion. Also you can verify what is exposed out of the box and what has not been exposed yet via:

api.businesscentral.dynamics.com/.../$metadata

Hope at least this helps.

Was this reply helpful? Yes No