How do you add a search to form? (Purchase Receipts)
When entering payables (bills to be paid) there is a lovely search box that you can type in an order number and it pulls in any transactions matching that PO.
Unfortunately, the purchase receipts screen is not the same can be a nightmare (especially for those that have multiple warehouses).
You have the option to use the small search functions within each section (i.e. “Type” “Order Nbr.” “Date” “Status” etc. – see below), however, the problem with using those is that the search history stays for the next purchase receipt you do and therefore the purchase receipt screen comes in completely blank.
Ultimately, we need the same search box needs to be available within the Purchase Receipts screen as in the Bills and Adjustments screen.
Are there any guides on how I might be able to add this search bar to the “Add Purchase Order” screen?
Page 1 / 1
There actually already is a field for the Order Number on the POOrderFilter view. You should be able to add that via a customization project. Make sure to set CommitChanges to true so the view will update when you select an order number.
Once you have that in you will need to create a graph extension to modify the view to filter based on the order number. It’s quite a lot of BQL but essentially all I did below was add an And2 clause that filters the POOrder by the order number if it is not blank.
public class POReceiptEntryExt : PXGraphExtension<POReceiptEntry> { public static bool IsActive() => true;
Here is a simple way to fix your issue by setting up AutoReload = True to Add Purchase Order Dialog box.
@mtreske1 Forgot to mention you need to set AutoRepaint = False, follow the below steps you will achieve your requirement.
Create Customization
Add Existing Screen - PO302000
Select Dialogs - Add Purchase Order
Set AutoReload = True
Set AutoRepaint = False (By default, it will be set to true)
Select Grid - openOrders
Set AllowFilter = True
FastFilterFields = OrderNbr (you can add other fields as well)
Publish the customization
You should be able to see search text box under the gird to filter the records based on the order nbr.
AutoReload property is the key here to reloads and clears the caches in the dialog box every time you open it.
Quick test:
Happy Coding!
Outstanding. I can’t thank you all enough for the responses. This is going to make our lives 100x easier as we continue to integrate more companies and warehouses into our system.
Hopefully Matt understands this more than I do (I’m not a coder), however, I can tell you that last screenshot I see via @Vinay K is literally exactly what I was asking Matt to see if it was possible.
Outstanding. I can’t thank you all enough for the responses. This is going to make our lives 100x easier as we continue to integrate more companies and warehouses into our system.
Hopefully Matt understands this more than I do (I’m not a coder), however, I can tell you that last screenshot I see via @Vinay K is literally exactly what I was asking Matt to see if it was possible.
Thank you @ptreske76 !
Thank you so much to both of you for the completely thorough responses. I was just hoping to get a bit of direction and to know whether or not it was even possible. I will give this a go and update with the results. This is fantastic.
@mtreske1 you are most welcome! will appreciate your feedback.
@mtreske1 you are most welcome! will appreciate your feedback.
I know that I’m really late on responding to this, but this solution worked well in our environment. Thank you again.