8.7. Procurement Reports

• • Organization - only transactions registered to this organization will be displayed;

• Account Date - define a from - to period. Only transactions with "Account Date" belonging to this period will be displayed;

  • Sales Transaction - clear this checkbox to display a procurement report;

Invoice Transactions (doc) Report

The report lists the invoice transactions by invoice date. The following parameters are available:

• Organization - only transactions registered to this organization will be displayed;

• Business Partner Group - only transactions with vendors in this group will be displayed;

• Business Partner - only transactions with this vendor will be displayed;

• Date Invoiced - define a from - to period. Only transactions with "Date invoiced" belonging to this period will be displayed;

• Payment Method - only transactions using this payment method will be displayed;

• Sales Transaction - clear this checkbox to display a procurement report;

Example:

Invoice Detail & Margin Report

The report lists customer and vendor invoice details with margins. The following parameters are available:

• • Organization - only invoice details registered to this organization will be displayed;

• Business Partner Group - only details from invoices from vendors in this group will be displayed

  • Business Partner - only details from invoices from this vendor will be displayed;

  • Product Category, Subcategory - only lines containing products from this category can be displayed;

  • Product - only details containing this product will be displayed;

  • Product Name- only details containing products with this name will be displayed;

  • Date Invoiced - define a from - to period. Only invoice details with "Date invoiced" belonging to this period will be displayed;

  • Sales Transaction - clear this checkbox to display a procurement report;

Example:

• 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;

Daily Invoice Report

The report lists daily invoiced amounts, by organization and sales representative. The following parameters are available:

• Date Invoiced - define a from - to period. Only invoice details with "Date invoiced" belonging to this period will be displayed;

• Sales Transaction - clear this checkbox to display a procurement report;

• Representative - only invoice details with this representative will be displayed;

Example:

• 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;

Weekly Invoice Report

The report lists weekly invoiced amounts, by sales representative. The following parameters are available:

• Date Invoiced - define a from - to period. Only invoice details with "Date invoiced" belonging to this period will be displayed;

• Sales Transaction - clear this checkbox to display a procurement report;

• Representative - only invoice details with this representative will be displayed;

Example:

• 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;

Weekly Invoice Prod Cat Report

The report lists weekly invoiced amounts, by product category. The following parameters are available:

• Date Invoiced - define a from - to period. Only invoice details with "Date invoiced" belonging to this period will be displayed;

• Sales Transaction - clear this checkbox to display a procurement report;

• Product Category - only details containing products from this category will be displayed;

Example:

• 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;

Monthly Invoice Report

The report lists monthly invoiced amounts, by sales representative. The following parameters are available:

• Date Invoiced - define a from - to period. Only invoice lines with "Date invoiced" belonging to this period will be displayed;

• Sales Transaction - clear this checkbox to display a procurement report;

• Representative - only invoice details with this representative will be displayed;

Report Columns:

• 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;

Monthly Invoice Vendor

The report lists monthly invoiced amounts, by vendor and product category. The following parameters are available:

• Date Invoiced - define a from - to period. Only invoice lines with "Date invoiced" belonging to this period will be displayed;

• Business Partner - only details from invoices from this vendor will be displayed;

• Product Category - only lines containing products from this category will be displayed;

Report Columns:

• 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;

Monthly Invoice Prod Cat Report

The report lists monthly invoiced amounts, by product category. The following parameters are available:

• Date Invoiced - clear this checkbox to display a procurement report;

• Sales Transaction - define a from - to period. Only invoice details with "Date invoiced" belonging to this period will be displayed;

• Product Category - only details containing products from this category can be displayed;

Report Columns:

• 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;

Monthly Invoice product Report

The report lists monthly invoiced amounts, by organization and product. The following parameters are available:

• Organization - only invoice details registered to this organization will be displayed;

• Date Invoiced - define a from - to period. Only invoice details with "Date invoiced" belonging to this period will be displayed;

• Sales Transaction - clear this checkbox to display a procurement report;

• Product - only details containing this product will be displayed;

Report Columns:

• 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;

Quarterly Invoice Customer by Vendor Report

The report lists quarterly invoiced amounts, by customer and vendor (what customer bought from which vendor). The following parameters are available:

• Date Invoiced - define a from - to period. Only invoice lines with "Date invoiced" belonging to this period will be displayed;

• Vendor - only details containing products procured from this vendor will be displayed;

• Business Partner - only details from invoices sent to this customer will be displayed;

Report Columns:

• 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;

Quarterly Invoice Customer by Product

The report lists quarterly invoiced amounts, by vendor and product category. The following parameters are available:

• Date Invoiced - define a from - to period. Only invoice details with "Date invoiced" belonging to this period will be displayed;

• Sales Transaction - clear this checkbox to display a procurement report;

• Product Category - only details containing products from this category can be displayed;

• Business Partner - only details from invoices from this vendor will be displayed;

Report Columns:

• 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;

Quarter Invoice Product

The report lists quarterly invoiced amounts, by product. The following parameters are available:

• Organization - only invoice details registered to this organization will be displayed;

• Date Invoiced - define a from - to period. Only invoice details with "Date invoiced" belonging to this period will be displayed;

• Sales Transaction - clear this checkbox to display a procurement report;

• Product - only details containing this product will be displayed;

Report Columns:

• 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;

Receptions and Revaluations Report

The report presents the receipts situation not invoiced, whole or partial, base currency value adjusted according to last revaluation and the values in currency document. The following parameters are available:

• Organization - only transactions registered to this organization will be displayed;

• Report Date - mandatory - date at which the revaluation is computed;

• Currency - only receipts generated from purchase orders in this currency will be displayed;

• Business partner - only receipts from this vendor will be displayed;

For a correct computation, the following conditions need to be met:

• The receipts need to be Completed or Closed;

• The receipts need to be generated from purchase orders and all the corresponding PO-Receipt matchings need to exist;

• The receipts need to be associated with invoices and the corresponding Receipt-Invocie matchings need to exist (in the case of partial invoicing);

• All the numbered documents need to be posted.