Create XML file for Polish Tax Authorities
Follow these steps
- Open 'Standard Audit File for Tax. Generate' (AAS380) to specify selections for the invoices to be included in the report.
- Select 'Output file rep'.
- Select the check box 'Correction' to determine the type of file (correction or not).
- Specify 'VAT Run' (this is only available for VAT, FA, and V7M files).
- 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.
- Specify 'Base country'. Set to PL (Poland) as recommended (only available for EWP, KR, MAG, and WB files).
- Specify 'Invoice date range' from and to (optional field and only available for FA file).
- Specify 'Accounting date range' from and to (optional field and only available for FA file).
- Specify 'VAT date range' from and to (optional field and only available for FA file).
- Specify 'Delivery date range' from and to (optional field and only available for FA file).
- Specify 'Warehouse' (this is only available for MAG files).
- Specify 'Bank Account ID' (this is only available for WB files).
- Specify 'File name' (must end with .XML).
- 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.
- 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 |
|
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 |
|
|
P_11A |
|
|
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' | |
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:
|
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:
|
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)
-
All the additional field numbers 939-950 should be defined for base country PL and Transaction Type 4.
Set up MAG JPK file
-
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).
-
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
-
Use related option 11= 'Translate' on (CRS881/B) to start (CRS882).
-
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
-
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). -
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
-
Use related option 11='Translate' on (CRS881/B) to start (CRS882).
-
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)
-
Run (AAS380) once to automatically create the header record for translation in (CRS881).
-
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
-
Use related option 11='Translate' on (CRS881/B) to start (CRS882).
-
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)
-
Run (AAS380) once to automatically create the header record for translation in (CRS881).
-
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
-
Use related option 11='Translate' on (CRS881/B) to start (CRS882).
-
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
-
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).
-
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
-
Use related option 11='Translate' on (CRS881/B) to start (CRS882).
-
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)
- 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.
- Select the record in (CMS880) and with specific element to maintain and use related option 11='Translate' on (CMS880/B) to start (CMS881).
- 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:
- 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).
- 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.
- Use related option 11='Translate' on (CRS881/B) to start (CRS882).
- 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:
- 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.
- Select the record in (CMS880) and with specific element to maintain and use related option 11='Translate' on (CMS880/B) to start (CMS881).
- 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.
-
Open 'VAT Report Template. Connect Lines' (TXS008).
-
The Line ID rep (LNID) pertains to each element of the XML.
-
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.