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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: abatblack
  • Content: Threads
  • Order by date
  1. abatblack

    Repeated use of same table trouble

    I am tying to write a report that connects overdue purchase orders (PO) to any sales orders (SO) that they relate to. The MRP system creates 2 tables of supply and demand references (PSAD.ID's and ID Links) that can link through up to five levels of components in the manufacturing process. My...
  2. abatblack

    Entries missing in one db that appear in another

    Line items from sales orders that get deleted disappear from the sales_order.items database and get placed in a sales_order.cancelled_items database. If its a missing line in items it will be in cancelled. The two db's are tied together by the sales_order.header db. I need a report that can...
  3. abatblack

    Using selected latest date value in further calculation

    I have a report that checks the costing run of manufactured parts. Each part is manufactured against a works order number. The costing runs are done on an arbitrary time basis by part, there is no common correlation between time of costing between parts nor works orders. I wish to pick the last...

Part and Inventory Search

Back
Top