Language:


Open Invoices

This Export function in the Integration module will export all open Invoices in the system (i.e. Invoices that have been marked as OK that are partially or wholly unpaid). You can use the resulting file to help with a change of financial systems or when creating a new database at the start of a financial year.

Use the Backup Comment to place a short description in the export file (up to 40 characters are permitted). This comment will be shown in the list of importable files that will appear when you use the 'Automatic' Import function in the System module (and also when you create a new database using the [Import Textbackup] button in the 'Welcome to Standard ERP' window).

When you import the file into a new database, the Invoices will be marked as OK, but no Nominal Ledger Transactions will be created (you should enter opening balances to the Nominal Ledger separately).

If you select the Create Receipts for Partly paid Invoices option before creating the export file, Receipts will be created in the new database for the paid amounts on part-paid Invoices. Again these Receipts will be marked as OK, but there will be no corresponding Nominal Ledger Transactions. If you select this option, you should also specify the Payment Mode that will be used in these Receipts (using 'Paste Special' if necessary), the Receipt Date and the first Receipt Number. Receipt Numbers will be generated by the export function, not when the file is imported, so be sure to choose a First Receipt Number that does not conflict with any Receipts already in the new database. If you do not specify a First Receipt Number, Receipts in the new database will be numbered from 1. If you do not choose a Payment Mode, the first Payment Mode in the setting in the exporting database will be used.

If you also need Prepayments and On Account Receipts to be transferred to the new database, select the Include On Account Payment option. You should only use this option if you also select the Create Receipts for Partly paid Invoices option as it will have no effect otherwise. Prepayments and On Account Receipts will be imported to the new database as On Account Receipts.

You must specify a Receipt Date, even if you choose not to use the Create Receipts for Partly paid Invoices option.

If any of the amounts are in Currency, be sure to import all Currency and Exchange Rate records to the new database before importing the Invoices.

If you select the Export as Invoices not Updating Stock option, any Invoices in which the Update Stock option has been ticked will be exported with that option unticked.

If you are exporting with the intention of importing into another Standard ERP database or Company using the 'Automatic' and 'Manual file search' Import routines, do not name the file with two leading minus signs/hyphens (e.g. --Data.txt). Information will not be imported from files named in this way.

---

Export functions in the Sales Ledger and Integration modules:

Go back to: