Skip to Content
0
Former Member
Dec 04, 2009 at 11:42 AM

Stock transfer from 1 branch to another(with allocation of freight charges)

595 Views

Hi

The clients scenario is: Its a Trading company. Head office is located at Delhi. All the material is purchased and received in general wharehouse. After that it is to be transfered to diffrent branches. All branches are marked as warehouse. During transfer freight is applicable. This freight is to allocate on item cost CBM/Volume wise means inventory should get updated by Last purchase price+ freight allocated on item CBM/Volume wise.

Standard inventory transfer does not have freight allocation provision.

Rs 10,000(Suppose)= this is total lorry freight

UDF lorry volume= 1000m3, so 1m3 will cost Rs 10.

Now calculation:

CBM/Volume of item=2m3(in master data)

Qty during inventory transfer=3, so 6m3 is volume occupied by item in the lorry.

So item freight should be 6m3*10Rs=Rs 60.

Inventory should get updated by last price+freight applicable on item.

How to handle this SAP B1?

Thanks