Using Vendor Orders

Managing costs is an important part of the commodities business. The Vendor Order system in CATS is a distinctive tool to help anticipate costs, cut down on duplicative entry and streamline vendor reconciliations. The Vendor Order system leverages the standard traffic documents (delivery order, shipping instruction, etc.) as the framework for a customizable and extensible costing rubric. Defining the vendor roles that pertain to specific traffic documents, allows CATS to automatically generate the vendor charges when those traffic documents are created. Additionally, vendor order templates can be set up to mirror individual vendor's price lists.

In this wiki, you can learn:

• How to set up and configure vendor roles and vendor order templates.
• How to generate vendor orders using traffic forms.
• How to add and modify vendor orders on a traffic form.
• How to generate payable invoices using vendor orders.

Vendor orders represent itemized charges that could, for example, be entered on a vendor invoice. Vendor orders are generated in the process of creating traffic forms (also called traffic orders, e.g., DO, SI). Vendor orders for multiple different vendors may be generated from a single traffic form.

Each line item on a vendor order is the charge you expect your vendors to send you after performing a specific action on your inventory (loading, shrinkwrapping, customs fees, etc.).

First, you will set up pre-defined vendor roles, which specify the type of charges that relate to each traffic document type.

Further, you can set up templates for each role. CATS will use these templates to automatically calculate the amount due to each vendor based on a specific traffic form.

When you create a new traffic form, CATS will pull in all of the vendor order line items that it finds that relate to the roles and templates you have set up.

1. Open the traffic form you will be using.
2. Select VO to see the orders to be applied to the form. CATS will show you a list of the vendor orders that apply to this particular traffic form.
3. Add/review vendor orders for this traffic form by entering the accounts and rates.
4. Use the checkboxes to include/exclude vendor orders.
5. Pick Save to save your changes and return to the traffic form.

When a new Traffic Form is printed or PDF generated, CATS will pull from the vendor roles for that traffic form to create vendor orders corresponding to the inventory material. CATS will attempt to pull counterparty information automatically based on the source and/or account in the vendor templates file.

When the traffic form is printed, CATS will automatically update & display the vendor orders. To see the vendor orders for a traffic form, first open the traffic form you will be using. From the form's review screen, select the menu option VO to see the vendor orders that have been applied to this traffic form.

Select VO from the traffic form menu to see vendor order information.

CATS will show you a list of the vendor orders that apply to this particular traffic form.

Vendor orders that apply to this traffic screen.

The steps for determining Vendor Order Line Item creation are:

1. Match the role traffic form type to this traffic form (Is it a DO? SH? etc.).
2. Match the source counterparty code to the counterparty code on the role.
3. Match the source counterparty code to the templates file.

This flowchart describes how CATS determines how vendor roles and templates are used to create vendor order line items on traffic forms.

Flowchart for applying vendor order line items

Here is how CATS applied all of the vendor roles and templates to create the vendor order line items on this particular DO.

Vendor order line item

On the location screen we have used to create a DO, we see the following:

Codes on Location Screen affecting Vendor Orders

• Warehouse Code: WARYWH
• Pier Code: WATER
• Carrier Code: KARRIEZ
• Customs Broker: SESAME

We also see above that our DO is for account MYSHIP.

Here are the relevant templates that were applied as vendor order line items for our IDO.

Relevant templates applied as vendor orders.

As you can see, CATS pulled in the information it found from the appropriate templates. Roles with no matching template come in with no account and no rate. Templates without codes on them come in with no account and no rate.

In order to properly create all of the Vendor Order line items, every line item in the list must have an account and a rate. If we fill in the rates and accounts, we can see the total charges that CATS will reserve for this traffic form. In our example, we have un-checked the line item for Other Customs Charges and filled in the other missing account codes and rates.

Completed Vendor Order line items on the Traffic form

Pick Save to save your changes and return to the traffic form. Choose Cancel to undo changes and return to the traffic form.

Once you have entered all of the rates and picked Save, CATS will show you the total number of Vendor order line items and their charges.

Summary of charges for VO items on traffic form

If you need to add another vendor order item to this form, you can do so by selecting the Add button when in the VO (vendor order item list) screen.

Pick Add when on the VO item list screen.

Next, CATS will ask you to select an existing role. You can pick from a role, and enter the information as you would when creating a template.

Enter details on an existing role for this form.

Or, you can pick Cancel to enter a manual role to be applied to this one form.

Select Cancel to create a new manual role to apply to this specific traffic form.

You will be prompted to add a new manual vendor order item. Pick Yes to proceed.

Select Yes to add a manual role.

Next, enter the details on this manual vendor order item, and pick Save to proceed.

Pick Save to add this manual vendor order item.

The new vendor order item will be displayed on the bottom of the list.

The new vendor order item with manual role will be displayed in the list.

The change in total will be displayed on the order screen in the vendor orders box.

New vendor order items totals.

A specific invoice type (VR) is required to use the vendor orders to generate a vendor invoice payable. If one does not already exist, you can set one up. For additional help with creating a new invoice type, see the wiki on Invoice types. Create a new vendor invoice and select the “VR” invoice type.

Enter the invoice number and the date.

On the main invoice screen, instead of “SInv” (Select Inventory) the menu has an option “SOrd” (for Select Order). Click on the “SOrd” menu option to enter a scan that displays all the unpaid Vendor Orders for the counterparty on this invoice.

The scan lists all unpaid vendor orders on a container-by-container basis.

The scan of unpaid vendor orders is shown here.

The on-screen search dialog allows filtering the list to find a specific container or traffic detail.
You can filter by

• Traffic form - Enter the type and number.
• Code - Cost code.
• Purchase - Purchase contract number.
• Sale - Sale contract number.
• Container.
• ICO Marks - Use one, two, or three fields of ICO marks to filter the list.
• Warehouse receipt.
• BL# - Bill of Lading number on the traffic screen.

It also displays status information so the user can see the current total amount of the VR they are creating and the total for the currently selected line.

On-Screen filter for vendor order line items with summary and selected item details.

1. As with paying disbursements and receipts, you can specify an alternative amount to pay on a line-by-line basis by entering the amount to put on the invoice directly in the scan.

2. You can choose “Pick” from the menu to pay the currently selected line at its calculated price.

3. You can select “Pick VO” to pay all containers for a particular vendor order item. This means that all containers that fit this vendor order will be selected.

Choose VO to select all containers related to this particular VO.

4. Use “Pick Form” to select all vendor order line items from the traffic form displayed in the form number column.

Choosing Pick Form selects all of the vendor order line items from a traffic form.

You can also modify the original vendor order definition by selecting Tools > Edit Vendor Order from the toolbar menu.

Use the menu item to modify the vendor order line item from the invoice.

This takes you to the box on the original traffic form for the order line item you picked. From here, you can modify the vendor order if it has not yet been charged on an invoice and it is for the invoice account.

Change the vendor order line item details from this box.

Once the orders have been picked, exit the scan and CATS will populate the invoice to match the vendor order details selected. Print and post the invoice as normal.

A Printed VR Vendor Order Invoice.

If you go back to any of the traffic forms affected by this invoice, the Charged amount will have changed in the VO summary section.

VO Summary Charged amount has now changed.