Finance | Project Operations, Human Resources, ...

Difference between Subledger and Ledger balances for Sales tax

(0) Share

Report

Posted on by Emilia_R

140

Dear All,

We have he following scenario:

Invoice with Cash discount has been booked and paid.

Cash discount was used. Parameters are set up in a way to ensure that VAT is reversed on Cash discount.

The following booking is made by the system for the payment, cash discount and VAT reversal:

The VAT code is setup to use UseTax, this is why you can see the VAT booking for both sides.

This is almost correct, the issue is with the VAT amount.

On the GL level it shows and books 215.98 EUR but when you look in to the Posted sales tax the amount is 107.99, exactly the half of it.

Because if this now there is a difference in between the subledger and the ledger balances.

Interestingly only this single invoice payment behaves like this, all other times the payment and the cash discount and the VAT is correctly calculated and booked.

I have tried to recreate this behavior and created the same PO, Invoice, Payment process and now it is done correctly.

However if I undo the settlement of the original invoice and try to book a new payment to it the issue is there again.

Any ideas why this is happening?

Thank you

Emilia

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

André Arnaud de Cal... 301,171 Super User 2025 Season 2 on at

Like (0)

Report

Hi Emilia,

I would suggest to have a look at LCS issue search if there is a known issue. If not, you can create a support incident for Microsoft Support.

PS: What is the correct amount? 215.98 or 107.99?

Was this reply helpful? Yes No
Emilia_R 140 on at

Like (0)

Report

Hi André,

107.99 is the correct amount.

Considering creating a direct correction on the GL accounts on the short term.

Any down sides to it?

The VAT booking is correct, the VAT return and payment calculation/ report is correct as well, only the GL is wrong.

Kind regards,

Emilia

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Emilia,

If you record a similar transaction, do you see the same problem? In other words, can you replicate the issue?

Where and how did you identify and analyze the difference between the general and the subledgers?

What report/inquiry form did you use?

Can you share the transaction origin of the voucher that you shared above?

Many thanks,

Ludwig

Was this reply helpful? Yes No
Emilia_R 140 on at

Like (0)

Report
Hello Ludwig,

I used following reports:

Trial Balance,

Voucher transactions,

Posted sales tax,

Sales tax /Ledger reconciliation

I can`t reproduce the behavior with a new invoice and it`s payment.

However if I undo the settlement of the original invoice (where the problem was there originally) and try to book a new payment to it the issue is there again. Apart from with this single invoice I can`t reproduce the error.

Transaction origin:

This is a vendor invoice payment with cash discount.

Kind regards

Emilia

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Emilia,

Many thanks for the screenprints.

Yet, how can we know that the last one matches the voucher you shared above?

All voucher numbers are blurred :-(

Can you repost those screenposts in a way that we can see at least the last digits of the voucher numbers and also include the transaction and posting type fields?

Many thanks,

Ludwig

Was this reply helpful? Yes No