I need a FMS for Auto G/L account for Creating a customer & Restriction of Wrong GL Account Stored Procedure
Our company having branches like Bangalore , Chennai , Mumbai , Pune
1)Auto FMS query required as mentioned below...
If the customer is from Bangalore region then customer will be created with foreign name Bangalore & G/L Account for Accounts receivable, AR Down payment clearing account must be selected for Bangalore.
2)Stored Procedure is required as mentioned below.
If the customer is selected with foreign name Bangalore & Accounts receivable & AR Down payment clearing account is selected for Pune , Mumbai , Chennai then customer should not able to create..
Pls find the attached image below for reference