Hi
I am preparing a Accounts payable forecast report. It is using existing purchase order and purchase requsitions from SAP. I am also taking agreed payment terms from vendor master. Quite often payments are not paid exactly on the agreed time; they can be paid few days early or late. My report should show how much we have open payments in becomming months (if invoice date is within the month or earlier and payment date is not within the month, report should show this value for this month).This I try to simulate with slicer function in my Qlikview report. However, something is not working properly. I have following script in my pivot table
sum({<Month={"<=$(=Max(Month))"},#PVM=>} If((#PVM+[Due date]+ vDueDateChange)>=MonthEndPVM And [Period in Month]<=Month, PO_value))
in where
- "Month" is the forecast month
- #PVM is the invoice date
- "Due date" is the agreed payment term
- vDueDateChange is the variable in slicer, days paid early/late
- MonthEndPVM is the last day of the month
- Period in Month is the month when payment is due
- PO Value is the purchase order value
It looks like that if I said with slicer that I pay few days earlier it seems to change values, but If I would say that I paid late it gives the original value. Would someone know what is the problem in my script??
Thanks
Janne
