on 02-26-2015 11:08 AM
Hi,
In Journal Entry Rows, I have added a Udf for Vendor Name, as the debit / credit ledger in a particular business scenario will not involve the BP Name. Here expense GL will be debited and a Prepaid Expense GL will be credited.
In this UDF, I want to show the list of existing BPs (Code and Name) to help the user in selection.
Once selected, this UDF should support the same orange arrow for navigation to the BP master.
Please guide step by step.
Thanks.
Hi Rajesh.
first Create FMS.
Tools ---> Queries --> Query Generator--->Click On Execute Button.
Copy following query
SELECT T0.[CardCode], T0.[CardName] FROM OCRD T0
and Paste.
Save Query under FMS category.
--------------------------------------------------------
After this Open Document where your UDF exiest.
Select udf by cursour. Then enter (ALT+SHIFT+F2)
Select 3rd Option :- Search in Existing User-Defined Values according to Saved Query
Open Saved Query from FMS category.
If Need Of Auto Refresh Select like CardCode
When you Enter CardCode. In your UDF Its reflect desired Out Put.
Regards
Amol
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI Rajesh,
SELECT T0.[CardCode], T0.[CardName] FROM OCRD T0
Golden Arrow will not work with FMS.
Thanks
Mohammad Imran
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
6 | |
5 | |
5 | |
5 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.