• Mass Update GL_Account table via SQL update query

    We have upgraded to Sage100 Premium (SQL version). We have been using a separate Excel workbook for special coding we like to use. We would now like to get all those special codes into Sage100 into the rollup codes and UDF's. We do not want to manually…
  • Deleting main accounts in G/L

    As I understand it, if I change the "active" status to "delete" on a GL Main account prior to closing the year, the account will be removed once I complete the year end process. If I do that, do I lose the history too? Many of these accounts have not…
  • WE WANT TO PRINT/EXPORT TRANSACTION DETAIL FROM ACCOUNT MGMT/INQUIRY

    FormerMember
    FormerMember
    We've always wished that we could export or print the transaction detail that we see under the Transaction tab in G/L Account Maintenance and Account Inquiry. Yet that's not possible. What's most frustrating is that a Print button is staring you in the…
  • GL -> Account Inquiry -> History Best way to extract similar info for external report

    I'm looking to pull the current balance of the GL for each account, basically exactly what is in the History Tab of account inquiry. Whats the best way to accomplish this? I've looked around the GL tables for any sort of summary. Will I have to sum the…
  • Source Journal Disappeared and is not in GL Detail report

    We have a PO that was received and updated, then invoiced and updated, and then paid and updated. However when I go into A/P - Vendor Maintenance - Invoice and click on the invoice the Source Journal Drill down is gone. I also pulled up the GL Detail…