I just checked the Sales Invoice Header table and we have the SO number listed in the Posting Description as well as in the Order No_ field. I searched the table and found no SQ numbers listed.
In our situation, when the Sales Quote is converted to a Sales Order, the number on the order is replaced, so SQ012458 might become SO245348. It just takes the next SO number in the sequence and assigns it.
Looks like I may have to add a field to capture the Sales Quote number, if there was a quote, and have the system add that number at time of conversion. It is not the end of the world, but it does not allow me to go back in time for reporting.
Thank you for the suggestion. I can see where this could have/should have been instituted this recording from day one, but then again, hindsight is 20/20.
Steven R. Hoag
Information Technology Manager
M&G Partners LLP, DBA Fashion Angels Enterprises
306 N. Milwaukee St.
Milwaukee, WI 53202
My office hours are 7am – 4pm M-F.
"CAPS LOCK – Preventing logins Since 1980" ~§~
If you've found this thread useful, dive deeper into User Group community content by role