Forum Discussion
Multiple Item price depends on remaining quantities
When I'm entering the order Invoice I want to bring the buying price of (Item1) and its Remaining quantities from (purchaseDetail) table, (Item1) had multiple records in the (purchaseDetail) table ...
if you want to go that path.
then not the purchase that you want to involve.
but you need a Separate Location for each purchase if the purchase price is not
the same.
and on allocating for sales you should enter which Location you have withdrawn the
said item.
therefore, your combo should include the Location, Item, and price.
and item is deducted from that Location.
then not the purchase that you want to involve.
but you need a Separate Location for each purchase if the purchase price is not
the same.
and on allocating for sales you should enter which Location you have withdrawn the
said item.
therefore, your combo should include the Location, Item, and price.
and item is deducted from that Location.
Hello bro
The items are in the same location , the same item has different buying price . So I want to know which item price I'm ordering now to give it the selling price and also to calculate profits.
The items are in the same location , the same item has different buying price . So I want to know which item price I'm ordering now to give it the selling price and also to calculate profits.