D365 F&O GST Report

(0) Share

Report

Posted on by Biren

Hi All,

Could you please help to locate data source of the 'GST transaction - detail'.

I want to know where I can find GST transaction detail DATA in the Data Entity so that I can bring into Azure DB for further analysis and reporting.

Regards,

Birendra

I have the same question (0)

All responses (7)

Answers (2)

Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Birendra,

I believe that the taxtrans table will give you the data you are looking for to execute a deeper analysis and probably create a new form/report.

Best regards,

Ludwig

Was this reply helpful? Yes No
Verified answer

saurabh bharti 15,045 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Birendra,

As far as my knowledge goes, there is no data entity for GST transactions but there are few inquires available in Tax module which might help you.

Tax > Inquires > Tax document transactions or Tax component transactions

Yes, all this information gets stored in "GST Tax transaction" table.

Was this reply helpful? Yes No
Biren 50 on at

Like (0)

Report
Copy link

Link copied!

Hi Ludwig,

Thank you but this table don't give Vendor/Customer detail and there ABN Detail. I can do create similar report from GeneralJournalAccountEntryStaging Data Entity but I don't have Vendor/Customer Detail. Is there anyway to link with vendor/customer table?

Regards,

Birendra

Was this reply helpful? Yes No
Suggested answer

ZvikaR 184 on at

Like (0)

Report
Copy link

Link copied!

what do you mean by ABN detail?

The table Dr Ludwig mentioned has reference to the posted voucher and through that link you can find a connection to vendor/customer account, if such connection exists.

Note that not all posted GST transactions are always linked to a specific customer/vendor.

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

Like (0)

Report
Copy link

Link copied!

Good Morning Birendra,

Can you list us the data that you want to see in your report and possibly provide a drafted sample?

Otherwise, we might never end up with a good result here because you might always find something that is missing.

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
Biren 50 on at

Like (0)

Report
Copy link

Link copied!

Hi Ludwig,

Thanks for your response. Please see below screenshot of the report. I believe this report is the combination of the VendTrans, TaxTrans, Vendor tables. I don't see any data entity equivalent. This is the report generated from D365 F&O but I want this in the tabular format for the analysis.

Was this reply helpful? Yes No
Simone@Apollo 25 on at

Like (0)

Report
Copy link

Link copied!

Hi Biren

Did you work out how to do this as i am trying to do the same?

Was this reply helpful? Yes No