Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Fields:
REC_DAT Received Date
WERKS Plant
MATNR Material Number
INV_QTY Invoice Quantity – 3PL qty
PCN_DAT PCN date
GR_DAT GR Date
Logic
For 3PL stock as on 30.04.2014
REC_DAT <= monthend & GR_DAT = “ ” or > monthend this is the logic that i should calculate for all the monthend value to get the 3pl stock
({<REC_DAT= {"<=$(=MonthEnd(Today()))"}, [GR Date]= {">$(=MonthEnd(Today()))", ''}>}
I tried the above expression but it doesnt work
In such queries attach a sample qvw to get faster solution.
Try something like sum({<REC_DAT= {"<=$(=MonthEnd(Today()))"}, [GR Date]= {">$(=MonthEnd(Today()))"'}>} INV_QTY).
Note, you will have to make sure the date formats of REC_DAT and GR Date match the default date format of your document.
thats not working and i have tried it before
and date formats is same for all
what is the format of REC_DAT and GR_DAT are they numeric or readable dates?
MonthEnd(Today()) will return a value that is formatted and not numeric
31-04-2014(DD-MM-YYYY) this is the format for all the date fields in the application
Make sure your date fields actually contain data values and not string values that only look like dates.
if your date fields are numeric use $(=num(DayStart(MonthEnd(Today()))))
I would update these values by using num(DayStart(Rec_Dat)) as Rec_Dat in the script
then in the expression us $(=num(DayStart(MonthEnd(Today()))))
date values that are formatted are hideous
this is the sample application have a look at it once