Margin by Nominal Code

Originally written by John Hardwick, last updated Apr 25, 2024, on the Swan Retail knowledge base (FRS).

Part of: Financial Reports

The report shows margin for the user selected analysis criteria.  The output totals use the sales account code broken down by range within supplier, all grouped by location.

When viewing the report in the application viewer, double-clicking the product group value drill down shows the details making up the value. This feature does not work when exported to PDF.

Selection Criteria

Run time choices, user selectable.

• Selection Choice

  • Week Number / Accounting Period

• Range

  • Week / Accounting Period

• Financial Year

• Restricted Location(s)

• Supplier(s)

Print Sequence

As indicated by blue numbered squares in the report example.

1 Location

2 Account Code

3 Supplier / Vendor

4 Range / Collection

Report Totals

As indicated by yellow numbered squares in the report example.

1 Range / Collection

2 Account Code

3 Location

4 Report

Printed Fields

Fields printed on the report.

• Invoice Branch

• Nominal Account Number

• Supplier / Vendor

• Range / Collection

• Cost Value

• Selling Value

• Tax / VAT Value

• Margin or Profit Value

• Margin or Profit Percentage

Drill Down Report

• Sales Order Number

• Product Description

• Invoice ID

• Current Cost

• Line Selling Price

• VAT / Tax Value

• Week Number (Shown in Red)

• Accounting Period (Shown in Red)

• Financial Year Number (Shown in Red)

Attachments (2)

image-20230515-123544.png
91.5 KB

image-20230515-123913.png
50.3 KB