How to show Remaining balance amount in distributi

[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.

[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

[mazahirabbas]

Can you please tell me the process that how can i do it with form personalization?

[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

[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

[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

[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

[mazahirabbas]

Thanks Octavio,,


I got this Done,,


Regards

Mazahir Abbas