Midmonth Pmt Export

Typically, account credits are interfaced to an Accounts Payable system at the end of a billing period (see Interface to AP). However, some newspapers give accounts advances on certain recurring credits, such as mileage. In order to do this, the credits may have to be interfaced between billing periods, using the Mid-Month Payment Export feature.

In order to use this feature, you must set up a new billing period for mid-month credits. You should then modify account setup for all accounts involved, changing the bill period for all applicable recurring charges to the new mid-month period. Account billing should not be run for the mid-month bill period. This will prevent the recurring credits from being applied to the account’s balance twice.

Credits for the recurring credit codes selected will be exported to the file /dti/exchange/cm/midmonthpmtMMDD, where “MMDD” are the month and day of the due date entered. The format of the file is based on Business Rules (see Appendix B). A debit transaction will also be created for the account, which will be picked up during the next account billing and debited from the account’s balance (billing will be crediting the account for the full recurring credit, but the account has already received a portion of it, so that portion must be debited).

To run the mid-month AP interface:

  • Select Midmonth Pmt Export from the AP/Direct Deposit menu to display the Recurring Mid-Month Payment Export window.

  • Click Add and complete the following fields.

    FieldTypeWhat to enter

    COMPANY, BILL SOURCE

    setup

    Enter the company and bill source for which to interface recurring credits, or enter “*” to multi-select companies and bill sources.

    PROCESS DATE

    date

    Enter the date for which to export recurring credits. Only recurring credits active on this date will be exported.

    MINIMUM AMT

    decimal (10)

    Enter a minimum amount for the interface. Only recurring credits that are equal to or greater than this amount will be interfaced.

    DUE DATE

    date

    Enter the due date for the check to be cut by the AP system.

    RECURRING CHARGE CODE

    setup

    Enter the recurring credit code that should be interfaced, or enter “*” to multi-select recurring credit codes. Only recurring credits can be selected, not charges.

  • Click OK and then Continue to run the interface. A processing report will list accounts that had recurring credits exported.

Last updated

Logo

COPYRIGHT © 2024 NAVIGA