Search results for query: *

Thanks, did exactly that, put they overwrite each other.

How can I query ICHIST to produce two different set of data on the same report i.e using two similar parameters but for different time periods. Thanks

Got it working using the following formula in select expert: pwFormatDate ({ICSHIPH.TRANSDATE}) <= {?ToDate} and pwFormatDate ({ICSHIPH.TRANSDATE}) >= {?FromDate} Thanks to all for their assistance.

I had no luck trying that, could ICSHIPD and ICSHIPH be used to produce the data, seeing that its shipment data?

ettienne how do you summarize it by week?

Thanks, will look at it today.

if the formula can be developed, I could use the group summary to solve the details problem (thanks to ettienne)

Thanks ettienne, can you help me develop the formula (not a very good programmer)

Thanks tuba2007 ICHIST is detailed (list every transaction) while ICSTATI summarizes the transactions. ettienne Yes I am using crystal report, that IC option is set to fiscal year by period, when I changed it gives me a prompt saying that this option should only be changed at year end...

The table is {ICSTATI.SALESQTY}. It would be great if I could get some help with developing a formula to extract data on a week1,week2,week3 basis.

I just discovered the data is stored in icstati, my prob is just how to get that data broken down into separate weeks.

thanks ettienne, but we do not use order entry. We use Inventory Control & Purchase Order.

Hello all, I would like to be able to extract shipment data from ICSTAT for periods of Lastweek lasttwoweeks etc for shipments to add to a market list so that there is some sort of a history for each product. Can anyone advise how this can be achieved. Thanks

Thanks a million worked perfect. You guys are really great help!!!

Thanks tried your suggestion and worked in one aspect but had data loss - prices, uom etc.

Hello, **Spec** Accpac 5.3a running on Pervasive V8 I have two locations numbered 1 & 2. I successfully created a market list in crystal reports, but have one problem, each item is printed twice due to the different locations. How can I get the quantities at both locations to be summarized so...

That should be the total balance on the system.

Thanks ettienne Thats where the stock for the storeroom is entered, if I enter it there it is going to add it to the total physical balance.

Using accpac 5.3a At the end of the month an inventory is done at each outlet, is there a method that can be used to enter this into accpac and get a valuation. This method must not affect the system balance for the items. Thanks

Thanks for the info on this one.