Page 1 of 1
How to show Remaining balance amount in distributi
Posted: Sat May 08, 2010 5:08 am
by mazahirabbas
When we enter distribution lines while entering invoice, which is less then total amount, it should show total of all distributions after entering each line. If total amount is 10,000 and we enter value 9,000 on distribution, we want to show 1,000 remaining balance there on the form so that we can easily distinguish the remaining balance amount.
Posted: Mon May 10, 2010 11:01 am
by oteixeira
Hello.
You can use Forms Personalization to display a message to user with the amount remaining each time he/she hits a certain field.
Octavio
Posted: Mon May 10, 2010 2:47 pm
by mazahirabbas
Can you please tell me the process that how can i do it with form personalization?
Posted: Tue May 11, 2010 3:48 am
by shaikjohnpasha
In R12,It shows clearly the amount at the header level and distribution total.If the total doesn't match the amounts shown in different colour(Red).So what else you are looking for.I don't suggest form personalisation for the existing functionality.
Regards,
John Pasha Shaik
Posted: Tue May 11, 2010 5:37 am
by oteixeira
Hello.
Navigate to Help/Diagnostics/Custom Code/Personalize and enter the following personalization:
Condition Tab
Trigger Event->WHEN-NEW-ITEM-INSTANCE
Trigger Object->D_SUM_FOLDER.AMOUNT
Condition->:INV_SUM_FOLDER.INVOICE_AMOUNT > :INV_SUM_FOLDER.DISTRIBUTION_TOTAL
Action Tab
Type->Message
Message Type->Show
Message Text->='The amount remaining is now: '||' ' ||(:INV_SUM_FOLDER.INVOICE_AMOUNT - :INV_SUM_FOLDER.DISTRIBUTION_TOTAL)
Pay attention to colon.
Let me know if it worked.
Octavio
Posted: Sat May 15, 2010 8:58 am
by mazahirabbas
Thanks Octavio
it calculates the condition but doesnt provide the result,,,
i cant understand where is the mistake.. can you pleaze tell me
Condition is:
:LINE_SUM_FOLDER.D_SUM_AMOUNT > :LINE_SUM_FOLDER.D_SUM_DIST_TOTAL
works fine but
in message
(:LINE_SUM_FOLDER.D_SUM_AMOUNT - :LINE_SUM_FOLDER.D_SUM_DIST_TOTAL)
it is not calculating the difference...
can you please tell me where i am having the problem.
Mazahir Abbas
Posted: Mon May 17, 2010 5:35 am
by oteixeira
Hello Mazahir.
Please re-check the personalization.
Condition->:INV_SUM_FOLDER.INVOICE_AMOUNT > :INV_SUM_FOLDER.DISTRIBUTION_TOTAL
Message Text->='The amount remaining is now: '||' ' ||(:INV_SUM_FOLDER.INVOICE_AMOUNT - :INV_SUM_FOLDER.DISTRIBUTION_TOTAL)
Octavio
Posted: Tue May 18, 2010 5:43 am
by mazahirabbas
Thanks Octavio,,
I got this Done,,
Regards
Mazahir Abbas