I was working on the invoice. But I cannot find this invoice in GP10.
I have checked the invoice No. in SQL Server, and found that are availble in open tables(SOP10100 and SOP10200) with docamnt=0.
Why I dont know with docamnt=0.
But still I cannot find that invoice in GP.
Please Assist me.
*This post is locked for comments
What I would suggest is that you download a free copy of ApexSQL Search www.apexsql.com/sql_tools_search.aspx and then search the database for any value you know about the evasive invoice. The search will find any record that meets the criteria and will thereby tell you exactly where the invoice ran off to so that you can make any corrections necessary. Personally, I think every GP Admin or consultant should have this tool installed, I use it all the time to help me identify tables that may be related to other tables. It's not recommended, but conditions come up where you can't correct the issue with the user interface.
Kind regards,
Leslie
Click the Tables menu, and then select Tables from the drop-down list.
Select SOP_LINE_WRK from the list of tables, and then click Open.
In the Table Definition window, click Relationships.
In the Table Relationship window, click New. https://mobdro.io
Click the ellipsis button, select Sales Payment Work and History from the drop-down list, and then click OK.
If you are getting the message that it has been posted then it is in the SOP30200 and SOP30300 tables. Are you going to Inquiry->Sales->Sales Documents Entry and click the history button and then enter the invoice number?
Hi Vj,
Once you post the invoice you cant view the invoice on transaction window but please go to inquiry window on sales document and view it.
Hi Richard sir,
Thanks for your reply.
I have followed all above steps, but
Can't find Invoice(Sopnumbe='Invxxxx') in sales document number in Remove Sales Documents lookup.
In brief:-
1. I have created one Invoice ( Sopnumbe='Invxxxx') from Sales transaction Entry Window.
2. This Invoice is available in open table with docamnt=0 in sop10100 and no problem with line details(sop10200).
3. When I tried to open this Invoice(Sopnumbe='Invxxxx') from Sales transaction Entry Window, It display a message "This document has been posted ".
I can't find this Invoice in GP.
OR
From where I can see this invoice?
Please assist me.
Thanks,
Tools->Utilities->Sales->Reconcile Remove Sales Documents enter your SOP number and choose to Reconcile and that should fix the document amount issue. Then create backup and run check links on the Sales Work Tables.
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (