General description #

The purchase processing report illustrates the data about the Purchase invoices. This is a very detailed report on purchase bookings. When expected costs are booked into Qbil-Trade they get assigned an internal Qbil-Trade purchase booking number. Each purchase booking is logged into this report with all the important details related to these bookings. Not just the details of the booking itself but also what order, transport order, contract, etc are associated with this purchase booking. You can quickly look up all paid invoices on a certain contract, or order.

Purposes/Objectives #

The report can serve multiple purposes as per your business requirements and the way you are handling data from the report, but the main purposes of this report can be enumerated as follows:

• The report can be used to get an overview of all the purchases made with a particular relation or of a particular product (using the filters). Thus allowing you to get the periodic turnover details with a particular relation or of a particular product.
  P.S. You can also create a custom report(using web reports) per product or relation to get a clear overview of the purchases made with the respective relation or of the product.
• The report can also be used to evaluate the differences(if any) between the purchase invoices in Qbil-trade and your accounting software for the smooth processing of your accounts.
• The report can also be useful in terms of filing tax returns and financial reporting requirements.

Additional Filters #

The additional filter available for the report is the Date range. The date range filter in this report displays only those records that fall between the dates chosen for “From Date” and “To Date” of the filter. The date range filter is used on the Invoice date column, which shows the invoice date entered for an invoice. You can use this filter in the report to view the invoices created between a particular date range.

Columns #

• Subsidiary: This column displays the name of the subsidiary used in the invoice. On hover, shows the info text/description “Subsidiary that owns the contract/lot”.
• Invoice number: This column displays the given invoice number. On hover, displays the info text “The invoice number”.
• Creditor: This column displays the name of the creditor of the associated booking line. On hover, displays the text “The transporter/broker used in the lot”.
• Creditor number: This column displays the creditor’s invoice number. On hover, displays the text “Creditor’s invoice number”.
• Invoice Description: This column displays the description added to the invoice. On hover, displays the info text “The invoice description in Q.T.”.
• Payment condition: This column displays the payment condition used in the invoice. On hover, will display the text “Payment Condition”.
• Invoice date: This column displays the invoice date of the purchase invoice. On hover, will display the text “The invoice date”.
• Expiry date: This column displays the due date of the purchase invoice. On hover, will display the info text “Expiry date of the stored lot or production order”.
• Payment date: This column displays the payment date of the purchase invoice. On hover, displays the text “Payment date”.
• Currency: This column displays the currency used in the purchase invoice. On hover, displays the 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.”
• Exchange Rate: This column displays the exchange rate of the booking line in the booked purchase invoice. On hover, displays the text “Currency exchange rate”.
• Net amount F.C: This column displays the Net amount in the currency used in the invoice. On hover, displays the text “Net amount in foreign currency”.
• Net amount base currency: This column displays the Net amount in the base currency of the operating subsidiary. On hover, displays the text “Net amount in base currency”.
• VAT amount F.C: This column displays the VAT amount of the invoice in invoice currency. On hover, the column displays the short info text “VAT amount in foreign currency.”
• VAT amount base currency: This column displays the VAT amount of the invoice in base currency. On hover, displays the text “VAT amount in base currency”.
• Total amount F.C: This column displays the total amount of the invoice in the currency used in the invoice. On hover, displays the text “Total amount in foreign currency”.
• Total amount base currency: This column displays the total amount of the invoice in base currency. On hover, displays the text “Total amount in base currency”.
• Status: This column displays the status of the purchase invoice, two values are shown ‘Expected’ or ‘Still assign’. On hover, displays the text info “Status”.
• Date of the Status change: This column displays the last date of the status change. On hover, displays the info tip “Last date of the status change”
• Supplier VAT no.: This column displays the supplier VAT number. In hover, gives the info tip “Supplier VAT number”.
• Remarks: This column displays the internal remark of the invoice. On hover, displays the info tip “Remarks chosen in the contract or placed at stock lot”.
• Order number: This column displays the order number of the booking line in the booked purchase invoice. On hover, the column header displays the info text “Order associated with the contract”
• Unloading date: This column displays the unloading date of the order given in the booking line. On hover, displays the info text “Unloading date for the lot”.
• Invoice number in Q.T: This column displays the Invoice no in Q.T given in the associated booking line. On hover, displays the text “Invoice number in Q.T.”
• Contract number: This column displays the Contract number of the associated booking line. On hover, displays the text “Contract number”.
• Contract Exchange Rate: This column display the exchange rate set in the contract. On hover, displays the info tip “Contract exchange rate”.
• VAT Code: This column displays the VAT code selected in the Purchase invoice. On hover, displays the info tip “VAT code”.
• Ledger account net amount: This column displays the code for VAT of the purchase invoice type from the payable account side in the ledger account of selected VAT. On hover, displays the info tip “Ledger account net amount”.
• Ledger account description: This column displays the VAT code description of the invoice type in the ledger account of the selected VAT. On hover, displays the info tip “Ledger account description”.
• Cost Type: This column displays the type of the costs like transport, goods, commission, etc. On hover, displays the text “Cost type”.
• Product code: This column displays the code of the product used in the contract. On hover, displays the text “Shortcode of the product”.
• GN code: This column displays the GN code of the product used in the contract. On hover, displays the info tip “GN code of the product”.
• Expected amount in F.C.: This column displays the contract value in the currency used in the related contract. On hover, displays the info tip “Expected amount in foreign currency”.
• Expected amount in base currency: This column displays the contract value in base currency. On hover, displays the info tip “Expected amount in base currency”.
• Net allocated quantity: This column displays the total quantity in kgs used in the contract. On hover, displays the info tip “Total quantity in KGs”.
• Quantity Unit: The quantity unit used in the contract is displayed in this column. On hover, the column displays the info text “Unit used in quantity”.
• Pricing unit: The unit used for pricing in the contract is given in this column. On hover, the column displays the short info text “Unit the contract is priced in.”
• Net allocated amount F.C: This column displays the total amount in the currency used in the contract. On hover, the column displays the short info text “Net allocated amount in Foreign currency.”
• Net allocated amount base currency: This column displays the total amount in the base currency of the subsidiary. On hover, the column displays the short info text “Net allocated amount in base currency.”
• Correction quantity: This column displays the corrected quantity in kgs shown in the invoice. On hover, displays the info tip “Corrected quantity in kgs”.
• Correction amount F.C: This column displays the amount in the currency used in the invoice. On hover, displays the info tip “Correction amount in foreign currency.”
• Correction amount base currency: This column displays the amount in the base currency of the subsidiary. On hover, displays the info tip “Correction amount in base currency.”
• Difference in amount: This column displays the difference amount calculated in base currency. On hover, displays the info tip “Differenced amount calculated in euros”.
• Contract sender: This column displays the name of the users that are set as a trader in the contract. On hover, displays the info tip “Name of the users”.
• Logistic employees: This column displays the value from the field “person responsible for order” of the related order. On hover, displays the info tip “Responsible logistic employees”.
• Our VAT registration number: This column displays the company’s VAT registration number. On hover, displays the info tip “Company’s VAT registration number”.
• DUNS Code: This column displays the nine-digit DUNS number of the buyer. On hover, displays the info tip “DUNS Code”.
• ONS Code: This column shows the ONS number of the relation. On hover, displays the info tip “ONS code”.
• Origin for intrastat purposes: The column gives the value entered in the field “Origin for intrastat” on the purchase contract associated with the invoice. On hover, the column displays the short info text “origin for intrastat.”
• Purchase incoterms: The column displays the delivery condition as per the purchase contract associated with the invoice. On hover, the column displays a short info text, “Incoterms(Purchase contract).”