Originally written by John Hardwick, last updated Apr 16, 2024, on the Swan Retail knowledge base (FRS).
Part of: Financial Reports
This audit is designed to be run after the accounts interface has been operated and lists the transactions sent to the accounts' system within a specified date range.
Crystal report name Accounts Posted Report 1
When run for a specific account code, only the Nominal section is produced.
Postings are grouped by posting date (posting batch).
Selection Criteria
Run time choices, user selectable.
-
Date Range
The Date range is the posting date and not the transaction date.
-
Account Code
Choose all lists all posting sent to the accounts' system.
Typing in a specific account code instructs the print to only show posts for the specified code.
Print Sequence
As indicated by blue numbered squares in the report example.
-
Purchasing
-
Purchase Invoices - Posting Date / Supplier / Vendor
-
Purchase Details - Posting Date / Nominal Code
-
VAT - Posting Date / Tax Rate
-
-
Nominals - Posting Date /Transaction Date
Report Totals
As indicated by yellow numbered squares in the report example.
-
Report Totals by Section.
Printed Fields
Fields printed on the report.
-
Purchase Invoices
-
Posting Date
-
Invoice ID
-
Invoice Number
-
Reference
-
Invoice Date
-
Goods Value
-
VAT / Tax Value
-
Comments
-
Currency
-
Exchange Rate
-
Name of Operator
-
-
Purchase Details
-
Posting Date
-
Nominal Account Number
-
Invoice ID
-
Goods Value
-
VAT / Tax ID
-
VAT / Tax Rate
-
VAT / Tax Code
-
-
Purchase VAT
-
Posting Date
-
VAT / Tax ID
-
VAT / Tax Rate
-
VAT / Tax Code
-
Invoice ID
-
Goods Value
-
VAT / Tax Value
-
-
Nominal
-
Posting Date
-
Transaction Date
-
Reference 1
-
Reference 2
-
Quantity
-
Value
-
VAT / Tax Value
-
VAT / Tax ID
-
Value in Foreign Currency
-
Foreign Currency Vat / Tax
-
Nominal Code 1
-
Cost Centre 1
-
Department 1
-
Nominal Code 2
-
Cost Centre 2
-
Department 2
-
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article