Skip to main content
Solved

Tie an AP bill to an SO Shipment

  • 30 September 2021
  • 2 replies
  • 131 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. 

View original
Did this topic help you find an answer to your question?

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

@bhalvorsen did you get this going?


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings