Add Posting lines in FM Budget document using different Funds

[former_member515535]

We have the next business scenario for a Public Sector industry were the budget of projects can use multiple funds.

Consider the next assumptions:

1. All taxes are part of the value of the material, so they are posted with the same expense account.

2. The TAX (IVA) is posted using a tax code.

The Project has budget assignment from 4 different Funds and all documents PR, PO, IR and Payment must use different funds in the same posting document, this can change from one project to another.

1. Material Value = 100

2. Tax value (IVA) = 12 %

3. Total value = 112

The Material value will use 80% of Fund FM01 and 20% of Fund FM02.

The Tax value will use 10 % of Fund FM03 and 2 % of Fund FM04.

1. Material Value original line = 80

2. Material value line 1 = 20

3. Tax value original line = 10

4. Tax value line 1 = 2

The proposal is to use ADD_POSTING_LINES to include additional line items to Budget Control Document, The rules for the document split inside a FMDERIVE using one step for the Material Value and another step for tax as follows.

Source field 1 = Funded Program

Source field 2 = Temporary field 4 to identify the # of additional line item

Target field 1 = Temporary field 1 to identify the % of the value, will be used to calculate the value of the new line and will be reduced from the original material value line

Target field 2 = Fund to identify the fund to be used for the new line

Please confirm if the proposed solution is correct or if there is a better solution.

[iklovski · Accepted solution]

Hi,

As an approach, it sounds perfectly correct. Alternative to this solution could be only splitting (manually or by programmed algorithm) of the original document.

Of course, you should check the whole flow, including the cancellation of the original document, its carry-forward, etc.

Regards,

Eli