Skip to Content
0
Jan 02, 2019 at 10:57 PM

FICA - Multiple VAT line items + Funds Management

260 Views

Hi dear all,

I'm currently on public sector project.

Our customer is requiring VAT to be updated in funds management with the same key as the profit account.

The problem is when we use the same VAT code, despite several profit gl account and items, the VAT is summarized. If so, we are not able to correctly derivate the funds management key (commitment item, funds and funds center).

I want to know how to post VAT line by line on FICA.

lets give an example of the requirement: (same VAT code used, but commitment item should be different according to the profit and loss gl account ).

item 1 Customer 1 - Amt: 123 euros - tax code: 06 - 23%, Commitment Item: 1 Fund: dummy: Funds Center: P1

item 2 Customer 1 - Amt: 61,5 euros - tax code 06 - 23% Commitment Item: 2 Fund: dummy: Funds Center: P2

item 3 Profit Account Service 1 - Amt: 100 Euros, Commitment Item: 1 Fund: dummy: Funds Center: P1

item 4 Profit Account Service 2 - Amt: 50 euros, Commitment Item: 2 Fund: dummy: Funds Center: P2

item 5 VAT Service 1: Amt: 23 euros, tax code 06 -23%. Commitment Item: 1 Fund: dummy: Funds Center: P1

item 6 VAT Service 2: Amt: 11,5 euros, tax code 06 -23%. Commitment Item: 2 Fund: dummy: Funds Center: P2