Introduction
The accounting Tech One report will generate a report and utilise the tech one format.
This report is hidden by default, please contact support or customer success to activate this report on your site.
Before you start
The following custom attributes will need to be configured. More information on how this is set up can be found in the following article here.
Default Ledger - Category
- Code - PG.Australia.DefaultLedgerCategory
- Category Type - Set as Club (this will display the attribute in PGM->Clubs->List of Clubs).
- Translations - Name of the category, set this in English (any other languages can be used, however may not be visible unless using that language). The name itself can be anything you wish. eg. 'Default Ledger'
Default Ledger - Attributes
- Is required - (Optional) Selecting this will prevent editing/creation of a new club unless a value is set on this attribute in PGM->Clubs->List of clubs
- Data Type - This must be set as 'Integer number'
- Is Visible On - Remove all applications listed. When this is left blank, it will only be visible on PGM
- Code - This must be set as the following PG.Australia.Accounting.DefaultLedgerId as reports will look for the attribute set against this code
- Description - Leave blank
- Translations - Set the attribute name to what you want, eg. 'Default Ledger Id'. This will allow it to be identified in PGM->Clubs->List of clubs
Tech One Extract - Category
- Code - PG.Australia.TechOneExtract
- Category Type - Set as Club (this will display the attribute in PGM->Clubs->List of Clubs).
- Translations - Name of the category, set this in English (any other languages can be used, however may not be visible unless using that language). The name itself can be anything you wish. eg. 'Tech One Extract'
Tech One Extract - Attributes
Three (3) attributes will need to be created, this will allow you to configure which fields go where. If you wish for different fields not listed, please contact support as this will be a custom development request.
- Is required - (Optional) Selecting this will prevent editing/creation of a new club unless a value is set on this attribute in PGM->Clubs->List of clubs
- Data Type - This must be set as 'String'
- Is Visible On - Remove all applications listed. When this is left blank, it will only be visible on PGM
-
Code - The following 3 codes are acceptable as reports will look for the attribute set against this code.
- PG.Australia.Accounting.TechOne.narr1
- PG.Australia.Accounting.TechOne.narr2
- PG.Australia.Accounting.TechOne.narr3
- Description - Leave blank
- Translations - Set the attribute name to what you want, eg. 'Tech One Narr 2'. This will allow it to be identified in PGM->Clubs->List of clubs
System Permission
To access this report, please add the following system permissions to the suitable employee roles in PGM->Clubs->System permissions.
- Reports
- Custom
- Accounting - TechOne Extract
- Custom
Club Set up
Go to PGM->Clubs->List of clubs, and select the club.
You will need to fill out the custom attributes listed above.
In the following fields - Tech One Narr 1, Tech One Narr2, Tech One Narr3. These fields can be used
- Ledger
- PaymentType
- AccountingAccountId
- LedgerId
- AccountNumber
- AccountingAccount
- ContractClubId
- UserId
- SourceClubId
- (Blank)
With any other fields, please contact support or customer success as they may need to be developed for the report.
Instruction
To access the report go to PGM -> Reports -> All
To find the report, go to the Custom Tab and search for the report Accounting - Tech One
Select the Date Range
Press XLSX (to export as an Excel XLSX format file) or CSV (as a comma delimiter file)
Hints
- If you are using split percentages in your accounting module (For example 1 product split over multiple categories), any rounding of values will be added or subtracted by the group with the lowest percentage from the category split.
- With CSV file extracts, this will download as a ZIP file (compressed).
- If opening the file using Excel or similar spreadsheet program, any fields with multiple leading 0's will treat these as a number and remove the leading 0's. For Example 000000 will convert to 0, 000003 will convert to 3, 3000 will stay as 3000. If opening up using a Text editor, it will keep the leading 0's.