When editing a line item on an inventory receipt, you should be able to enter the total line item price instead of the UOM price. The invoices that we receive from our supplier’s will show the supplier UOM price and the total line item price but never shows the UOM price as it is set in our system. We track by pounds, the supplier sends invoices based on bags.
As an example;
We received 110 lbs of 2-Row Malt in 2 55 lb bags. The Supplier lists this line item with a quantity of 2 (2x55lbs) and a unit price of $40.00 with a total line item price of $80.00. If I generate an inventory receipt for this invoice from the purchase order and the pricing changed, I need to go into the line item on the inventory receipt and do the math of $80/110 lbs to arrive at the UOM price that the inventory receipt wants me to enter. The application should be able to handle this math for you.
Also, when viewing an inventory receipt, each line item should list the line item total (not including the landed costs) so that you can quickly scan/compare the supplier’s invoice to the inventory receipt and see where there is a discrepancy in pricing.
Any thoughts on implementing this? The functionality exists when adding line items to a purchase order. Shouldn’t be a tall order to adapt and would save alot of time.
It’s a great suggestion, thank you. The difficulty is that there are (literally) over a thousand great ideas, but don’t worry, we’re working hard on them every day.
Votes are not the only factor in how we prioritise feature requests, but they are an important one. If this could pick up some more votes, that would really help, so if anyone else would like to see this, please give this thread a vote
Bumping this with the hope that more users are frustrated with having to manually calculate the UOM price each time a pricing adjustment needs to happen.
Good news, you can now enter either a total price or the UOM price when editing a PO or Inventory receipt line, not just when adding a new line
We’ve also added a new Item total cost column on both documents, which should make it easier to perform an at-a-glance comparison with the supplier’s invoice.
Thanks again for the suggestion, and we hope that helps!
