The Trial Balance report will show balances for both profit & loss and balance sheet nominal codes at division level.
Select the ‘Trial Balance’ report from the main menu.
The filter screen is displayed. Filter the report to select ‘All Codes’ or ‘Non Zero Only’ codes. Further criteria can be added to specify a particular range of codes for the period chosen. Click ‘Reset’ to clear the criteria and start again or click ‘Display’ to view the report.
Double click on a code to display the transaction in more detail.
Double click again to drill down further to display the transaction detail including the user, company, department, source, date and run number. The corresponding side of the posting will also be shown.
If the transaction was from Vehicle Management. Double click on the stock number to view the stock card. By selecting the icon at the end of the transaction, an archived invoice can be viewed, printed or emailed out.
The Trial Balance Report may be printed or exported into Excel.
In the unusual circumstance that the ledger becomes out of balance, the report will highlight in red. Double click this to produce a list of the transactions related to the problem. This may be printed. It is important to call Pinewood Support with this information.
Nominal Ledger Trial Balance Export
It is critical for some users that a daily export of the nominal trial balance is completed prior to any activity every day. To make this process easier an automated export has been added.
Once activated the parameters for the export are held in:
Accounts > Nominal Ledger > Manufacturer > Parameters.
These are held in the ETL tab at the top of the screen.
This allows you to set an FTP address a directory you want to copy it to and has a username and password to allow login to the FTP server. This is then set at a set time which runs overnight. This exports a copy of your trial balance in the same format as the trial balance export within the system. This will transmit the latest open period’s trial balance. So if period 1 and 2 are open the period 2’s trial balance will be transmitted. There is also the option to view transmission history by selecting Trial Balance Export History within the ETL tab.
Contact the Business Support Team for further information to enable this.