Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Suggested answer

Sub Account SegDef PV

Posted on by Microsoft Employee

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?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sub Account SegDef PV

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sub Account SegDef PV

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sub Account SegDef PV

    Hi Joe,

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sub Account SegDef PV

    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.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sub Account SegDef PV

    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.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans