EDI Audit

yellowbox

image4

The intended purpose of the EDI Audit program is to allow changes to different status messages which have been placed on HOLD (See EDI Communication Manager) prior to releasing the information to your trading partner (customer / vendor). Under normal circumstances, status updates would flow freely from the order update through the EDI system to your trading partner. In some cases, such as late deliveries, or OSD issues, it may be desirable to verify the issue and usage of proper EDI codes prior to releasing the status update to your trading partner. In the case of short shipments or damage, the EDI Audit program gives the auditor a chance to review, verify, and enter the quantities affected. In the case of a late delivery, there may be issues where the load was in fact not late at all, or the reason the load was late needs to be entered along with the status update to the customer. In the case of payments the normal flow for payment records generated from the Check Register post through the EDI system to your trading partner. If you wish to verify payment records before they are sent, you can configure the 820 Outbound messages to be held in the EDI Communication Manager and then be audited and verified before sending.

The EDI Audit program is readily configurable to only view messages, which are on-hold for review (Default setting). Once the auditor is satisfied with the information’s accuracy, the 'hold' is released. The EDI Communication Manager program will now send the message with the next timed update. The EDI Audit program’s main purpose is to work with held messages and is strictly an optional program. If your situation is such that auditing messages for accuracy is not necessary, you may not require its use. If you have any status codes in the EDI Communication Manager set to other than Hold = 'Never', you will need to use and monitor the EDI Audit program. The only way to release a held message is through the use of the EDI Audit program.

To access EDI Audit:

From this location Go to

TruckMate Menu and TruckMate Task List

EDI > EDI Audit

Windows Start Menu

TruckMate 20xx > EDI Audit

Windows Explorer

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

Ensure you have completed the steps shown in the EDI Audit program overview in order to view data in the EDI Audit header section. Header and Footer information for the main screen of the EDI Audit program are shown below.

The EDI Audit program screen is broken into three parts: trading partner information, EDI message information, and the tabbed areas of Order, Order Dates, Details, Trace, User Defined, Status History, and Trip. The header area will itemize and define the trading partner information and EDI message information areas. Separate online help topics are available for each of the tabbed items.

The EDI Audit program has been expanded to include Intermodal functions, which can be accessed by selecting the Intermodal Tab option at the top of the window. It has also been expanded to include Trace functionality for all EDI message types. See the Trace Tab, below, for more information.

How Do I?

How do I Edit an On-Hold 214 EDI Outbound Message?

  1. Open the EDI Audit program (EDIAUDIT.EXE).

  2. Go to the Filter section and select all filters on-hold. The reason this message has been placed on-hold might be if this load was delivered late. This allows the operator to see a brief description of why the load is late, and he might contact the driver to find out why he’s late, or contact dispatch to notify the customer. These descriptions would all be configured in the EDI program.

  3. The bottom grid shows all of the on-hold messages. The top area shows the description of the on-hold. In the center section of the screen, there are a few areas you’re able to edit. These are: the status date and time, the EDI code, the appointment code, the reason code, and the lading exception code. You can also edit the location of where the status occurred, the latitude and longitude, and you can add in free-form remarks (depending on the version the trading partner has installed).

How do I Resend a 214 Freight Status message?

  1. Open the EDI Audit program (EDIAUDIT.EXE).

  2. Check the 'Filters On', select the particular 'Trading Partner' (use the search button menu), select the 'Bill Number (use the search button menu), and in the 'Show Messages' section, select: 'All'.

  3. The freight bills status will show up in the bottom of the screen

  4. Locate the particular status you would like to resend. Access the Context Menu (right-click) on the status and select the 'Toggle Posted Status' option. This will set the 'Posted' status to 'False' from 'True' and will force the message to be resent the next time that the EDI Communications Manager program is run.

  5. You will need to repeat this process for all the 214 Status messages you want to resend.

EDI Audit setup and configuration

The EDI Audit program deals with EDI messages . For information to appear in the EDI Audit program, you have to have a few items set up:

  • In the EDI Communication Manager program, you must have a trading partner set up for the status messaging type you want to use, and that trading partner must be marked as 'Active'.

  • At least one rule must be set up for the type you want to use.

  • At least one 'Status Code' must be set up.

  • If the rules apply, an entry is added to the appropriate staging table (EDI_PENDING or EDI_208_PENDING).

  • The EDI Audit program reads from the staging tables.

For DB2: EDI Communication Manager needs to be running before any staging table can be updated.

Here’s how it works: You prepare a Freight Bill in Customer Service, and every time you perform a status update in Customer Service (and you have a matching Status Code in the EDI Communication Manager), then you should be able to see your trading partner in the EDI Audit program. If you have completed the above steps, then when you first open the EDI Audit program, draw your eye to the bottom grid. Highlight one of the items shown there, and all relevant information pertaining to that item will appear in the top portion of the program. If you’re interested in viewing the 'On Hold' messages only, select that checkbox. Or, if you’re interested in viewing 'Posted' messages only, select that checkbox. You would only use the 'Posted' information if you wanted to re-send messages.

If the EDI Communication Manager program is running, information won’t stay long in the EDI Audit program.

Menu Bar / Toolbar

File Menu

Exit

image5 Selecting this option will close the EDI Audit 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

image6 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.

Help Menu

TruckMate Help

image7 Selecting this button will open the EDI Audit topic in the TruckMate Online Help file (the page you are currently viewing).

Service Portal

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

About

image9 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).

Standard Tab

Trading Partner Information

Trading Partner

Auto-populated information based on the Client Profile.

Order #

Auto-populated information based on the Client Profile.

Name

Auto-populated information based on the Client Profile.

Address:

Auto-populated information based on the Client Profile.

City, St., Zip

Auto-populated information based on the Client Profile.

Contact

Auto-populated information based on the Client Profile.

Phone/Fax

Auto-populated information based on the Client Profile.

E-Mail

Auto-populated information based on the Client Profile.

Active

Auto-populated from the EDI Communication Manager program > 214 Tab.

Notes

This is the same option as in Customer Service displaying the notes for the order. Notes may be viewed, entered, and modified from within EDI Audit program. The notes are the only item other than the EDI status message, which can be modified in EDI Audit program.

EDI Message Area

The EDI Message Area contains options and fields that allow you to view and control the content of your EDI Messages.

Held

Depending on the timing, you will seldom catch a glimpse of '214' messages not on hold. Once the held '214' message is validated and checked for accuracy, the hold is removed by un-checking this box. Here’s the basis of the EDI Audit program- it’s an optional program allowing editing of the '214' EDI outbound messages, which have been placed on 'HOLD', prior to releasing the message to the trading partner. Messages involving service failures can optionally be placed on 'HOLD'. A customer service agent can then investigate and qualify the '214' EDI status message with the proper (reason) codes.

Reason

Displays a textual abbreviated reason offering why the EDI Communication Manager program put the message on hold.

Example:

Status Change Date [3-MAR-2002 17:05:] > DELIVER_BY_END [2-MAR-2002 17:00].

This means the load was delivered late. The load was supposed to be delivered no later than 5:00 pm on March 2. The load was actually delivered a full 24 hours later at 5:05 pm on March 3. It’s now up to the EDI auditor to determine if this was a data entry mistake and correct the delivery information before releasing it, or perhaps qualify the late delivery with an appropriate reason code before releasing the message from being held.

Status Date

This is the date applicable to the status change being sent to the trading partner. It is usually the date and time the status change occurred, but it may be another date/time purpose such as an appointment date/time for pick up or delivery.

Show Messages

Allows you to select the regular EDI messages, or the ones on-hold, or posted.

Hold

Select this option if you wish to view messages currently on-hold.

Posted

Select this option if you wish to view posted messages.

EDI Code

Select the search button and you’ll see a list of EDI Codes. Select the appropriate EDI Code.

Only codes configured for this trading partner will be listed as configured in EDI Communication Manager program’s 214 EDI Tab, EDI Status Codes grid. The code may also be entered in free format if required.

Appt. Code

Select this option if you wish to add an appointment code to this message. Simply select the search button and a list of available appointment codes will appear. Ensure no characters are present in the filter field.

Reason Code

If you have imported EDI Reason Codes into your EDI Communication Manager, a list of selections will appear here.

Only codes configured for this trading partner will be listed as configured in EDI Communication Manager program’s 214 EDI Tab, EDI Status Codes grid. The code may also be entered in free format if required.

Loc / Lat / Lon

Location information as per your zone codes. Latitude and longitude as per your zone code setup.

Remarks

Fields offering a place for relevant remarks.

In most EDI '214' versions, there is an option to send two short text messages with the status update.

Lading Exceptions

Allows you to enter Exception Codes, and a particular quantify.

Type

Select the search button to view potential Exception Codes.

Quantity

Enter the quantity in the field provided.

Filters On

You may wish to set particular filters for certain trading partners. Selecting this option will enable this filter feature.

Trading Partner

Select the search button to see a list of available trading partners. Use the 'Clear' button to the right of the search button, if you’ve mistakenly selected an incorrect trading partner.

Bill Number

Select the search button to see a list of Freight Bills. Use the 'Clear' button to the right of the search button, if you’ve mistakenly selected an incorrect Freight Bill.

EDI Code

Select the search button to see a list of available EDI Codes. Use the 'Clear' button to the right of the search button, if you’ve mistakenly selected an incorrect EDI Code.

Orders Only

When checked, this feature, disables all screen items and allows searches on all Freight Bills. Plus, this option gives the ability to display a Freight Bill which normally cannot be located in the EDI Audit program due to no EDI status history. Once located, on the Freight Bill status tab, an EDI status entry in can be created manually.

Find Order

Brings up the 'Find Freight Bill' dialog box where you can search using a variety of methods.

Navigation Bar

Use the scrolling buttons to navigate through the EDI Audit records.

Grid Details

All of the fields in the EDI Message Area Grid are auto-populated based on the EDI message information.

Context Menu

Assign Lat/Lon

Assigns the Latitude and longitude for this zone '*.DBB' performs a look up of the zone and retrieves the specified latitude and longitude for the zone code.

View Freight Bill

Opens the Customer Service program with the details of the selected Freight Bill displayed.

Toggle Posted Status

Select this option if you wish to change this message from the default Posted status of 'False' to 'True' meaning that this message will now be posted and re-sent. You will receive a confirming message on-screen.

Toggle Held Status

Select this option if you wish to change the 'Held' status from 'False', which is the default, to 'True' which would place this EDI message on hold.

Detail Tabs

Order Tab

All of the information on the Order Tab is taken from the Customer Service program and is available in condensed format here in the EDI Audit program.

View

Selecting this button will bring you to this Freight Bill in the Customer Service program.

Order Details

Auto-populated based on the Customer Service program information. 'True' or 'False' will display next to 'Dang Goods' and 'Temp Control' if they meet these criteria, and the fields below will populate with values based on the information passed from Customer Service.

Caller

Auto-populated based on the Customer Service program information.

Shipper

Auto-populated based on the Customer Service program information.

Customer

Auto-populated based on the Customer Service program information.

Consignee

Auto-populated based on the Customer Service program information.

Order Dates Tab

All information on the Order Dates Tab is taken from the Customer Service program and is available in condensed format here in the EDI Audit program. The purpose of this tab is to present all date-specific items on one tab to make it easier to determine if there were any problems with the delivery or pick up dates

Details Tab

The Details Tab automatically populates with the Freight Bill Detail Line details from the Customer Service program.

Trace Tab

The Trace Tab displays the Trace numbers associated with the Freight Bill. Trace Types are setup in the Codes Maintenance program > Trace Number Types Tab.

User Defined Tab

The User Defined Tab will display all data entered into the User Defined fields of the Customer Service program > User Defined Tab. You have the ability to edit the values contained in these fields by selecting the 'Edit' button at the bottom of the Tab window.

Status History Tab

All information on the Status History Tab is taken from the Customer Service program > Status Tab and is available in condensed format here in the EDI Audit program.

Current Status

Highlight one of the records in the grid and the current status of that record will appear in this box.

Add New Status

Select the search button to view status' option for this Freight Bill.

  • EDI Status Code

    Select the search button to review status codes entered on your system.

  • Effective Date

    Double-click to bring up a calendar. Scroll to the desired date.

  • Comment

    Enter any relevant comments in the field provided.

A valid order must be displayed prior to selecting this option. If you have the 'Orders Only' checkbox selected (located in the bottom part of the screen lower left corner) you may get a message saying 'This order does not quality for EDI '214' status updates'. This means that the order selected does not have a '214' EDI Communication Manager program trading partner associated with it and so adding a status here would have no effect.

Trip Tab

All information on the Trip Tab is taken from the Trip grid in the Dispatch program and is available in condensed format here in the EDI Audit program.

Intermodal Tab

Trading Partner Information

The Trading Partner Header section is very similar to the one used in the Standard Tab of the EDI Audit program, with the exception of the Filter options within the 'Show Messages' section near the bottom. Instead of having options to view the '214' and '204' EDI Messages, there are options to view Intermodal 'InGate' and 'OutGate' messages.

Intermodal Message Area

The Intermodal Message Area contains several options for Filtering and controlling your Intermodal EDI Messages.

Filters On

Check this box to apply the Filters chosen in the Trading Partner Header to the Intermodal Messages within your system. If this box is unchecked, no Filters will be applied (all Intermodal Messages will be displayed).

Trading Partner

Displays the Trading Partner ID being used to Filter the Messages in the bottom Grid. Clicking the search button will open a form where you may search the Trading Partners setup on your system. The button to the right of the search button will clear the current Trading Partner ID from the Filter box.

Control Number

Displays the Control Number being used to Filter the Messages in the bottom Grid. Clicking the search button will open a form where you may search the Control Numbers setup on your system. The button to the right of the search button will clear the current Control Number from the Filter box.

Grid Details

Control Number

Displays the Control Number of the Intermodal Message.

In / Out Gate

Displays either 'InGate' or 'OutGate', depending on the type of Intermodal Message.

In / Out Date

Displays the Date associated with the Intermodal Message of the current Detail line.

Held

Displays 'True' or 'False' depending on the 'Held' status of the current Intermodal Message.

Posted

Displays 'True' of 'False' depending on the 'Posted' status of the current Message.

Comments

Displays any Notes associated with the current Intermodal Message.

Context Menu

Toggle Posted Status

Using this option will toggle the value within the 'Posted' field for the currently selected Detail line.

Intermodal Tabs

The Intermodal Tabs within the EDI Audit program will populate with data from the Intermodal Container Inventory Control program.

Container Tab

The Container Tab will automatically populate with data from the Container Inventory program For more information on the specific fields within this Tab, see the Container Inventory Control program.

Chassis Tab

The Chassis Tab will automatically populate with data from the Container Inventory program For more information on the specific fields within this Tab, see the Container Inventory Control program.

Driver Tab

The Driver Tab will automatically populate with data from the Container Inventory program For more information on the specific fields within this Tab, see the Container Inventory Control program.

Misc Tab

The Misc Tab will automatically populate with data from the Container Inventory program For more information on the specific fields within this Tab, see the Container Inventory Control program.

User Defined Tab

The User Defined Tab will display all data entered into the User Defined fields of the Container Inventory Control program, which are stored in the CD_INGATE_OUTGATE Table.

User Field 1 - User Field 10

If no data exists in the CD_INGATE_OUTGATE Table, you may enter the information in these fields using your keyboard. You have the ability to edit the values contained in these fields by selecting the 'Edit' button at the bottom of the Tab window.

Select the 'Checkmark' button to save any modified data.

Notes Tab

This Tab will display any Notes associated with the Intermodal details of the current Freight Bill being used.

Trace Tab

Trace Tab support logistics EDI functionality. As Inbound data from outside Carriers can easily be lost due to mismatched or unexpected data, the Tracing features available on the Trace Tab provide visibility for ALL transactions (Inbound and Outbound,) not just for Logistics purposes, but for all EDI transactions.

The EDI Audit program’s Trace Tab has been designed to function similar to the Trip Tracer program. For a general overview of using the EDI Audit program > Trace Tab, Users should view the help for the Trip Tracer program. The major difference between the two programs is that the EDI Audit program’s Trace functionality will facilitate reporting of the EDI_AUDIT and EDI_AUDIT_FA Tables. Each time a regular EDI transaction occurs, an entry is inserted into EDI_AUDIT, and each time a functional acknowledgement is generated (or received,) an entry is inserted into EDI_AUDIT_FA. As the 997 relates to an original EDI tx set, there is a link between the EDI_AUDIT_FA record and the EDI_AUDIT record.

Running Traces

To create a Trace, simply select the checkboxes of the filtering values you wish to use ('Trading Partner', 'EDI Type', and so on). Once you have specified any number of Trace filters, select the 'Run Trace' button. EDI records that match the filtering criteria will be displayed in either the 'EDI History' or '997 Functional Acknowledgements' grids, depending on the type of EDI they are.

997 Only

Flagging this option will limit the Trace to only 997 Functional Acknowledgement messages.

Vendor Payment Tab

This tab is to provide the user with the ability to check and audit the outbound payment messages made through the EDI 820 outbound messaging before they are actually sent, the user can select a setup option in the EDI Communication Manager program to set all EDI 820 outbound messages to 'Hold' in which case no messages will be sent except the ones audited and approved through the EDI Audit program.

Trading Partner

Auto-populated information based on the Vendor Profile.

Name

Auto-populated information based on the Vendor Profile.

Address:

Auto-populated information based on the Vendor Profile.

City, St., Zip

Auto-populated information based on the Vendor Profile.

Contact

Auto-populated information based on the Vendor Profile.

Phone/Fax

Auto-populated information based on the Vendor Profile.

E-Mail

Auto-populated information based on the Vendor Profile.

Active

Auto-populated from the EDI Communication Manager program > 820 Tab.

Hold

This button toggles the 'Hold' status between 'Hold' and 'Release', to resend a message that was put on-hold select the desired on-hold message and click the hold button, the next time the EDI Communication Manager program runs the message will be resent.

Payment Details

Total Amount

This is the total amount of all payment transactions displayed in the payment details section for the selected vendor ('Trading Partner'), this will be populated automatically when the transactions are displayed.

Bank

This the bank used for making the displayed payments.

Payment Details Grid

This grid contains information populated from the APNI.exe Payment Details Grid.

Show 820 Messages

This section provides options to filter the displayed 820 Messages based on their statuses.

Held

Displays only messages that are on-hold.

Posted

Only posted messages will be displayed.

All

Displays messages of all statuses.