So I took our report and added in ICITMC table, but also had to bring in the ICITEM table in order to cross link the Item numbers properly. Because OEORDD shows the Item with the dashes in it, I have to go into the ICITEM tables, reference the OEORDD.ITEM to ICITEM.FMTITEMNO, then link ICITEM.ITEMNO to ICITMC.ITEMNO
by: Jeff C. | over a year ago | Reports / BI
Comments
So what's the problem? That's report writing.
All I am suggesting is that this information should already be in the table.