Finance | Project Operations, Human Resources, ...

Supplier Ledger - Transactions list versus Invoice List

(0) Share

Report

Posted on by Reign

200

Dear Dynamics Community:

I searched for a voucher and invoice number inside the supplier ledger. Apparently, for the same voucher & invoice number, I get different amounts when using all Transaction list versus Invoice list

I searched for this voucher and invoice using Transaction list and the amount shown is 69,563.16. I clicked Voucher and entries are shown which also captures both 69,536.16 and 118,452.00.

I also searched for the same voucher and invoice number using the Invoices list but the amount shown is 118,452.00. This amount is shown in the voucher entries in the above screen capture. When Voucher is clicked, no entries is shown. These entries can be shown through View Accounting only.

Though when I view this voucher/invoice on the journal where it was recorded/posted, only the amount of 69,536.16 is shown and not this amount.

There is a settlement amount matched to this voucher 69,536 as shown below

I just wish to know possible issues that caused this and how it can be corrected.

Thanks,

Reign

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

saurabh bharti 15,039 Moderator on at

Like (1)

Report

Hi Reign,

Please see my analysis for this voucher:

So , vendor has different balance because it is excluding some amount from total invoice amount which has to be paid , that amount is nothing but Tax amount.

Was this reply helpful? Yes No
Reign 200 on at

Like (0)

Report

Thank you very much Saurabh for sharing your analysis. The tax amount is based on the current setup but I also see some suspicious lines which I still dont understand how it came about? I tried to reverse this transaction but that option is grey-off in the option. Any idea how to reverse this? Should I create a GJ to reverse every line entry here then recreate this entry?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Hello Reign,

In your first screenprint I see an amount of 118452 posted with the posting type supplier balance.

Your second screenprint shows the same amount for this posting type except for the 0.01 ct difference.

This seems to be ok to me.

Do you know what this 69536 has been posted for?

Is this a prepayment or an old credit note that has been applied or something alike?

Best regards,

Ludwig

Was this reply helpful? Yes No
Reign 200 on at

Like (0)

Report

Hi Ludwig / Saurabh

I just want to share and seek your confirmation related to this issue.

I have a PO line which was linked to 'P-Dom' VAT Group. and the item used in this PO is linked to Item'Electric' VAT Group'. When this PO was invoiced, the invoice journal was linked to VAT Group P_Dom and Item VAT Group is 'Item'. So I can see 3 VAT groups used in PO and the invoice of this PO. I remembered the rule for VAT Group and Item VAT group, that it will get the common vat codes and apply the common code in the transaction. Apparently upon checking the amount that is causing an issue here is a result of double taxes calculated, P_Electric and P_ElecVAT was calculated 2 times. Sharing the setup below. I hope you can confirm if this finding could be the cause of the issue.

So I would like to confirm if on my PO line, the vat groups used are:

VAT Group - P-Dom and Item VAT Group: Electric. Here are the VAT codes inside these VAT groups

And on the Invoice Journal matched to this PO. The VAT groups used are: VAT Group: P_Dom and Item VAT group: Item. Here are the VAT codes inside Item vat group

Given the above setup, will the amount on my PO gets calculated with tax 2 times?

P_Dom VAT code appears in 'P_Dom' VAT Group and 'Electric' Item VAT group and 'Item' Item VAT Group

P_Electric VAT code appears in 'P_Dom' VAT Group and 'Electric' Item VAT Group

P_ElecVAT VAT code appears in 'P_Dom' VAT Group and 'Electric' Item VAT Group

Was this reply helpful? Yes No