PL_JPK_KR_PD - Dziennik Fields and Default Mapping

PL_JPK_KR_PD - Dziennik Fields and Default Mapping


The Dziennik section includes a detailed list of all journal entries and posting transactions relevant to the reporting period. Each entry provides information such as account, amount, reference, and type. It reflects the general ledger movement within the defined period.

This section is generated based on a dataset defined in the Poland Localization Settings → JPK_KR_PD → JPK_KR_PD Dziennik Dataset ID.

Below is the standard mapping based on the default dataset:

Field Name

Field Description

Default Mapping

Default Mapping Description

Notes & Compliance Guidance

Field Name

Field Description

Default Mapping

Default Mapping Description

Notes & Compliance Guidance

D_1

Sequential journal number formatted like “1/Zak/01/2025”

{custbody_sta_pl_gaplessnumber}

Displays the gapless number per journal type.

Example format: 1/Zak/01/2025

Create a gapless, human-readable journal number per journal type. Often used for auditing.

By default, this is mapped to Staria’s Poland Localization gapless numbering system.

If you are using your own gapless numbering setup, you must update the mapping accordingly. Create a custom version of the dataset in NetSuite, and assign this custom dataset in the Poland Localization Settings.

If your existing transactions do not currently use any gapless numbering system, you should review this requirement and plan how to implement it to ensure compliance.

D_2

Journal description like “Purchase” or “Sales”

TO_CHAR({custbody_spl_je_type#display})

Displays the name of the journal type selected in the new custom field on the transaction record.

Examples: Purchase, Sales, General Journal.

By default, this is mapped to Staria’s Poland Localization custom field for Journal Type.

If you are using your own Journal Type configuration, update the mapping to reflect your setup. Create a custom version of the dataset in NetSuite and assign it in the Poland Localization Settings.

If your existing transactions do not currently use any Journal Type field, review this requirement and plan for its implementation to ensure compliance.

D_3

Unique counterparty (customer/vendor) ID

COALESCE(TO_CHAR({transactionlines.entity^entity.id}),TO_CHAR({entity^entity.id}))

Uses the line-level entity ID if available, otherwise the header-level one.

 

D_4

Document number assigned by the issuer

{tranid}

Displays the internal transaction number (e.g., invoice number).

Uses the transaction number, e.g., invoice number: F-10023/07/2025.

D_5

Type of accounting document (e.g. invoice, receipt)

{custbody_spl_acc_ev_type#display}

Displays the label or name of the accounting document type selected from the new custom field on the transaction.

Examples: Invoice, Cash Receipt, Credit Note.

By default, this is mapped to Staria’s Poland Localization custom field for Accounting Evidence.

If you are using your own Accounting Evidence Type configuration, update the mapping to reflect your setup. Create a custom version of the dataset in NetSuite and assign it in the Poland Localization Settings.

If your existing transactions do not currently use any Accounting Evidence Type field, review this requirement and plan for its implementation to ensure compliance.

D_6

Date the business transaction happened

TO_CHAR({trandate},'YYYY-MM-DD')

Converts transaction date to YYYY-MM-DD format.

Represents the economic event date. Should reflect when goods/services were delivered.

D_7

Date the accounting document was prepared

TO_CHAR({createddate},'YYYY-MM-DD')

Converts document creation date to YYYY-MM-DD format.

When the transaction was entered into NetSuite.

D_8

Date entry was recorded in the books

TO_CHAR({transactionlines.accountingimpact.glauditnumberdate},'YYYY-MM-DD')

Converts journal posting date to YYYY-MM-DD format.

Useful for identifying timing differences between creation and posting.

If you are not using the GL audit numbering in NetSuite, you need to remap to your existing “posting date” field.

D_9

Name of the person responsible for the entry

NVL({nextapprover#display},{createdby#display})

Shows the next approver’s name, or the creator if not approved yet.

 

D_10

Business transaction description (max 512 chars)

SUBSTR(COALESCE({transactionlines.memo},{memo}),1,512)

Uses the line memo if present, otherwise the header memo.

Prefer line-level memo for more accuracy. Example: Invoice for order #7894 - July supplies.

D_11

Amount of the transaction (PLN)

{custrecord_sta_pl_corrected_invoice<customrecord_pl_transaction_details.custrecord_sta_pl_ksef_ref_num}

Retrieves value from custom linked record field.

 

D_12

Invoice number from KSeF (if applicable)

{custbody_sta_pl_transaction_details.custrecord_sta_pl_ksef_ref_num}

Displays the KSeF invoice number if the invoice was issued through the KSeF system. This field will only populate correctly if the new KSeF feature is implemented alongside the JPK_KR_PD report. If a different solution is used for KSeF integration, this field must be remapped to the appropriate source field accordingly.

Available only if KSeF integration is enabled. If you're using a different solution, remap this field accordingly.

Z_1

Entry line sequence number

SUBSTR(TO_CHAR({transactionlines.linesequencenumber}+1),1,256)

Converts the line number to text, starts from 1.

Used to sequence lines within each journal entry. Starts from 1.

Z_2

Entry line description

SUBSTR(COALESCE({transactionlines.memo},{memo}),1,512)

Shows memo at line level if available, or header memo.

Recommended to use descriptive memos, e.g., Raw materials for PO#1234.

Z_3

Final G/L account name/number

SUBSTR({transactionlines.accountingimpact.account#display},1,256)

Displays the name or number of the account affected.

Make sure G/L account names follow a clear naming convention for audit readiness.

Z_4

Debit amount

TO_CHAR({transactionlines.accountingimpact.debit})

Converts the debit amount to text.

 

Z_5

Debit amount in foreign currency (if applicable)

CASE WHEN {currency.symbol} <> 'PLN' AND TO_CHAR({transactionlines.accountingimpact.debit}) IS NOT EMPTY THEN TO_CHAR({transactionlines.foreignamount}) ELSE '' END

If currency isn’t PLN and there’s a debit amount, show the foreign currency value.

 

Z_6

Foreign currency code for debit (optional)

CASE WHEN {currency.symbol} <> 'PLN' AND {transactionlines.accountingimpact.debit} IS NOT EMPTY THEN TO_CHAR({currency.symbol}) ELSE '' END

Shows the foreign currency (e.g., USD) used for the debit if not PLN.

 

Z_7

Credit amount

TO_CHAR({transactionlines.accountingimpact.credit})

Converts the credit amount to text.

 

Z_8

Credit amount in foreign currency (if applicable)

CASE WHEN {currency.symbol} <> 'PLN' AND {transactionlines.accountingimpact.credit} IS NOT EMPTY THEN TO_CHAR(ABS(TO_NUMBER({transactionlines.foreignamount}))) ELSE '' END

Shows the foreign currency amount (positive value) for credit if currency ≠ PLN.

 

Z_9

Foreign currency code for credit (optional)

CASE WHEN {currency.symbol} <> 'PLN' AND {transactionlines.accountingimpact.credit} IS NOT EMPTY THEN TO_CHAR({currency.symbol}) ELSE '' END

Displays the foreign currency used for the credit amount if not PLN.

 

©2024 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.