Skip to Content

FIFO Consumption to calculate Sec.price gain

Hi,

My customer used the product type Shareholdings, as follow:

  1. Tr.Type Date Price Units Total

BUY 01.10.2015 1.052681 239,923,502.5 239,923,502.50

BUY 02.10.2015 1.053644 474,543,583.98 500,000,000.00

BUY 05.10.2015 1.056930 946,136,451.80 1,000,000,000.00

SELL 06.10.2015 1.057974 1,417,804,218.25 1,500,000,000.00

I need to use FIFO Valuation as follow:

To get the following Security Price Gain in tx. TPM12

  1. Tr.Type Date Price Units Total Sec.Price Gain

SELL 06.10.2015 1.057974 239,923,502.5 239,923,502.50 1,269,915.10

SELL 06.10.2015 1.057974 474,543,583.98 500,000,000.00 2,054,773.72

SELL 06.10.2015 1.057974 703,337,131.77 744,112,398.65 40,775,266.88

Total Gain: 44,099,955.69

I customized in: Treasury and Risk Management-> Transaction Manager-> General Settings ->Accounting ->Settings for Position Management->Assign Consumption Sequence Procedure

But the system use Avg. Cost to calculate the price gain, but that is not useful for me.


How I can calculate FIFO to get the total gain?


Regards,


Adriana Rivera

imagen2.jpg (95.7 kB)
imagen1.jpg (83.2 kB)
imagen0.jpg (82.4 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Oct 21, 2015 at 06:25 AM

    Hello Adriana,

    You could realize this by using single position management (lot assignment) as differentiation criteria.

    Please check customizing in "Define and Assign Differentiations".

    Best regards,

    Jasmine

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.