Skip to Content
avatar image
Former Member

Need an FMS Query to increment months

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:

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Feb 05, 2017 at 09:11 AM

    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

    Add comment
    10|10000 characters needed characters exceeded