Language:


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

Previous   Next               Entire Chapter in Printable Form               Search  

This text refers to program version 8.0  

Item Statistics

This Export function in the Sales Ledger will export a list of the Items you have sold during a specified period (i.e. the Items included in Invoices, POS Invoices and Bar Tabs from that period). For each Item, the export file will first contain the Item Number, followed by the quantities sold in each month of the period, then the total sales values excluding VAT for each month of the period. For example, if the period is a year, the Item Number will be followed by twelve quantities and twelve sales values, all separated by tabs. Only Items that have been sold during the period will be included.

Using 'Paste Special' if necessary, enter a single Item Number, a range of Item Numbers separated by a colon (:) and/or an Item Group, and specify the period. Only the month and year in the start and end dates will be used when determining the period: the day will be ignored. For example, if you enter a period of 31 August:1 September, the export file will contain figures for the whole of August and the whole of September. Then, click the [Run] button. 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:

Go back to:

Previous   Next   Top            Entire Chapter in Printable Form