What is the Overall Influence on WAC(Weighted Average Cost) in ReIM(Retail Invoice Matching)? (Doc ID 1456400.1)

Last updated on FEBRUARY 08, 2024

Applies to:

Goal

What is the overall influence on WAC(Weighted Average Cost) in ReIM(Retail Invoice Matching) for the following scenario?

For example:-

Create a purchase order (PO) for a supplier for Item A. Supplier unit cost is 10 and ordered quantity is 100 units. There is also an expense component, freight charges which is 3 per unit defined.

That means Order cost is = Estimated Landed cost (ELC) Cost * No. of units ordered

= (10+3) * 100

= 1300

It is expected while receiving, order cost should be 1300 so that WAC can be calculated.

While doing invoice matching, supplier has given the invoice for the above PO considering only the supplier cost (since supplier is not arranging for the freights and transportation). That means invoice includes only 1000.

For the freight cost, metro accounts has to create a non-merchandise invoice along with the supplier invoice. Non-merchandise invoice will be of 300 in this case?

Also please confirm if freight expense is not included at the time of PO creation, that means PO is created only for 1000 and received the same. WAC got calculated based on 1000 itself. Can business post non-merchandise invoice of remaining 300 separately and do a WAC calculation based on 300?
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.