Statement Export
Last updated
Last updated
COPYRIGHT © 2024 NAVIGA
Use this option to export all of the information necessary to perform corporate billing for selected accounts.
If individual single copy chain stores maintain their own accounts receivable, but the corporate office prefers to make payments on behalf of the stores, you can use this option to prepare a summarized statement for corporate billing that includes payment information, aging, charges details, and invoice details for those stores. To accomplish this, you must assign each store to an account group, and then run this option on the account group. All of the accounts that belong to the account group will then be included in the Statement Export file. The export file uses file mapping.
Select Statement Export from the Account Billing Menu to display the Account Statement Export window.
Click Add and complete the following fields.
COMPANY
setup
Enter the company for which statement information should be exported.
BILL SOURCE
setup
Enter the bill source for which statement information should be exported. A bill source is a group of accounts you bill together (examples are Carrier, Dealer, NIE, etc.).
TRUCK SEQUENCE
setup
Indicate the truck sequence to ensure the export of correct trucking information for the account bill route.
SELECTION TYPE
predefined
Indicate whether this export should sort by group area, region, reason, zone, district, truck, account group, or account.
SELECTION
setup
Enter a specific selection based on the Selection Type entered.
AGING CRITERIA
predefined
Select an aging period to include (e.g., 1st, 2nd, etc.) or select all aging periods.
START DATE END DATE
date
Enter a date range for the export.
FILE FORMAT
setup
Enter a user-defined format that has been set up in File Map
.
FILE NAME
open (30)
Enter the file name of the file in the /dti/exchange/cm
directory.
FILE OPTION
predefined
Select append to add this information to the existing file, or replace to replace the existing file.
Click OK and then Continue to export the information.