JPK_V7 Default Data Sources

Owned by Lou Dizon
Last updated: Mar 14, 2024 by Kiro Franco
1 min read
Version Date Comment
Current Version (v. 7) Mar 14, 2024 07:48 Kiro Franco
v. 6 Mar 14, 2024 07:41 Kiro Franco
v. 5 Jan 28, 2022 08:43 Jhelver Layderos
v. 4 Jan 28, 2022 08:36 Jhelver Layderos
v. 3 Jan 28, 2022 08:31 Jhelver Layderos
v. 2 Jan 28, 2022 08:28 Jhelver Layderos
v. 1 Oct 15, 2021 07:09 Lou Dizon

Tax Position Mapping

The table below shows the common mapping of the NetSuite tax codes against the JPK_VAT position:

Tax Label

Tax Rate

Notional Rate

Position

FA-PL

23%

0%

40-41

I-PL

23%

0%

25-26,42-43

S-PL

23%

0%

19-20,42-43

R-PL

8%

0%

17-18,42-43

R1-PL

5%

0%

15-16,42-43

E-PL

0%

0%

10,42-43

ER-PL

0%

8%

21,23-24,42-43

ES-PL

0%

23%

21,23-24,42-43

ESSP-PL

0%

23%

29-30,42-43

ESSS-PL

0%

23%

11,12

EZ-PL

0%

0%

21,23-24,42-43

IS-PL

0%

23%

27-28,42-43

O-PL

0%

0%

22

OS-PL

0%

0%

11

RC-PL

0%

23%

13

Z-PL

0%

0%

13,14,42-43

You may create or rename the tax labels based on their preferences as long as they ensure that they map it with the correct JPK_VAT position.

Including Journal Entries in JPK_V7

For journal entries to be included in the JPK_V7 XML file:

  • Select a tax code mapped with JPK_VAT Position in the VAT column.

  • And, select either of the following in the [STA] VAT Txn Type PL column:

    • Sales; or

    • Purchase

Sales Data Sources for JPK_V7

XML Tag

NetSuite Field

KodKrajuNadaniaTIN

  • For sales transactions:

    • Customer: Country Code

  • For purchase transactions:

    • Vendor: Country Code

    • Vendor Line: Country Code

NrKontrahenta

  • For sales transactions:

    • Customer: Tax Number

  • For purchase transactions:

    • Vendor: Tax Number

    • Vendor Line: Tax Number

If blank, “BRAK”.

NazwaKontrahenta

  • For sales transactions:

    • Customer: Company Name

  • For purchase transactions:

    • Vendor: Company Name

    • Vendor Company Name

If blank, “BRAK”.

DowodSprzedazy

Document Number, if blank, “BRAK”

DataWystawienia

Document Date, if blank, Transaction Date

DataSprzedazy

Delivery or Receipt Date

KorektaPodstawyOpodt

Tax Base Adjustment

Purchase Data Sources for JPK_V7

XML Tag

NetSuite Field

KodKrajuNadaniaTIN

Vendor: Country Code

Vendor Line: Country Code

NrDostawcy

Vendor: Tax Number or

Vendor Line: Tax Number

If blank, “BRAK”.

NazwaDostawcy

Vendor: Company Name

Vendor Line: Company Name

If blank, “BRAK”.

DowodZakupu

Document Number, if blank, “BRAK”

DataZakupu

Document Date, if blank, Transaction Date

DataSprzedazy

Delivery or Receipt Date

Send an email to support@staria.com for questions or concerns regarding this topic.

© 2023 Staria. All rights reserved. No part of this publication may be reproduced, distributed, or transmitted in any form or by any means, including photocopying, recording, or other electronic or mechanical methods, without the prior written permission of the publisher.