Weighted Average part's PO is invoicing to a different supplier

Hi @Tharindu Illangasinghe ,

Given that you're utilizing supplier invoice consideration using transaction-based, it seems likely that you'd achieve expected cost calculation. Upon arrival, you could base it on your purchase price, and if you invoice at a higher or lower price, it should revalue accordingly irrespective whom you are going to pay. Although I haven't tested this process, I'm optimistic that it would function in this manner.

regards,

Piyal

Thank you @Piyal Perera and @Marcel.Ausan for your inputs.  

So, our expectation is when we Invoice with a different (compared to the PO) amount a revaluation to be triggered and update the Unit Cost of the Part based on new amounts.

It looks like something is still missing here. Even though we update the “Gross Amount” in the invoice (regardless of which supplier we select) it is not updating the “Invoiced Price Net/Unit”.

As a result, from the system point of view there is no change in the Price. Hence, no change has happened with the Unit Cost of the Part.

No change to the Unit Cost of the Part has taken place. Whereas we have new amounts invoiced.

@Piyal Perera that would be great… 😊

thanks a lot for that.

Here is the Postings section of the invoice

Inventory Part setup is like this

Thank you very much for checking this @Piyal Perera .

In my Posting Proposal there is no option to edit it (so I could try to balance it). Do you happen to know how that could be done ?

Or is there a way to balance it automatically at the Invoice creation itself ?

Hi @Piyal Perera

I will try that. At the moment I can’t see any data in the “Posting Proposal” window. So, I will check about this and get back.

However, the Transaction Revaluation has been triggered already the moment the Manual Supplier Invoice is created. Even though the postings are Unbalanced.

So changing the postings values now will trigger another Revaluation Event ? That is to update the Unit Cost with the Invoiced Amount ?