Invoice: Split Receivable Gl Account based on Invoice Memo Line Amount(s)

Summary:

Hello Team,

We have a requirement to split the Invoice receivable GL account based on one of the invoice memo line amount.

E.g, Product A 100 with GL Account 4123

Product B 50 with GL Account 4124 (need to have a different receivable account)

Product C 25 with GL Account 4125

Receivable account 1234 (in general), 1789 (for Product B)

1234 A/c   125 Dr

1789 A/c   50 Dr

4123 A/c 100 Cr

4124 A/c 50 Cr

4125 A/c 25 Cr

Please let us know if anyone had this requirement and any insights to achieve this, appreciate your guidance

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):