Sales ledger export (window)

Economy > Sales ledger export

In this window, the accounting document is to be exported is created. The information to be included in the documented is first collected by clicking on File > Create export. That document will be at the top of the list and can be exported as many times as needed without its content being changed.

Accounting documents that have been created previously can also be exported by selecting them in the list, clicking on Exports and choosing one of the options.

For instructions on how to create and export a sales ledger, seeExporting accounting records.

Menu options

Function	Explanation
File	Create export: Opens the Create export window, see Create export (window). Close: Closes the window without creating any accounting documents, and without exporting any files.
Exports	Export: Opens the Export window, see Export (window). Invoice journal: The document is exported directly to Excel. Invoice journal (customer summary): The document is exported directly to Excel. Payment journal: The document is exported directly to Excel. Supplier bill list: The document is exported directly to Excel. Choose one of the following ways to group the information in the Export window: Total if you want a single account coding for everything, regardless of the date. Summary per month if you want the account coding to be displayed per month. This option is appropriate if the export contains only invoices and credits. Summary per day if you want the account coding to be displayed per day, on those days for which account coding information is available. This option is appropriate if you have included payments in the export as it helps you to monitor the current account on a daily basis. Transaction if you want each invoice, payment and crediting to be displayed separately. This option works well in most cases.
Region	Select the region for which you want to see the list of past sales ledger exports. If account coding is not done by region, select [None] or [Any].

Function

Explanation

File

Create export: Opens the Create export window, see Create export (window).
Close: Closes the window without creating any accounting documents, and without exporting any files.

Exports

Export: Opens the Export window, see Export (window).
Invoice journal: The document is exported directly to Excel.
Invoice journal (customer summary): The document is exported directly to Excel.
Payment journal: The document is exported directly to Excel.
Supplier bill list: The document is exported directly to Excel.

Choose one of the following ways to group the information in the Export window:

Total if you want a single account coding for everything, regardless of the date.
Summary per month if you want the account coding to be displayed per month. This option is appropriate if the export contains only invoices and credits.
Summary per day if you want the account coding to be displayed per day, on those days for which account coding information is available. This option is appropriate if you have included payments in the export as it helps you to monitor the current account on a daily basis.
Transaction if you want each invoice, payment and crediting to be displayed separately. This option works well in most cases.

Region

Select the region for which you want to see the list of past sales ledger exports.

If account coding is not done by region, select [None] or [Any].

Columns in the list

Column	Explanation
Number	The sales ledger export number. The numbers are an unbroken series to make it easy to ensure that all exports have been included in the accounts.
Until date	The sales ledger export contains codings up to this date. This date is the Until date you selected when you created the sales ledger export. If you selected today’s date, there is no guarantee that all of today’s codings will be included, as the day has not yet ended. If you select a Until date earlier than today’s date, all account codings not yet exported up to the specified date will be included.
Created by	The user who created the sales ledger export.
Invoices	The number of invoices included in the sales ledger export.
Payments	The number of payments included in the sales ledger export.
Supplier bills	The number of credit notes included in the sales ledger export.
Created	The date and time at which the sales ledger export was created.