on 04-29-2015 1:36 PM
Dear Experts,
I am designing an FMS on sale order Item Code Field. When it will executed on first line it will show all the sale items but as it will be executed on 2nd line it will show sale items excluding the item which has been entered at first line and same scenario will occur at 3rd line means it shows Sale Items excluding Items entered on line 1 & 2 and same for other lines. So the user will not be able to enter a single item twice not even by mistake.
Please tell me what would be the FMS query for this.
Hi,
Not possible by FMS. Formatted search cannot see other lines.
Regards
Edy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Muhammad,
Executing a stored procedure will not solve your problem.
Stored procedure can only evaluate when your records is written in table.
In your case, when user enter an item code, it is not yet committed to database.
Thus your stored procedure will never know what items have been entered.
Your current requirement cannot be addressed by FMS.
You have 2 choices.
1. If you insists on validating live as when the user enter the items, you need an UI API addon.
2. If you can live with validating when the user click the add/update the document, you can use Transaction Notification.
Regards
Edy
User | Count |
---|---|
89 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
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.