Versions Compared

Version Old Version 4 New Version 5
Changes made by

Kiro Franco (Unlicensed)

Kiro Franco (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents

Feature Overview

The Journal Evidence Report records all financial transactions as they occur chronologically, given a specific reporting period for an entity. It is used to reconcile its turnovers with the balances of the general ledger accounts. This report meets the basic legal requirements of the Polish Accounting Act:

  • Entries in the report are numbered consecutively, and

  • The sums of entries (turnovers) are counted continuously.

  • The entries are linked to verified and approved accounting documents.

  • The entries are automatically assigned a number based on when it was entered into the journal.

  • The accounting program used and the person responsible for the entered content are defined.

Benefits

  • Maintaining a Historical Record: The report is a chronological record of all financial transactions, essential for tracking the company's financial history.

  • Supporting Documentation: The entries include references to supporting documents, which are vital for auditing and verification.

  • Compliance and Reporting: It ensures compliance with Polish accounting principles and aids in preparing accurate financial reports.

Configuring the Journal Evidence Report

To configure the report:

  1. Navigate to Setup > Staria Poland Localization > Poland Localization Settings.

    1. If you are creating a new Localization Setting, refer to Setting Up Poland Localization

  2. Click Edit beside the localization setting record you wish to modify.

  3. Under the Journal Evidence tab, provide the following details:

    1. Folder ID - Enter the internal ID of a File Cabinet folder where the generated reports are stored and saved.

    2. Saved Search - Select the saved search to be used as the data source of the report. By default, the value of this field should be PL Domyślny raport dowodowy dziennika.

    3. Report Page Size - Select the page size for generating the report. The default value is A3 (297 mm x 420 mm).

  4. Optionally, you may also configure the following fields:

    1. Report by Period - Check this box to report by period. If left unchecked, the report is run based on the transaction date.

    2. Default Email Sender - Select the default employee to be used as the sender of email notifications. If left blank, no email notifications are sent. Please ensure that an email address is set for the selected employee. Otherwise, an email error will occur.

    3. Optional Report Column - Enter the column label of the optional column to be added to the report. This references the default saved search column corresponding to the custom segment. The default value of this field is “customSegment.” The optional column will be added after the Department, Class, and Location columns.

    4. Optional Report Column Label - English - Enter the name of the optional report column in English. This is used as the column header when printing the PDF in English.

    5. Optional Report Column - Polish - Enter the name of the optional report column in Polish. This is used as the column header when printing the PDF in Polish.

Customizing the Default Saved Search

The Poland Localization bundle includes a default saved search named PL Domyślny raport dowodowy dziennika.

...

  1. Review the modified search one last time and then hit Save. You may now use the modified search on your Poland Localization Settings.

Assigning Value to the Optional Report Column

When using the optional report column feature, you must customize your saved searches with the proper field reference to display the correct value. Follow the steps indicated in Customizing the Default Saved Search and ensure that the correct field ID is referenced on the Formula column for the Formula (Text) field with a label of customSegment.

...

Note

Please note that the field IDs shown in the example are not the exact field IDs in your system. Custom fields and segments may have a field ID different from the ones shown.

Default Search Configuration

The default configuration of the default searches is shown below:

PL Domyślny raport dowodowy dziennika

Field

Formula

Custom Label

Date

PostingDate

Formula (Date)

DocumentDate

Formula (Text)

{createdby}

UserID

Transaction Number

DocumentNumber

Account : Number

GLAccount

Formula (Text)

SUBSTR(COALESCE({memo},{memomain}),0,40)

Description

Amount (Debit)

AmountDebit

Amount (Credit)

AmountCredit

Line Unique Key

EntryNo

Formula (Text)

customSegment

Formula (Text)

{departmentnohierarchy}

department

Formula (Text)

{classnohierarchy}

class

Formula (Text)

{locationnohierarchy}

location

Formula (Text)

{mainname}

name

Formula (Text)

{postingperiod}

accountingPeriod

Generating the Journal Evidence Report

To generate a journal evidence report:

...

Note

It's important to note that discrepancies can occur between the Generated Date in the record and the Generated Date in the file when the server's time zone and the current user's time zone under user preferences are different. The Generated Date in the file will always follow the time zone of the server, while the Date and Time shown in NetSuite will always follow the user preference. However, if the user preference is switched to the server's timezone, both values should be the same.

Viewing the Journal Evidence Report

Once a file is generated, you may download the file under the PDF field or click on the link to see a preview of the file. The report is divided between a report header and a report line section. The contents of each section are explained below.

Report Header Information

  • Report Name: This details the type of report generated, namely the General Ledger Report.

  • Report Period: This displays the date range of the transactions included in the report.

  • Subsidiary Legal Name: This displays the legal name of the selected subsidiary during report generation.

  • Subsidiary Address: This displays the address of the selected subsidiary.

  • Total Report Pagination: This displays the pagination of the overall file.

  • Date Generated: This displays the date the system generated the report.

  • Generated By: This displays the NetSuite employee who generated the report.

Report Line Information

The generated journal evidence report contains the following report line information:

...