Open account list sales

General description #

The open account list sales report in Qbil-Trade provides insight into all unpaid sales invoices of a company. The report gives the details of unpaid sales invoices with other important details like the relation name(buyer), VAT, and net amounts in base and foreign currency, etc. The report thus helps you to track current outstanding sales invoices that have not been paid by customers

Purposes/Objectives #

The few purposes among various purposes served by the report are:

  • The report lets you get the status of the due or overdue invoices, thus enabling you to keep track of your receivable account and monitor the amount of money owed by the customers/buyers.
  • The report enables you to filter the unpaid invoices per buyer and thus helps you to get the payment status per buyer.

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 “Invoice number”.
  • Invoice date: The invoice creation date is displayed in this column. The value is fetched from the field “Invoice Date” of the 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, the customer for the 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 order 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 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 base currency 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
  • Sales Contract: The sales contract number related to the order is given in this column. On hover, it displays the info text “Sales 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.