18,267
In Inquiry-->Sales-->Transaction by document or Customer when I clicked Invoice says '00274519' to see details it pulled totally different Invoice '00261110' in Sales Transaction Inquiry Zoom window.
I have checked RM20101 table and both invoice look good but don't know why system shows 00261110 instead of '00274519'.
How can I resolve this issue? Your earliest reply is highly appreciable.
Thanks
Sandip
*This post is locked for comments
I am suggesting to disable PA just to see if you can print an invoice. You can enable it immediately after testing.
I cannot disable Project Accounting. We are using it. I have same issue with another invoice. Do I need to open support request with Microsoft?
Your earliest reply is highly appreciable.
Thanks
Sandip
SOP10104 is the sales process holds table. Can you turn off Process Holds by going to Tools->Setup->Sales->Sales Order Processing and click the Order type and then Holds and Removbe all Holds? Try turning of Project Accoiunting as well by Tools->Customize->Customization Status and click PA and then Disable. Then try the inquiry again.
MOh'd- TRXSORCE field look good on RM20101.
Richard-SQL Profiler start with: exec FLASH.dbo.zDP_PA01901SS_3 1,'00274519'. PA01901 has no record it is not Project Accounting Invoice and then second statement in profile : exec FLASH.dbo.zDP_SOP10104F_1 3,'00261110','',3,'00261110','þþþþþþþþþþþþþþþ'
Any help on this will be highly appreciable.
Thanks
Sandip
I might be thinking of Transaction Source field among RM and SOP tables. Give it a shot and check whether they have distinct values under TRXSORCE.
This is very strange. The detail lines are correct in SQL but when you use GP to show you the lines they get mixed. I would try running check lines on the sales series and if that does not correct the problem, they running SQL Profiler while using the inquiry screen and capture the query GP issues to show the lines.
It does show both records details by items.
Thanks
Sandip
Ooops a typo. Use this instead.
select * from sop30200 t1
inner join sop30300 t2 on t1.sopnumbe=t2.sopnumbe and t1.soptype=t2.soptype
where t1.sopnumber='00261110' and t1.soptype=3
select * from sop30200 t1
inner join sop30300 t2 on t1.sopnumbe=t2.sopnumbe and t1.soptype=t2.soptype
where t1.sopnumber='00274519' and t1.soptype=3
What happens if you run this script in SSMS?
select * from sop30200 t1
inner join sop30300 t2 on t1.sopnumbe=t2.sopnumbe and t1.soptype=t2.soptype
where t1.sopnumber='00261110' and soptype=3
select * from sop30200 t1
inner join sop30300 t2 on t1.sopnumbe=t2.sopnumbe and t1.soptype=t2.soptype
where t1.sopnumber='00274519' and soptype=3
Do the correct detail lines stay associated with the correct sop header records?
Richard,
Much appreciate for your quick reply. I have deleted and recreated RM00401 table on test environment but nothing has changed still system pulled wrong invoice no. In SOP30200 MSTRNUMB shows different no for each invoice.
FYI both invoices are for different customers. If I inquiry about 00261110 it shows correctly. But when I pulled Invoice # 00274519 it shows 00274519 invoice details.
Any other solution that might help me?
Your earliest reply is highly appreciable.
Thanks
Sandip
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
