Apparently a salesman was assigned to an incorrect customer and we found out after the invoice was printed. I have a sales meeting friday where these figues will be presented. I have corrected the salesperson code in A/R customers but the sales dollars are still going to the incorrect salesman. Can someone please help me?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Sales History Report
- Thread starter DSM664
- Start date
What kind of help do you want?
The commission table has been incorrectly updated, as has the invoice record. Do you have the skills to go and edit these records and correct or would you like someone to do it? Why not just make a manual adjustment on your reports?
If you want to update the records, you should change OEINVH and OECOMM tables.
The commission table has been incorrectly updated, as has the invoice record. Do you have the skills to go and edit these records and correct or would you like someone to do it? Why not just make a manual adjustment on your reports?
If you want to update the records, you should change OEINVH and OECOMM tables.
- Thread starter
- #3
Thank you!
However I do not have the skills to do this. I am unfamiliar with SQL and have limited crystal reports experience. I have exported the data and manually changed it, however i would like to permanantly change the record so that if we run these reports in the future we will not have to manually change them.
anyone willing to walk me through this?
However I do not have the skills to do this. I am unfamiliar with SQL and have limited crystal reports experience. I have exported the data and manually changed it, however i would like to permanantly change the record so that if we run these reports in the future we will not have to manually change them.
anyone willing to walk me through this?
jayconverse
MIS
That's like saying "I am unfamiliar with auto maintenance, can you walk me through how to change a timing chain?".
You'll be better off adding a credit note for the original invoice, making sure you select the wrong salesperson, then putting in a corrected invoice.
Jay Converse
IT Director
Systemlink, Inc.
You'll be better off adding a credit note for the original invoice, making sure you select the wrong salesperson, then putting in a corrected invoice.
Jay Converse
IT Director
Systemlink, Inc.
- Status
Similar threads
- Locked
- Question