Show TOC

Procedure documentationGenerating a List of Balances Locate this document in the navigation structure

 

You can generate a list summarizing all G/L account and/or business partner balances in SAP Business One for specific dates.

Note Note

This system query includes all G/L accounts and business partner master data within the specified date range except for control accounts with amounts.

End of the note.

Prerequisites

To export data files containing Hebrew correctly, the SAP Business One display language must be Hebrew.

Procedure

  1. From the SAP Business One Main Menu, choose   Financials   Financials Reports   Accounting   Open Interface—Trial Balance  . Alternatively, choose   Tools   Queries   System Queries   Open Interface—Trial Balance  . The Query–Selection Criteria window appears.

  2. Specify one or more of the following date ranges to restrict the transactions in the report:

    • Posting Date From...To...

    • Due Date From...To...

    • Document Date From...To...

    By default, the posting date is the current date. Change it if necessary. The due date is the date on which the entry takes place. The document date is the journal entry date for tax reporting purposes.

  3. Choose the OK button. The Open Interface – Trial Balance window appears.

  4. Choose the OK button.

Result

A Windows Explorer window opens, enabling you to save the list as a txt. format file.