455
I have closed invoices showing on my Unposted Invoice SmartList report however, when I query the SOP10100 table, these invoices are not in the database. Any ideas?
Thanks!
*This post is locked for comments
Frank - that worked! That is a stock GP SmartList, we must have modifed by accident at some point.
Thanks again!
My bad - the field is 'Document Status' not Posted Status. Sorry about that Susan!
Was this SmartList created via SmartList Builder? If you're using a SmartList favorite, the 'Posted Status' should be there. I just looked at it this morning on my system and it's there. If it's an SLB list, maybe 'Posted Status' wasn't included in the default fields or list of fields to show.
Frank - that makes perfect sense. However, I don't have a 'Posted Status' only have 'Posting Status'. I have looked at ALL columns and that option is not there. Help! :)
Make sure you're using 'Posted Status' and not 'Posting Status' in your Smartlist. Posted Status refers to posting in SOP. Posting Status refers to posting in the GL. Documents can show Posted in SOP and Unposted in GL.
I am assuming that you have a Favorite (Clipboard icon) of a SmartList (Folder Icon) with Searches (Selects specific records) that pick only Unposted transactions. If a sales order is voided before posting, it is moved to history. It is not, however, posted. Also, orders, quotes, and back orders are moved to history when their contents are transferred to an Invoice. These document types are not ever posted.
Do your Search Statements pick only invoices?
What SmartList is this Favorite built against? What are the Search statements?
The movement of transactions through the Work and History tables of GP is not simple. We did document it, however, in our Information Flow and Posting book. Take a look at it on our web site.
Pardon my ignorance but, if this is the Unposted Invoices SmartList, why would it have historical invoices on it? Shouldn't those be closed and not open?
The closed / posted invoices will be in the SOP30200 table. The SmartList shows both open (SOP10100) and closed or historical (SOP30200) documents.
We map the flow of such documents in our Information Flow and Posting manual. Check it out on our web site!
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,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (