Versions Compared

Version Old Version 11 New Version Current
Changes made by

Kiro Franco

Lou Dizon

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.

...

  • Type: This displays the transaction type of the line.

  • Transaction Date: This displays the actual date of the transaction. The format of this date depends on the user preference of the employee who generated the report.

  • Posting Date: This displays the posting date of the transaction. The format of this date depends on the user preference of the employee who generated the report.

  • Period: This displays the transaction's posting period. This column has a maximum width of ten (10) characters.

  • Document Number: This displays the document number in the NetSuite system. This column has a maximum width of twenty-five (25) characters without the optional column and fifteen (15) characters with the optional column.

  • Name: This displays the relevant entity for the transaction.

  • Memo: This displays the memo associated with the transaction.

  • Department: This displays the Department set on the transaction. This column has a maximum width of fifteen (15) characters. Anything beyond is subject to truncation.

  • Class: This displays the Class set on the transaction. This column has a maximum width of fifteen (15) characters. Anything beyond that is subject to truncation.

  • Location: This displays the Location set on the transaction. This column has a maximum width of fifteen (15) characters. Anything beyond that is subject to truncation.

  • Optional Column: This displays the optional column value set on the transaction. This column has a maximum width of fifteen (15) characters. Anything beyond that is subject to truncation. Note that this field is only shown if configured on the Poland Localization Settings.

  • Created By: This displays the NetSuite employee who made the transaction.

  • Debit: This displays the debit balance of the transaction.

  • Credit: This displays the credit balance of the transaction.

  • Balance: This displays the running balance of the report on a per-entity basis.

Example

Attachments
Note

Date Range Limitation: The maximum report date range may vary based on transaction volume and text field length. High transaction counts and lengthy text fields can reduce the allowable date range, potentially causing errors during report generation.

Recommendation To avoid errors, users should reduce the report date range, which can help prevent script issues and ensure successful report generation.

...

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