General description #

The Controlelijsten report or control list report is one of the most important logistics reports in Qbil-Trade. It provides you with an overview of numerous basic data of a company, For example, customers and clients, products, relations, etc. This report allows you to view the different details related to the standard data of the business.

The Controlelijsten report or control list report provides the descriptive view of various root data of a company. This report views the list of the different root data elements and other details related to them. For example, Klanten & Artikelen(supplier & product) report different information related to the product, its packaging, expiry dates, subsidiaries using the product, different price factors, taxes involved, etc. are provided. In a similar manner, various other basic elements and other parameters related to them are included in multiple sheets. Thus this report provides a thorough analysis of all data and other parameters associated with the data in multiple separately classified sheets/tabs.

Columns per sheet #

The data in this report is fetched from different root data elements and various information related to them is provided in separate sheets/tabs.

Artikelen (commodity/products): #

The sheet provides information related to products used by the company (whether active or inactive currently). The report helps you to get an overview regarding all the products added in the product management, their pricing details, packing details, classification, etc.

• Groepnaam (Group name): This column gives the Product group to which the product has been added. This value is fetched from the field “Product group” of a product.
• Code: The code of the product is shown in this column. This value is retrieved from the field “Code” of a product.
• Omschrijving (Description): The description related to a product is given in this column.
• Classification: The classification of the product as per the Harmonised System that helps in identifying the product is given in this column. The HS-Code entered for the product is given in this column.
• BTW Code (Tax code): This column displays the code of the default VAT selected for the product.
• Palletsoort (Pallet type): Default pallet type selected for the product in the product screen is shown in this column.
• Exp-months: The shelf life of a product is given in this field. This value is given in months.
• kg per pallet: Maximum quantity of products that can be handled per pallet is given in this column.
• Verpakking (Packaging): The default packaging used for a product is given in the field. This value is selected in the dropdown menu in the product screen field “Default Packaging”.
• Linked_subsidiaries: The subsidiaries that are using this product are displayed here.
• Recipe_price: The purchase price of the product can be viewed in this column.
• Packing_price: The cost of the default packaging selected for the product is shown in this column. This value is fetched from the packaging screen of the selected packing type.
• Pallet_Price: The price of the default pallet type selected for the product is given in this column. The data is fetched from the pallet information of the selected pallet type.
• ADR: Whether the product is ADR or not is mentioned in this field. If yes it displays “J” otherwise it shows “N”.
• Supplier: The supplier of the product added(if any) can be viewed in this column.
• Tariccode: The taric code of a product that identifies the rules applied to products while imported to the European Union. The taric code of a product is added to the related product screen.
• Tariefcode (Tariff code): The tariff code of the product is given in this column.

A tariff code is a product-specific code as documented in the Harmonised System (HS) maintained by the World Customs Organisation (WCO). Tariff codes exist for almost every product involved in global commerce. Required on official shipping documents for tax assessment purposes, a tariff code ensures uniformity of product classification worldwide.

• GN Code: The GN code of the product is displayed in its column.

The GN code (Gecombineerde Nomenclature) is the 8-digit code used when exporting products from an EU country to a non-EU country. This code is also called CN code(Combined Nomenclature).

• Gevaarlijk (Dangerous): This column gives the information related to a product whether the product is hazardous or not.
• Big bag: Gives the information number of big bags used for the product.
• Label_color: The colour of the label of the product is given in this column. This value is fetched from the customized field “label kleur” on the product screen.
• Associated products: Any product associated with the product is shown in this column. The code of the product associated is displayed.
• Hidden: This column conveys whether the product is active or not for the usage. The column displays two values “Yes” or “No”.

Verpakkingen (Packaging): #

This sheet provides the information about all the packaging used by the company which is added to the root data.

• Code: The code added for the packaging is displayed in this column.
• hvh per packing (Quantity per packing): This column provides information about the number of products that can be accommodated per packing.
• Bulk_of_zakg (Bulk or bag): Whether the packaging is bulk type or bag type is shown n this column. This data is retrieved from the related packaging type.
• Big bag: Gives the information whether the packaging type is a big bag or not. The value is fetched from the checkbox “big bag” of the related packaging type.
• Packing Price: The cost of each packing unit is shown in this field. The value is fetched from the related packaging screen.
• Zaksoort (Bag type): This gives the info about the bag type of the selected packaging.
• Afmetingen (Dimensions): The dimensions of the packaging are shown in this column. The value is fetched from the related packaging field “Dimensions”.
• Tare: The unladen weight or tare weight that is the weight of an empty packing type, is given in this column. This information is fetched from the related packaging screen.
• NL_omschrjiving (NL_description): The description of the packaging in the Dutch language.
• EN_omschrjiving (EN_description): The description of the packaging in the English language.
• DE_omschrjiving (DE_description): The description of the packaging in the Spanish Language
• FR_omschrjiving (FR_description): The description of the packaging in the French language.

Bedrijven (Relations) #

This sheet provides a report on all the relations and other details related to these relations added by the company.

• Bedrijfsnaam (Company Name): This column displays the name or Company Name of the relation.
• Verkorte Code (ShortCode): The shortcode of the relation is shown in this field.
• Relatiesoort (Relation type): This column gives the information relation type Fetched from the screen. For example, the relation can be a customer, supplier, business unit, or anything likewise. This value for a relation is added in the relation screen.
• Valuta (currency): The default currency of the relation is shown in this column.
• Incoterms_Sales: The default sales delivery conditions set for the relation. This information is added in the default tab of the Relation Screen.
• Incoterms_purchase: The default purchase delivery conditions set for the relation. This condition is set in the default tab of the relation Screen.
• Land(Country): The country of the relation is displayed in this column. This country is set in the address tab of the Relation.
• Exp_months: The default expiry months of the products for the relation are shown in this column.
• Betaalvoorwarde Sales(Payment conditions Sales): The default Payment condition for the sales contract with the relation is displayed in this column.
• Betaalvoorwarde Purchase(Payment conditions purchase): The default Payment condition for a purchase contract with the relation is displayed in this column.
• Omschrijving betaalvoorwarde Sales (Description payment condition Sales): The description for the default payment conditions set for the sales for relation is displayed in this column.
• Omschrijving betaalvoorwarde Purchase (Description payment condition Purchase): The description for the default payment conditions set for the purchase for relation is given in this column.
• Relatie: Voor transport (Transport costs of Relation): The default transportation cost of the carrier for the relation is given in this column.
• Relatie: Wegtransport (Relation: Road Transport): The default transportation cost of road transport for the relation is given in this column.
• Relatie: Zeetransport (Relation: Sea Transport): The default charges set for sea transportation for the relation are given in this column.
• Land: Zeetransport (Country: Sea Transport): The default sea transportation charges in the country of the relation are given in this column.
• Leverconditie Sales: transp. verz (Delivery Condition Sales): The fixed shipping charges for sale or export in the country of the relation are given in the column.
• Leverconditie Purchase: transp. verz (Delivery Condition Purchase): The default purchase or importing charges for the relation’s country are given in this column.
• Land: bankkosten (Country: Bank costs): Any bank costs involved in the trade with the relation for the relation’s country are shown in this column.
• Land: Legalistie (Country: legalization): The default legalization costs that are implied on trading with the relation are displayed in this column.
• Relatie: THC (Relation: THC): THC or Terminal Handling charges that apply default when trading with the relation is given in this column.
• Land: THC (Relation: THC): The default THC or terminal charges applied when trading with the Land or Country of the relation are viewed in this column.

Commissies (Commission): #

This sheet provides information on all the relations and commission or broker details related to these relations.

• Bedrijfsnaam (Company Name): The name of the relation fetched from the field “Company Name” of the relation.
• Verkorte Code (ShortCode): The shortcode of the relation is shown in this column.
• Makelaar (Broker): The broker(commission agent) added for the relation is displayed in this column. This value is fetched from the broker agreement section of the relation.
• Makelaar Code (Broker Code): The shortcode of the broker(relation) is displayed in this column.
• Type: The commission agreement is based on either percentage or amount per 1000 units in the currency agreed. This column gives the information about the commission type agreed with the broker or commission agent.
• Currency: The currency selected for the broker agreement is given in this column if the commission type is the amount per 1000 units.
• Price per tonne: The amount to be paid to the broker or commission agent for the broker agreement. This displays the price per tonne in the currency selected for the commission.
• Percentage: The percentage agreed with the broker for commission(if percentage type agreed) is displayed in this column.

HS-codes #

The Sheet for HS-Codes gives the summarised information about the Harmonised Standard(HS) codes used for the products. These codes are added in the classification module of Product Management.

• Id: unique ID of the classification type or HS- Code is given in this column.
• Code: The code of the HS-code is displayed in this column.
• Description: The description mentioned related to the HS-Code is displayed in this column.
• Required Docs: The documents required for the products under this HS-Code are given in this field.

Landen (Country) #

The sheet provides the overview of all the countries added for trading and other important information related to these countries like documentation and import/export rules for these countries.

• Code: The alphabetic code of the country is displayed in this column. For example, NL is the code of the Netherland.
• Naam (Name): The name of the country is given in this column.
• Export Document: Any important export document required when trading with the country.
• Bank: In this column, you will find any costs involved in trade (import/export) within this country.
• Legalisatie (Legalisation): Any legalisation costs applying for the trade in the country are displayed in this column.
• Zee transport (Sea Transport): The column shows the fixed charges for Sea transport in the country.
• THC Costs: The default THC or terminal handling Costs for the country are displayed in this column.

Betaalvoorwaarden (Payment Conditions) #

This sheet provides the information related to the payment conditions added in root data. These Payment conditions are mutually agreed upon by the buyer/seller for the contracts. All the general details related to these payment conditions are summarised in this report.

• Code: The code of a payment condition is shown in this field. This code is entered in the Payment condition screen.
• Opmerking (Remarks): The remarks related to the payment condition are given in this column.
• Verval Period (Expiration Period or Due Period): This column indicates the number of days during which the payment must be made in this payment condition.
• Verval Method (Expiration method or due method): This column explains the basis for the due date. For instance, whether the period set in the payment condition is determined by invoice date, loading date, unloading date, etc.
• Percentage vooruit (Percentage in advance): This column gives the percentage to be paid in advance against the invoice where the payment condition is applied.
• Auto incasso (Auto collection): Whether the amount is to be auto-collected or not under this payment condition is displayed in this column. This value is given in either 1 meaning ‘Yes’ or 0 meaning ‘No’.
• Active: Whether the payment condition is currently active or not for the company is displayed in this column.
• Rente(Interest): The default interest applied under the payment condition can be viewed in this column.
• Omschrijving in NL (Description in NL): The description of the payment condition is displayed in the Dutch language.
• Omschrijving in EN (Description in EN): The description of the payment condition in the English language.
• Omschrijving in DE (Description in DE): The description of the payment condition is displayed in the Spanish Language.
• Omschrijving in FR (Description in FR): The description of payment conditions displayed in the French Language.

Klanten & Commodity (Clients & Products) #

This sheet provides you with an overview and list of all their clients and products. The report also gives the other details per product.

• Id: The unique id of the product is given in this column.
• Verkorte Code (ShortCode): The shortcode of the relation that is added as supplier or customer of the product.
• Bedrifs Naam (Company Name): The name of the relation which is the supplier or customer of the product is given in this field.
• Land: The country of the relation(Supplier or customer of product) is mentioned in this column. The country is added in the Address Details of a relation.
• Artikel Group (Product Group): The group of products is given in this column. This group is added to the Product screen.
• Artikel Code (Product Code): The product code of the product is given in this column.
• Klantspecifieke omschrijving (Customer Specific description): This column provides the product description that is specific to this relation, who has been added as a customer or supplier. This description is added in the products tab of the relation.
• Omschrijving (Description): The description of the product is added to the product screen.
• Classification: The HS- Code of the product is displayed in this column. HS-code or harmonized system code is a universally accepted code of a product used to classify a product in customs.
• Pallet Soort (Pallet Type): The pallet type added for the product stacking is displayed in the column.
• Verpakking (Packaging): The type of packaging added for the product packing is shown in this column.
• Exp_months Artikel (Exp_months Product): The shelf life of the product in months added to the product screen is mentioned in this column.
• Exp_months relatie (Exp_months Relation): The shelf life of the product in months added in the relation screen is given in this column.
• Linked subsidiaries: The subsidiaries linked with the product or the subsidiaries that use the product for sale or purchase are displayed in this column.
• Recipe price: The purchase price added for the product in the relation tab is displayed in this column.
• Marge (Margin): The margin added by the relation for the product is displayed in this column.
• Packing price: The price of the packing used for the product packaging is displayed in this column.
• Pallet price: The charges for the default pallet selected for the product is given in this column.
• ADR: The ADR status of the product whether checked or not for the product is given in this column.
• Tariccode: The taric code of a product that identifies the rules applied to products while imported to the European Union is given in this column. The taric code of a product is added to the related product screen.
• Tariefcode (tariff code): The tariff code of the product is given in this column.
• GN Code: The GN code of the product is displayed in this column.
• Gevaarlijk (Dangerous): This column shows the nature of the product whether hazardous or dangerous or not.
• Idtf nummer: The IDTF number of the Product is given in this column.
• Bigbag: Whether the packaging used for the product is bigbag or not is given in this field.
• Labelc_color (Label Color): The colour of the label of the product added in the relation screen is mentioned in this column.
• Associated Products: Any associated products related to the product are given in this product. The code of the product is displayed in this column.