Configuration guidelines

Program ID Program name Description or comment
TXS001 VAT Reporting. Connect MI transactions

Define three transactions. Specify this information:

Base country

Specify SI.

Report template

Specify the sales book VAT report template.

Transaction

Specify these transactions:

GetHeadInfo

LstVATUserDef

LstVATUserDef2
TXS004 VAT Report Template. Connect User-Defined Report Template

Specify the detailed information to be included in the M3 electronic VAT reporting tables.

See Configuration guidelines for ‘VAT Report Template. Connect User-Defined Report Template’ (TXS004).
TXS005 VAT Report Template. Open Define the template header for the purchase book report.
TXS006 VAT Report Template. Connect Columns

Define the report columns for VAT and purchase amounts.

See Configuration guidelines for ‘VAT Report Template. Connect Columns’ (TXS006).
TXS007 VAT Report Template. Connect Column Selection

Define rules for each column that is defined in (TXS006).

These column rules are used in conjunction with the report line rules defined in (TXS008).
TXS008 VAT Report Template. Connect Lines Define the various lines that are required to group and subtotal the purchase book. The rules and content for each line are then defined in (TXS009).
TXS009 VAT Report Template. Connect Line Selection

For the defined VAT reporting lines in (TXS008), you can specify the content and rules for including or excluding general ledger transactions with this information:

  • VAT code
  • VAT account type
  • Account dimension 1
  • From/To country
  • VAT registration number existed
  • Create Intrastat or Extrastat
  • VAT rate 1 and VAT rate 2
  • Deductible VAT
  • Service code
  • VAT code group
  • Invoice class
  • State
TXS100 VAT Run. Open

Define the VAT reporting period with a unique run number. Specify this information:

Base country

Specify SI.

Report template

Select the VAT report template that is defined for purchase book reporting.

To create a user-defined VAT report, select Related > Crt electronic rep.
TXS118 VAT Run. Open User-Defined Lines

The lines that have been created for user-defined VAT reporting are displayed.

To open (TXS118), select a record in (TXS100), then select Related > Dsp User-Defined.
TXS120 Online VAT Adjustment. Open

Before the final reporting, users can validate, check, and adjust the VAT details stored in the M3 General Ledger module.

To open (TXS120), select a record in (TXS100), then select Related > Wrk online adjustm.