Skip to main content
Solved

Tie an AP bill to an SO Shipment

  • September 30, 2021
  • 2 replies
  • 153 views

We are trying to link the invoice we get from the shipper to the corresponding shipment.  My goal is to evaluate our shipping charges.  The way I envision it working is add a field when entering lines on an AP Bill where I can choose the appropriate shipment.  I’m sure this has been encountered many times so how do recommend solving the problem?  Thanks

Best answer by markusray17

If you want to link the line on the AP Bill to the line on the Shipment you would need to add two custom fields: ShipmentNbr, and ShipmentLineNbr. And then you could create an action similar to the PO Link action on Sales Orders to actually select the shipment line and fill in the custom fields. 

 

If you just want to link it to a shipment as whole(not the line) you could just add a custom field to the AP Bill line with a selector for shipments containing the item. This could be simpler depending on the validation requirements. 

2 replies

Forum|alt.badge.img+5
  • Jr Varsity II
  • 237 replies
  • Answer
  • October 1, 2021

If you want to link the line on the AP Bill to the line on the Shipment you would need to add two custom fields: ShipmentNbr, and ShipmentLineNbr. And then you could create an action similar to the PO Link action on Sales Orders to actually select the shipment line and fill in the custom fields. 

 

If you just want to link it to a shipment as whole(not the line) you could just add a custom field to the AP Bill line with a selector for shipments containing the item. This could be simpler depending on the validation requirements. 


Forum|alt.badge.img+1
  • 151 replies
  • June 28, 2023

@bhalvorsen did you get this going?