General description #
The miscellaneous sales report gives you an overview of all miscellaneous sales invoices that have been created. Miscellaneous sales invoices enable you to send invoices outside the regular trading flow. This feature is primarily used for invoicing any expenses that occur. It displays various details of these invoices, such as the invoice date, payment date, VAT details of the subsidiary and relation, invoice amount, and so on. This report also indicates whether a specific invoice was printed or exported.
The report is available only for customers with configuration misc_sales_invoice enabled.
Purposes/Objectives #
Following are some of the objectives of the report.
- The report is to keep track of all the miscellaneous expenses involved with the sales of the company.
- The report enables its users to manage the impact of the misc. sales invoices on the overall profit/loss position of the company.
- The report can be used to compare the information with the accounting software to avoid any accounting errors or discrepancies.
Columns #
- Invoice Number: This column shows the invoice number of the miscellaneous sales invoice. On hover, it displays the info text “Invoice number.”.
- Invoice Date: This column shows the creation date of the misc. Sales invoice. This data is fetched from the related miscellaneous sales invoice. On hover, it displays the info text “The invoice date”.
- Expiry Date: The expiry date column shows the due date of the miscellaneous sales invoice. The data in the report is fetched from the field “Due date” in the miscellaneous sales invoice. On hover, it displays the info text “Expiry date of the stored lot or production order”.
- Payment date: This is the date on which the payment against the related invoice is made. On hover, it displays the info text “Payment date”.
- Subsidiary: This column shows the subsidiary ID of the selected subsidiary in the miscellaneous sales invoice. On hover, it displays the info text “Subsidiary that owns the contract/lot”.
- Our VAT registration: This field shows the VAT number of the selected subsidiary. The data is fetched from the field “Our VAT registration” in the miscellaneous sales invoice. On hover, it displays the info text “Our VAT registration”.
- Relation: This field shows the name of the relation for which the invoice was generated. The data from the field “Company” of the related Sales invoices are shown in this column. On hover, it displays the info text “Relation”.
- Your VAT no.: This column shows the VAT registration of the relation. The data for this column is fetched from the field “VAT number of the supplier/buyer”.
- Revenue Account: This shows the sales ledger account related to the selected VAT in the invoice. The data is fetched from the field “Receivable account” in the related Misc. Sales Invoice. On hover, it displays the info text “Revenue account”.
- Currency: The currency selected in the currency field of the miscellaneous sales invoice is shown here. On hover, it displays the info text “Currency”.
- Sum(F.C.): This column shows the amount in the selected currency. The data is fetched from the “Amount” field in the miscellaneous sales invoice. On hover, it displays the info text “Sum(F.C.)”.
- VAT Code: The VAT Code of the selected VAT percentage that applies to the Sum(F.C.) is shown in this column. On hover, it displays the info text “VAT code”.
- 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.”
- VAT Amount F.C: The VAT amount as per the selected VAT percentage is shown in this column. The amount is shown in the currency selected in the invoice. On hover, it displays the info text “VAT amount in foreign currency”.
- Total amount F.C: This displays the total amount of invoice, that is, Sum + VAT in the selected currency. On hover, it displays the info text “Total amount in foreign currency”.
- Sum in base currency: The amount excluding VAT is shown in base currency in this column. On hover, it displays the info text “Sum base currency”.
- VAT Amount base currency: The vat charges applied to the sum are displayed in this column in base currency. On hover, it displays the info text “VAT amount in base currency”
- Total Amount base currency: The total amount of invoices in base currency is displayed in this field. On hover, it displays the info text “Total amount in base currency”.
- Printed: This column shows whether the invoice has been printed or not. On hover, it displays the info text “Invoice is printed or not”.
- Exported: This column shows whether the invoice has been exported or not. On hover, it displays the info text “Report has been exported or not”.
- Description accounting: This shows the description added in the field “Receivable Account Desc” in the invoice lines of the related miscellaneous sales invoice. . On hover, it displays the info text “Description Accounting”.