Skip to Content
0
Former Member
Jul 27, 2010 at 06:52 AM

Invoice Price refer to GR quantity

40 Views

Hi experts,

I had maintain scale quantity in Info Record.

Qty 1 - 1000 -- Price 100.00

Qty 1001 - 3000 -- Price 80.00

Qty 3000 - 5000 -- Price 60.00

Qty 5000 above -- Price 50.00

My problem is my invoice want to refer to GR quantity

1st GR 500pcs -- Invoice Price should 100.00

2nd GR 3000pcs -- Invoice Price should 80.00

3rd GR 8000pcs -- Invoice Price should 50.00

Do you have any idea how i want to get the price based on GR quantity instead of PO quantity?