Open account list purchase

General description #

The open account list purchase report allows you to get an overview of all the purchase invoices that are unpaid or open. The report gives the details of unpaid purchase(booked) invoices with important details like the relations associated with the unpaid purchase invoices, VAT, and net amounts in base currency and foreign currency. The report will thus help you to list the relations you owe money against the various purchase invoices.

Purposes/Objectives #

The main purposes of the report are:

  • The report helps mostly the users to get the list of all unpaid invoices who don’t have linked accounting software with the Qbil-trade.
  • The report enables you to filter the unpaid invoices per supplier and thus helps you to get the payment status per supplier.

Columns #

  • Subsidiary: The column displays the name of the subsidiary associated with the invoice. On hover, it displays the info text “Subsidiary that owns the contract/lot”.
  • Invoice Number: The Qbil-Trade invoice number is displayed in this column. On hover, it displays the info text “The invoice number”.
  • Invoice date: The invoice creation date is displayed in this column. The value is fetched from the field “Invoice Date” of the Sales or purchase invoice. On hover, it displays the info text “The invoice date”.
  • Expiry Date: The due date entered for the invoice is displayed in this column. On hover, it displays the info text “ Expiry date of the stored lot or production order”.
  • Relation Name: The company name of the relation of the invoice, that is, supplier for purchase invoice is given in this column. On hover, it displays the info text “Buyer/Seller of the product”.
  • Currency: The currency of the invoice is displayed in this column. The value is fetched from the field “Currency” of the related invoice. On hover, it displays the info text “Currency”.
  • Base Currency: The currency of the operating subsidiary for the invoice is displayed in this column. On hover, it displays the info text “Base currency.”
  • Net Amount F.C.: The net amount of the invoice in foreign currency is displayed in this column. On hover, it displays the info text “Net amount in foreign currency”.
  • Net Amount base currency: The net amount of the invoice in base currency is given in this column. On hover, it displays the info text “Net amount in base currency”.
  • Vat Amount F.C: The VAT amount of the invoice in foreign currency is displayed in this column. On hover, it displays the info text “VAT amount in foreign currency”.
  • VAT Amount Base currency: The VAT amount of the invoice in base currency is displayed in this column. On hover, it displays the info text “VAT amount in base currency”.
  • Total Amount F.C: The total amount of the invoice including the VAT amount is displayed in the column. On hover, it displays the info text “Total amount in foreign currency”.
    • Calculations: Net Amount F.C. + Vat Amount F.C = Total Amount F.C.
  • Total Amount base currency: The total amount of invoices in Euros is displayed in this column. On hover, it displays the info text “Total amount in base currency”.
    • Calculations: Net Amount base currency + VAT Amount base currency = Total Amount base currency.
  • Purchase Contract: The contract number (purchase/sales) related to the order is given in this column. On hover, displays the info text “Purchase contract”.
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.