Technical Articles
Including Freight in Inventory Valuation and Purchasing Invoice Processing – SAP S4HANA & ECC
According to IFRS, Inventory Valuation should be at landed cost which includes the Purchase Price, Freight Cost, Customs and any other costs needed to make the product available in our warehouse
Based on this standard the correct financial entry for Goods Receipt should be:
Account | Debit | Credit | Notes |
Inventory | 820 | ||
Goods Receipt Invoice Receipt | 800 | Purchase Price | |
Goods Receipt Invoice Receipt | 20 | Freight, Customs, Duties, ..etc |
And furthermore, any Purchase Price Variance (PPV) during invoice processing should also impact:
- The inventory value in case of moving average valuation
- The Inventory PPV in case of standard cost valuation
How can we easily post the freight and other related expenses to our inventory value without activating Transportation Management or any other components?
Check the video below for:
- Business Process explanation
- Full demo on the process on SAP S4HANA which is also applicable to ECC
Many SAP users don’t know about this process, so they end up posting the freight and other similar expenses (insurance, duties, customs, etc) to expense accounts without any link to the inventory, and this is wrong as it leads to wrong inventory valuation and a lot of manual processing
Let me know your thoughts in the comments and help me spread the knowledge by sharing this everywhere!
See you in the next blog post 😉
Very nicely explained Abdullah Galal. Keep up the great work.
Thanks,
NSK
Thanks a lot Narasimhulu Konnipati, you've great knowledge in SAP and you always give great answers on all questions, I'm one of your followers.
Please keep helping the community, I learn a lot from what you share.
Thank you.
Best regards,
Abdullah Galal
How did that GR posted with 820 amount to inventory account. Is inventory getting valuated at moving average price?
Yes it's valuated at moving average
Hi Abdullah Galal
You should align your tab in striating of your post with same value as your video, it will be more helpful.
Nice presentation, I haven't seen any progress between ECC and S4 on this topic, and you?
Philippe
Hi Philippe Gauthier ,
Very valuable comment, I've updated the blog accordingly, thank you.
No I've not seen any difference between ECC and S4 in this basic scenario, but there maybe differences in more complicated scenarios, you never know until you get a complicated requirement and investigate
Hello dear,
In S4hana is there is no option to freight charge to directly to the freight vendor at the time of invoice verification … Like ECC.
There is much difference between S4hana & ECC.
For example if you want pay to freight charge in ECC , there is a option, that is planning delivery cost at invoice verification screen .
But S4hana no such option (1809 version). there is only one option , that is invoice verification with reference to Bill of Landing .
Can you please check once...
Thank you
Jai
Hi Jai,
It's there, even now in 1909 it's still available
Nice demo and presentation. This process works fine for freight dependent on the quantity. If it's flat fee for freight then the freight amount is proportioned based on goods receipt quantity. This is a problem whenever there is under or over delivery compared to PO item quantity. Is there any difference or new functionality introduced in S/4 HANA (without using transportation)
Hey Abduallah,
Can you help me with Delivery charges not to post to inventory acc.
I have done the below cofigs.
Actually which is not happening. I am getting..
BSX - DR - 12500
WRX - Cr - 10000
FR1 - Cr - 2500
Did I missed anything?
Appreciate your help on this.
Thanks
Sreenivas@