DavidC_IL 6/28/2021 11:42:13 AM

Journal Entry - DETAILS

We did a Standard Cost Roll-up and revaluation this weekend that generated a 2,961 line long Journal Entry.  Unfortunately, nothing tics and ties me back to the the Item, or the Site ID.  I have the 'Item Pending Revaluation Report' in .PDF, which at least gives item detail by cost category. but Accounting really wants me to provide him an EXCEL file that contains all of that data.

Has anyone done something like this already by chance and can share the tables I need to join to get a view that I can then export to Excel?

THANKS

DavidC_IL

Version: All
Section: Dynamics GP, SQL Scripts


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3