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 gkittelson 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: *

  1. peamkay

    Need report showing stock, sales, purchases

    lbass - I had never used a command before but this worked great. Thanks!
  2. peamkay

    Need report showing stock, sales, purchases

    Great! I'll give it a shot. I tried the subreport route but ended up with a bunch of blank space on the report because I was trying to suppress the footer when on hand + po - so > 0 so I got blank "detail" lines for all the items that didn't meet my criteria.
  3. peamkay

    Need report showing stock, sales, purchases

    There are 4 tables. Item table contains the ITEMNO, DESC Stock table contains BIN, ITEMNO, QTY Sales table contains DOCNO, ITEMNO, ORD_QTY Purchase table contains PONO, ITEMNO, PURCH_QTY ITEMNO DESC Z1 Widgit Z2 Blue Widgit ----------------------------------- BIN ITEMNO Qty B1 Z1...
  4. peamkay

    Need report showing stock, sales, purchases

    I am using Crystal 10 with a SQL database and need to figure out how to create a report from the following 4 tables: Items, Stock Area, Orders, Purchase Orders that shows my total on hand (adding up records in the Stock Area table), total on open sales orders and total on open purchase orders...

Part and Inventory Search

Back
Top