Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
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:

Example date screen shots here:
This is the result output from crystal report:

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 9:34am
VitorHugoGarcia at 15-Nov-12 12:32pm
whats your record selection formula ?
JMAM at 21-Nov-12 7:19am
I don't have record selection formula
ChandraRam at 22-Nov-12 9:32am
How are you calculating the "starting inventory"?
JMAM at 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

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1


This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 230
1 PIEBALDconsult 150
2 DamithSL 125
3 Andreas Gieriet 90
4 Jochen Arndt 90
0 OriginalGriff 5,790
1 DamithSL 4,601
2 Maciej Los 4,012
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,195

Advertise | Privacy | Mobile
Web04 | 2.8.141220.1 | Last Updated 31 Oct 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100