Microsoft Dynamics AX (Archived)

How to calculate LedgerJournalTrans GSt Tax line Information

(0) Share

Report

Posted on by AX 2012 r3

2,426

Good morning,

i am trying to print GST Tax information for Payment Voucher .

I have placed one button on Accounts Payable --> Payment Journal --> Lines --> Action Pane -->GST Payment Voucher.

The tax is available on same form(LedgerJournalTransVendPaym).By clicking TaxDocument Button in Top.

7510.Tax.png

then

1643.tax1.png

this form has temporary table.

Please tell me how can i print rate and amount in my report.

Please help me.

Regards.

Have a great day.

*This post is locked for comments

I have the same question (0)

All responses (16)

Answers (2)

AX 2012 r3 2,426 on at

Like (0)

Report

RE: How to calculate LedgerJournalTrans GSt Tax line Information

Please give some suggestions

Was this reply helpful? Yes No
André Arnaud de Cal... 299,407 Super User 2025 Season 2 on at

Like (0)

Report

RE: How to calculate LedgerJournalTrans GSt Tax line Information

Hi AX 2012 r3,

You are not very patient when you post a question on the community. It is run by volunteers, mainly also having their own work to do. Sending private messages will also not help in responding earlier.

I'm not sure if I can be of great help as I'm not aware of the Indian GST regulations. What report are you referring to? Potentially you could call the same logic used on the forms you provided to fill the data provider with the correct GST data?

Was this reply helpful? Yes No
AX 2012 r3 2,426 on at

Like (0)

Report

RE: How to calculate LedgerJournalTrans GSt Tax line Information

Hi Andre,

I am going to print Payment Voucher report.(New Customized report)

Accounts Payable --> Payment Journal --> Lines (I added one button to get args values)

i got perfect journal number and voucher .

I am not getting how tax is calculated for this journal numbers.

Please do some help.

i have already searched in TaxTrans and TaxTrans_IN.there is no data stored.

Can you please share table names those are involved while posting Payment Journals.

Regards.

Have a great day Andre.

Was this reply helpful? Yes No
André Arnaud de Cal... 299,407 Super User 2025 Season 2 on at

Like (0)

Report

RE: How to calculate LedgerJournalTrans GSt Tax line Information

Hi,

Unfortunately I cannot help you with the table names or x++ logic. As said above, I'm not familiar with the Indian GST. The form you shared above is part of the Indian localization.

You can have a look at the Tax document form how standard AX is collecting the data. You could use that as an example.

Was this reply helpful? Yes No
AX 2012 r3 2,426 on at

Like (0)

Report

RE: How to calculate LedgerJournalTrans GSt Tax line Information

Hi Andre,

Thankyou for the reply.

Atleast you gave reply.

No one in this forum is giving replies.

I will Search more and will update soon.

Thankyou

Was this reply helpful? Yes No
Vilmos Kintera 46,149 on at

Like (1)

Report

RE: How to calculate LedgerJournalTrans GSt Tax line Information

I have checked your recent topics and I can see helpful replies in all of them, not exactly sure what is the complaint about above.

You just simply cannot have expectations that we as volunteers are here to resolve your issues immediately and do all work instead of you, as it has been pointed out by André as well.

This is especially true when it is about a topic with which we are not familiar with at all - namely Indian GST localization.

You may be in a better position to resolve this issue than us, since we neither have the code, nor the knowledge about the legal requirements and the functionality behind the localization.

You at least have the code, and know what you expect as an outcome from a functional side. Combining these two with the tools available in AX should help you reveal what you want:

- checking the properties of the form control which you want details for

- reading the code behind the controls' datasource/methods/menuitems' classes

- using the debugger to actually trace the code execution

- checking the cross-references which shows us all places where a specific table record is being generated or value is assigned

If you are not familiar with using the tools and methods above, the best course of action is to read up about them in the freely available documentation, purchase some books to deepen your knowledge, finally attend some class-room courses where you may get additional experience on how to resolve more advanced issues.

Was this reply helpful? Yes No
AX 2012 r3 2,426 on at

Like (0)

Report

RE: How to calculate LedgerJournalTrans GSt Tax line Information

Thank you so much vilmos for your detailed reply,

I will update this post very soon.

Was this reply helpful? Yes No
Verified answer

AX 2012 r3 2,426 on at

Like (0)

Report

RE: How to calculate LedgerJournalTrans GSt Tax line Information

I said i will Update.Here i am.

I found the solution.No need to break your heads by debugging.

the solution is.

1.Take LedgerJournalTransRecid.

2.Filter in table - TaxDocumentRowTransaction.TransactionRecid(this field is in status No for Visible.Change it to yes and Filter)

3.Take TaxDocumentRowTransaction.recid

4.Filter in TaxDocumentComponentTransaction.Taxdocumentrowtransactionrecid.

Here in this table after filter see fields( TaxDocumentComponentTransaction)

1.TaxRate

2.TaxBaseAmount

3.TaxAmount.

Thats it.

No need of Advance Training to do this.

Just Searching in right way will do.

Regards.

Have a great day.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: How to calculate LedgerJournalTrans GSt Tax line Information

I have an error "account number for transaction type GST does not exist" can you please advice which set up I am missing, I did set up GL accounts in General ledger>set up> India > tax set up

Was this reply helpful? Yes No
AX 2012 r3 2,426 on at

Like (0)

Report

RE: How to calculate LedgerJournalTrans GSt Tax line Information

I am extremely Sorry.

I am technical Consultant .

i will ask functional guy and update you very soon bro.

Thanks.

Was this reply helpful? Yes No