When creating a Bill sometimes a amortization schedule is applied.
Based on the amortization schedule a journal is created.
The memo on the lines of the journal does however contain a text which is not meaningful and is for example: Amortization Destination.
Finance want this memo text on the journal line to be equal to the text from the memo line on the bill.
I haved checked on doing this with a workflow but unfortunately that cannot be done since the amortization journal entry is linked to a schedule and the schedule is linked to the bill. So getting the value from the bill lines is to far for the workflow where amortization journal are created.
We are creating a script to overright the text on the memo line of the amortization journal entries.
However, we are finding it difficult to trigger the script on the click of the button “Create Journal Entries”.
We have tried different deployments, like: Journal Entry, Amortization Schedule, and Amortization Template but nothing helped.
Does anyone have any pointers?