'Item Description' for GL Detail reporting

I have been trying to create a GL Detail report within Sage 50 Canadian Edition Business Intelligence that shows the 'item description' but have not been successful.

The reports currently show 'description' which is not the actual description entered within the source document.

I have tried to customize all the reports within the business intelligence as well as create my own but nowhere is the 'item description' listed as an option. I can only find description which is the made up Sage description and is usually just the vendor name and invoice number.

Has anyone had this issue before, or found out how to pull accurate item descriptions? is this something that Sage is capable of producing? 

Without having proper descriptions pulled for the GL account activity it is very time consuming to analysis as you have to individually look up the source journals one by one.

  • 0

    Hi Mechelle

    That is an uncommon request generally speaking and is also not possible to achieve in Sage 50 because that level of detail does not propagate to the GL.

    If you could describe the business need you have then I may be able to advise.

    Respect, Craig Juta

  • 0

    Thanks Craig

    The description of your source documents (such as invoices, payments etc) do not translate over to the general ledger.

  • 0

    Hi Craig and David,

    I use QuickBooks for other companies that I complete the accounting for and am able to easily pull these reports. We need this to review the GL's on a monthly basis to ensure that correct charges are in the correct accounts. We also use it for  year  over year comparisons. It is very time consuming to have to individually click and open every source journal to determine the charge description.

    We were advised by Sage to purchase the business intelligence as it would provide these details and it does not.

    When you are reviewing the GL for accuracy without the description you cannot be certain that the charges are in the correct GL's.

    So are you saying that Sage is not capable of pulling the supplier item description into the general ledger or on any type of reporting?

  • 0

    Hi Mechelle

    It is possible but not exactly in the way you described it.

    Using Sage Intelligence it is possible to report on - generally speaking - all source documents and their associated detail and then attach the GL account from each line on the source documents to the report.

    This would give you optics on the document level activity by GL account.

    Happy to get on a call with you....let me know @ [email protected]

  • 0

    Hi Craig,

    I have emailed you as I have tried many reports over the past few months pulling in all columns possible  and  have not  found  the item description that  we add into  the supplier bill or journal entry. Instead the only description that I have been able to pull on any reports is the Sage generated description which is generally the supplier name and source document number.

  • 0

    I am making this post to see if there have been any improvements to Sage50 since this thread was originally opened. I am currently using Accountant Edition Release 2024.0. I require a report of sales transaction postings (sales invoice) from the general ledger that gives me all of the postings to a specific general ledger revenue account and provides what the user has entered in the ITEM DESCRIPTION cell from the data entry screen. As mentioned in this tread, clicking on every single individual entry to open the "looking up" screen is simply not a reasonable solution due to the extensive volume of transactions.