Dear IFS Community, I need your help.

Our customer needs a unique (or maybe not so unique) setup in our project management resp. financial project.

The figures are.

Estimates

Sales: 3000

Costs: 2000

Margin: 1000

The margin in %: 66,67 %.

Project type is: Capitalize Expenses 

Revenue Recognition Method is: Actual Revenue. 

Contribution Margin: 0%.

In the Periodical Capitalization posting, costs and the calculated costs (from sales) will be posted to unfinished goods vs. WIP. So far so good.

But the problem is, if a customer invoice has been posted with sales from 2000, IFS should reverse the proportionally costs from WIP against unfinished goods. In our example should it be the 66,67 % from the 2000 EUR Sales = 1333,4 EUR.

Calculation:

Booked sales: 2000 EUR * 66,67% = 1333,4 EUR

The cost of sales with 1333,34 should be reversed from the WIP accruals.

IS THIS POSSIBLE IN IFS? And IF this is possible, what are the correct setups?
 

Second point is that if we have booked real costs about 1200 EUR but the “cost of sales” are 1333,34 EUR. The customer wants to book a accrual about the difference 133,34 EUR. Is there a function for in IFS?

The customer does not use the project invoices and only customer order with non inventory sales part. Therefore there is no M24 posting control to drive the cost of sales and the project transactions will not be invoiced yet.

Thank you in advance for your help.

BR,

Benjamin

IFS Cloud 23.2.3