Versions Compared

Version Old Version 8 New Version 9
Changes made by

Kiro Franco

Kiro Franco

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Table of Contents

Table of Contents
minLevel1
maxLevel6
include
outlinefalse
indent
styledefault
excludeTable of Contents
typelist
class
printablefalse

...

Overview

General Ledger is a complete record of transactions per account. It shows transactions sorted and subtotaled by account during a fiscal period or other period you specify.

The general ledger is already available in NetSuite. However, the standard version of this report does not have all the details required to meet the rules of Poland, which needs a more detailed analysis of accounts. To fix this, extra information is included in a new version of the General Report specifically designed for reporting in Poland.

Configuring the General Ledger

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.

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

  3. Under the General Ledger 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 [STA] PL General Ledger. The saved search must be [STA] PL General Ledger (Multi-book) if the multi-book feature is enabled.

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

    4. 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.

    5. 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.

    6. 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.

    7. PDF Template - Select the advanced PDF template for generating the report. If left empty, the default PDF template is used to generate the report.

Customizing the Default Saved Search

The Poland Localization bundle includes a default saved search named [STA] PL General Ledger and another default saved search for multi-book accounting-enabled accounts named [STA] PL General Ledger (Multi-Book).

...

Field

Formula

Custom Label

Multi-Book Accounting Transaction : Account

account

Date

postingDate

Formula (Date)

{trandate}

transactionDate

Period

period

Type

type

Transaction Number

documentNumber

Memo

memo

Department (no hierarchy)

department

Class (no hierarchy)

class

Location (no hierarchy)

location

Main Line Name

name

Created By

createdBy

Multi-Book Accounting Transaction : Amount (Debit)

amountDebit

Multi-Book Accounting Transaction : Amount (Credit)

amountCredit

Formula (Text)

customSegment

Generating the General Ledger

To generate the general ledger:

...

  1. The page will automatically refresh once the process is complete. Optionally, you may click the Refresh button. After the process, a prompt will be shown in the banner, whether successful or unsuccessful.

    1. If successful, the Status is set to Complete, and the file can be downloaded under the PDF field.

    2. If unsuccessful, the Status is set to Failed or Complete-With Error, and an error message is displayed under the banner.

  2. Additionally, the following fields are updated for each run:

    1. Generated By - This is the user that clicked the Generate Report button. The same user is printed on the report under the Generated By section in the PDF report.

    2. Generated Date - This is the date the report generation finished. The same date is printed on the report under the Generation Date section.

Viewing the General Ledger 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.

...