12,398,816 members (55,591 online)
Rate this:
See more:
Good day to all of you.

I would like to ask if someone knows an idea to solve my problem, i am dealing with this for almost a week and i still don't get what i want to achieve.

Here it is, First I have table "Product_Inventory" where it has the ff fields:

```secret_code
inv_date
inv_pro_category
inv_pro_sub_category
inv_pro_code
inv_pro_name
inv_beg
inv_pur_ref
inv_pur_ret
inv_dam
inv_sal_rel
inv_sal_ret
inv_ending
inv_actual```

Example date screen shots here: https://dl.dropbox.com/u/65392916/Product_Inventory.png

This is the result output from crystal report: https://dl.dropbox.com/u/65392916/Report.png

Where beginning inventory should not be 53 when i set the date range from Nov 15, 2012 to Nov, 17, 2012

What happens is that crystal report summarized all beg inventory from nov 15 to nov 17. Inv_beg should start from the beginning of date range "Nov 15, 2012" = 25 pcs

Hope someone can understand me and help. thanks a lot in advance hope to hear from you soon
Posted 14-Nov-12 8:34am
JMAM669
VitorHugoGarcia 15-Nov-12 12:32pm

whats your record selection formula ?
JMAM 21-Nov-12 7:19am

I don't have record selection formula
ChandraRam 22-Nov-12 9:32am

How are you calculating the "starting inventory"?
JMAM 22-Nov-12 9:46am

I am getting the starting inventory based on the last transaction day ending inventory.
For instance if i made transactions from Nov 1, 2012 to Nov 30, 2012 thus i generate a report from November 15, 2012 to November 30, 2012 All products beginning inventory should come from the last ending inventory before the date range "From"

So November 15, 2012 Starting Inventory shall come from Vovember 14, 2012 ending inventory

Rate this:

## Solution 1

Top Experts
Last 24hrsThis month
 OriginalGriff 340 ppolymorphe 330 Richard Deeming 220 Richard MacCutchan 195 0x01AA 120
 OriginalGriff 6,623 ppolymorphe 2,785 Karthik Bangalore 2,667 Richard MacCutchan 2,037 F-ES Sitecore 2,012