Create XML file for Polish Tax Authorities

Follow these steps

  1. Open 'Standard Audit File for Tax. Generate' (AAS380) to specify selections for the invoices to be included in the report.
  2. Select 'Output file rep'.
  3. Select the check box 'Correction' to determine the type of file (correction or not).
  4. Specify 'VAT Run' (this is only available for VAT, FA, and V7M files).
  5. Specify 'Accounting date range' from and to (only available for EWP, KR, MAG, and WB files).

    See more information about the file structure of the different files below.

  6. Specify 'Base country'. Set to PL (Poland) as recommended (only available for EWP, KR, MAG, and WB files).
  7. Specify 'Invoice date range' from and to (optional field and only available for FA file).
  8. Specify 'Accounting date range' from and to (optional field and only available for FA file).
  9. Specify 'VAT date range' from and to (optional field and only available for FA file).
  10. Specify 'Delivery date range' from and to (optional field and only available for FA file).
  11. Specify 'Warehouse' (this is only available for MAG files).
  12. Specify 'Bank Account ID' (this is only available for WB files).
  13. Specify 'File name' (must end with .XML).
  14. Specify 'Folder name' or leave this field blank. The folder must be located in the folder used for MVXFILETRANSFER and set up before the report is submitted.
  15. Click Next or press Enter to start the creation of the XML file.

    If a file with the same file name already exists in the folder, a message stating that the specified file already exists is displayed. The check box 'Replace doc' is also displayed. Select the check box to replace the existing file, or change the file name, and press 'Next' to create the file.

    The XML file is automatically placed in the folder used for MVXFILETRANSFER or in the specified subfolder.

EWP file structure

XML element name XML element description Comments
Message header

XML declaration for character encoding and namespace.

<?xml version="1.0" encoding="UTF-8"?>

<JPK xmlns="http://jpk.mf.gov.pl/wzor/2022/02/01/02011/" xmlns:etd="http://crd.gov.pl/xml/schematy/dziedzinowe/mf/2020/03/11/eD/DefinicjeTypy/">

Naglowek
KodFormularza Attributes: kodSystemowy="JPK_EWP (3)" wersjaSchemy="1-0" Fix value JPK_EWP
WariantFormularza Value is retrieved from 'Taxation Reporting. Open Report Fields' (TXS035) TTYP = 4, ESAF = 930 where base country is the same as (AAS380) base country. Should be set to '2'.
CelZlozenia Fix value 1
DataWytworzeniaJPK Creation date Date created format YYYYMMDDTHH:MM:SS
DataOd Date From Value is retrieved from (AAS380) from date.
DataDo Date To Value is retrieved from (AAS380) to date.
DomyslnyKodWaluty ISO Country PLN
KodUrzedu Office code Value is retrieved from (TXS035) TTYP = 4, ESAF = 931 where base country is the same as base country in (AAS380).
Podmiot1
IdentyfikatorPodmiotu
etd:NIP VAT Identity Code Value is retrieved from internal supplier of fiscal representative VAT registration number, or company VAT registration number.
etd:PelnaNazwa Full name Value is retrieved from internal supplier name of fiscal representative, or company name.
etd:REGON Region Value is retrieved from (TXS035) TTYP = 4, ESAF = 932 where base country is the same as (AAS380) base country.
AdresPodmiotu
etd:KodKraju Base country Value is retrieved from (AAS380) base country.
etd:Wojewodztwo State Value is retrieved from internal supplier of fiscal representative, or company state.
etd:Powiat County Value is retrieved from the country name of internal supplier if a fiscal representative is defined. Otherwise set in (TXS035) TTYP = 4, ESAF = 933 where base country is the same as (AAS380) base country.
etd:Gmina Community Value is retrieved from (TXS035) TTYP = 4, ESAF = 934 where base country is the same as (AAS380) base country.
etd:Ulica Street Value is retrieved from (TXS035) TTYP = 4, ESAF = 935 where base country is the same as (AAS380) base country.
etd:NrDomu Building number Value is retrieved from (TXS035) TTYP = 4, ESAF = 936 where base country is the same as (AAS380) base country.
etd:NrLokalu Apartment number Value is retrieved from (TXS035) TTYP = 4, ESAF = 937 where base country is the same as (AAS380) base country.
etd:Miejscowosc Town Value is retrieved from internal supplier of fiscal representative town, or company town.
etd:KodPocztowy Post code Value is retrieved from internal supplier of fiscal representative post code, or company post code.
etd:Poczta Post office Value is retrieved from (TXS035) TTYP = 4, ESAF = 938 where base country is the same as (AAS380) base country.
EWPWiersz Attribute: typ G
K1 Column 1 Ordinal number
K2 Column 2 Accounting date
K3 Column 3 Invoice date
K4 Column 4 Voucher number
K5 Column 5 Value is retrieved from recorded amount with VAT Rate1 = 17
K6 Column 6 Value is retrieved from recorded amount with VAT Rate1 = 15
K7 Column 7 Value is retrieved from recorded amount with VAT Rate1 = 14
K8 Column 8 Value is retrieved from recorded amount with VAT Rate1 = 12.5
K9 Column 9 Value is retrieved from recorded amount with VAT Rate1 = 12
K10 Column 10 Value is retrieved from recorded amount with VAT Rate1 = 10
K11 Column 11 Value is retrieved from recorded amount with VAT Rate1 = 8.5
K12 Column 12 Value is retrieved from recorded amount with VAT Rate1 = 5.5
K13 Column 12 Value is retrieved from recorded amount with VAT Rate1 = 5.5
K14 Column 12 Value is retrieved from recorded amount with VAT Rate1 = 3
EWPCtrl Sum of K5 + K6 + K7 + K8 + K9 + K10 + K11 + K12 + K13
LiczbaWierszy Number of rows Number of records in details
SumaPrzychodow Total revenue Sum of column 10

KR file structure

XML element name XML element description
Message header

XML declaration for character encoding and namespace.

<?xml version="1.0" encoding="UTF-8"?>

<JPK xmlns="http://jpk.mf.gov.pl/wzor/2016/03/09/03091/" xmlns:etd="http://crd.gov.pl/xml/schematy/dziedzinowe/mf/2016/01/25/eD/DefinicjeTypy/">

Naglowek
KodFormularza Attributes: kodSystemowy="JPK_KR (1)" wersjaSchemy="1-0" Fix value JPK_KR
WariantFormularza Value is retrieved from 'Taxation Reporting. Open Report Fields' (TXS035) TTYP = 4, ESAF = 930 where base country is the same as (AAS380) base country. Should be set to '1'.
CelZlozenia 1
DataWytworzeniaJPK Creation date Date created format YYYYMMDDTHH:MM:SS
DataOd Date From Value is retrieved from (AAS380) from date
DataDo Date To Value is retrieved from (AAS380) to date
DomyslnyKodWaluty ISO Country PLN
KodUrzedu Office code Value is retrieved from (TXS035) TTYP = 4, ESAF = 931 where base country is the same as (AAS380) base country.
Podmiot1
IdentyfikatorPodmiotu
etd:NIP VAT Identity Code Value is retrieved from internal supplier of fiscal representative VAT registration number, or company VAT registration number.
etd:PelnaNazwa Full name Value is retrieved from internal supplier name of fiscal representative, or company name.
etd:REGON Region Value is retrieved from (TXS035) TTYP = 4, ESAF = 932 where base country is the same as (AAS380) base country.
AdresPodmiotu
etd:KodKraju Base country Value is retrieved from (AAS380) base country
etd:Wojewodztwo State Value is retrieved from internal supplier of fiscal representative, or company state.
etd:Powiat County Value is retrieved from the country name of internal supplier if a fiscal representative is defined. Otherwise set in (TXS035) TTYP = 4, ESAF = 933 where base country is the same as (AAS380) base country.
etd:Gmina Community Value is retrieved from (TXS035) TTYP = 4, ESAF = 934 where base country is the same as (AAS380) base country.
etd:Ulica Street Value is retrieved from (TXS035) TTYP = 4, ESAF = 935 where base country is the same as (AAS380) base country.
etd:NrDomu Building number Value is retrieved from (TXS035) TTYP = 4, ESAF = 936 where base country is the same as (AAS380) base country.
etd:NrLokalu Apartment number Value is retrieved from (TXS035) TTYP = 4, ESAF = 937 where base country is the same as (AAS380) base country.
etd:Miejscowosc Town Value is retrieved from internal supplier of fiscal representative town, or company town.
etd:KodPocztowy Post code Value is retrieved from internal supplier of fiscal representative post code, or company post code.
etd:Poczta Post office Value is retrieved from (TXS035) TTYP = 4, ESAF = 938 where base country is the same as (AAS380) base country.
ZOiS Attribute: typ G
KodKonta Account ID Value is retrieved from account ID in chart of accounts
OpisKonta Account description Value is retrieved from account description
TypKonta Account type Value is retrieved from account type
KodZespolu Group code Value is retrieved from account group. Level 5 is used.
OpisZespolu Group account description Account group description level 5 in 'Account Group. Open' (CRS633). If not defined, the value is set to 'Nie dotyczy'.
KodKategorii Category code Account group description level 5 in (CRS633). Set to group code (AICL) level 1, default value 'Nie dotyczy'
OpisKategorii Category description Account group description level 5 in (CRS633). Set to group code description (TX40) level 1, default value 'Nie dotyczy'
KodPodkategorii Sub Account Code Account group description level 5 in (CRS633). Set to group code (AICL) level 2, default value 'Nie dotyczy'
OpisPodkategorii Sub Account Description Account group description level 5 in (CRS633). Set to group code description (TX40) level 2, default value 'Nie dotyczy'
BilansOtwarciaWinien Opening Balance Debit Debit opening balance of the year (Period 00 of current year), external transactions only.
BilansOtwarciaMa Opening Balance Credit Credit opening balance of the year (Period 00 of current year), external transactions only.
ObrotyWinien Debit Transactions Debit external transaction within the current periods
ObrotyMa Credit Transactions Credit external transactions within the current periods
ObrotyWinienNarast Accumulated Debits Debit external transactions Period 1 of the current year up to 'to date' selection (year to date).
ObrotyMaNarast Accumulated Credits Credit external transactions period 1 of the current year up to 'to date' selection (year to date).
SaldoWinien Debit Balance Opening debit balance + sum of debit in table FGLEDG.ACAM for external transactions only. If Debit, this is shown in this field.
SaldoMa Credit Balance Opening credit balance + sum of credit in table FGLEDG.ACAM for external transactions only. If Credit, this is shown in this field.
Dziennik Attribute: typ G
LpZapisuDziennika Record log sequential number Journal number
NrZapisuDziennika Record number in the log Journal sequence number
OpisDziennika Description of the record Voucher name
NrDowoduKsiegowego Accounting Transaction Reference Voucher number
RodzajDowodu Voucher type FAM Function ID
DataOperacji Transaction Date Transaction date
DataDowodu Voucher date Accounting date
DataKsiegowania Posting Date Accounting date
KodOperatora Operator Code User ID
OpisOperacji Description of the operation log Voucher text
DziennikKwotaOperacji Value of the operation log Running balance of recorded amount
DziennikCtrl
LiczbaWierszyDziennika Number of record rows Number of records in the record log
SumaKwotOperacji Sum of the amounts Sum of amounts from the record log
KontoZapis Attribute: typ G
LpZapisu Sequential Record Number
NrZapisu Record Number Journal number
KodKontaWinien Debit Account Code Voucher name
KwotaWinien Debit Amount If debit amount, recorded as a positive decimal value.
KwotaWinienWaluta Debit Amount in foreign currency If debit amount, recorded as a positive decimal value in foreign currency.
KodWalutyWinien Currency Code for Debit Currency
OpisZapisuWinien Debit Record Description Voucher text
KodKontaMa Credit Account Code Voucher name
KwotaMa Credit Amount If credit amount, recorded as a positive decimal value.
KwotaMaWaluta Credit Amount in foreign currency If credit amount, recorded as a positive decimal value in foreign currency.
KodWalutyMa Currency Code for Credit Currency
OpisZapisuMa Credit Record Description Voucher text
KontoZapisCtrl
LiczbaWierszyKontoZapisj Number of rows of Account Records Number of records
SumaWinien Total Debits Sum of debit account records
SumaMa Total Credits Sum of credit account records

MAG file structure

XML element name XML element description Comments
Message header

XML declaration for character encoding and namespace.

<?xml version="1.0" encoding="UTF-8"?>

<JPK xmlns="http://jpk.mf.gov.pl/wzor/2016/03/09/03093/" xmlns:etd="http://crd.gov.pl/xml/schematy/dziedzinowe/mf/2016/01/25/eD/DefinicjeTypy/">

Naglowek
KodFormularza Attributes: kodSystemowy="JPK_MAG (1)" wersjaSchemy="1-0" Fix value JPK_MAG
WariantFormularza Value is retrieved from 'Taxation Reporting. Open Report Fields' (TXS035) TTYP = 4, ESAF = 930 where base country is the same as (AAS380) base country. Should be set to '1'.
CelZlozenia 1
DataWytworzeniaJPK Creation date Date created format YYYYMMDDTHH:MM:SS
DataOd Date From Value is retrieved from (AAS380) from date
DataDo Date To Value is retrieved from (AAS380) to date
DomyslnyKodWaluty ISO Country PLN
KodUrzedu Office Code Value is retrieved from (TXS035) TTYP = 4, ESAF = 931 where base country is the same as (AAS380) base country.
Podmiot1
IdentyfikatorPodmiotu
etd:NIP VAT Identity Code Value is retrieved from internal supplier of fiscal representative VAT registration number, or company VAT registration number.
etd:PelnaNazwa Full Name Value is retrieved from internal supplier name of fiscal representative, or company name.
etd:REGON Region Value is retrieved from (TXS035) TTYP = 4, ESAF = 932 where base country is the same as (AAS380) base country.
AdresPodmiotu
etd:KodKraju Base Country Value is retrieved from (AAS380) base country
etd:Wojewodztwo State Value is retrieved from internal supplier of fiscal representative, or company state.
etd:Powiat County Value is retrieved from the country name of internal supplier if a fiscal representative is defined. Otherwise set in (TXS035) TTYP = 4, ESAF = 933 where base country is the same as (AAS380) base country.
etd:Gmina Community Value is retrieved from (TXS035) TTYP = 4, ESAF = 934 where base country is the same as (AAS380) base country.
etd:Ulica Street Value is retrieved from (TXS035) TTYP = 4, ESAF = 935 where base country is the same as (AAS380) base country.
etd:NrDomu Building number Value is retrieved from (TXS035) TTYP = 4, ESAF = 936 where base country is the same as (AAS380) base country.
etd:NrLokalu Apartment number Value is retrieved from (TXS035) TTYP = 4, ESAF = 937 where base country is the same as (AAS380) base country.
etd:Miejscowosc Town Value is retrieved from internal supplier of fiscal representative town, or company town.
etd:KodPocztowy Post code Value is retrieved from internal supplier of fiscal representative post code, or company post code.
etd:Poczta Post office Value is retrieved from (TXS035) TTYP = 4, ESAF = 938 where base country is the same as (AAS380) base country.
Magazyn Warehouse Value is retrieved from (AAS380) warehouse selection
PZ The content of this section is based on the TTYP sets in (CRS881)
PZWartosc Summary of evidence for external receipt
NumerPZ External receipt document number Reference number retrieved from table (MITTRA.REPN)
DataPZ Date of the external receipt document Transaction date
WartoscPZ Value of the overall external receipt document Unit price * Quantity
DataOtrzymaniaPZ Date of receipt of the goods/materials Transaction date
Dostawca Supplier of the goods/materials Supplier name and supplier code in table FGRECL.SUNO or table CIDMAS.SUNM
NumerFaPZ Invoice number of specifications received concerning goods/materials Optional field, retrieved from program APS370.SINO
DataFaPZ Date of invoice of specifications received concerning goods/materials Optional field, retrieved from program APS370.IVDT
PZWiersz
Numer2PZ External receipt document number Reference number retrieved from table (MITTRA.REPN)
KodTowaruPZ Code of the goods/material/packaging Item number
NazwaTowaruPZ Name of the goods/material/packaging Item description
IloscPrzyjetaPZ Quantity taken Quantity
JednostkaMiaryPZ Unit of measure Unit of measure
CenaJednPZ Unit price of the goods/material/packaging Unit price
WartoscPozycjiPZ Value of the goods/material/packaging Unit price * Quantity
PZCtrl
LiczbaPZ Number of external receipt documents Total count of external receipt transactions
SumaPZ Value of external receipt documents Sum of Unit price * Quantity
WZ The content of this section is based on the TTYP sets in (CRS881)
WZWartosc
NumerWZ External issue document number Reference number retrieved from table (MITTRA.RIDI)
DataWZ Date of the external issue document Transaction date
WartoscWZ Value of the external issue document Calculated value of Unit price * Quantity
DataWydaniaWZ Date of issue of the goods/materials Transaction date
OdbiorcaWZ Recipient of the goods/materials Not used/updated
NumerFaWZ Invoice number of specifications for goods/materials issued Not used/updated
DataFaWZ Date of the invoice of specifications for goods/materials issued Not used/updated
WZWiersz
Numer2WZ External issue document number Reference number retrieved from table (MITTRA.RIDI)
KodTowaruWZ Code of the goods/material/packaging Item number
NazwaTowaruWZ Name of the goods/material/packaging Item description
IloscWydanaWZ Quantity issued Quantity
JednostkaMiaryWZ Unit of measure Unit of measure
CenaJednWZ Unit price of the goods/material/packaging Unit price
WartoscPozycjiWZ Value of the goods/material/packaging Calculated value of Unit price * Quantity
WZCtrl
LiczbaWZ Number of external issue documents Total count of external issue transactions
SumaWZ Value of External issue documents Sum of Unit price * Quantity
RW The content of this section is based on the TTYP sets in (CRS881)
RWWartosc
NumerRW Internal issue document number Reference number retrieved from table (MITTRA.RIDN)
DataRW Date of the internal issue document Transaction date
WartoscRW Value of the internal issue document Unit price * Quantity
DataWydaniaRW Date of issue of the goods/material Date of issue
SkadRW Place of delivery of the goods/material Not used/updated
DokadRW Place of the goods/material Not used/updated
RWWiersz
Numer2RW Internal issue document number Reference number retrieved from table (MITTRA.RIDN)
KodTowaruRW Code of the goods/material/packaging Item number
NazwaTowaruRW Name of the goods/material/packaging Item description
IloscWydanaRW Quantity issued Quantity
JednostkaMiaryRW Unit of measure Unit of measure
CenaJednRW Unit price of the goods/material/packaging Unit price
WartoscPozycjiRW Value of the goods/material/packaging Unit price * Quantity
RWCtrl
LiczbaRW Number of internal issue documents Total count of the internal issue transactions
SumaRW Value of internal issue documents Sum of Unit price * Quantity
MM
MMWartosc The content of this section is based on the TTYP sets in (CRS881)
NumerMM Movement between warehouses number Reference number retrieved from table (MITTRA.RIDI)
DataMM Movement between warehouses date Transaction date
WartoscMM Movement between warehouses value Unit price
DataWydaniaMM Issue date of movement between warehouses document Issue date
SkadMM Movement between warehouses from Not used/updated
DokadMM Movement between warehouses to Not used/updated
MMWiersz
Numer2MM Movement between warehouses number (2) Reference number retrieved from table (MITTRA.RIDI)
KodTowaruMM Movement between warehouses goods code Item number
NazwaTowaruMM Movement between warehouses goods name Item description
IloscWydanaMM Movement between warehouses quantity issued Quantity issued
JednostkaMiaryMM Movement between warehouses unit of measure Unit of measure
CenaJednMM Movement between warehouses unit price Unit price
WartoscPozycjiMM Movement between warehouses value Quantity issued * Unit price
MMCtrl
LiczbaMM Number of movements between warehouses Total count of movement transactions
SumaMM Value of movements between warehouses Sum of Quantity issued * Unit price

VAT file Structure

XML element name XML element description Comments
Message header

XML declaration for character encoding and namespace.

<?xml version="1.0" encoding="UTF-8"?> '

<JPK xmlns="http://jpk.mf.gov.pl/wzor/2017/11/13/1113/" xmlns:etd="http://crd.gov.pl/xml/schematy/dziedzinowe/mf/2016/01/25/eD/DefinicjeTypy/">

Naglowek
KodFormularza Attributes: kodSystemowy="JPK_VAT (3)" wersjaSchemy="1-1" Fix value JPK_VAT
WariantFormularza Value is retrieved from 'Taxation Reporting. Open Report Fields' (TXS035) TTYP = 4, ESAF = 930 where base country is the same as (AAS380) base country. Should be set to '1'.
CelZlozenia 1
DataWytworzeniaJPK Creation date Date created format YYYYMMDDTHH:MM:SS
DataOd Date From Value is retrieved from (AAS380) from date
DataDo Date To Value is retrieved from (AAS380) to date
DomyslnyKodWaluty ISO Country PLN
KodUrzedu Office Code Value is retrieved from (TXS035) TTYP = 4, ESAF = 931 where base country is the same as (AAS380) base country.
Podmiot1
IdentyfikatorPodmiotu
etd:NIP VAT Identity Code Value is retrieved from internal supplier of fiscal representative VAT registration number, or company VAT registration number.
etd:PelnaNazwa Full name Value is retrieved from internal supplier name of fiscal representative, or company name.
etd:REGON Region Value is retrieved from (TXS035) TTYP = 4, ESAF = 932 where base country is the same as (AAS380) base country.
AdresPodmiotu
etd:KodKraju Base Country Value is retrieved from (AAS380) base country
etd:Wojewodztwo State Value is retrieved from internal supplier of fiscal representative, or company state.
etd:Powiat County Value is retrieved from the country name of internal supplier if a fiscal representative is defined, otherwise set in (TXS035) TTYP = 4, ESAF = 933 where base country is the same as (AAS380) base country.
etd:Gmina Community Value is retrieved from (TXS035) TTYP = 4, ESAF = 934, where base country is the same as (AAS380) base country.
etd:Ulica Street Value is retrieved from (TXS035) TTYP = 4, ESAF = 935, where base country is the same as (AAS380) base country.
etd:NrDomu Building number Value is retrieved from (TXS035) TTYP = 4, ESAF = 936, where base country is the same as (AAS380) base country.
etd:NrLokalu Apartment number Value is retrieved from (TXS035) TTYP = 4, ESAF = 937, where base country is the same as (AAS380) base country.
etd:Miejscowosc Town Value is retrieved from internal supplier of fiscal representative town, or company town.
etd:KodPocztowy Post code Value retrieved from internal supplier of fiscal representative post code, or company post code.
etd:Poczta Post office Value is retrieved from (TXS035) TTYP = 4, ESAF = 938 where base country is the same as (AAS380) base country.
SprzedazWiersz Attribute typ G
LpSprzedazy Sales sequential number Number - sequence number
DataSprzedazy Date of sale VAT date
DataWystawienia Date of issue Invoice date
NrDokumentu Document number Supplier invoice number
NazwaNabywcy Buyer's name Value is retrieved from table FVATIN.CUSP or from the program Customer Master (CRS610.CUNM).
AdresNabywcy Address of the buyer Address 1 + Address 2 + Address 3 + Address 4
K_10 Column 10 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3). Always a positive value.
K_11 Column 11

Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3). Always a positive value.

The net amount for VAT exempted invoices for the supply of goods and provision of services outside the national territory.

K_12 Column 12

Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3). Always a positive value.

The net amount for VAT exempted invoices to EU for supply of goods and provision of services referred to in article 100, paragraph 1, point 4 of the Act. Note that these sales are also included in line K_11.

K_13 Column 13 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3). Always a positive value.
K_14 Column 14 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3). Always a positive value.
K_15 Column 15 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3). Always a positive value.
K_16 Column 16 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3). Always a positive value.
K_17 Column 17 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3). Always a positive value.
K_18 Column 18 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3). Always a positive value.
K_19 Column 19 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3). Always a positive value.
K_20 Column 20 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3). Always a positive value.
K_21 Column 21 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3). Always a positive value.
K_22 Column 22 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3). Always a positive value.
K_23 Column 23 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3). Always a positive value.
K_24 Column 24 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3). Always a positive value.
K_25 Column 25 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3). Always a positive value.
K_26 Column 26 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3). Always a positive value.
K_27 Column 27 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3). Always a positive value.
K_28 Column 28 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3). Always a positive value.
K_29 Column 29 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3). Always a positive value.
K_30 Column 30 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3). Always a positive value.
K_31 Column 31 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3). Always a positive value.
K_32 Column 32 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3). Always a positive value.
K_33 Column 33 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3). Always a positive value.
K_34 Column 34 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3). Always a positive value.
K_35 Column 35 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3). Always a positive value.
K_36 Column 36 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3). Always a positive value.
K_37 Column 37 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3). Always a positive value.
K_38 Column 38 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3). Always a positive value.
SprzedazCtrl
LiczbaWierszySprzedazy Number of Rows Total number of lines
PodatekNalezny Tax payable Sum of FVATIN.ACA2 + ACA3 * -1
ZakupWiersz Attribute typ G
LpZakupu Purchase sequential number Running number
NazwaWystawcy Issuer name Value is retrieved from table FVATIN.CUSP or table CIDMAS.SUNM
AdresWystawcy Issuer address Supplier connect Address 1 + Address 2 + Address 3 + Address 4 with Address type 1
NrIdWystawcy ID of the issuer of the invoice VAT registration number. If blank set to 'brak'.
NrFaktury Invoice Number Supplier invoice number
DataWplywuFaktury Date of receipt of the invoice Accounting date
K_42 Column 42 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3). Always a positive value.
K_43 Column 43 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3). Always a positive value.
K_44 Column 44 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3). Always a positive value.
K_45 Column 45 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3). Always a positive value.
K_46 Column 46 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3). Always a positive value.
K_47 Column 47 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3). Always a positive value.
K_48 Column 48 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3). Always a positive value.
ZakupCtrl
LiczbaWierszyZakupow Number of rows Number of lines
PodatekNaliczony Total (input) Tax Charged Sum of value in table FVATIN.ACA2 + ACA3

FA file structure

XML element name XML element description Comments
Message header

XML declaration for character encoding and namespace.

<?xml version="1.0" encoding="UTF-8"?>

<JPK xmlns="http://jpk.mf.gov.pl/wzor/2022/02/17/02171/" xmlns:etd="http://crd.gov.pl/xml/schematy/dziedzinowe/mf/2018/08/24/eD/DefinicjeTypy/">
Naglowek
KodFormularza Attributes: kodSystemowy="JPK_FA (4)" wersjaSchemy="1-0" Fix value JPK_FA
WariantFormularza Fix value 4
CelZlozenia 1
DataWytworzeniaJPK Creation date Date created format YYYYMMDDTHH:MM:SS
DataOd Date From Value is retrieved from (AAS380) from date
DataDo Date To Value is retrieved from (AAS380) to date
KodUrzedu Office Code Value is retrieved from (TXS035) TTYP = 4, ESAF = 931, where base country is the same as (AAS380) base country.
Podmiot1
IdentyfikatorPodmiotu
etd:NIP etd:NIP Value is retrieved from internal supplier of fiscal representative VAT registration number, or company VAT registration number.
etd:PelnaNazwa Full name Value is retrieved from internal supplier name of fiscal representative, or company name.
AdresPodmiotu
etd:KodKraju Base Country Value is retrieved from (AAS380) base country
etd:Wojewodztwo State Value is retrieved from internal supplier of fiscal representative, or company state.
etd:Powiat County Value is retrieved from the country name of internal supplier if a fiscal representative is defined. Otherwise set in (TXS035) TTYP = 4, ESAF = 933 where base country is the same as (AAS380) base country.
etd:Gmina Community Value is retrieved from (TXS035) TTYP = 4, ESAF = 934, where base country is the same as (AAS380) base country.
etd:NrDomu Building number Value is retrieved from (TXS035) TTYP = 4, ESAF = 936, where base country is the same as (AAS380) base country.
etd:Miejscowosc Town Value is retrieved from internal supplier of fiscal representative town, or company town.
etd:KodPocztowy Post code Value is retrieved from internal supplier of fiscal representative post code, or company post code.
Faktura
KodWaluty ISO(4217) Currency Three letter currency code
P_1 Date of issue Invoice date
P_2A Invoice number Customer invoice number
P_3A Customer name Customer name
P_3B Customer address Customer Address 1 + Address 2 + Address 3 + Address 4
P_3C Internal supplier/ Company name Supplier name is retrieved from fiscal representative internal supplier, or company name is used.
P_3D Company address Internal supplier or Company Address 1 + Address 2 + Address 3 + Address 4
P_4A Country of the VAT registration number Value is retrieved from country in supplier VAT registration number. If it is not included, country or company country is used.
P_4B VAT Registration number without country Value is retrieved from supplier VAT registration number without country. If it is not included, company VAT registration number is used.
P_5A Country of the VAT registration number VAT registration number (where the first 2 characters are country code) or blank
P_5B VAT registration number without country VAT registration number (without the leading country code)
P_6 VAT date VAT date
P_13_1

If invoice is in foreign currency, VAT report template Line ID report '19'. Sum of VAT base amount (ACC1), VAT payable (ACC2), VAT receivable (ACC3) in whole number. Always a positive value.

If invoice is in local currency, VAT report template Line ID report '19'. Sum of VAT base amount (ACA1), VAT payable (ACA2), VAT receivable (ACA3) in whole number. Always a positive value.

P_14_1

If invoice is in foreign currency, VAT report template Line ID report '20'. Sum of VAT base amount (ACC1), VAT payable (ACC2), VAT receivable (ACC3) in whole number. Always a positive value.

If invoice is in local currency, VAT report template Line ID report '20'. Sum of VAT base amount (ACA1), VAT payable (ACA2), VAT receivable (ACA3) in whole number. Always a positive value.

P_14_1W

Local currency amount, VAT report template Line ID report '20'. Sum of VAT base amount (ACA1), VAT payable (ACA2), VAT receivable (ACA3) in whole number. Always a positive value.

Is only displayed if the invoice is in foreign currency.

P_13_2

If invoice is in foreign currency, VAT report template Line ID report '17'. Sum of VAT base amount (ACC1), VAT payable (ACC2), VAT receivable (ACC3) in whole number. Always a positive value.

If invoice is in local currency, VAT report template Line ID report '17'. Sum of VAT base amount (ACA1), VAT payable (ACA2), VAT receivable (ACA3) in whole number. Always a positive value.

P_14_2

If invoice is in foreign currency, VAT report template Line ID report '18'. Sum of VAT base amount (ACC1), VAT payable (ACC2), VAT receivable (ACC3) in whole number. Always a positive value.

If invoice is in local currency, VAT report template Line ID report '18'. Sum of VAT base amount (ACA1), VAT payable (ACA2), VAT receivable (ACA3) in whole number. Always a positive value.

P_14_2W

Local currency amount., VAT report template Line ID report '18'. Sum of VAT base amount (ACA1), VAT payable (ACA2), VAT receivable (ACA3) in whole number. Always a positive value.

Is only displayed if the invoice is in foreign currency.

P_13_3

If invoice is in foreign currency, VAT report template Line ID report '15'. Sum of VAT base amount (ACC1), VAT payable (ACC2), VAT Receivable (ACC3) in whole number. Always a positive value.

If invoice is in local currency, VAT report template Line ID report '15'. Sum of VAT base amount (ACA1), VAT payable (ACA2), VAT receivable (ACA3) in whole number. Always a positive value.

P_14_3

If invoice is in foreign currency, VAT report template Line ID report '16'. Sum of VAT base amount (ACC1), VAT payable (ACC2), VAT receivable (ACC3) in whole number. Always a positive value.

If invoice is in local currency, VAT report template Line ID report '16'. Sum of VAT base amount (ACA1), VAT payable (ACA2), VAT receivable (ACA3) in whole number. Always a positive value.

P_14_3W

Local currency amount, VAT report template Line ID report '16'. Sum of VAT base amount (ACA1), VAT payable (ACA2), VAT receivable (ACA3) in whole number. Always a positive value.

Is only displayed if the invoice is in foreign currency.

P_13_4

If invoice is in foreign currency, VAT report template Line ID report '11'. Sum of VAT base amount (ACC1), VAT payable (ACC2), VAT receivable (ACC3) in whole number. Always a positive value.

If invoice is in local currency, VAT report template Line ID report '11’. Sum of VAT base amount (ACA1), VAT payable (ACA2), VAT receivable (ACA3) in whole number. Always a positive value.

P_14_4 Not used/updated
P_14_4W Reserved field
P_13_5

If invoice is in foreign currency, VAT report template Line ID report '21' and '22'. Sum of VAT base amount (ACC1), VAT payable (ACC2), VAT receivable (ACC3) in whole number. Always a positive value.

If invoice is in local currency, VAT report template Line ID report '21' and '22'. Sum of VAT base amount (ACA1), VAT payable (ACA2), VAT receivable (ACA3) in whole number. Always a positive value.

P_14_5

If invoice is in foreign currency, VAT report template Line ID report '23' and '24'. Sum of VAT base amount (ACC1), VAT payable (ACC2), VAT receivable (ACC3) in whole number, always a positive value.

If invoice is in local currency, VAT report template Line ID report '23' and '24'. Sum of VAT base amount (ACC1), VAT payable (ACC2), VAT receivable (ACC3) in whole number, always a positive value.

P_13_6

If invoice is in foreign currency, VAT report template Line ID report '13'. Sum of VAT base amount (ACC1), VAT payable (ACC2), VAT receivable (ACC3) in whole number. Always a positive value.

If invoice is in local currency, VAT report template Line ID report '13’. Sum of VAT base amount (ACA1), VAT payable (ACA2), VAT receivable (ACA3) in whole number. Always a positive value.

P_13_7

If invoice is in foreign currency, VAT report template Line ID report '10'. Sum of VAT base amount (ACC1), VAT payable (ACC2), VAT receivable (ACC3) in whole number. Always a positive value.

If invoice is in local currency, VAT report template Line ID report '10’. Sum of VAT base amount (ACA1), VAT payable (ACA2), VAT receivable (ACA3) in whole number. Always a positive value.

P_15 Sum of invoice gross amount. The amount of total receivables.
P_16 TRUE or FALSE If the VAT code used is 'VAT on payment'= TRUE otherwise FALSE
P_17 TRUE or FALSE Check for VAT code list in (CRS881). If VAT code exists in the list set to TRUE, otherwise FALSE.
P_18 TRUE or FALSE Check for VAT code list in (CRS881). If VAT code exists in the list set to TRUE, otherwise FALSE.
P_18A TRUE or FALSE Check for additional info 258. If additional info exists set to TRUE, otherwise FALSE.
P_19 TRUE or FALSE Check for VAT code list in (CRS881). If VAT code exists in the list set to TRUE, otherwise FALSE.
P_19A Check if element P19 = TRUE: If language field (LNCD) = blank use "PL". Find the exemption text for the VAT code.
P_19B Check if element P19 = TRUE: If language field (LNCD) = blank use "PL". Find the exemption text for the VAT code.
P_19C Check if element P19 = TRUE: If language field (LNCD) = blank use "PL". Find the exemption text for the VAT code.
P_20 TRUE or FALSE Check for VAT code list in (CRS881): If VAT Code exists in the list set to TRUE, otherwise FALSE.
P_20A Name of the enforcement Authority Check if element P20 = TRUE: (TXS035) TTYP = 4, ESAF = 939, where base country is the same as (AAS380) base country.
P_20B Address of the enforcement Authority Check if element P20 = TRUE: (TXS035) TTYP = 4, ESAF = 940, where base country is the same as (AAS380) base country.
P_21 TRUE or FALSE Set to TRUE if fiscal representative is found for the header
P_21A TRUE or FALSE Check if element P21 = TRUE: Supplier name (internal supplier based on fiscal representative).
P_21B TRUE or FALSE Check if element P21 = TRUE: Value is retrieved from table CIDMAS.ADR1/ADR2/ADR3/ADR4/
P_21C TRUE or FALSE Check if element P21 = TRUE: Value is retrieved from program CRS620.VRNO (remove leading country code if it exists).
P_22 TRUE or FALSE Check if invoice ‘From/to country’ is the same with ‘Base country’ set the value to TRUE, otherwise FALSE.
P_22A Not Defined Not used/updated
P_22B Not Defined Not used/updated
P_22C Not Defined Not used/updated
P_23 TRUE or FALSE Check the VAT code. If VAT Method is 7- 'Triangular trade', set to TRUE, otherwise FALSE.
P_106E_2 TRUE or FALSE Check for VAT code list in (CRS881). If the VAT code exists in the list set to TRUE, otherwise FALSE.
P_106E_3 TRUE or FALSE Check for VAT code list in (CRS881). If the VAT code exists in the list set to TRUE otherwise FALSE.
P_106E_3A TRUE or FALSE Check if P19 = TRUE: If language field (LNCD) = blank use "PL". Find the exemption text for the VAT code.
RodzajFaktury

Type of invoice

- regular VAT invoice - value = "VAT"

- corrective invoice - value = "KOREKTA"

- advance invoice - value = "ZAL"

Transaction Code 10 and Check for Invoice Type.

Set value to "VAT" if blank, "KOREKTA" if invoice type is 'CN', "ZAL" if invoice type is 'PP'.

PrzyczynaKorekty For corrective invoice, reason code If invoice is corrective invoice set the value from additional info 257
NrFaKorygowanej For corrective invoice, Invoice number If invoice is corrective invoice, set the value from additional info 235
OkresFaKorygowanej For corrective invoice, invoice date Same customer and payer. Use original invoice date then get period (using invoice number and year).
FakturaCtrl
LiczbaFaktur Number of invoices Number of invoices
WartoscFaktur Sum of P14_1 + P14_2 + P_14_3 + P13_1 + P13_2 + P_13_3 + P_13_6 + P_13_7
FakturaWiersz
P_2B Invoice number Value is retrieved from table FSLEDG.CINO
P_7 Item
  1. For Invoice Type (31) Item Description
  2. For Invoice Type (60) External Charge Description
  3. For Invoice Type (65) Service Charge Description
  4. For Invoice Type (50) Advance Invoice (OOPINV.TX30) + Description (OOPINV.TX60)
  5. For Invoice Type (51) Invoice reference (OINVOL.IVRF + OINVOL.ORNO)
  6. For Invoice Type (67) OLICHL.CRD0 (CRS276/E) (PL) or OOLICH.CRD0 (OIS107/E) Internal Invoices Item Description
  7. Other invoices (grouped by VAT code) voucher text.
P_8A Unit of measure

For customer invoices (IVTP31) and internal invoices. The value is retrieved from tables CSYUNL.UNI2 (PL) or MITMAS.UNMS.

Otherwise set to "szt" - Polish for "pcs".

P_8B

Customer invoices - Sum of ODLINE.IVQT

Internal invoices - CMUFTR.DLQT

Other invoices - Sum of table FGLEDG.ACQT for the invoice per VAT code

No value for IVTP (60, 65, 67, 50, 51).

P_9A

Value retrieved from table OOLINE.NEPR or OOLINE.NLAM/OLINE.IVQT

No value for IVTP (60, 65, 67, 50, 51)

P_9B

(OINVOL.IVAM + OINVOL.VTAM) / OOLINE.IVQT

No value for IVTP (60, 65, 67, 50, 51)

P_10

Value of table OINACC.ACAM with IVTP = 32 or 34

No value for IVTP (60, 65, 67, 50, 51)

P_11
  1. For invoice type (31) the value is the foreign currency amount minus the value in element P_10
  2. For invoice type (60, 65, 67, 50, 51) the value is the foreign currency amount
  3. For internal invoices the value is the quantity multiplied by price
  4. Other invoices: The sum of foreign currency amount invoice per VAT code. Only valid for VAT account type 3-9 net value.
P_11A
  1. For invoice type (31): Sum of foreign currency amount and VAT amount minus the value in element P_10
  2. For invoice types (60, 65, 67): Value is the sum of invoice amount + VAT amount
  3. For invoice type (50): Value is the sum of foreign currency amount of invoice types 50 and 41
  4. For invoice type (51): Value is the sum of foreign currency amount of invoice types 50 and 42
  5. For internal invoices: Value is the sum of element P_11 and calculated VAT amount based on either voucher VAT rate 1 or table CMUFTR.VTP1 (controlled by (CRS881))
  6. Other invoices: Sum of voucher currency amount for the invoice per VAT code. Valid for VAT account type 3 - 9 gross value.
P_12 Acceptable values 23, 22, 8, 7, 5, 4, 3, 0, zw, oo, np
P_12_XII VAT rate for Import One Stop Shop (IOSS) and One Stop Shop (OSS). For IOSS invoice, check for VAT code list in (CRS881): If VAT code exists in the list, display the VAT rate. For OSS, if the customer does not have a VAT registration number, from and to country is defined in 'VAT Rate Rule. Open' (TXS031) and VAT rule is set to '1', VAT rate of the invoice is displayed.
FakturaWierszCtrl
LiczbaWierszyFaktur Number of records
WartoscWierszyFaktur Sum of P11A
Zamowienie Advance invoice
P_2AZ Invoice number Value is retrieved from table FSLEDG.CINO
WartoscZamowienia Total amount of invoice
ZamowienieWiersz
P_7Z Item Invoice Type (50) Advance Invoice (OOPINV.TX30) + Description (OOPINV.TX60)
P_8AZ Unit of measure set to "szt" - Polish for "pcs"
P_11NettoZ Value of advance Invoice without VAT
P_11VatZ Advance invoice VAT amount
P_12Z VAT rate
P_12Z_XII VAT rate for Import One Stop Shop (IOSS) and One Stop Shop (OSS). For IOSS invoice, check for VAT code list in (CRS881): If VAT code exists in the list, display the VAT rate. For OSS, if the customer does not have a VAT registration number, from and to country is defined in 'VAT Rate Rule. Open' (TXS031) and VAT rule is set to '1', VAT rate of the invoice is displayed.
ZamowienieCtrl
LiczbaZamowien Total number of advance invoice
WartoscZamowien Sum of ‘WartoscZamowienia’

Invoice type tag "Rodzaj faktury" (RodzajFaktury)

This tag is controlled by the M3 BE invoice type (IVTP) of the invoice record in Sales Ledger (FSLEDG) and gets set in the "FA xml" as follows:

  • Regular VAT invoice = "VAT": IVTP = "blank"
  • Corrective invoice = "KOREKTA": IVTP = "CN"
  • Advance invoice = "ZAL": IVTP = "PP"

In case of a corrective invoice (IVTP="CN") we put "KOREKTA" in the tag "PrzyczynaKorekty", the original invoice number in tag "NrFaKorygowanej" (from AR extra info 235 or 255) and invoice period in tag "OkresFaKorygowanej".

<RodzajFaktury>POZ</RodzajFaktury>
<PrzyczynaKorekty>KOREKTA</PrzyczynaKorekty>
<NrFaKorygowanej>GEN-201600007</NrFaKorygowanej>
<OkresFaKorygowanej>201606</OkresFaKorygowanej>

Supplier invoice receipt date tag "DataWplywuFaktury" (ZakupWiersze)

The Polish market modifications provide an option to enter the invoice receipt date during supplier invoice entry resulting in extra info AP 420 with the receipt date in format YYYYMMDD. (AAS380) routines for the VAT file check if this information exists for a supplier invoice. If it exists, this date will be taken for tag "DataWplywuFaktury" in section "ZakupWiersze".

WB file structure

XML Element name XML Element description Comments
Message header

XML declaration for character encoding and namespace.

<?xml version="1.0" encoding="UTF-8"?>

<JPK xmlns="http://jpk.mf.gov.pl/wzor/2016/03/09/03091/" xmlns:etd="http://crd.gov.pl/xml/schematy/dziedzinowe/mf/2016/01/25/eD/DefinicjeTypy/">

Naglowek
KodFormularza Attributes: kodSystemowy="JPK_EWP (1)" wersjaSchemy="1-0" Fix value JPK_EWP
WariantFormularza Value is retrieved from 'Taxation Reporting. Open Report Fields' (TXS035) TTYP = 4, ESAF = 930 where base country is the same with (AAS380) base country. Should be set to '1'.
CelZlozenia 1
DataWytworzeniaJPK Creation date Date created format YYYYMMDDTHH:MM:SS
DataOd Date From Value is retrieved from (AAS380) from date
DataDo Date To Value is retrieved from (AAS380) to date
DomyslnyKodWaluty ISO Country PLN
KodUrzedu Office Code Value is retrieved from (TXS035) TTYP = 4, ESAF = 931, where base country is same as (AAS380) base country.
Podmiot1
IdentyfikatorPodmiotu
etd:NIP VAT Identity Code Value is retrieved from internal supplier of fiscal representative VAT registration number, or company VAT registration number.
etd:PelnaNazwa Full Name Value is retrieved from internal supplier name of fiscal representative, or company name.
etd:REGON Region Value is retrieved from (TXS035) TTYP = 4, ESAF = 932, where base country is the same as (AAS380) base country.
AdresPodmiotu
etd:KodKraju Base Country Value is retrieved from (AAS380) base country
etd:Wojewodztwo State Value is retrieved from internal supplier of fiscal representative, or company state.
etd:Powiat County Value is retrieved from the country name of internal supplier if a fiscal representative is defined. Otherwise set in (TXS035) TTYP = 4, ESAF = 933 where base country is the same as (AAS380) base country.
etd:Gmina Community Value is retrieved from (TXS035) TTYP = 4, ESAF = 934 where base country is the same as (AAS380) base country.
etd:Ulica Street Value is retrieved from (TXS035) TTYP = 4, ESAF = 935, where base country is the same as (AAS380) base country.
etd:NrDomu Building number Value is retrieved from (TXS035) TTYP = 4, ESAF = 936 where base country is the same as (AAS380) base country.
etd:NrLokalu Apartment number Value is retrieved from (TXS035) TTYP = 4, ESAF = 937 where base country is the same as (AAS380) base country.
etd:Miejscowosc Town Value is retrieved from internal supplier of fiscal representative town, or company town.
etd:KodPocztowy Post code Value is retrieved from internal supplier of fiscal representative post code, or company post code.
etd:Poczta Post office Value is retrieved from (TXS035) TTYP = 4, ESAF = 938 where base country is the same as (AAS380) base country.
NumerRachunku Bank account ID Bank account IBAN number
Salda
SaldoPoczatkowe Opening balance of the statement Transaction amount using from date as ending date to receive all transactions
SaldoKoncowe Closing balance of the statement Opening balance + all transactions in the accounting date range
WyciagWiersz
NumerWiersza Sequential number Sequential number
DataOperacji Accounting date Accounting date
NazwaPodmiotu Customer name / Supplier name / Account name Customer name / Supplier name / Account name.
OpisOperacji Book of account, Year, Voucher text, Invoice number, Voucher number, and Journal sequence number This will have a concatenation of Book of account, Year, Voucher text, Invoice number, Voucher number, and Journal sequence number.
KwotaOperacji Recorded amount Recorded amount in local currency
SaldoOperacji Total amount Running balance (starting with the opening balance) + transaction amount
WyciagCtrl
LiczbaWierszy Number of lines Total number of statement detail lines
SumaObciazen Total debit amount Total debit amount from the statement detail lines
SumaUznan Total credit amount Total credit amount from the statement detail lines

V7M file structure

XML Element name XML Element description Comments
Message header

XML declaration for character encoding and namespace.

<?xml version="1.0" encoding="UTF-8"?>

<JPK xmlns="http://crd.gov.pl/wzor/2020/05/08/9393/" xmlns:etd="http://crd.gov.pl/xml/schematy/dziedzinowe/mf/2020/03/11/eD/DefinicjeTypy/">

Naglowek
KodFormularza Attributes: kodSystemowy=" JPK_V7M (1)" wersjaSchemy="1-2E" Fix value JPK_VAT
WariantFormularza Value is retrieved from 'Taxation Reporting. Open Report Fields' (TXS035) TTYP = 4, ESAF = 930 where base country is the same as (AAS380) base country. Should be set to '1'.
DataWytworzeniaJPK Creation date Date created format YYYYMMDDTHH:MM:SS
NazwaSystemu Value is retrieved from 'Taxation Reporting. Open Report Fields' (TXS035) TTYP = 4, ESAF = 950 where base country is the same as (AAS380) base country.
CelZlozenia Constant value '1'
poz Attribute Constant value 'P_7'
KodUrzedu Office Code Value is retrieved from (TXS035) TTYP = 4, ESAF = 931 where base country is the same as (AAS380) base country.
Rok Year
Miesiac Period Month
Podmiot1
rola Attribute Constant value 'Podatnik
OsobaNiefizyczna
NIP Date when the file is created
PelnaNazwa Constant value '1'
Email Value is retrieved from (TXS035) TTYP = 4, ESAF = '491' & '492' where base country is the same as (AAS380) base country.
Deklaracja
Naglowek
KodFormularzaDekl Text 'VAT-7'
kodSystemowy Attribute Constant value 'VAT-7 (21)'
KodPodatku Attribute Constant value 'VAT'
RodzajZobowiazania Attribute Constant value 'Z'
wersjaSchemy Attribute Constant value '1-2E'
WariantFormularzaDekl Constant value '21'
PozycjeSzczegolowe Attribute Constatnt 'Podatnik
P_10 Column 10 Sum of amount in ACA1, ACA2, ACA3 where LNID = 10
P_11 Column 11 Sum of amount in ACA1, ACA2, ACA3 where LNID = 11
P_12 Column 12 Sum of amount in ACA1, ACA2, ACA3 where LNID = 12
P_13 Column 13 Sum of amount in ACA1, ACA2, ACA3 where LNID = 13
P_14 Column 14 Sum of amount in ACA1, ACA2, ACA3 where LNID = 14
P_15 Column 15 Sum of amount in ACA1, ACA2, ACA3 where LNID = 15
P_16 Column 16 Sum of amount in ACA1, ACA2, ACA3 where LNID = 16
P_17 Column 17 Sum of amount in ACA1, ACA2, ACA3 where LNID = 17
P_18 Column 18 Sum of amount in ACA1, ACA2, ACA3 where LNID = 18
P_19 Column 19 Sum of amount in ACA1, ACA2, ACA3 where LNID = 19
P_20 Column 20 Sum of amount in ACA1, ACA2, ACA3 where LNID = 20
P_21 Column 21 Sum of amount in ACA1, ACA2, ACA3 where LNID = 21
P_22 Column 22 Sum of amount in ACA1, ACA2, ACA3 where LNID = 22
P_23 Column 23 Sum of amount in ACA1, ACA2, ACA3 where LNID = 23
P_24 Column 24 Sum of amount in ACA1, ACA2, ACA3 where LNID = 24
P_25 Column 25 Sum of amount in ACA1, ACA2, ACA3 where LNID = 25
P_26 Column 26 Sum of amount in ACA1, ACA2, ACA3 where LNID = 26
P_27 Column 27 Sum of amount in ACA1, ACA2, ACA3 where LNID = 27
P_28 Column 28 Sum of amount in ACA1, ACA2, ACA3 where LNID = 28
P_29 Column 29 Sum of amount in ACA1, ACA2, ACA3 where LNID = 29
P_30 Column 30 Sum of amount in ACA1, ACA2, ACA3 where LNID = 30
P_31 Column 31 Sum of amount in ACA1, ACA2, ACA3 where LNID = 31
P_32 Column 32 Sum of amount in ACA1, ACA2, ACA3 where LNID = 32
P_33 Column 33 Sum of amount in ACA1, ACA2, ACA3 where LNID = 33
P_34 Column 34 Sum of amount in ACA1, ACA2, ACA3 where LNID = 34
P_35 Column 35 Sum of amount in ACA1, ACA2, ACA3 where LNID = 35
P_36 Column 36 Sum of amount in ACA1, ACA2, ACA3 where LNID = 36
P_37 Column 37 Sum of amounts in ACA1, ACA2, ACA3 of LNID P_10, P_11, P_13, P_15, P_17, P_19, P_21, P_22, P_23, P_25, P_27, P_29, and P_31
P_38 Column 38 Sum of amounts in ACA1, ACA2, ACA3 of LNID P_16, P_18, P_20, P_24, P_26, P_28, P_30, P_32, P_33, and P_34, less the amounts in ACA1, ACA2, ACA3 of LNID P_35 and P_36
P_39 Column 10 Sum of amount in ACA1, ACA2, ACA3 where LNID = 39
P_40 Column 11 Sum of amount in ACA1, ACA2, ACA3 where LNID = 40
P_41 Column 12 Sum of amount in ACA1, ACA2, ACA3 where LNID = 41
P_42 Column 13 Sum of amount in ACA1, ACA2, ACA3 where LNID = 42
P_43 Column 14 Sum of amount in ACA1, ACA2, ACA3 where LNID = 43
P_44 Column 15 Sum of amount in ACA1, ACA2, ACA3 where LNID = 44
P_45 Column 16 Sum of amount in ACA1, ACA2, ACA3 where LNID = 45
P_46 Column 46 Sum of amount in ACA1, ACA2, ACA3 where LNID = 46
P_47 Column 47 Sum of amount in ACA1, ACA2, ACA3 where LNID = 47
P_48 Column 48 Sum of amounts in ACA1, ACA2, ACA3 of LNID P_39, P_41, P_43, P_44, P_45, P_46, and P_47
P_49 Column 49 Sum of amount in ACA1, ACA2, ACA3 where LNID = 49
P_50 Column 50 Sum of amount in ACA1, ACA2, ACA3 where LNID = 50
P_51 Column 51 Total amount in ACA1, ACA2, ACA3 of LNID P_38 minus P_48
P_52 Column 52 Sum of amount in ACA1, ACA2, ACA3 where LNID = 52
P_53 Column 53 Sum of amount in ACA1, ACA2, ACA3 where LNID = 53
P_54 Column 54 Sum of amount in ACA1, ACA2, ACA3 where LNID = 54
P_55 Column 55 Sum of amount in ACA1, ACA2, ACA3 where LNID = 55
P_56 Column 56 Sum of amount in ACA1, ACA2, ACA3 where LNID = 56
P_57 Column 57 Sum of amount in ACA1, ACA2, ACA3 where LNID = 57
P_58 Column 58 Sum of amount in ACA1, ACA2, ACA3 where LNID = 58
P_59 Column 59 Sum of amount in ACA1, ACA2, ACA3 where LNID = 59
P_60 Column 60 Sum of amount in ACA1, ACA2, ACA3 where LNID = 60
P_61 Column 61 Sum of amount in ACA1, ACA2, ACA3 where LNID = 61
P_62 Column 62 Sum of amount in ACA1, ACA2, ACA3 where LNID = 62
P_63 Column 63 Sum of amount in ACA1, ACA2, ACA3 where LNID = 63
P_64 Column 64 Sum of amount in ACA1, ACA2, ACA3 where LNID = 64
P_65 Column 65 Sum of amount in ACA1, ACA2, ACA3 where LNID = 65
P_66 Column 66 Sum of amount in ACA1, ACA2, ACA3 where LNID = 66
P_67 Column 67 Sum of amount in ACA1, ACA2, ACA3 where LNID = 67
P_68 Column 68 Sum of amount in ACA1, ACA2, ACA3 where LNID = 68
P_69 Column 69 Sum of amount in ACA1, ACA2, ACA3 where LNID = 69
Pouczenia Constant value '1.0'
Ewidencja
SprzedazWiersz
LpSprzedazy
KodKrajuNadaniaTIN Country on VAT registration number Retrieved from table OCUSMA, Country on VAT registration number
NrKontrahenta VAT registration number Retrieved from table OCUSMA, VAT registration number
NazwaKontrahenta Customer name Retrieved from table OCUSMA, Customer name
DowodSprzedazy Invoice number Retrieved from table FSLEDG
DataWystawienia Invoice Date Retrieved from table FSLEDG, Invoice Date
DataSprzedazy VAT Date Retrieved from table FSLEDG, VAT Date
TypDokumentu Value retrieved from setup in (CRS881) define per VAT code. Accepted value RO, WEW, FP
KorektaPodstawyOpodt Optional not included Not included
GTU_01 Value retrieved from setup in (CMS880) Added and set the value to '1' if the item custom stat number (CSNO) exists in the setup in (CMS880).
GTU_02 Value retrieved from setup in (CMS880) Added and set the value to '1' if the item custom stat number (CSNO) exists in the setup in (CMS880).
GTU_03 Value retrieved from setup in (CMS880) Added and set the value to '1' if the item custom stat number (CSNO) exists in the setup in (CMS880).
GTU_04 Value retrieved from setup in (CMS880) Added and set the value to '1' if the item custom stat number (CSNO) exists in the setup in (CMS880).
GTU_05 Value retrieved from setup in (CMS880) Added and set the value to '1' if the item custom stat number (CSNO) exists in the setup in (CMS880).
GTU_06 Value retrieved from setup in (CMS880) Added and set the value to '1' if the item custom stat number (CSNO) exists in the setup in (CMS880).
GTU_07 Value retrieved from setup in (CMS880) Added and set the value to '1' if the item custom stat number (CSNO) exists in the setup in (CMS880).
GTU_08 Value retrieved from setup in (CMS880) Added and set the value to '1' if the item custom stat number (CSNO) exists in the setup in (CMS880).
GTU_09 Value retrieved from setup in (CMS880) Added and set the value to '1' if the item custom stat number (CSNO) exists in the setup in (CMS880).
GTU_10 Value retrieved from setup in (CMS880) Added and set the value to '1' if the item custom stat number (CSNO) exists in the setup in (CMS880).
GTU_11 Value retrieved from setup in (CMS880) Added and set the value to '1' if the item custom stat number (CSNO) exists in the setup in (CMS880)
GTU_12 Value retrieved from setup in (CMS880) Added and set the value to '1' if the item custom stat number (CSNO) exists in the setup in (CMS880)
GTU_13 Value retrieved from setup in (CMS880) Added and set the value to '1' if any of these conditions are met:
  • The item custom stat number (CSNO) exists in the setup in (CMS880) GTU_13.
  • The service charge (EXCD) exists in the setup in (CMS880) GTU_13 Service Charge.
  • The header charge (CRID) exists in the setup in (CMS880) GTU_13 Header Charge.
  • The line charge (CRID) exists in the setup in (CMS880) GTU_13 Line Charge.
SW Value retrieved from setup in (CMS880) Added and set the value to '1' if the item custom stat number (CSNO) exists in the setup in (CMS880)
EE Value retrieved from setup in (CMS880) Added and set the value to '1' if the item custom stat number (CSNO) exists in the setup in (CMS880)
TP Value retrieved from setup in (CMS880) Added and set the value to '1' if the item custom stat number (CSNO) exists in the setup in (CMS880)
MR_T Value retrieved from setup in (CMS880) Added and set the value to '1' if the item custom stat number (CSNO) exists in the setup in (CMS880)
MR_UZ Value retrieved from setup in (CMS880) Added and set the value to '1' if the item custom stat number (CSNO) exists in the setup in (CMS880)
I_42 Value retrieved from setup in (CMS880) Added and set the value to '1' if the item custom stat number (CSNO) exists in the setup in (CMS880)
I_63 Value retrieved from setup in (CMS880) Added and set the value to '1' if the item custom stat number (CSNO) exists in the setup in (CMS880)
B_SPV Value retrieved from setup in (CMS880) Added and set the value to '1' if the item custom stat number (CSNO) exists in the setup in (CMS880)
B_SPV_DOSTAWA Value retrieved from setup in (CMS880) Added and set the value to '1' if the item custom stat number (CSNO) exists in the setup in (CMS880
B_MPV_PROWIZJA Value retrieved from setup in (CMS880) Added and set the value to '1' if the item custom stat number (CSNO) exists in the setup in (CMS880
MPP Value retrieved from setup in (CMS880) Added and set the value to '1' if these conditions are true:
  • If there is a custom stat number (CSNO) maintained in CMS880 for MPP and the custom stat number matched with any of the item in the invoice. If there are no setup in CMS880 for MPP then it proceeds to next criteria.
  • If invoice is domestic.
  • If invoice amount exceeds 15000 PLN.
KorektaPodstawyOpodt Optional not included Not included
K_10 Column 10 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_11 Column 11 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_12 Column 12 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_13 Column 13 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_14 Column 14 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_15 Column 15 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_16 Column 16 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_17 Column 17 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_18 Column 18 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_19 Column 19 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_20 Column 20 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_21 Column 21 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_22 Column 22 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_23 Column 23 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_24 Column 24 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_25 Column 25 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_26 Column 26 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_27 Column 27 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_28 Column 28 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_29 Column 29 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_30 Column 30 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_31 Column 31 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_32 Column 32 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_33 Column 33 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_34 Column 34 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_35 Column 35 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_36 Column 36 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
SprzedazVAT_Marza Column 399 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
SprzedazCtrl
LiczbaWierszySprzedazy Number of Rows Total number of lines
PodatekNalezny Tax payable Sum of all amounts from K_10 to K_36
ZakupWiersz
LpZakupu Purchase sequential number Running number
KodKrajuNadaniaTIN Country on VAT registration number Retrieved from IDMAS, Country on VAT registration number
NrDostawcy VAT registration number Retrieved from IDMAS, VAT registration number
NazwaDostawcy SINO + VSER
DowodZakupu Invoice number Retrieved from FVATIN and FGLEDG (SINO + VSER)
DataZakupu Invoice Date Invoice Date
DataWplywu VAT Date VAT Date
DokumentZakupu Value retrieved from setup in (CRS881) define per VAT code. Accepted values are MK, VAT_RR, WEW
IMP Value retrieved from setup in (CRS880) Added and set the value to ‘1’ if the VAT code used exist in the setup in (CMS880).
MPP Value retrieved from setup in (CRS880) Added and set the value to ‘1’ if the VAT code used exist in the setup in (CMS880).
K_40 Column 43 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_41 Column 43 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_42 Column 43 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_43 Column 43 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_44 Column 44 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_45 Column 45 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_46 Column 46 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
K_47 Column 47 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
ZakupVAT_Marza Column 499 Sum of VAT Base amount (ACA1), VAT Payable (ACA2), VAT Receivable (ACA3).
ZakupCtrl
LiczbaWierszyZakupow Number of rows Number of lines
PodatekNaliczony Total (input) Tax Charged Sum of value in table FVATIN.ACA2 + ACA3

Settings

Several settings should be defined for the SAF-T, including 'Taxation Reporting. Open Report Fields' (TXS035), 'Business Message Data Translation. Displ' (CRS881) , 'Business Message Mapping. Open' (CMS880), and 'VAT report template. Connect lines' (TXS008).

Report fields for taxation reporting in (TXS035)

  1. All the additional field numbers 939-950 should be defined for base country PL and Transaction Type 4.

Set up MAG JPK file

  1. MAG JPK files are composed of 4 sections (PZ, WZ, RW, MM). Each section should define the transaction types that are to be included in each section by setting up transaction types in 'Business Message Data Translation. Displ' (CRS881/CRS882).

  2. Run (AAS380) once to automatically create the header record for translation in (CRS881). After the first (AAS380) run, select the the record in (CRS881) and specify these values:

    MSTD

    Message standard , set it to M3BE

    MVRS

    Version, set it to 1

    BMSG

    Message, set it to PL-MAG_JPK

    IBOB

    I/O , set it to O

    ELMP

    (leave blank)

    ELMD

    Data element , set it to PZ, WZ, RW, MM

  3. Use related option 11= 'Translate' on (CRS881/B) to start (CRS882).

  4. In (CRS882), specify the translation by using these values:

    EXTP

    External partner (leave blank)

    MVXD

    M3 data, enter TTYP that will be included in each section (PZ, WZ, RW, MM)

    MBMD

    Message data (leave blank)

Set up VAT JPK file

  1. In the VAT JPK file, identify which Customer/Payer and Supplier/Payee should be used for element NazwaNabywcy (either Customer or Payer) and for element NazwaWystawcy (either Supplier or Payee) by setting the value 1 on these elements in 'Business Message Data Translation. Displ' (CRS881).

  2. Run (AAS380) once to automatically create the header record for translation in CRS881.

    After the first (AAS380) run, select the record in (CRS881) and specify these values:

    MSTD

    Message standard, set it to M3BE

    MVRS

    Version, set it to 1

    BMSG

    Message, set it to PL-VAT_JPK

    IBOB

    I/O, set it to O

    ELMP

    Parent elements, set it to SprzedazWiersz

    ELMD

    Data element, set it to NazwaNabyw

  3. Use related option 11='Translate' on (CRS881/B) to start (CRS882).

  4. In (CRS882), specify the translation by using these values:

    EXTP

    External partner (leave blank)

    MVXD

    M3BE data, Set to 1 if Payer will be used, otherwise leave it blank or set it to 0 if a Customer will be used.

    MBMD

    Message data (leave blank)

  5. Run (AAS380) once to automatically create the header record for translation in (CRS881).

  6. Select the record in (CRS881) and specify these values:

    MSTD

    Message standard, set it to M3BE

    MVRS

    Version, set it to 1

    BMSG

    Message, set it to PL-VAT_JPK

    IBOB

    I/O, set it to O

    ELMP

    Parent elements, set it to SprzedazWiersz

    ELMD

    Data element, set it to NazwaWystawcy

  7. Use related option 11='Translate' on (CRS881/B) to start (CRS882).

  8. In (CRS882), specify the translation by entering these values:

    EXTP

    External partner (leave blank)

    MVXD

    M3 data, set to 1 if Payee will be used, otherwise leave blank or set it to 0 if Supplier will be used.

    MBMD

    Message data (leave blank)

  9. Run (AAS380) once to automatically create the header record for translation in (CRS881).

  10. Select the record in (CRS881) and specify these values:

    MSTD

    Message standard, set it to M3BE

    MVRS

    Version, set it to 1

    BMSG

    Message, set it to PL-VAT_JPK

    IBOB

    I/O, set it to O

    ELMP

    Parent elements, set it to ZakupWiersz

    ELMD

    Data element, set it to NazwaWystawcy

  11. Use related option 11='Translate' on (CRS881/B) to start (CRS882).

  12. In (CRS882), specify the translation by entering these values:

    EXTP

    External partner (leave blank)

    MVXD

    M3 data, set to 1 if Payee will be used, otherwise leave blank or set it to 0 if Supplier will be used.

    MBMD

    Message data (leave blank)

Set up FA JPK file

  1. Identify which VAT codes will be used in checking for element P_17, P_18, P_19, P_20, P_3A, P_106E_2, P_106E3 by setting up VAT codes in 'Business Message Data Translation. Displ' (CRS881/CRS882).

    Run (AAS380) once to automatically create the header record for translation in (CRS881).

  2. Select the record in (CRS881) and specify these values:

    MSTD

    Message standard, set it to M3BE

    MVRS

    Version, set it to 1

    BMSG

    Message, set it to PL-FA_JPK

    IBOB

    I/O, set it to O

    ELMP

    Parent elements, set it to Faktura

    ELMD

    Data element, set it to P_17, P_18, P_19, P_20, P_3A, P_106E_2, P_106E3

  3. Use related option 11='Translate' on (CRS881/B) to start (CRS882).

  4. In (CRS882), specify the translation by using these values:

    EXTP

    External partner (leave blank)

    MVXD

    M3 data, set to VAT Code

    MBMD

    Message data (leave blank)

In (CMS880), carry out these steps:
  1. Run (AAS380) once to automatically create the header record for translation in 'Business Message Mapping. Open Details' (CMS881).
    • Identify which VAT code will be used in checking for element P_22 of Faktura.
    • Identify which VAT code will be used in checking for element P_12_XII of FakturaWiersz and element P_12Z_XII of ZamowienieWiersz.
  2. Select the record in (CMS880) and with specific element to maintain and use related option 11='Translate' on (CMS880/B) to start (CMS881).
  3. In (CMS881), specify the translation by using these values:
    Note: M3 value from and to should be the same as we are using 1 is to 1 relation and not range.
    MVLF
    M3 value from should contain VAT code for element P_22 and P_12_XII.
    MVLT
    M3 value to should be the same value as entered in 'M3 value from'.
    MBMD
    Data element value Description.

Set up V7M JPK file

In (CRS881), carry out these steps:

  1. Identify which VAT codes will be used in checking for element TypuDOkumentu, DokumentZakupu by setting up VAT codes in 'Business Message Data Translation. Displ' (CRS881/CRS882).

    Run (AAS380) once to automatically create the header record for translation in (CRS881).

  2. Select the record in (CRS881) and specify these values:
    MSTD
    Message standard - set to M3BE
    MVRS
    Version - set to 1
    BMSG
    Message - set to PL-V7M_JPK
    IBOB
    I/O - set to O
    ELMP
    Parent elements - set to Faktura
    ELMD
    Data element - set to TypuDOkumentu, DokumentZakupu.
  3. Use related option 11='Translate' on (CRS881/B) to start (CRS882).
  4. In (CRS882) specify the translation by using these values:
    EXTP
    External partner (leave blank)
    MVXD
    M3 data, set to VAT Code
    MBMD
    Message data RO, WEW, FP (for TypuDOkumentu) and MK, VAT_RR, WEW (for DokumentZakupu)

In (CMS880) carry out these steps:

  1. Run (AAS380) once to automatically create the header record for translation in 'Business Message Mapping. Open Details' (CMS881).
    • Identify which Custom statistic number will be used in checking for element GTU_01, GTU_02, GTU_03, GTU_04, GTU_05, GTU_06, GTU_07, GTU_08, GTU_09, GTU_10, GTU_11, GTU_12, B_MPV_PROWIZJA, EE, MPP, MR_T, MR_UZ, SW of SprzedazWiersz.
    • Identify which customer payment method will be used in checking for element B_SPV, B_SPV_DOSTAWA of SprzedazWiersz.
    • Identify which VAT code will be used in checking for element I_42, I_63 of SprzedazWiersz.
    • Identify which customer will be used in checking for element TP of SprzedazWiersz.
    • Identify which supplier payment method will be used in checking for element MPP of ZakupWiersz.
    • Identify which VAT code will be used in checking for element IMP of ZakupWiersz.
    • Identify which Custom statistic number / service charge / header charge / line charge will be used in checking for element GU_13 of SprzedazWiersz.
  2. Select the record in (CMS880) and with specific element to maintain and use related option 11='Translate' on (CMS880/B) to start (CMS881).
  3. In (CMS881) specify the translation by using these values:
    Note: M3 value from and to should be the same as we are using 1 is to 1 relation and not range
    MVLF
    M3 value from, should contain custom statistic number/service charge/header charge/line charge payment method/VAT code/customer, depending on element being maintained.
    MVLT
    M3 value to same value entered in ‘M3 value from'.
    MBMD
    Data element value Description.

VAT report template

Field elements in the VAT JPK File will be based on VAT reporting in 'VAT Report Template. Open' (TXS008).

It is important that electronic VAT report is created based on the report template created. The report template will determine what transactions will be included for each element in the XML file.

  1. Open 'VAT Report Template. Connect Lines' (TXS008).

  2. The Line ID rep (LNID) pertains to each element of the XML.

  3. An example here is Line ID rep 10 refers to K_10 element. Set this for K_10 to K_38 and K_42 to K_48.