Skip to main content
Question

Absorbing the charges to the part cost when cost is known after the receipt


Chamath Kuruppuarachchi
Hero (Partner)
Forum|alt.badge.img+12

Hi All,

Managing freight costs and allocating various charges to inventory part cost can be a challenging process. Within IFS, there are several methods to handle this — for example, by defining an overhead or using purchase charges combined with different distribution methods.

This process is straightforward as long as we know the charge amounts before the goods are received, allowing us to adjust the purchase order accordingly.

However, I often encounter difficulties when freight costs are unknown at the time of receipt. For instance, we may receive the freight invoice two weeks after the goods have been received. I would like to ask what is the best approach to add these charges to the inventory cost of the parts in such cases? Re-receiving the PO does not appear to be an option.

Could you please share how you typically manage these situations?

Thanks,

Chamath

5 replies

Vimukthi Mahakumbura
Superhero (Customer)
Forum|alt.badge.img+19

@Chamath Kuruppuarachchi Hi Chamath, I have seen scenarios where the charge line is matched later when the freight charges are known and received. This then creates a cascading inventory revaluation. Is this an option for you? 


Harsha Siriwardhana
Hero (Former Employee)
Forum|alt.badge.img+8

Hi ​@Chamath Kuruppuarachchi ,

As mentioned by Vimukthi, if you have configured the Inventory Part with the valuation method set to Weighted Average and the supplier invoice consideration set to Transaction Based, the system will revalue the inventory transaction (ARRIVAL – Receipt of Purchase Order) when the supplier invoice is matched against the PO receipt.

However, for this revaluation event to occur, a charge line with an estimated cost must be added prior to receiving the PO.

Let me know if you need further clarification.

 

Best regards,
Harsha


Chamath Kuruppuarachchi
Hero (Partner)
Forum|alt.badge.img+12

Hi Vimukthi and Harsha,

Hope you both are doing good. Thanks for the insights. I will work on this but I am afraid my customer is not using weight average or transaction based. Is this option only works with that combination?

 

Thanks,

Chamath


Harsha Siriwardhana
Hero (Former Employee)
Forum|alt.badge.img+8

Hi Chamath,

Unfortunately, the supplier invoice consideration method ‘Transaction Based’ can only be used in conjunction with the Weighted Average valuation method.

However, if your customer is using Standard Cost as the valuation method, the Periodic Weighted Average option can be used for supplier invoice consideration.

 

You can find more details about Periodic Weighted Average in the link below:

IFS Cloud Documentation

 

Best regards,

Harsha


Piyal Perera
Hero (Employee)
Forum|alt.badge.img+10
  • Hero (Employee)
  • 287 replies
  • May 1, 2025

Hi ​@Chamath Kuruppuarachchi 

    I just thinking.. Can’t we calculate Latest Purchase Price cost then copy to Inventory Value cost set. I think that calculating latest- and average purchase price considers charges entered on purchase orders.

regards,

Piyal


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings