HansaManuals Home   >> Standard ERP   >> Sales Ledger   >> Exports  

Previous   Next               Entire Chapter in Printable Form               Search  

This text refers to program version 8.0  

Item Turnover History

The 'Item Turnover History' Export function in the Sales Ledger will export a list of the Items you have sold during a specified year, together with monthly sales figures (either quantities or values). For each Item, the export file will first contain the Item Number and Description, followed either by the quantities sold in each month of the period, or by the total sales values excluding VAT for each month of the period. Items with no sales will not be included in the export file. The figures will be compiled from Invoices, POS Invoices and Bar Tabs.

Leave all the fields blank if the report is to cover all the Items in the Item register. Otherwise, use the fields as described below.

Start Date

Paste Special    Choose date

The export file will contain a separate sales figure for each Item for each month in the year beginning with the date that you specify here. This date should be the first day of a month.

Items

Paste Special    Item register

Range Reporting    Alpha

Use this field to limit the export to a single Item, or range of Items.

Item Group

Paste Special    Item Group register, Sales Ledger

To limit the export to a single Item Group, enter an Item Group Code here.

If you specify both an Item Group and a range of Items, only those Items in the range that are members of the specified Item Group will be included in the export file.

Values

Use these options to choose whether the export file should contain the quantities of each month sold per month, or the total sales values excluding VAT per month.

Confirm by clicking the [Run] button, or cancel using the close box. After clicking [Run], a dialogue box will open, where you can name the export file and specify where it is to be saved. Enter a name for the file, and click [Save] or press the Enter key. The export file will be created and saved. When the export finishes, you can close the ?Export? window using the close box.

---

Export functions in the Sales Ledger and Integration modules:

• Introduction
  

• Analytical Cash Flow
  

• Customer Statistics
  

• Customer Turnover History
  

• Customer/Item Statistics
  

• Direct Debit to Hansabank
  

• Intrastat Invoices
  

• Intrastat Invoices (UK)
  

• Invoice Rows
  

• Invoices
  

• Invoices for Factoring
  

• Item Statistics
  

• Item Turnover History
  

• Items to Fiscal Printer Fi550
  

• Open Invoices

Go back to:

• Home page for Sales Ledger manual
  

• Home page for Standard ERP manual

Previous   Next   Top            Entire Chapter in Printable Form