Like what you see? Discover the benefits of the GPUG Community. Learn More
I've run into a bit of an issue with a new staff member. We use a third party product to copy & paste multiple journal entries to GP using Excel. This works great for us.Unfortunately, the new staff member didn't pay close attention to the distribution reference descriptions when importing and posting.We now have a few entries with incorrect reference descriptions which can cause us huge headaches come audit time.Is there a way to correct just the reference descriptions without having to void and re-create the entire entry?My gut says no.Is there a solution via SQL?Your thoughts?I am attaching a factitious Detailed Trial Balance report for visual representation.
update GL20000set DSCRIPTN = 'New Distribution Reference' -- change thiswhere JRNENTRY = 123456 -- change this to the JE number
update GL20000 set dscriptn = 'corrected description'
where dex_row_id = 61994I find the dex row ID based on the JE#/date first. However, I don't like updating in SQL because of the risk of updating the tables directly. I generally ask staff to reverse and correct in Dynamics. Although this is straight forward, I'm not sure it will take less time than correcting in Dynamics.
Site designed by Brightfind
Powered by Cobalt xRM and Higher Logic