Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Jill Wadkins]

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]

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]

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]

Hi,
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

——————————
Leslie Vail
Accounting Systems Consulting, Inc.
Dallas TX
——————————
——————————————-

[Bruce Strom]

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
——————————
——————————————-