Páginas filhas
  • Trial ledger (FINR550 - SIGAFIN)

Note

This routine was adjusted to comply with the General Personal Data Protection Law (Statute no. 13.70), so that some fields containing data regarded as sensitive and/or personal are blurred, becoming illegible.


01. OVERVIEW

This report presents the trial ledger of Customers or Suppliers, and it can be printed both in detail or summarized.

The parameters of the report establish the presentation of all customers' or suppliers' transactions in a certain period, or only the original values. It is also possible to select bills types and the customers' or suppliers' accounting balance statement.

Important

When integrating Easy Export Control, you can generate the report using Posting Reason? set to EEC.

02. EXAMPLE OF USE


To issue the trial ledger:

1.In the Trial ledger report, click Parameters.

A screen is displayed to configure report parameters.

2. Configure the parameters according to the field's help instructions.

Check the parameter Group stores?, which allows you to group bills and totalizators for all stores by supplier/customer.


Important

Grouping by stores (customer/supplier) is not performed if the Filter ledger accounts? parameter is set to Yes.


3. Check the configurations and confirm printing.

03. QUESTIONS

Question

Help

From

Enter the start date of the issue dates interval to get the desired result.
Note: Filtering will happen on fields E1_EMIS1, E2_EMIS2, and E5DTDIGIT.

To the date

Enter the end date of the issue dates interval to get the desired result.
NOTE: If the system base date is before the To the date, the base date will be considered as the end date.

From portfolio

Enter if the portfolio to be considered for generating the report is "Receivable" or "Payable".

From code

Enter the start code of the customers or suppliers' code interval to be considered in the report.

To code

Enter the end code of the customers or suppliers' code interval to be considered in the report.

Print Fin. Vl

Select "Yes" to print the financial value in the trial ledger. Otherwise, select "No".

Print

Select if the trial ledger will be printed with bill types "All", "Regular" or just "Advances".

From prefix

Enter the start code of the bills' prefixes interval to be considered for report generation.

To Prefix

Enter the end code of the bills' prefixes interval to be considered for report generation.

List by

Select if the ledger will be listed considering the current branch or "By Company", meaning all branches.

Select Types

Select "Yes" if the bills must be selected by type. Otherwise, select "No".

From Class

Select the start code of the classes code range to be considered in the report. The [F3] key is available to query the Classes File.

To Class

Select the end code of the classes code range to be considered in the report. The [F3] key is available to query the Classes File.

Print Report

Select if the report will be printed in detail, displaying the information for transactions that build up the customers or suppliers' balances, or summarized, displaying only the totals by customer or supplier according to the portfolio selected.

Filt. Pref. to Prev. Bal.

Select "Yes" for the report to consider the prefixes entered in the prefixes range when building up the customer or supplier's previous balance.

From page

Enter the number of the initial page to be printed in the first report page

To page

Enter the number of the final page to be printed in the last report page

Filter ledger accounts

Select "Yes" to filter the ledger accounts entered in the customer or supplier's file.

Initial account

Enter the initial account of the ledger accounts interval entered in the customer or supplier's registration that you wish to filter if the previous question is set to "Yes"

Final account

Enter the final account of the ledger accounts interval entered in the customer or supplier's file to be filtered if the previous question is set to "Yes"

Print acct. balance

Select "Yes" to print the accounting balance of the customer or supplier account entered in the record.

Print Cust/Sup w/o Trans.

Select "Yes" to print customers/suppliers that have a previous balance, but do not have financial transactions in the period entered. Otherwise, select "No".

Rows by page

Enter the number of rows to be printed. If this is not entered, the system will consider 75 rows in the portrait mode and 58 rows in the landscape mode.

History

Enter the number of rows to be printed. If this is not entered, the system will consider 75 rows in the portrait mode and 58 rows in the landscape mode.

Group stores

This determines if the stores must be grouped.

04. TABLES USED

  • SE1 – Accounts receivable
  • SE2 – Accounts Payable
  • SE5 – Bank Transactions
  • SA1 – Customers     
  • SA2 – Suppliers

05. MORE INFORMATION

Default Report Configuration
Custom report configuration