Container System

Tariffs are assigned to products and will increase the landed cost of the product based on a cost markup, weight markup and/or piece markup.

Here is where you can enter the Tariffs:

Or

Inventory System Inventory File Maintenance International Product Maintenance Enter & Edit Tariff Classification

Tariff Code – enter the tariff code (typically the tariff number XXXX. XX. XXXX)

Tariff Description – enter a description for the Tariff.

Duty – Cost – Duty % based on the cost of the product

Duty – Weight – Duty based on weight of the product (in kg)

Duty – Piece – Duty based on number of pieces.

Active – this will allow you to make tariff codes inactive so they cannot be assigned to products.

In Enter & Edit Products, under the Kits & Specification accordion select F6 Shipping & Quality

This is where the Tariff can be associated to an individual product:

or

Inventory System Inventory File Maintenance International Product Maintenance Enter & Edit Port

Port Code – Enter the port code to lookup the port.

Port Description – enter a description of the port.

County of Origin – enter the country of origin.

Active – this will allow you to make ports inactive so they cannot be assigned to containers.

or

Inventory System Inventory File Maintenance International Product Maintenance Enter & Edit Distribution Category

These are the different categories that costs assigned to containers (other than product and duty) get assigned to. These costs are distributed over the products by either weight or cost. They are sorted on the screens in Code Sequence, but only the description will be shown.

Distribution Category Code – enter a code (this is the sorting sequence) for the category. Distribution Category Description – enter the description (this will be shown on the screen) for the category.

Allocate Costs by – Choose either weight or cost on how to allocate the assigned costs. Active – this will allow you to make categories inactive so they cannot be assigned to containers in vendor invoices.

We suggest minimally having two distribution Categories – one allocated by cost and one allocated by weight. You can be as detailed as you want if you want to track different categories. Examples of detailed Distribution Categories would be:

Insurance Ocean Freight Wharfage and Handling Broker Fee Consolidation Fee

First, you must select an “Inventory on the Water Account”. This account cannot be an inventory asset account, but should be the next number after the inventory asset accounts so it shows on your financial reports right after your actual inventory numbers. This account will represent the inventory that you “own” that is on the water and not actually in your warehouse.

Secondly, we will be using an accrued account for the value of the product and duty. If you want a special accrued account for this, please enter it and expand your Accrued Payables range in the “Control Accounts – Balance Sheet”

Purchase Order System P.O. Receipt Routines Container Receipts Enter & Edit Container

The Vessel Name, Carrier, Bill of Lading, Route and Comments are basic fields that you fill in with information that you want.

The Port of Origin and Port of Entry lookup from Port List.

The Departure Date will be the GL date that the system puts the inventory into the Inventory on the Water Account.

The Expected Arrival Date is used in inquiries when looking at when a PO’s product is expected to be received. It overrides the PO’s and PO Detail’s Original & Current Promised Date in inquiries.

In ENTER & EDIT CONTAINER – Detail Lines, you choose a Purchase order to add to the container and do a pre-receipt (the normal receiving screens for a Purchase Order). This will be the detail of the amount of product that you are receiving. You setup the receipt, but until the Container is received, the PO remains “In Container” status

WARNING – The backorder of the PO is created immediately. If you receive or assign the PO backorder to another container, you can no longer edit the original PO in the first container.

As soon as the container is created, you can start assigning vendor invoices for the “added costs”. Product and duty vendor invoices cannot be assigned until the container is “shipped”.

In Ship Container, you choose the container, and update any of the basic information of the container and choose the accrued account that you want to offset the Product Cost and Duty into. The Departure Date will be the as of date that the inventory is posted into your GL.

Once the container is shipped, the value is posted to your On the Water Account and it will show as an asset in your GL reports. You can still edit basic information in Enter & Edit Container (for example to change the Expected Arrival Date).

Receive Container

In Receive Container, you choose the container and change any basic information. You can change the Posting Date (the date the PO is updated in the GL) and also the Over / Under Account. The Over/Under account will be used to deal with rounding errors due to the quantity and decimal precision of the unit cost of the products you are receiving.

If The Business Edge generates your internal lot numbers in (Document #)-(Revision)- (Line #) format, once the container is received, additional vendor invoices can be applied and are allocated to the items that are lot tracked using our laid in cost function. If you purchase items that are not lot tracked, those items cannot have additional costs allocated to them.

Shipped Containers can be reversed providing that vendor invoices have not been applied to the product or Duty cost.

Received Containers can be reversed providing that the inventory that was received is still in the same location and that vendor invoices have not been allocated to the container after the container was received

Container Inquiry

The Container Inquiry is a typical inquiry where general information such as departure date and expected arrival date can be viewed. As a Container is processed through the system the changers are recorded and can be viewed in Container Inquiry F3=Basic Information, F2=Change History.

F3=Basic Information, F3=Vendor Invoice(s) will show you the vendor invoices that were applied to this container. You can drill in to get more information.

F4=Detail Lines shows the Purchase Orders that are assigned to the container. You can drill into the PO’s to get more detailed information.

F5=Duty and Allocation Detail shows the products that are assigned to the container. While in the GUI, it is possible to export the Detail into excel, where you can see how each of the distribution categories affected each line. You can also drill into the lines to get more information about the Duty costs assigned to the individual line.

Accounts Payable System A/P Invoice Routines Enter Vendor Invoices

In vendor invoices, there is a new F-key – F6=Container. When you enter a vendor invoice that applies to a container, you select F6=Container and apply the vendor invoice to the container(s) it applies to.

Here is where you will choose the Container and can enter the amount that applies to the Product Cost and the Duty (assuming the container is shipped), and then you can allocate the rest over the container categories that you have setup.

You can assign vendor invoices to containers that have not shipped, however, then the container cannot be deleted without first canceling the vendor invoice.