on 04-28-2008 11:00 AM
Hi Expert guys and girls!
I use the "Start" point to execute my BAPI "Salesorder GetList" / BAPI_SALESORDER_GETLIST.
In order to use this BAPI you have to define
1) Customer Number
2) Sales Org
and optionally I checked also
3) Document Date
4) Document Date To
I fill in the values for all the fields. Using formulas for all - which works fine otherwise.
My Date - formulas are designed to retrieve the last 3 months.
ad 3)
DVAL(DADD(NOW(),-3,'M'))
4)
DVAL(NOW())
(I added the DVAL in front, but still I do not get any effect)
Problem is now that the model retrieves ALL records for the logged in Customer No. and Sales Org. NOT limiting data to the specified date-interval. This takes a long time and is certainly not what I expected.
I run SP14 - anybody had any experience in SP15 - maybe it is a simple upgrade?
Or am I missing something in parsing the dates??
Best regards
Jakob Diness
I got it to work with a little effort.
1) Try parse fixed-dates (e.g. 08.08.2008) as Start and End dates. When that works, replace first the Start date then the end-date with DADD formulas like DADD(NOW(), -3, 'M') and NOW() in the End-date for example (going three months back in the example).
2) Maybe you need to try with the Flex compiler instead of Flex 2 - since that was also not working for me in other cases. (Tools/Options/Compiler - change to Flex)
3) Otherwise - pls. let me know. I somehow got it to work in my customer model.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thx,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thx, but should it not work without using DADD then?
Or can you not parse a date without using DADD?
And is it fixed in SP15 for example?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
DADD Formula is not working fine .It has bug.
Wait untill it fixed.
Regards,
Govindu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.