Adding Negative Amount/Value for Landed Cost is not yet available on NetSuite. It is currently logged under Enhancement 312480: Transactions > Purchases/Vendors > Receive Purchase Order > Landed Cost Tab: Ability to Enter Negative Value on Landed Cost.
Negative value for Landed Cost can serve as a discount for the item cost. The discount item on the vendor bill can only be applied as a decrease from the total payable to the vendor but it is not a decrease on the individual item cost.
As an alternate solution, the negative landed cost allocation for each item can be manually computed and then deduct the computed amount from the regular rate of the item. The difference is the amount that will be entered on the rate field.
As an example, the items on the purchase order are:
– Item A, Quantity = 1, Item Rate = $10
– Item B, Quantity = 1, Item Rate = $5
– Item C, Quantity = 1, Item Rate = $10
Negative value Landed Cost (Amount/Base Unit) to be applied on the Item Receipt is $6 with Cost Allocation Method: Value.
Compute for the allocation for each item:
Total Value for all items: $25
For Item A: $10/$25 x $6 = 2.4
For Item B: $5/$25 X $6 = 1.2
For Item C: $10/$25 x $6 = 2.4
The item rate to be entered for each item upon Item Receipt:
For Item A: $10 – 2.4 = 7.6
For Item B: $5 – 1.2 = 3.8
For Item C: $10 – 2.4 = 7.6