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 Chriss Miller 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 CRdesigner

  1. CRdesigner

    How to show the history of quantity salesorder in ACCPAC?

    Hi, first of all, thanks for the reply. second, yes I am looking for totals per date. Lastly, I have been told that I can't the values that I've been looking for. They said that there's no such thing as history of sales order and purchase order. I'm glad that someone like you replied to my...
  2. CRdesigner

    How to show the history of quantity salesorder in ACCPAC?

    Hi guys, I am making a monitoring report in ACCPAC and i need the show the quantity on hand, quantity salesorder and quantity onorder. I already figure out how to get the history of quantity on hand as of date(current or previous)using ICHIST table, meaning i can show the quantity for the...
  3. CRdesigner

    Help in IC Location Details

    Hi Good Day to all, First of all i am making a monitoring report for items in I/C. so the format would be like this: parameter: date output: item, QonHand, SO, PO, quotation in OE so what they want is when they enter a date for example is their beginning balance 1/1/09, their would be an...
  4. CRdesigner

    quantity on hand

    hi again, there's a problem again, lets say i have total quantity of 5000 per item A as of january 31,2009. but when i try to filter the date of january 15, 2009 it only shows the total quantity of it,example 1500 quantity of item A. but i want to get the total quantity of item A from...
  5. CRdesigner

    quantity on hand

    hi, before you answer, i did some changes in the report ^_^ and this what happen lets say same scenario i got a total of 92 per item1 in 1/2/2001 right? so what i did is make a running total not a formula rtotal1. in this rtotal1: summarize quantity, evaluate each record, reset at item no...
  6. CRdesigner

    quantity on hand

    Hi tuba2007, thanks for the reply, i tried to include the ICHIST table in my report and this is the output of it: item quantity transdate item1 8 1/1/2001 item1 87 1/1/2001 item1 -8 1/1/2001 sum...
  7. CRdesigner

    quantity on hand

    hi, good day to all! i need your help guys about inventory regarding quantity on hand. this is the scenario: transaction date: quantity jan 1,2009 +1000 jan 2, 2009 +1000 for example i have a beginning balance of 1000 pcs of item1 as of january 1,2009...
  8. CRdesigner

    how to get the quantity order in OE entry if the order type is ACTIVE

    thanks for the reply, i appreciate it i did add 3 groups namely gh1: icitem.category(suppress) gh2: oeordd.item(supress) details: oeordd.desc recqty quantity for active, for quote actually i already figure it out why the quantity for order type " active" shows zero values because the...
  9. CRdesigner

    how to include the quantity ordered in OE entry if order type is ACTIV

    Hi guys, I'm using CRXI(crystal report version XI) and i'm getting tables from accpac module OE(OE ENTRY). my problem is i want to include the quantity ordered in the report if order type is "ACTIVE" but the only thing that crystal report shows is the order type "QUOTE" scenario: reference =...
  10. CRdesigner

    how to get the quantity order in OE entry if the order type is ACTIVE

    Hi guys, I'm using CRXI and i'm getting tables from accpac module OE(OE ENTRY). my problem is i want to include the quantity ordered in the report if order type is "ACTIVE" but the only thing that crystal report shows is the order type "QUOTE" scenario: reference = parameter...
See more

Part and Inventory Search

Back
Top