HansaManuals Home   >> Discontinued Products   >> Books by HansaWorld   >> Exports  

Previous   Next               Entire Chapter in Printable Form               Search  

This text refers to program version 6.2  

Export Functions in the Receivables module - Invoice Rows

The 'Invoice Rows' export function produces a text file containing all the rows from the Invoices in the selection you make. You can use this information for statistical analysis in other programs, for example spreadsheets.

For each Invoice row, this function will export the Invoice Number, Date, Customer Number and Name, Invoice Type, Item Number, Quantity, Description, Unit Price, Sum, Discount %, Sales Account, Salesman, GP and Tax Code, separated by tabs.

Invoice Type can be any of the following values:

1. Standard Invoice
   

2. Cash Note
   

3. Credit Note

Period

Paste Special    Reporting Periods setting, System module

Enter the start and end dates for the period to be covered by the export, separated by a colon (:). The default is the first period in the Reporting Periods setting.

Invoice No.

Range Reporting    Numeric

If necessary, specify an Invoice Number or range of Invoice Numbers separated by a colon (:). Only rows from Invoices in the range will be exported.

Customer

Paste Special    Customers in Contact register

Range Reporting    Alpha

Enter a Customer Number or range of Numbers to export rows from Invoices issued to specific Customers.

Item

Paste Special    Item register

Range Reporting    Alpha

Enter an Item Number or range of Numbers to export Invoices rows featuring specific Items.

Status

Choose whether you want to export rows from approved and/or unapproved Invoices.

Click the [Run] button in the Button Bar to proceed. A dialog box will open where you can name the export file and specify where it is to be saved.

Enter a name for the file. Click [Save] or press the Enter key.

A message window informs you about the progress of the export process. You can interrupt the process at any time by pressing ⌘-Period (Mac OS X) or Esc (Windows).

---

In this chapter:

• Introduction
  

• Export Functions in the General Ledger
  

• Export Functions in the Payables module
  

• Export Functions in the Receivables module, including:
  
  • Contact Data
    

  • Customer Statistics
    

  • Invoice Rows
    

  • Item Statistics
  
  
• Export Functions in the System module

Go back to:

• Home page for Books by HansaWorld manual

Previous   Next   Top            Entire Chapter in Printable Form