You can generate a list summarizing all G/L account and/or business partner balances in SAP Business One for specific dates.
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.
To export data files containing Hebrew correctly, the SAP Business One display language must be Hebrew.
From the SAP Business One Main Menu, choose
. Alternatively, choose . The Query–Selection Criteria window appears.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.
Choose the OK button. The Open Interface – Trial Balance window appears.
Choose the OK button.
A Windows Explorer window opens, enabling you to save the list as a txt. format file.