Solved

FIFO parts, Inventory cost & fetched cost buckets are different from calculated part cost

  • 15 December 2022
  • 1 reply
  • 275 views

Userlevel 3
Badge +3

FIFO parts, Inventory cost & fetched cost buckets are different from calculated part cost

 

 Pre-requisite data-

• Purchase part with component part/s

• Component parts available in the inventory

• FIFO costing used

• Cost calculated and copied to cost set 1

 

Functional steps to recreate:

 

a) Create purchase order & Add purchase order line for the Top part

b) Process the Purchase order in the regular flow.

a. Release

b. Reserve supplier material

c. Ship supplier material

d. Register arrival

e. Receipt purchase order

 

c) For the purchase part, Inventory transaction history window > observe Receipt of purchase order (ARRIVAL) transaction > Cost details tab

 

Why the Inventory cost & fetched cost buckets are different from calculated part cost?

icon

Best answer by Dinidu Udana 16 December 2022, 03:43

View original

1 reply

Userlevel 5
Badge +12

When it comes to purchase parts at the receipt,  arrival transactions of FIFO parts do not show Material Overheads and General Overheads unlike inventory parts with Standard Cost valuation method, which is why some cost buckets are not appearing on the cost detail tab. This is the known behavior for FIFO parts.

 

As per the Design, the system ignores certain types of cost types; Labor, Machine and Outside cost buckets in the arrival transaction since they are only applicable to manufacturing processes and not meaningful for purchasing processes. In contrast, the transaction fetches any delivery overheads corresponding to cost element 141, which are applicable for parts being purchased. This is how the application has been designed and it explains why all the overheads except Delivery OHs are missing from the transaction. 

 

If Part Cost has not been calculated and established according to preferred cost buckets prior to receiving the parts, then the default material cost bucket 110 shows up as in the inventory transaction. In this particular scenario, if the receipt transaction of the component part has been posted as 110, all the subsequent transactions; Issue Material for Supplier (PURSHIP), Material Cost for Purchase (POINV-WIP) and Receipt of Purchase Order (ARRIVAL) of the structured part, will be posted with 110 since 110 bucket gets accumulated in the top part cost. To overcome this, the component part should be received into inventory with 120 cost bucket by selecting 120 at NREC transaction or calculating and establishing the Part Cost with 120 cost bucket prior to receipt.

Reply