Need an FMS Query to increment months

[Former Member]

I have UDF field called Billing Month that I populate based on the posting date.

IF $[OQUT.DocDate.Date]>='01/01/17' AND $[OQUT.DocDate.Date] <= '01/31/17' select 'January' ELSE IF $[OQUT.DocDate.Date]>='02/01/17' AND $[OQUT.DocDate.Date] <= '02/28/17' select 'February' ELSE IF $[OQUT.DocDate.Date]>='03/01/17' AND $[OQUT.DocDate.Date] <= '03/31/17' select 'March' ELSE IF $[OQUT.DocDate.Date]>='04/01/17' AND $[OQUT.DocDate.Date] <= '04/30/17' select 'April' ELSE etc...

I would like the query to "automatically" increment by month in each line item. So(posting date in January) first line item January; second line item February; third line item March; etc..

If the posting date in February - start with February and increment from there

first line item February; second line item March; third line item April; etc..

I have a second UDF called Months which is the number of months(line items)to add. So if the number is 3 and the posting date is February(I use BOYUM to create the additional lines. I would want to populate the UDF field "Billing Month" in the three line items accordingly:

[Former Member]

Hello,

You can achieve this by writing a SDK code. Which will automatically fill your matrix rows based on posting dates.

Or you can write fms but for this you need to add lines one by one.

Thanks

Engr.Taseeb Saeed