10.07. Sales Reports

SocrateCloud offers a number of predefined reports to analyse sales operations. All reports can be edited in order to comply with the organization's requirements. Details in Reporting.

The following reports can be found in the Quote-to-Invoice -> Invoice Inquiry menu:

Sales Transactions Reports

The Sales Invoice Transactions (doc), Sales Invoice Transactions (acct) and Sales by Country-Region-City reports display a list of customer invoices and related information:

• Report Parameters - search filters for the customer invoice lines displayed in the report:

  • The Sales Invoice Transactions (doc) report allows you to filter customer invoices by document date;

  • Sales Invoice Transactions (acct) report allows you to filter customer invoices by account date;

  • The Sales by Country-Region-City report allows you to filters the customer invoices by customer address information: Country, Region, Town, In EU;

• Report Columns - represents fields that can be found on customer invoices: document date, customer, total amount and payment info;

Sales Invoice Detail & Margin

The report displays a list of invoiced products, grouped and totaled by customer group, customer, product category and product:

• Report Parameters - search filters for the customer invoice lines displayed in the report:

• Report Columns - represents fields that can be found on customer invoices: customer and customer group, product name, quantity and price;

Summary Sales Reports

The Daily Sales Invoice, Weekly Sales Invoice and Monthly Sales Invoice reports display a list of invoices and related information (margin, amounts), cummulated per day, week and respectively, month:

• Report Parameters - search filters for the customer invoices displayed in the report:

  • Date Invoiced - interval for the document date;

  • Representative - sales representative selected on the invoice;

• Report Columns - besides columns representing fields on customer invoices, the report may contain:

  • Margin = (Price - Limit Price)*Invoiced Quantity;

  • Margin % = (Price - Limit Price)/Limit Price*100;

  • Limit Amt - invoice limit price multiplied with product quantity;

  • Discount % = (Price - List Price)/List Price*100;

  • Discount = (Price - List Price)*Invoiced Quantity;

  • List Amt - invoice list price multiplied with product quantity;

  • Net Amt - invoice product price multiplied with product quantity;

If the Limit Price on the invoice is 0 the Margin values will be 0;

If the List Price on the invoice is 0 the Discount values will be 0;

Invoice Lines Reports

The reports display a list of customer invoice lines and related information (margin, amounts), cummulated per day, week, month or trimester:

• Report Parameters - search filters for the customer invoices displayed in the report:

  • Date Invoiced - interval for the document date;

    • Product Category: Weekly Sales Invoice by Product Cat, Monthly Sales Invoice by Product Cat;

  • Organization, Product: Monthly Sales Invoice Product, Quarterly Invoice Product

  • Business Partner, Product Category: Quarterly Invoice Customer by Product;

• Report Columns - besides columns representing fields on customer invoices, the report may contain:

  • Margin = (Price - Limit Price)*Invoiced Quantity;

  • Margin % = (Price - Limit Price)/Limit Price*100;

  • Limit Amt - invoice limit price multiplied with product quantity;

  • Discount % = (Price - List Price)/List Price*100;

  • Discount = (Price - List Price)*Invoiced Quantity;

  • List Amt - invoice list price multiplied with product quantity;

  • Net Amt - invoice product price multiplied with product quantity;

Sales Reports

The Sales by Product Categories and Sales by Categories & Business Partners reports display a list of sales amounts, taken from customer invoices or sales orders

• Report Parameters

  • Business Partner Group, Business Partner - customer or customer group for which the sales report is generated

    • Year - the year for which the report is generated

  • Currency - currency in which the report amounts are calculated;

  • Document Type - determines the documents based on which the sales amounts are calculated: orders or invoices

• Report Columns - the report is split into columns by trimester and the report lines are grouped by organization, customer and product category;

Order - Invoice - Payment G/L

The report is used to display currency exchange rate differences between invoices and payments, which exist due to the fact that the exchange rate applicable on the invoice date may be different from the exchange rate applicable for on payment date.

Note: Only invoices generated from orders with a currency different from the default currency will be displayed