Detailed Trial Balance with User Who Posted

  • Detailed Trial Balance with User Who Posted

    Posted by DSC Communities on February 24, 2017 at 3:47 pm
    • Jill Wadkins


      February 24, 2017 at 3:47 PM

      Our auditors are looking for a Detailed Trial Balance that shows the “User who posted”.  I Modified a Financial Account Transaction Smartlist to include this column but unfortunately the Smartlist does not include transactions from Sales & Purchasing and does not tie to the canned Detailed Trial Balance that I ran from Financial -> Reports ->Trial Balance.  Is there a way I can add the “User who posted” to the canned report that will work for financial, sales and purchasing transactions?

      Thank you for any help :o)

      Jill Wadkins
      Senior Financial Analyst
      ReliaMax Holding Company
      Sioux Falls, SD

    • Stuart Gallion


      February 24, 2017 at 5:56 PM

      You will need to modify the standard detail trial balance report. It isn’t difficult for someone who is used to the report writer interface. We had the column added to our report back when we first installed GP7 in 2003 and the modification was done by our partner.

      Stuart Gallion
      Project Accountant/GP System Administrator GP2016/FRx6.7
      Stanford Hotels Corporation
      San Francisco CA

    • Martha Machado


      February 26, 2017 at 5:14 PM

      Hi Jill,

      If you have Excel Reports in GP, look for either one of these.

      • AccountTransactions Current Financials Journal
      • AccountTransactions History Financial Journal

      Run the report so it opens in an Excel file. It will have less data that what you’re looking for but we can bring in more – in Excel, open the data connections and change the command text as follows:

      (Note: where I typed the dates, you should replace with your own beginning and ending of year dates.)

      Click OK and then Close. Your Excel Report should have a lot more data now. I see a “Series” column that identifies which module the transaction originated in, as well as a “User Who Posted” column that identifies who keyed the transaction.

      This is the skinny but please post a message if you get stuck.

      Martha Machado
      CPA / Consultant
      CPA Projects
      Pompano Beach FL

    • Leslie Vail


      February 27, 2017 at 7:27 PM

      I had to make this change just the other day. I’ve attached a .package file to this message that includes the modified reports for the trial balance detail and trial balance history. The reports have been modified to include the column ‘Posted By’
      Kind regards,

      Leslie Vail
      Accounting Systems Consulting, Inc.
      Dallas TX

    • Bruce Strom


      March 1, 2017 at 10:08 AM

      If you are going to modify the GL reports anyway, you should add the Master ID and Master Name and document number so the vendor/customer transaction info prints as well.

      Bruce Strom
      Programmer Analyst
      Associated Grocers of Florida
      sunrise FL

    DSC Communities replied 6 years, 7 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

Log in to reply.

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!