Out of the box, the Sales Order Confirmation does not display line items after they have been delivered or invoiced. We need the report to display all line items regardless of the line status. Does anyone know if there is a setting that can be changed or what code needs to be modified to make this happen.
Thanks in advance for any help you can provide?
*This post is locked for comments
I've added code to add lines from the salesLine table with a status = (delivered or invoiced). However, its still not working. Would either one of you be interested in doing a join me to help resolved the issue? I will be happy to pay for your time.
Crispin has mentioned this above correctly that the reason while your lines are not coming are because those confirm transactions only exist for the non-invoiced lines.
And yes, you could modify the data provider class to insert the other rows using the SalesLine as well into the Tmp table, if you would like to include all on the report (for whatever reason).
I queried the custConfirmTrans table and it doesn't appear to have the invoiced line items so I'm not sure if I do a "select * from custConfirmTrans = salesID" if it will return all of the records for the Sales Order. I wonder if I populate the temp table from the SalesLine table because that has all of the line items??? What are your thoughts? I want to minimize the code changes as much as possible. Thanks for your help!!!!
Yes, making sense. Where should I add the code from above:
CustConfirmTrans where SalesId == ""..
Thanks guys!! .... working on it right now.
Yes, walking through the code. I Viewed the SQL select statement for tradelooptrans (within createData), however I never see a filter as part of the SQL statement. Just a straight forward select statement
Thanks for the reply.... I have been looking at the method for a couple of hours thinking the filter had to be in there but I don't see it. Which line is the filter?
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
