Skip to Content
avatar image
Former Member

need FMS query to automate a user define field with Standard Field in Out going payment

Respected Sir

I had created a UDF in Outgoing payment called Mode of Payement in which i had 4 Static Data

1. Cash

2.Credit Card

3.Cheque

4.Transfer

Also i had different series number for each type of transfer

1.IN-RB-CA for Cash

2.IN-RB-CC for Credit Card

3.IN-RB-CQ for Cheque

4.IN-RB-TR for Transfer

what i need is eg : when the user select CASH from UDF then IN-RB-CA has to automatically updated, and when select Credi Card then IN-RB-CC

like wise it should get auto update, pls give me a FMS Query or SPT

Regards

3.jpg (53.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jun 01, 2017 at 09:51 AM

    Its fixed

    IF $[ORCT.U_MOP]='Cash' Begin SELECT 'IN-RB-CA' END IF $[ORCT.U_MOP]='CreditCard' Begin SELECT 'IN-RB-CC' END IF $[ORCT.U_MOP]='Cheque' Begin SELECT 'IN-RB-CQ' END IF $[ORCT.U_MOP]='Transfer' Begin SELECT 'IN-RB-TR' END.

    Regards

    Add comment
    10|10000 characters needed characters exceeded