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!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by PJ62

  1. PJ62

    joining work centers on crew history

    Whoops I out the wrong table into the question, it's MCTRXHST_SQL.
  2. PJ62

    actual versus standard cost

    I need to make a report summing up the total cost per order for labor, materials, outsourcing, etc, and compare it to the standard cost. What tables do I need to look at?
  3. PJ62

    joining work centers on crew history

    It's a report showing planned versus actual labor, calculating efficiency by order and individual. ... but I don't see any hours in the crew file. Maybe I should just give the user a list per order in a sub report and tell him that we can't do efficiency at that level of granularity.
  4. PJ62

    joining work centers on crew history

    Hi, I'm looking at a report that joins the HZCTRFIL, work centers information, with MCCRWHST, the crew history, on ord_no. The user complained that this generated duplicates, which I confirmed. I attempted to fix this by adding oper_no to the join. This eliminated only some of the duplicates...
  5. PJ62

    getting PO from invoice

    I'm doing an AR aging report and it's not clear to me how to associate a PO with each invoice number. Is there a way to do this? I've looked through the table documentation and can't find any explicit links.
See more

Part and Inventory Search

Back
Top