Vendor Invoice Journalize

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi,

When posting vendor invoices , the records in SubledgerJournalAccountEntry table for the PostingType : Sales Tax,Vendor Balance are created two or more times and also these records have different amounts in SubledgerJournalAccountEntryDistribution Table(sum of that does not equals the parent) , anybody know how it was created and is it normal as the posting type SalesTax , Vendor Balance was created multiple times for the same Voucher and also the amounts are not balanced in SubledgerJournalAccountEntryDistribution table

Anyhelp would be appreciated?

*This post is locked for comments

All responses (15)

Answers (0)

André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at

Like (0)

Report

RE: Vendor Invoice Journalize

Hi Vairam,

If you still have an issue you can either debug the scenario if it is a data issue or bug. Or you can contact Microsoft Support.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Vendor Invoice Journalize

Hi Andre,

Now we're on the latest Cummulative Update 13 and the issue still exists.

Please help to find if there are any Hotfixes available.
André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at

Like (0)

Report

RE: Vendor Invoice Journalize

Hi Vairam,

Now, I do understand your issue. Have you checked LCS issue search if there is a known issue and possibly already a hotfix available? Note that CU13 is the latest cumulative update. If there is no hotfix mentioned, you can also test the scenario in the latest available version.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Vendor Invoice Journalize

Hi Andre,

If you run the below query for a negative sales tax used Purchase Order , then you may find that it is not getting balanced,

select sum(sljaed.AccountingCurrencyAmount)

,sum(sljaed.ReportingCurrencyAmount)

from SubledgerJournalEntry slje

join SubledgerJournalAccountEntry sljae

on slje.recid = sljae.subledgerjournalentry

join SubledgerJournalAccountEntryDistribution sljaed

on sljae.recid = sljaed.subledgerjournalaccountentry

where slje.Voucher = 'VOUCHER NUMBER'

When the above results are not equal to 0.00 , then the below method tries to balance it , while we run the reporting currency conversion.

Classes\LedgerCurrencyConversionProvider_FIM\balanceSubledgerJournalAccountEntryDist()

and when it tries to balance it , it picks the Posting Type - "Penny differences in Reporting Currency" in SubledgerJournalAccountEntry table and it joins the child table SubledgerJournalAccountEntryDistribution and tries to update it for the Balancing.

After CU11 upgrade for the certain posting types like (Penny differnces in Accounting Currency,Penny differnces in reporting Currency,Purchase accruals) , the records are not created in SubledgerJournalAccountEntryDistribution and finally i am getting the below error.
André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at

Like (0)

Report

RE: Vendor Invoice Journalize

Hi Vairam,

I did ask several times to explain what you exactly mean with not balancing. Is it the rounding of 0.01 in reporting currency?
Community Member Microsoft Employee on at

Like (0)

Report

RE: Vendor Invoice Journalize

Hi Andre,

AX allows Sales Tax Codes to be negative by default as below,

If i use this in a PO and after invoicing , the AccountingCurrencyAmount and ReportingCurrencyAmount in SubLedgerJournalAccountEntryDistribution table not getting balanced for the Voucher.

Is there any Hotfix available to fix it?
André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at

Like (0)

Report

RE: Vendor Invoice Journalize

Hi Vairam,

Can you share all details from this PO and the Sales tax setup? Why do you have a negative sales tax? What exactly do you mean with imbalance as the screenshots above are balanced. If you have multiple sales tax codes used on a voucher, they will be visible separately in the distributions.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Vendor Invoice Journalize

Hi Ludwig,

I had ran the GL reconciliation reports and it is showing the imbalance that i have mentioned in the Difference column
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Vendor Invoice Journalize

Hello Vairam,

Have you run the GL reconciliation reports for AP-GL, AR-GL, etc. and do they show the imbalance that you mentioned?

Best regards,

Ludwig
Community Member Microsoft Employee on at

Like (0)

Report

RE: Vendor Invoice Journalize

Hi Andre,

This was the posted Sales Tax Transactions for this Voucher,

We have marked one of the Sales tax code '****_12%' to be 'Negative sales tax percentage'.

Our issue is .we have imbalanced distributions in SubledgerJournalAccountEntryDistribution table.