When a PV is fired on the Sub Account field in Journal Transactions and Valid Combinations are not turned on, the user is able to select the sub account segments in a multi-segment setup before the PV is checked against the SubXref table. If Multi-Company is configured it appears it will list the segments in the destination company.
What is the PV that shows the Segments and can it be modified?
*This post is locked for comments
Thanks - bummer to hear, but I appreciate the response!
Can't be done. You cannot get to the PV for this.
Hi Joe,
Did you ever figure this out? I'm trying to do the same thing.
Rich,
Thanks for the response. When validcombos is turned off on FlexDef for the subaccount when multiple segments are defined, the PV on the SUB field displays each segment for the user to select and build the subaccount prior to validating it against the subxref table. I am looking for the PV that does the display of the segments.
The PV is subxref_sub. You can modify, to some extent, standard PVs on a field by modifying the stored procedure and the PV text. You will find the PV text in the file called pvrec.csv located in the csvs folder under the DB folder of the Dynamics SL folder. I would recommend not directly editing pvrec.csv but, rather, copying the text line for that particular PV from that file and saving your edits of that line under another file name (e.g, subxref_sub.csv). You can overlay the standard PV with your modified one under Administration / Possible Values Import and pointing to your custom file name.
Also, the stored procedure in question is located in the system database, not the application database.
Share
Report
All responses (
Answers (
