• Missing "updated by" GL Journal Drill down

    Sage 100 2020 Premium (6.20.1) After deleting old users off a system, the GL drill down from Transaction tab "Updated By" is blank for the deleted users. The deleted user keys are listed in SY_UserHistory. Short of 'reactivating' the deleted users…
  • Changing the default Item Inquiry Transaction Dates to the current month rather than General Ledger Period

    My users are experiencing an issue where the accounting department is still performing month end closing processes for the previous month after start of the next month so the current General Ledger period is still last month and does not match the current…
  • Updating Batches via BOI

    Hello all! I'm working on a script to auto approve batches but I am running into some issues. I looked through the BOI course and there is an example in there that updates the SalesOrder so I adapted my code from that. I'm not sure if I'm setting it…
  • Custom report: G/L Account and Date Last Used?

    Is there a specific field and/or table to use within Crystal Reports to determine when a G/L account was last used? This would be for the purpose of delete the obsolete account. Please advise and thanks! T. Helm