• How to add a where clause to a custom report on the Custom SQL tab

    We are trying to add a where clause to a custom report on the Custom SQL tab when choosing "Open Print Form" We want to add a where clause to be able to easily run the report for selected employees instead of selecting the employees on the Report Filter…
  • Work Anniversary

    Hi All, Is it possible to get the work anniversary of employees from report in Sage 300 people. If so, how?
  • Payroll register report printing in excel

    Is it possible to get the report in excel in rows and columns specifically in excel, coz i am getting pdf format in excel. Please advice.
  • Report export formula issue

    Good day I have created a report on SAGE which includes a formula to calculate the amount of days a position has been vacant, but when I export this report to excel the formula column just goes to all zero. It seems that the formula is remove with the…
  • 12 Month Report Displaying Incorrect Values/no date at top

    Good day I just wanted to know if Sage is aware of the issue where the 12 month report displays incorrectly on People? This seems to be the case where clients have weekly companies. If so, is there an expected resolution date for this issue?
  • how to Download report to check performance appraisal status?

    Hello everyone, I need to download a report on WebESS People online to check the progress of our performance appraisals. However, the report i can download only indicates whether the contract has been initiated, in process or approved and does not…
  • MEIBC / MIBFA BIM REPORT

    Hi All Please can I be sent the latest version of the MIBFA/ MEIBC BIM report. Spoke to Alwyn yesterday, but did not receive the report Kind regards Leoni Barnard
  • 300 People Report design - Sub reports source

    Hi All. I require help on how to add sub reports to the payslip in 300 people. I am skilled in Crystal reports but the 300 people interface has me scratching my head. When I add a sub report to the existing report there is no fields in the field list…
  • Sage 300 People remuneration listing report import error

    Hi, I customized a remuneration listing report for a client and I am trying to import it for another client but I keep getting the error below ( The input stream is not a valid binary format. The starting contents (in bytes) are: 54-68-69-73-20-61-74…
  • TERS Docs .csv - Prescribed file format Update

    Good day, When will we be receiving an update that will allow us to export the documents that we require for submission? Is there an ETA on it? Many thanks,
  • Some of my Reports prints incorrect detail

    If you run a Report and the Headers are reflecting correctly, however the content of the report is not correct, see solution below. On the People Home Page in the Routing Field at the bottom of your screen you can type in: --DISABLELOCALIZATION and…
  • Generic Exception Error when viewing payslip in WebSS

    When a user access WebSS to view the payslip they get an error - Generic Exception - Item has already been added. Key in dictionary: '1437' Key being added: '1437' A few things needs to be in place. 1. On Company Rule > Default Rules a Payslip Layout…
  • Help

    Can someone help me on our to get this done. Client is currently using Sage 300 two companies on one database.He has been posted on it, now he wants to seperate it.Same users will be working on the new comapny,He wants seperate reporting, customer statement…
  • Medical Aid History Report

    The Medical Aid History report is a detailed report showing the Total Contributions, Beneficiaries , Tax Credits and Medical Aid start date. On the Navigation Pane: Expand: Reports Double click on: All Reports Expand: Employee Expand: Medical…
  • Export Report Layout

    The Export Report Layout function under All Reports enables you to export a report layout from your database. Here's How On the Navigation Pane Expand: Reports Double Click on: All reports Expand: Applicable Report Click on: Export Layout…
  • Import Report Layout

    This function in the All Reports screen enables you to import an exported report layout from another database. This is the framework of the report and will exclude the report base view containing the field list. Here's how On the Navigation Pane …
  • Employee not reflecting on any Councils report

    Have you loaded a new employee but the employee does not reflect on any of your specific Council reports? check the following. On the Navigation Pane Expand: Employee Management Double lick on: Employees Search for and select the specific employee…