Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Kelley Karl]

Is there a report after data entry yet prior to posting batches that can be run for review purposes?  Thanks, Kelley

——————————
Kelley Karl
Professional Assist Corp
Golden CO
——————————

[Thomas Garcia]

Hi Kelley:

You can always print the Transaction Edit List report. This report can be printed from the Batch Entry window, using the “Printer icon button” at the right upper corner of the window.  You can also print this report from the transaction entry window, once the transaction is saved to a batch, by using the same printer icon button at the top of that window.

Hope it helps!

——————————
Thomas Garcia
ICON Business Consulting, LLC | Cooper City FL
ICON, SRL | Santiago, Dominican Republic
954-804-2140
——————————
——————————————-

[Jeff Hassenboehler]

Excel refreshable reports works great for us for this and a few other purposes.  I use an Excel Report Builder report to pull all data from the PM Distribution WORK OPEN table.  After I deploy the file the first time I add a pivot table in the Excel file that summarizes all the fields we want to review.  Now each time we open the Excel file, I refresh it (Data / Refresh All) and refresh the Pivot Table.  We filter the pivot table by Batch Number and include the following fields –Voucher Number, Vendor ID, Vendor Name, Vendor Class ID, Transaction Description, Document Number, Document Date, Document Amount, 1099 Amount, Account Number String, Account Description, Distribution Reference, and Sum of AMOUNT.

This print screen is from our (old) GP 2010R2 system:

We also use Excel refreshable reports to get current Open A/P and Open A/R subledgers.
.

——————————
Jeff Hassenboehler
Definition6
Atlanta GA
——————————
——————————————-