Statement Export

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.

To run the Statement Export option:

  1. Select Statement Export from the Account Billing Menu to display the Account Statement Export window.

  2. Click Add and complete the following fields.

    FieldTypeWhat to enter

    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.

  3. Click OK and then Continue to export the information.

Last updated

Logo

COPYRIGHT © 2024 NAVIGA