You’re offline. This is a read only version of the page.
Hello,
I went to post a sales invoice in Sales Transaction Entry and it stated as posted. When I checked my Historical Aged Balance Report, the invoice was not showing there. I then went and did an inquiry using the Sales Document function to pull up the invoice. It is showing as unposted. I also clicked in the distribution area, the RECV line was missing information. How do I remove the invoice from the unposted area and post it again so it can reflect on my aging report? Please advise.
Thanks.
Rolston
*This post is locked for comments
Hi Rolston,
Your transaction is got stuck on the batch and has to be cleared at SQL. If you don't have access to SQL please contact the GP Partner to help with this.
Hello, thanks for the reply. I am not an I.T. person so not sure what SOP10100 or SOP30200 really is. How do I get to those tables? Also, I am now having problems accessing the Sales Transaction Entry window. Its bringing up an error message stating that "Your previous transaction-level posting session has not finished processing. Please allow time for it to finish. If you believe it has failed, log out of Great Plains and log back in to recover transactions". What is this new issue now. I can't even post or create invoices. I need that window to do my work. Any advise would be appreciated.
Thanks
Rolston
sounds like it is partially posted, the invoice is still in SOP10100 (work table, should not be here) and SOP30200 (posted table, where it should be). have the original user (you) login to GP, and open the sales trx window, then close it. Doing that should get the SOP10100 cleared up, but running any remaining posting cleanup work. If it is still stuck, try running sop check links, reconciles, etc. A last resort is to manually clear it out of the sop work tables. highly not recommended unless you have no choice.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (