Tracking different shipper quantity vs invoiced quantity

[barbola]

We purchase several products by weight. We pay the invoice based on Invoiced quantity, but we also want to track the shipper's quantity (weight).

I tried receiving one quantity and invoice/matching using a different quantity, but we can't match MORE than what was received, only less. I can't find anywhere to record the two separate amounts.

We do not want the unit price to change but either amount in inventory is fine, preferably shipped weight.

Does anyone know a way around this? We do not have VBA modifier.

 

[jazgeek]

you can invoice more than the quantity on the purchase order by not actually matching against any receipt

just enter the part number and overquantity amount as a seperate line on your invoice match

you may have to set the allow receiving without a purchase order flag in purchase order processing setup.





-----------
and they wonder why they call it Great Pains!

jaz

 

[barbola]

I still get the error "One or more line items are not fully matched".

I have no PO on the second line and no RCT to match to, just the Item Number and the over-quantity amount, and it will not post. There is a "caution" flag in the RCT matched field.

I have "allow receiving without a purchase order" checked in the setup.

I'm thinking I may need to receive the shipper's weight to one site ID and then do an adjustment for the invoiced quantity to a secondary site...unless there is another way to track both quantities, even a comment field somewhere in SQL. I looked at the user-defined fields, but they are only string and date fields...and not line specific.