Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Anchor
topofpage
topofpage

Excerpt

In this article, you will learn how to add the full cost of the AWB, including freight, duties, and handling to your orders. This feature is only available for Freight/Handling vendors. 

Tip

User Roles: Admin and Accounts Payable.

Info

Invoices associated with AWB can only be approved or rejected by authorized users. To learn more, read Allow Invoice Approval on Reconciliation Screens.

Table of Contents

Table of Contents
minLevel1
maxLevel1
include
outlinefalse
indent
excludeTable of Contents
typelist
class
printablefalse



What is a Real AWB Cost?

The Real AWB Cost is the actual handling cost known after fulfilling an order.

When you sell a product, the system will determine the total cost of a product based on the estimated freight cost and the financial data provided. This means that if there are unexpected fluctuations in the handling cost, you might need to update this information.

If this happens, you can update the information in the system to reflect the accurate cost of the product as soon as you know the actual cost.

Any changes in these charges will impact your gross profit margin.

Back to top


Enter the Real AWB Cost

To upload AWB invoices, follow the steps below:

  1. Go to A/P >AWB Reconciliation> Go to the Actions or Total Cost column and click  and select AWB Reconciliation. 

  2. Click on the Set AWB Cost link from the Actions or Total Cost columns.

  3. The AWB Cost window will pop up. In this window, users will have two options to set the real AWB cost:

    Option 1Set the real AWB cost. There are two ways to add the costs:

    1. Manual: Manually enter the Freight, Handling, and Duties for the AWB invoice.

    Once
    1. The system will use this information

    is entered, the system will
    1. to automatically calculate the Total Cost per

    unit
    1. Unit of all products within the AWB and will override the original

    estimates from the financial settings, causing a recalculation of
    1. estimate, recalculating the landed cost

    (for products in units or boxes in all the system screens)
    1. .

    Option 2: Users can upload an attachment of  the AWB invoices. The user will click on the 
    1. Upload: Upload a file with AWB invoices by clicking on Upload AWB Invoice

     green button. A window called AWB Invoice will appear, fill out the requested information and search or drag the invoice file to upload. Then, click on Save.
    info: When entering $0 on the Freight or Handling fields, the system will leave that cost as 0$ whereas if you leave these fields in blank, the system will use the estimated value.After clicking on Save, the
    1. . To learn more, read Upload AWB Invoices.

  4. Click on Save, a window will expand to display additional information about the Type, Amount, and Description of the charge. Finally, click

  5. Click on Add

  6. After clicking on Add, the users will see another line with the information of the charge added to that invoice. If done adding all charges within that invoice, click on the Close button, and the system will show the invoice with all the charges added. 

  7. After uploading the invoice, the user will have the option to Approve, Edit, Delete or View that invoice by going to the Actions column.

  8. Once the user reviews the invoice, the invoice can be approved; then Repeat this process for every invoice and click on Close when you finish.

Once you upload the invoice, you can approve, edit, delete, or view it from the Actions column. After the invoice is approved, these charges will have to be approved

by accounting

by accounting and transferred to the external accounting system (if this option is

available

enabled).

info: The process above will cause the system to automatically re-calculate the freight per unit for items in the AWB. This calculation will override the original estimates from the financial settings. In addition to this, the landed cost per unit will be recalculated using the real freight, so keep in mind that your GPM might be affected either in a positive or a negative way.
  • The user can also download the invoice after it has been approved. 

  • The user will have the option to

    You can download the invoice and compare the Real AWB cost with the Estimated AWB cost that the system

    calculates with

    calculated using the Financial Settings by clicking on the Actions column to view the invoice details.

    The system will show a green arrow when the Estimated value is higher than the Real value

    ,

    and a red arrow when the Real value is higher than the Estimated value.

     Please see the image below:
  • An invoice can also be canceled from here by authorized users. Once an invoice is approved, click on the Actions box and you will be able to view the invoice details or cancel it.

  • InfoThe system allows you to identify those AWBs which don't stay in the warehouse once they arrive. The boxes are scanned and the products in transit continue to their final destination

    Info

    Once the AWBs reach the warehouse, you can easily identify the ones that are not stored there. This is done by scanning the boxes, and the products are then transported to their intended destination without delay. To learn more, read Ship Via Cross-Dock.

    Back to top

    Multimedia
    nameCUzTg3SVWG.mp4
    width600
    height450

    Enter the AWB Weight

    While When you are entering enter the AWB cost based on from your vendor invoices, the our system will also provide an estimate of the Weight weight per AWB. The Current weight will be estimated based This estimation relies on the weight of the boxes entered per box in the Box Dimensions setup for the products within in the AWB or in the Staging Area. The system will also calculate the Average Weight, which is obtained dividing the Total Weight In addition, our system calculates the average weight by dividing the total weight by the FBE of the AWB.The

    Image Added

    Chargeable Weight

    You have the option to manually input the AWB chargeable weight can be manually entered based on using the information sent provided by your vendor. Notice of If there is a difference discrepancy between the Current current weight and the chargeable weight, the system will alert about it.Underweight: the system will display a red arrownotify you.

    Image AddedImage Added

    Upload AWB Invoices

    To upload your AWB Invoices, do the following instructions:

    1. Go to A/P and select AWB Reconciliation.

    2. Search the AWB.

    3. Click on Set AWB Cost from the Actions column.

    4. Click on the Upload AWB Invoice green button.

    5. Fill out the requested information.

    6. Upload the file.

    7. Click on Save.

    If you enter $0 in the Freight or Handling fields, the system will consider the cost as $0. However, if you leave these fields blank, the system will utilize the estimated value.

    Back to top

    Image RemovedImage RemovedImage Removed


    Edit Invoices

    The system will allow users to edit the information previously entered or uploaded.

    If no invoice attachment was uploaded, follow do the next stepsfollowing instructions:

    1. Go to the Actions or Total Cost column and click on the "Change the AWB Cost" link. 

    2. Enter the new Freight, Handling, Handling  or Duties information and click on Save. The total cost will be recalculated.

    If the user uploaded an invoice to the system, the invoice must have a "Pending Approval" status in order for it to be edited. In order to do soIf the invoice was uploaded, do the following instructions:

    1. Go to to the Actions or Total Cost column and click on the "Change the AWB Cost" link. 

    2. Go to the Actions column next to the invoice that needs to be changed and click on Edit.

    3. A new window will pop up for the user to edit the information entered. Edit the information needed and click on Save.

    Back to top


    Filter by label (Content by label)
    showLabelsfalse
    max5
    sorttitle
    titleRelated Articles
    cqllabel in ( "awb-cost" , "awb-weight" , "upload-awb-invoices" , "awb-invoice" , "awb" , "accounts-payable" )
    labelsawb awb-weight awb-invoice awb-cost accounts-payable upload-awb-invoices