Export Invoices (Rental/Sales/Order)


Utilities Menu -> XML Data Exports -> Export Invoices

Back Office Menu -> Daily Close Menu -> Daily Close 2 -> Export Invoices


This utility can be used to re-create the XML export invoice files if the parser has failed or the XML files were deleted.
This utility can also be used to directly generate an XML export data file for a range of posted invoices, selecting by invoice number or date range.
A record is written for Invoice exports to the View Application Log.

The Customer records that are exported can be filtered by "Credit Rating" by selecting only the ratings to export in the Credit Rating XML Selection window.

Refer to Company Daily Close Parameters for the directory and parser setup used by the XML Export process with the option to email the resulting XML files to the operator currently signed in.
The feature to automatically capture and export invoice data by XML transactions in Daily Close 2, can also be activated in the Company Daily Close Parameters.

The prompts in this Export Invoice utility are:

XML TRANSACTION#
Recreate XML Export file:
To reproduce an XML file from an existing export file, select the XML transaction from the Select XML Transaction# window.
If an XML transaction number is selected the other filters for this utility do not apply.

Export New XML file:
Leave the XML Transaction# field blank, to export a new XML data file for a batch of invoices using either the selection filters provided in this utility or using the Sel option to select specific invoices to export, as follows:

  • SEL
    Leave this field blank to use the 'Export Selection Filters' below for the invoices to export, or type 'SEL' to define a list of invoices to include in the export as outlined in the Select Invoices window.
  • Export Selection Filters:
    The following filters are only enabled if the Sel option is not being used to select specific invoices to export.

    FROM INVOICE
    Leave this field blank to include invoices for all customers that match the Credit Rating XML Selection in the export file, or enter the starting invoice number in the range, or select a starting invoice from the Invoice Search window.
    TO INVOICE
    Leave this field blank to include invoices for all customers that match the Credit Rating XML Selection, or enter the ending invoice number in the range, or select an ending invoice from the window.

    FROM INVOICE DATE
    Accept the default date or enter a starting date for the range of invoices.
    TO INVOICE DATE
    Accept the default date or enter an ending date for the range of invoices.

    ONLY INVOICES NOT EXPORTED
    Uncheck this box to include all invoices in the selection range that are in history (IHIH), and export the data to an XML file.

    Note: Because invoices that are already included in an existing XML export transaction may also be included in this XML file, invoices will not be stamped with the new XML transaction number.
    As this could be an overlapping export, the XML file naming convention used is TRS_IHIH_yyyymmdd_hhmmss.xml, where TRS represents the 3 digit company code, IHIH (Invoice History) is the data type, yyyymmdd is the date, and hhmmss is the time of creation.

    Check this box to select only invoices that are in history (IHIH) but that are NOT already included in a saved XML transaction record.
    The option is then provided to stamp the invoices in this file with an XML transaction#.

    ASSIGN XML TRANSACTION#
    This field is only enabled if Only Invoices Not Exported has been selected.

    Check this box to create an XML transaction for future use, identifying the invoices as included in this trx file.
    The XML file naming convention for invoices is TRS_IHIH_00000000000000000161.xml where TRS represents the 3 digit company code, IHIH (Invoice History) is the data type, and 00000000000000000161 is the sequential XML transaction number.

    Uncheck this box to generate a one time XML export file identified by date/time in its name, but leaving the invoices "unstamped".


Finished?
Click ACCEPT to proceed or CANCEL to abort the export.

Topic Keyword: XMLEXP2
Converted from CHM to HTML with chm2web Pro 2.85 (unicode)