Hi
I have the following scenario.
Goods are ordered via a purchase order and receipted.
When they are billed through a vendor bill, sometimes the quantity for each line is equal to the original purchase order quantity for that line (i.e. the bill for that line is in full) while other times, it is only a bill for part of the quantity.
For example, the purchase order line for good A is for a quantity of 5.
1 quantity of good A has been receipted.
The vendor bill is for a quantity of 5 for that line for good A..
Another line on the PO might be for a quantity of 1 for good B.
0 have been received for that line for good B.
0 has been billed for that line for good B.
Is there a way to get the details of the original PO (what was ordered for that good and for that line) and what was receipted (from the item receipt record) on to the vendor bill?
Is it possible to do this by creating a custom transaction line field populated by a saved search or a script? The field would be on the vendor bill record.
That level of detail is available on the purchase order, per the screencap above, making me think there must be a a "common key" for each line between the item receipt record; the purchase order record and the vendor bill record.
If it is possible to do this, where can I find what the common key is between the three record types and for each line?
Thanks