Epicor version 9.05.701
I’ve had a request to put a field onto the below to say if the part is active or not.
The table/field is part.inactve and is simply a checkbox
I was just wondering what the steps are to bring this in as a customisation?
Many thanks in advance…
Which item would it be from the toolbox?
I thought it maybe the EpiRetrieverCombo but it doesn’t have much behind the “part section”.
The user has now changed his mind and wants the “inactve” just displaying on the PARTS/LIST tab as per screenshot.
I’ve done a personalisation to see if the field is just not visible…but its not there to unhide.
There is a Partview dataView available in the list of dataviews. Try to add a checkbox and bind it to the PartView.Inactive field ?
Make sure it is readonly …
Pierre
Thank you Pierre,
I’ve done as you said but the “Data read only” is greyed out and i cannot type True in this field.
When i tested it, its not working - so i think there is something missing on properties section displayed below.
On the left is the part entry screen where it shows the part is inactive, but it doesn’t match on the new field in supplier price list.
In the properties section on the customisation I did change the field “Enabled” to False and this stopped the field being edited. (This is under “misc” in the screenshot above)
For some reason the Partview doesn’t actually contain any data, so you don’t get a value. You could create another view with Data Tools from the Actions menu in the Customization screen, but that will probably impact the performance of this UI pretty dramatically.
Another way would be to run a trace when you retrieve the parts for a supplier to see which method is used, then you can use one of the setters (probably set by query) to lookup the data and set it to the partView fields.
This could become a problem again the the future if Epicor either corrects the partView or removes it.
You can use the extended properties from the wizards to add the readonly…My concern is that the info is not showing the same as the part itself…
I would follow Rick suggestion as you can add a foreign Key to Part (need to close the forms, then go back in order to have access to it then assign the field to your checkbox…)
Performance is acceptable… tested ok,
Pierre
Thank you.
I haven’t done this level of customisation. Is there an idiot’s walk through (step by step) on how to achieve what i need?
Under tools/DataTools
Under Foreign Key View create a new custom view
As a name use one of your choice
Parent view name select venPartView
Column name choose PartNum …the rest gets populated… click Add.
Close the form, close the supplier form.
Reopen them and add your binding to the checkbox, the view should be available….
Save all and test with known inactive parts….see if all ok.
That my friend is awesome and i can’t thank you enough!!!
Ok last part of the jigsaw…how do i get it into the LIST tab in supplier price list?
Look at this video
made by Jose!
