How to split Invoice distribution Account in Payables

Content

Hi,

How to split Invoice distribution Account in Payables depends on invoice line descriptive flexfield and this DFF including 3 context value for departments by percentages

DFF name : SPLIT   & Context values under DFF (Department 1 = 40, Department 2 = 30,and  Department 3 = 30)

For example department 1 = 40% from invoice line amount, department 2 = 30% from invoice line amount and department 3 = 30% from invoice line amount

Invoice Line Amount = 1000    

Expense Account combination : 01-00-5110-00

need to split expense account combination after select DFF Line as below when create accounting

01-01-5110-00  for department 1 = 400

01-02-5110-00  for department 2 = 300

01-03-5110-00  for department 3 = 300