• Payments collected During time of Sales order not hitting GL Account

    I have noticed that for the month of March, no credit card payment that was ran at the time of the sales order has hit the GL code. This is odd because it only happened for the month of March. Any ideas on what could have happened and how to fix it…
  • 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…
  • Cancelling Payment Batch

    FormerMember
    FormerMember
    I created an EFT payment batch, posted it and now want to cancel it. The open batch is still in the G/L. I'm wondering if I can just delete the batch in the G/L? What are the implications because I technically paid it, but didnt' actually send the funds…
  • 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…
  • G/L Detail Report vs. AP Expense by GL

    Before I contact my service provider, I thought I'd ask here. For several years in a row, we have some mystery amounts of $$ in accounts where they do not belong and we cannot figure out how they got there. We have no record of entering said amounts…
  • 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…
  • VI Import of Main Account

    I am trying to create a VI job to upload some main accounts. Not only is it not working, my log only shows ":" as the explanation - It doesn't even look like it's doing anything. I think this should be simple but it's not proving to be.... Main account…