Stock including contracts

General description #

The stock including contracts report in Qbil-Trade provides a summary of all the items that are currently in stock. Purchase contracts are also included in this report. As a result, this report includes details about the stock as well as the goods bought using the purchase contract. The purchase contract for a product is distinguished from the various stock lots of the associated contracts in the report. Information about stock products, including lot number, product specification, description, and packing, is included in the report. The report includes additional information about product quantity and cost. For available stock and purchase contracts, the majority of the information is typically retrieved from the lot screen and contract lines, respectively.

Columns #

  • Our Reference: This column shows the lot number that is fetched from the field “Our ref. No” on the lot screen. In the case of a purchase contract, the contract number is fetched from the related contract and displayed in the column. On hover, it displays the info text “Reference number of the lot as known by the subsidiary”.
  • Product Code: The code of the product is shown in this column which is fetched from the lot screen field “Product”. On hover, it displays the info text “Short code of the product”.
  • Product specification: This column shows any specifications of the product entered in the related lot’s purchase contract field “Product specifications”. On hover, it displays the info text “Product specification”.
  • Product description: The description related to the product is displayed in this column. This description is usually added to the product screen while adding a product. On hover, it displays the info text “product description”.
  • Packaging The packaging type used for the product is shown in this field. The data in this field is fetched from the field “Packaging” of the related contract. On hover, it displays the info text “Packing of the product”.
  • Warehouse: This column shows the name of the warehouse where the stock will be stored. In the case of the contract line, the “location/delivery address” mentioned in the related Purchase contract is shown. For the stock lot, the “Production Prefix” of warehouse relation used for the lot is displayed. On hover, it displays the info text “Warehouse where the lot is stored”.
  • Batch No.: This shows the batch number added to a lot in the warehouse. For purchase contracts, it displays “contract line”. For the available stock, the data is fetched from the field “ref. suppl./lot no.” of the lot screen. On hover, it displays the info text “Batch number”.
  • Remaining net expected quantity: The remaining quantity column shows the quantity of product available at the moment in stock. For available stock, the quantity shown under the remaining field in the mutation table of lots screen is shown here. In the case of the purchase contract line, the total quantity of the contract is displayed. On hover, it displays the info text “Remaining net expected quantity”.
  • Quantity Unit: The quantity unit of the contract is displayed in this column for the purchase contracts. For the stock lot, it shows the quantity unit from stock. On hover, the column displays the short info text “Unit used in quantity.”
  • Price per MT: The price of the product per 1000 kgs is mentioned under this column. The details are usually fetched from the purchase contract field with the same name in the case of the contract line & from the lots screen field “Price per 1000 kg” in case of available stock. On hover, it displays the info text “Price per 1000 units”.
  • Reference price per ton: Any reference price added in the related contract is shown in this column. On hover, it displays the info text “reference price per ton”.
  • Price per ton include other costs: This column shows the cost of the product per 1000 kg including all the other order costs (if any). The order costs are added to the order screen of the related contract. All the order costs included in the order screen are added to the net price per 1000 kg & displayed in this column. On hover, it displays the info text “price per ton include other costs”.
  • Pricing Unit: The Pricing unit from the contract is given in this column for purchase contracts. For stock lots, it displays the pricing unit of stock. The pricing unit is used for invoicing orders. On hover, the column displays the short info text “Unit the contract is priced in.”
  • Finalised: The column displays whether the related order is finalised or not. On hover, it displays the info text “FInalised”.
  • Remarks: Any remarks entered related to the lot are displayed in this contract. On hover, it displays the info text “Remarks chosen in the contract or placed at stock lot”.
What are your feelings
Updated on September 19, 2024
Table Of Contents

FAQ'S

Accounts and Financial

  • Unable to find invoice for export in current month

    Invoices are displayed on the export screen in a particular month. The month of the invoice is taken from the invoice date and not from another date, such as the due date.

    The invoice date is therefore leading in terms of month for export periods. For example: Invoice date 22-05-2022 and due date 15-06-2022. This invoice will appear in the export under the month May.