Registered Invoice Report

Created by Migration Bot, Modified on Fri, 23 Oct at 11:25 AM by Migration Bot

Originally written by John Hardwick, last updated Jun 14, 2023, on the Swan Retail knowledge base (FRS).

Part of: Financial Reports


This report is designed to show invoices entered / processed within the Invoice Matching routine.

Crystal report name Registered Invoice Report 1

If the variance value or percentage is higher than the specified ‘highlight’ value, the background will show Red. Negative variances will show with a green background.

Yellow background is an manually keyed invoice reference total.

Selection Criteria

Run time choices, user selectable.

  • Date Range

  • Highlight Variances above X (percentage)

  • Highlight Variance over X (money)

  • Format

    • Detailed / Summary

  • Include

    • All Invoices / Overcharged Invoices / Invoices with Variances

  • Internal Reference

Select ‘All' to include all invoices, or enter a specific combination of characters to filter the data.

  • Operator

  • Show

    • All / In Process / Complete / Posted / In Dispute

  • Restricted Location(s)

Print Sequence

As indicated by blue numbered squares in the report example.

1 Internal Reference

2 Date of Registry

3 Operator

4 Invoice Number

5 Purchase Order Number

Report Totals

As indicated by yellow numbered squares in the report example.

1 Internal Reference

2 Report

3 Report Summary

Printed Fields

Fields printed on the report.

  • Internal Reference

  • Date Registered

  • Operator

  • Invoice Variance Value

  • Invoice Variance Percentage

  • Invoice / Bill Number

  • Supplier / Vendor

  • Invoice / Bill Date

  • Invoice Amount

  • Comments

  • Invoice Status

  • Purchase Order Number (Detailed Only)

  • Supplier's Delivery Note / Reference (Detailed Only)

  • SKU (Detailed Only)

  • Stock Detail ID (Detailed Only)

  • Product Description (Detailed Only)

  • Quantity Invoiced (Detailed Only)

  • Expected Value (Detailed Only)

  • Invoiced Value (Detailed Only)

  • Variance (Detailed Only)

  • Add on Cost Description (Detailed Only)

  • Add on Cost (Detailed Only)

  • Cost Location (Detailed Only)

  • Nominal Apportionment / Code (Detailed Only)

Summary

  • Internal Reference

  • Invoice Date

  • Total Invoice Value Registered

  • Value ‘In Dispute’

  • Value ‘In Process’

  • Value ‘Posted’

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article