Search results for query: *

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...

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...

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...

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...

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...

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...

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...

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...

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 =...

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...