Report for VAT checking in Japan

(3) Share

Report

Posted on by Ulrika Zetterfeldt

Hi everyone,

we are currently setting up a Japanese company in FnO and they want a report with the data included in the "voucher transaction list" but now also including VAT amount and VAT rate for each transaction line (if any).

Currently, they are in AX2012 and using a combination of the "transaction list" and "Sales tax specification by ledger transaction report". This VAT checking report is needed for the consumption vat report check.

I know there are many tax reports in FnO but I haven't found any suitable.

Can anyone tell me if there is such a report or if there are any other possible ways of working with this VAT check?

Thank you so much!
Best regards

Ulrika Zetterfeldt

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

Holly Huffman 6,538 Super User 2025 Season 2 on at

Like (3)

Report
Good morning, afternoon, or evening :) depending on your location!

It seems like your client is looking for a tailored solution to include VAT amounts and rates in the "voucher transaction list" for their VAT checking process in Japan. I'm not sure there is an out-of-the-box report that matches their exact requirements, here are some potential approaches:

Customization: You can customize the "voucher transaction list" report to include the VAT amount and VAT rate for each transaction line. This would involve working with a developer to modify the report layout and data sources.

Combining Reports: Since they are currently using a combination of the "transaction list" and "Sales tax specification by ledger transaction report" in AX2012, you could explore replicating this approach in FnO. You might need to export data from both reports and merge them using tools like Excel or Power BI.

Tax Reports in FnO: FnO offers various tax reports, such as the "Tax transactions report" or "Tax register report," which might provide some of the required data. These reports can be reviewed to see if they can be adapted or used in conjunction with other reports.

Electronic Reporting (ER): FnO's Electronic Reporting (ER) framework allows you to create custom reports without coding. You can design a new report template that includes the required fields, such as VAT amount and rate, and map it to the data sources.

Third-Party Solutions: There might be third-party solutions or ISV (Independent Software Vendor) add-ons available for FnO that cater to VAT reporting requirements in Japan. Exploring the Microsoft AppSource marketplace could be helpful.

Hope this helps some!

Was this reply helpful? Yes No
Ulrika Zetterfeldt 51 on at

Like (1)

Report

Dear Holly,

this is good morning from Sweden. :)

Thank you so much for taking your time with my question. It does help a lot and it gives me a guiding direction who to solve this. Many thanks.
I will look into your suggestion no 1 with our developer!

Have a nice day!
All the best from Ulrika

Was this reply helpful? Yes No
Verified answer

Ankit Life 681 on at

Like (2)

Report

Hi,

You can try below standard reports available in D365 F&O. Please check if it suits to your requirements.

Path : General ledger > Enquiries and reports > Ledger reports

1. Transaction list by date

2. Ledger transaction list.

Mark the parameter GST specification to Yes.

Regards,

Ankit

Was this reply helpful? Yes No
Ulrika Zetterfeldt 51 on at

Like (1)

Report

Dear Ankit,

thank you for also helping me in this question. I looked into those reports and I agree with you. They could hopefully work.

The two things are that the want the VAT rate specified but as we only have one rate for one sales tax code, in my opinion this shouldn't be a problem. The second thing is that the want to have a clear export of all transactions into Excel. I will ask them if this kind of Excel export would be okay for them.

Thank you very much!

Best regards,

Ulrika

Was this reply helpful? Yes No

Join the conversation

Community site session details

Report for VAT checking in Japan

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Report for VAT checking in Japan

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates