Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 17 Next »

Overview

The system allows downloading an AWB liquidation report including details for the AWB selected within the filter.

Downloading the AWB Liquidation Report

To Download the AWB liquidation through the Grower tab report follow the steps below:

  1. Go to the Grower Tab.
  2. Then to the AWB Summary sub-tab.
  3. Click on Download AWB liquidation Report


     

  4. A window to enter the e-mail address of the user will pop up, enter it and click on Send.

Reports Tab

The second screen in Komet to find the AWB Liquidation report is in Reports  > Vendor Report. You will have the option to download an AWB Liquidation with Sales Information report (Excel), this report contains information about the sales per line item. You will also find the regular AWB Liquidation report with no sales information (Excel or PDF). When you select the option needed, a window to enter the e-mail address to whom the report will be sent, enter it and click on Save.

The AWB liquidation Report will show all details relating to all AWB's by Vendor. The report is available both in PDF and .xls formats and contains different information.

 

 AWB liquidation report in PDF


Report Explanation

- Product: Product description.

- PO: The purchase order number.

- Box Type: Box Type product is packed.

- Pack: Units per Box.

- Qty: Number of boxes shipped.

- FBE: Full box equivalence.

- Freight: Freight cost per FBE.

- Unit Cost: Flower unit cost.

- Total Cost: Total flower cost.

- Credit: Product credit.

- Total Due: Balance due.

 AWB liquidation report in excel

 When you download the AWB liquidation report in .xlx format, additional information will appear compared to the PDF report.

Report Explanation
- Vendor: The name of the vendor.
- AWB:Airway bill number.
- AWB Ship Date:Air waybill ship date.
- AWB Arrival Date:Air waybill arrival date.
- Port of Origin: Code of the origin.
- Location: Location Code (Only applies for multi-location companies).
- PO #: Thepuchaseorder number.
- Customer PO#: Customer Purchase Order number
- Vendor Inv #: Vendor invoice number.
- Product: Product description.
- Category: Product category.
- Color: Product color.
- Variety: Product variety.
- Grade: Product grade.
- Box Type: Box size.
- Pack: Units per box.
- Qty: Number of boxes.
- Total Units: Total units purchased.
- FBE: Full box equivalence.
- AWB Freight/FBE: Freight cost per FBE.
- AWB Freight/Unit: Freight cost per unit.
- AWB Freight: Total Freight Cost.
- AWB Freight Type: Real or estimated.
- Duties / Unit: Duties Cost per Unit.
- Duties: Duties cost.
- Truck Freight / Unit: Land freight cost per unit.
- Truck Freight: Total freight cost.
- Landed Cost / Unit: Landed cost per unit.
- Total Landed Cost: Total landed cost of the product.
- Unit Cost: Flower unit cost.
- Total Cost: Total flower cost.
- Credit: Product credit.
- Total Due: Balance due.
- Reference #: Reference number.
- Lot#: Lot number.
- Sales Price: Unit price.
- Vendor Commission: The percentage to be paid to the vendor based on what is sold.
  • No labels