Skip to Content
0

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

May 31, 2017 at 07:05 AM

30

avatar image

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)
10 |10000 characters needed characters left characters exceeded

Hi Experts

Any solution ...................

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Shahan Shams Jun 01, 2017 at 09:51 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded