Finance | Project Operations, Human Resources, ...

Difference between General Ledger and Posted Withholding Tax Report in GL Module.

(1) Share

Report

Posted on by ERP Doctor

Hi All,

In AX 2012 R3
GL > Inquiries > Tax > "posted withholding tax"

and GL > Reports > Tax > Withhold Trans.

I'm facing a problem, requesting an immediate help.

All Transactions in "Posted Withholding Tax" disappear related to previous financial years, as well as, current financial year remaining only few transactions from January 2020 and February 2020.

If we see Main Account in General Ledger, all transactions are intact there. But not showing in these reports.

Also no transactions in TaxWithholdTrans Table in AOT. Also no data in DB Table.

I have run consistency check with FIX also Reindexing, but, nothing happened.

Please guide.

Best Regards,

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Good Morning Abbas Syed,

Is the 'withhold trans' report a customized report?

I can't see it in my demo environment and would expect that this is not a standard report.

Is that right?

If so, can you talk to your developer who created that report to get it fixed.

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
ERP Doctor 42 on at

Like (0)

Report
Copy link

Link copied!

No, this is not customized report.

This is also available in General Ledger > Inquiries "Posted withholding Tax

Backend table name is Taxwithholdtrans

This is standard report.

I have records in it starting from January 2020 but all records in previous month and years disappear, do not know why.

I have a month old backup on my test server, where i have all records in this table. Worried where they go in my production server.

Pl. help.

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

Like (0)

Report
Copy link

Link copied!

Hi Abbas Syed,

Thanks for this clarification.

I was a bit confused about the abbreviation that you used.

About the records that disappeared: Do you know if somebody did possibly unintentionally some 'clean up' in the withholding tax tables?

AX does not delete records automatically and I was wondering whether somebody cleansed (deleted) the data.

Probably talk to some of your development colleagues if they have some information on this.

Best regards,

Ludwig

Was this reply helpful? Yes No
ERP Doctor 42 on at

Like (0)

Report
Copy link

Link copied!

Hi, Thanks for your reply.

No dear nothing like this happened, we did not applied any customization and cleansing.

I just ran the "Consistency Check" with Fix option. Info log was too long, it was telling some inconsistencies in Bank Vouchers, do you think consistency check can remove these entries ?

There is one thing amazing as well.

I did soft closing, and some Voucher started reflecting in "Posted Withholding Transactions" but not all of them which are also in GL.

In dire need of help, unable to hunt a solution.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Abbas,

I don't think that the consistency check can be responsible for this.

Would recommend the following:

a) If you have some in-house technical experts available, contact them to have a look

b) If you don't have in-house technical experts available then open a support request with MS and emphasize the urgency/importance.

Best regards,

Ludwig

Was this reply helpful? Yes No
Crisztina 5 on at

Like (0)

Report
Copy link

Link copied!

Hi Abbas,

I am facing same problem with the TaxWithHoldTrans table.

Did you find out any reason or solution about it.

Was this reply helpful? Yes No