I have a scenario, where I purchase goods and the same is kept at a third party godown. Based on my requirement I release the goods from the third party godown and receive them in my godown. Thus my actual receipts are not in for the entire goods but in tranches.
I also purchase freight service which is defined as Charge(Item) in NAV. But for purchase of Charge(Item), the entire value of the transaction has to be assigned to a GRN. But here as mentioned the GRN is happening in parts, so I have to assign it to the first GRN. This will not be correct as the freight cost will be assigned to the value of the goods for the first GRN. Also I cannot wait for the final GRN to happen before booking the freight purchase as the same may happen months after the actual receipt.
An e.g. for the same is as below.
Item P.O. = 10000 units
GRN1 = 2000 units on 01/04/2019
GRN2 = 3000 units on 03/05/2019
GRN3 = 1000 units on 14/06/2019
GRN4 = 2000 units on 21/07/2019
GRN5 = 1500 units on 25/07/2019
GRN 6 = 500 units on 03/08/2019
Charge(Item) P.O. = $200.00 on 02/04/2019
Please suggest me how tackle the scenario
Thanks in advance.