web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Sub Account SegDef PV
Microsoft Dynamics SL (Archived)

Sub Account SegDef PV

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    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.

  • Community Member Profile Picture
    Community Member on at

    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.

  • Community Member Profile Picture
    Community Member on at

    Hi Joe,

    Did you ever figure this out?  I'm trying to do the same thing.

  • Community Member Profile Picture
    Community Member on at

    Can't be done. You cannot get to the PV for this.

  • Community Member Profile Picture
    Community Member on at

    Thanks  - bummer to hear, but I appreciate the response!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans