Skip to main content

Report - Accounting Tech One Extract

Updated

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

 

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.

Related articles