Multiple Line Item VAT Account with different fund center in single invoice

[sayid_al_muzaffar_daulat]

Dear Tax Master

Business user has requirement to have multiple line VAT Account in invoice transaction for different Cost Center/fund center for each expense account. VAT Account is only one (Expense Account - Non Deductable) , but while posting the invoice then business user is expecting it can be posted in different line item depend on Cost Center/ Fund Center. This request purpose for internal report analysis for VAT Consumption for Each Cost Center / Fund Center.

Example :

Tax Code V1 = 5%

Expected Journal Posting :

Cr Vendor - Amount 210

Dr Expense 1 with CC 1 and FC 1 and tax Code V1 - Amount 100

Dr Expense 2 with CC 2 and FC 2 and tax code V1 - Amount 100

Dr VAT Account with CC 1 and FC 1 - Tax Amount 5

Dr VAT Account with CC 2 and FC 2 - Tax Amount 5

If anyone has same experience for this requirement , appreciated in advance if you can share it.

Thanks

SAM