x Want to participate? Join the group to interact

  • Downloading/exporting General Ledger Detail Reports - so slow

    It takes longer than I consider normal to run the GLDR, print to PDF, and export to .xls. Does everyone have a slow export? I miss my last job's accounting software that had instant GL downloads (smart lists in Great Plains). Is there a way to speed it…

  • (REPORTING) How to link invoice line items to GL Detail Posting?

    Hi all, We do most of our customer reports based off the GL_DetailPostings table. I have a few reports filtered to only show "SO" module transactions and I pull in some additional data from the InvoiceHistoryHeader table but now am being asked to…

  • Need to pull out the user who created a GL Gen Journ entry

    An auditor is asking for a report from G/L that lists all General Journal Entries from 2020 and includes the User Name that created the Entry and the User Name that posted the Entry. Obviously I can link SY_User to GL_DetailPosting and pull a report…

  • Why can not see bank balance?

    There is only one bank code on my Sage 100. Cash receivables and payables have been recorded on the system and I did bank reconciliation. But I do not see any balance of cash receivables on the GL balance sheet. I would be grateful if someone…

  • 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…

  • Does a "Waiting on Bill" feature from Sage 50 exist in Sage 100?

    We are migrating from Sage 50 to Sage 100? And in Sage 50 the "Waiting on Bill" feature allows you to get your costs (freight, Inventory, etc...) into payables without having an Invoice number. I have 6 freight Bills (Waiting on Bill-Do not have Invoice…

  • 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…

  • Client has a General Journal Entry that seemingly didn't post? Where is it?

    Our client entered a General Journal Entry, printed, updated the General Journal. The entry appears in Account Inquiry/Transactions. It shows in the General Ledger Detail Report. It DOES NOT show in General Ledger Trial Balance. It DOES NOT show in Sage…

  • List of previous month's activity

    Hello, I have taken over at a small non-profit association and was given zero information by the previous accountant. I have never used this software. I am trying to simply look at all of the journal entries from the previous month so I can see what…

  • 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…

  • RE: G/L Detail Report vs. AP Expense by GL

    AFCACCPAY said: 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…

  • GL Detail Report

    Can you run a GL Detail Report with a wildcard in the selections. I want to run a report where my Department (Seg2) = ?2? or *2* is that possible?

*Community Hub is the new name for Sage City