• employee master file import into sage 300 CRE

    We are exploring options to import an employee master file into sage 300 CRE. What are the sage specs needed to execute this import?
  • AP Vendor Clean UP

    - Is there a way to mass update active vendors to inactive status?
  • Can you use Crystal Reports to change the value of fields in Sage 300 CRE...?

    If this is not possible what would the best way to accomplish this? I have the Certified Class description i want to assign to the Occupation field on the Master Employee Record, we would like them to match and currently they do not. Thanks V
  • Creating upload files for Arcoro...

    We are in the process of moving to Arcoro HR and I have been building imports for this. Two of the imports concern pre/post 2020 employee tax info, and some of the data required is Year, Additional Withholding, Filling Status for that year, Exempt or…
  • Receipt Adjustments impacting GL. HELP

    GL overvalued vs physical inventory at year end. I believe it's being caused by a lot of Receipt Adjustments that don't have a location showing in them. Is anyone else having/had this problem? What causes Receipt Adjustments and why do they overvalue…
  • Any way to empty Sage 300 CRE log file?

    In log viewer it is possible to Archive & Delete but it is extremely slow, only being able to handle 200,000 records at a time and the archive only writes 10,000 per file. I don't want to archive, I just want to delete. I have tried ODBC connect and using…
  • 35 tables are not loading to timberline database

    FormerMember
    FormerMember
    I am querying the Timberline replicated database located on the Kettler “ktlrhq-db1.corp.ketsco.com” SQL Server instance. I need to perform several queries into this database. This query returns total amounts for each cost code, section and job: …
  • Importing Time into Payroll from a Third Party

    Hi, I'm having issues with trying to import a time entries file into Payroll. I've been reading that the file has to be a .txt and that I need to make sure there are no headers and each column needs to be made exactly how our layout is. Is there an…
  • PO archive and upgrade?

    Has anyone had experience with archiving the PO module? According to KB articles, moving POs and COs to history is the first step in improving performance in the PO module. Clean out all those old records. I have done this in a test environment and can…