We have an odd problem, when you go into OE consolidated to view one order in particular it shows the wrong customer, I checked in OEHDRHST and the correct customer is listed there. Does anyone know what table the info in OE consolidated is pulling from and why this may be happening.
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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
OE Consolidated showing wrong customer
- Thread starter smtoomey3
- Start date
- Thread starter
- #2
Sean,
How can this be happenning? The OEINQORD table is being populated by entering an order.
Did you dust off your all-in-one program? And if so is this the culprit?
Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
How can this be happenning? The OEINQORD table is being populated by entering an order.
Did you dust off your all-in-one program? And if so is this the culprit?
Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
maccrystal
Technical User
The table is built by normal oe transactional processes. IF the source data is correct, you can always reload the the table with OE\Processes\Reload OE view and see if the data is correct after the reload.
MacolaHelp
Instructor
This does happen from time to time & the load oe master view will fix it. However, if you do a mismatch query between order header/line & vice versa and order header history/line and vice versa, you will probably find stray records. Clean those up & you probably won't have the problem recur for a long time.
- Status
Similar threads
- Locked
- Question