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

General Ledger Entries change when posting in UK company

(0) Share

Report

Posted on by Jonathon Minard

We're writing an integration between GP and BC. It uses BC's API, but I'm able to recreate the issue we're running into in BC's UI as well.

Before posting a general ledger in BC, it can look like this:

And then when previewing posting, the G/L entries can look like this:

Why is this happening?

I take it that at least part of it is VAT related, but we really don't want this to be happening. We want the accounts to be credited and debited in the exact way that's entered on the unposted general ledger, since that's what happened in GP. Is there anyway to bypass these modifications?

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Tech-Lucky 1,288 Moderator on at

Like (0)

Report
Copy link

Link copied!

This looks like a setup issue usually this does not happen in BC You need the help of a functional consultant who can guide you where you have applied a wrong setup related to the G/L Account and its Posting Setups.

Was this reply helpful? Yes No
Suggested answer

Gavin 2,510 on at

Like (0)

Report
Copy link

Link copied!

Hi,

By the looks of things the lines of the journal are calculating VAT.

To correct the journal you'll need to blank the "Gen. Posting Type" and "VAT Bus. Posting Group" and "VAT Prod Posting Group" on each line. (you may need to add some of those columns using personalisation). This will stop the lines calculating VAT.

If you dont want VAT on a General Journal going forwards then switch off the "Copy VAT Setup to Gen. Lines" on the Batch Header.

Untick the option "Copy VAT Setup to Gen. Lines"

Hope this helps.

Thanks

Gavin

Was this reply helpful? Yes No