Skip to Content
0

Need an FMS Query to increment months

Feb 03, 2017 at 09:12 PM

60

avatar image

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:

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Taseeb Saeed Feb 05, 2017 at 09:11 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded