Due Dates Based on Payment Terms

Wed, 04 Dec 2013 15:54:04 GMT

Hi all,

I am trying to measure Accounts Receivable and I need due dates, but the due dates are not available in the data draw. The only method I could think of is by using the Invoice Date and the Payment Terms that define the amount of days after the Invoice Date that the payment is due. I am wondering if it is possible to use this data to code a listbox that will provide due dates. For example, I would have Invoice Dates of 12/1/2013 10/1/2013 and a Payment Term Code of XYZ that defines the payments should be due in 30 days. Is there a way to code this so that the dates 12/31/2013 and 10/31/2013 would show up in a new listbox labeled Due Date?

Thank you for the help

Re: Due Dates Based on Payment Terms

Wed, 04 Dec 2013 16:19:23 GMT

You could try something like this. See attached.

Re: Due Dates Based on Payment Terms

MK_QSL — Wed, 04 Dec 2013 16:53:33 GMT

Please check enclosed file showing due dates for payment terms

Advance, 30Days, 30DaysMonthEnd, 60Days, 60DaysMonthEnd

topic Re: Due Dates Based on Payment Terms in QlikView

Due Dates Based on Payment Terms

Re: Due Dates Based on Payment Terms

Re: Due Dates Based on Payment Terms