Unable to Derive the COA Segment Values based on the Item Category for Receivable Account using SLA

Hello Team,

Our client has the requirement to derive some COA segment values of Receivable account(AR) based on Item category/Item level sales account.

For eg : If an invoice is having 3 item lines with different categories, we are expected to have 3 different receivable accounting lines with different COA combination

Initially, Client had a similar requirement for Revenue account, we did the required SLA setups, and we were able to fetch the segment values based on Item category and now Client wants same segments for Receivable also.

We tried with  below 4 approaches in Created Accounting Rules

1.“Values type = Source” and “Value = Transaction Item Sales Account”