1. Localizations for Japan Implementation Guide
  2. Understanding the Consumption Tax Report for Japan

Understanding the Consumption Tax Report for Japan

The standard JD Edwards EnterpriseOne software provides the Tax Summary Report/Use VAT report (R0018P1) and Tax Detail/Summary report (R0018P) to enable you to view summary and detail information about the taxes. These reports, however, do not show the object account and subsidiary used by the original purchase transaction. In Japan, you can run the Consumption Tax Report for Japan program to obtain a list of the tax transactions generated by journal entries, invoices, and vouchers that are written to the Tax Reconciliation Repository table (F0018R).

For sales order transactions, the system includes this data:

  • Company.

  • Date range.

  • Tax explanation code.

  • Tax rate area.

  • Object and subsidiary of the credit and debit accounts for the transaction.

  • Taxable amount.

  • Tax amount.

For purchase order transactions, the system also retrieves from the Purchase Order Receiver File table (F43121) the object account and subsidiary to which the purchase order information was written. The system includes in the report the values for the object account and subsidiary from the offset account that is associated with the DMAAI 4320.

The system includes this data in the report for purchase transactions:

  • Company.

  • Date range.

  • Tax explanation code.

  • Tax rate area.

  • Object and subsidiary of the credit and debit accounts for the transaction.

  • GL class code.

  • Object account of the offset account for DMAAI 4320 (received not vouchered)

  • Subsidiary account of the offset account for DMAAI 4320.

  • Taxable amount.

  • Tax amount.

The Consumption Tax Report for Japan program produces a PDF file. You can also export the data to a comma-separated values (CSV) file by selecting the Export to CSV option on the Report Output Destination form.