Our client is using an external shipping calculation for Sales. Specifically EasyPost. There are a number of Ship Via codes they will use for Sales. At the same time they want to be able to use a different set of Ship Via codes on Purchase Orders. Right now in both Sales Orders and Purchase Orders you see the same set of Ship Via Codes. Is there any way to limit which are seen based on the document type?
My suggestion is to add two checkboxes in the Ship Via screen, “Visible in SOs” and “Visible in POs” and to then override the ShipVia field attributes in the respective screen to filter on that field by adding a Where<> clause to the selector attribute:
Do you have anyone in-house that is trained on the Acumatica platform and customization tools?
Hi
Option 1: It could be customized with the below approach which will provide the desired results.
- Adding a new Checkbox “Visibility” dropdown Value PO or SO or Both.” in Shipvia Screen. This will configurable.
- Sales Order Screen Customization : Change the PXSelector code on the Ship Via lookup in the Sales Order by including the new dropdown “Visibility” value (SO or Both) in the where Condition.
- Purchase Order Screen Customization : Change the PXSelector code on the Ship Via lookup in the Purchase Order by including the new dropdown “Visibility” value (PO or Both) in the where Condition.
Thanks for the suggestion...and yes we have someone in house that can do this.
Hi
Hi
Here is the option 2 without any customization. But, the suitability of this workaround depends on the business use case.
Option 2 : Workaround without any customization. Please review and analyze if this fits for you.
Assumption: Setting default Ship VIa in the Customers Screen and Vendors Screen works.
Default the Ship Via in Sales Order based on the Customer Settings.
- Set the defaults Ship via at the customers screen based on the suitable Shipvia for each customer
- If required, restrict the access to the Shipvia Selector in SO Screen
Default the Ship Via in Purchase Order based on the Vendor Settings.
- Set the defaults Ship via at the Vendors screen based on the suitable Shipvia for each Vendor.
- If required, restrict the access to the Shipvia Selector in PO Screen
Thanks
I’m newer to the customization projects. I was able to add in the checkbox for Visibility like you suggested. Could you provide more screenshots for the WHERE clause in the PXSelector area?
Thanks!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.