Interline Payable Audit Register

yellowbox

image30

The Interline Payable Audit Register program is used to update interliner transactions that have been approved in the Interline Payable Audit program. You can also re-print previous Interline Payable Audit Registers. Running the Interline Payable Audit Register program creates general ledger postings that can be viewed in the GL Journal Entries program. The Interline Payable Audit Register program also creates an outstanding invoice for the vendor (ie, the interliner) that can be viewed and selected for payment using the A/P Inquiry program.

To access Interline Payable Audit Register:

From this location Go to

TruckMate Menu and TruckMate Task List

  • TruckMate 2023.x and later:
    Accounting & Finance > Interline Payable > Interline Payable Audit Register

  • TruckMate 2022.x and earlier:
    Accounting & Finance > Interline Pay > Interline Payable Audit Register

Windows Start Menu

TruckMate 20xx > Interline Payable Audit Register

Windows Explorer

C:\Program Files (x86) > TruckMate 20xx > Ipiipr.exe

What’s New in Interline Payable Audit Register

Interline Payable Audit Register converted to a service

The Interline Pay > Interline Payable Audit Register (ApNcr.exe) program has been converted to run as a Windows service to allow the register to run in the background at pre-scheduled time without user intervention.

A new Windows Service tab has been added to the main form of the Check Register program together with some associated icon buttons and a pull-down menu in the tool bar.

TM 154371 211a

TM 154371 211b

The Service Options form is used for configuring other settings specific to this new service. The settings are saved in the Windows Registry.

TM 154371 211c

There is a new IPIIPR - Allow Service Configuration Button checkbox option in the Utilities > Security Configuration program > Security tab > Business Events > Allow Changes section.

Menu Bar / Toolbar

File Menu

Print Reports

printer Selecting the Print Reports button will bring up the report selection window, common to many TruckMate applications. Here, you will select a report file from those available in your system and a Crystal Report will be generated.

For more information on Report functionality in TruckMate, see the Crystal Reports Reference.

Exit

exit Selecting this option will close the Interline Payables Register program.

Multi-Company

For more information on the Multi-Company options available from the Menu Bar, see the Multi-Company documentation.

Tools Menu

TruckMate Monitor

monitor Click the down arrow next to this button to access the various functions of the new TruckMate Monitor.

Remember Position / Size

Selecting this option will maintain the program window position and size upon close. When the program is re-opened, it will appear the same.

Post

ok Selecting this option will generate a report identical to the one created using the Report function.

In addition, the status of all included interline transactions will be updated to 'Interfaced', and interline invoices for the transactions will be created in the A/P Inquiry program. General ledger postings will be created for the included interline transactions. These can be viewed using the GL Journal Entries program. Until the entries are updated using the GL Journal Entries Register program, they will not be included in the GL Chart of Accounts program balances.

When posting Accounts Payable entries, the Interline Payables Register will link the ORDER_INTERLINER record to an Accounts Payable Bill and use the Vendor’s 'Parent ID' for posting.

Window Menu

Interline Payable Audit

image32 Selecting this option will open an instance of the Interline Payables Audit program.

GL Journal Entries

image33 Selecting this option will open an instance of the GL Journal Entries program.

GL Journal Entries Register

image8 Selecting this option will open an instance of the GL Journal Entries Register program.

Help Menu

TruckMate Help

help Selecting this button will open the Interline Payable Register topic in the TruckMate Online Help file (the page you are currently viewing).

Service Portal

browser Selecting this button will open an instance of your default Internet browsing software, with the https://www.tmwcare.com login page displayed.

About

about Selecting this button will open the standard TruckMate About window, which contains important information about the application you are currently using, including its version number (important for support calls).

Filters

Date Range

You can post transactions based on a range of the freight bill’s Billing Date (as entered in the Customer Service program and Quick Bill Entry program). Click on the button to the right of the date fields for a calendar selection form.

Specific User ID

You can select transactions for posting based on the user who created the freight bill in the Customer Service program or Quick Bill Entry program. Select a user name from the drop down list box. User names are configured in the Security Setup program.

Creation / Approval

Select one of the radio buttons for 'Creation' or 'Approval'. Selecting 'Creation' would mean that only those freight bills created by this particular user would be updated. Alternatively, selecting 'Approval' would mean that only those freight bills approved by this particular user would be updated.

This field can be left blank and the program will still function.

Other Filters

Operations Code

This field is used to filter against certain Operation Codes in your system, and will check against the TLORDER table of this ORDER_INTERLINER record.

Currency Code

This option allows you to filter the checks that will be processed by their Currency Code (usually wither 'CAD' or 'USD'). This value chosen here is also used by the Application Configurator program > COMPANY.EXE > 'Match Quick Report Currency' option to determine which Company logo should be added to the Quick Reports generated by this application.

Report Options

Reprint Audit

To re-print a Interline Payable Register that had been previously updated, check the Reprint Audit box and enter the audit number in the field to the right. Audit numbers print on the register in the top right corner. You can also find the audit number associated with a interline transaction by displaying the transaction history for the invoice. In the A/P Inquiry program, find the invoice (it will be displayed under interliner’s account). Then select Transaction History from the context menu in the invoice grid.

Report and Post

Print Reports

Will create a report that shows the included Interliner transactions and the general ledger distribution, grouped by 'Trip ID'. You can use this report to confirm that your selection criteria are correct. The Report function does not update the status of the transaction or create postings in the general ledger module; nor does it generate an audit number. It is used only for reporting purposes. The report will be previewed to the screen. To send it to a printer, click the printer icon at the top.

See the Crystal Reports Reference for details about the other report functions.

Post

Will generate a report identical to the one created using the Report function.

In addition, the status of all included interline transactions will be updated to 'Interfaced', and interline invoices for the transactions will be created in the A/P Inquiry program. General ledger postings will be created for the included interline transactions. These can be viewed using the GL Journal Entries program. Until the entries are updated using the GL Journal Entries Register program, they will not be included in the GL Chart of Accounts program balances.

When posting Accounts Payable entries, the Interline Payables Register will link the ORDER_INTERLINER record to an Accounts Payable Bill and use the Vendor’s 'Parent ID' for posting.

Inter-Company Postings

The Interline Payables Register supports inter-company interline payables records. Inter-company IP will cause inter-company transactions to be added to the GL.

Zero Charge Pro-Rating

The Interline Payables Register will now prorate previously zero charges. When a bill is adjusted and the original charge was zero, the new adjustment will be prorated based on the original cost allocation rule.

General Ledger Postings

Unlike most other accounting registers, IP does not have a subledger (a listing of Debits and Credits relevant to a single ORDER_INTERLINER record). So, in order to maintain these subledger details, as the Interline Payables program posts to the GLTRANS Table, it will also post (insert) to the new IP_GL Table. Except, instead of grouping / totalling the amounts by 'Audit #' / 'GL Account' like in the case of the GLTRANS Table, the program will post (insert) every single line (individual 'Debit' or 'Credit').

Debit Posting

Will be made to the Interline Payable control account. To determine the IP control account, the system looks for the lowest numbered general ledger account (as configured in the GL Chart of Accounts program) that fits the following criteria:

  • It is of the 'Interline Payable' type.

  • It is not a sub-account.

  • It is of the same currency as the interline transaction.

Credit Posting

Will be made to the Accounts Payable control account. To determine the AP control account, the system looks for the lowest numbered general ledger account (as configured in the GL Chart of Accounts program) that fits the following criteria:

  • It is of the 'Accounts Payable' type.

  • It is not a sub-account.

  • It is of the same currency as the interline transaction.