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?
