Skip to main content
Answer

How to reference the field 'UserPreferences.DefaultSite' in a customization

  • July 17, 2025
  • 4 replies
  • 57 views
lauraj46
Captain II
Forum|alt.badge.img+8

Acumatica customization gurus, is it possible to reference the UserPreferences.DefaultSite field in an event?  Code snippet is below, but I’m receiving the error ‘UserPreferences’ does not include a definition for ‘DefaultSite’.   The field does exist in the SQL table in my local test environment.  Thanks in advance!

 

            var line = e.Row;
            var currentUserID = PXAccess.GetUserID();


            UserPreferences prefs = PXSelect<UserPreferences,
                Where<UserPreferences.userID, Equal<Required<UserPreferences.userID>>>>
                .Select(Base, currentUserID);

            if (prefs?.DefaultSite != null)
            {
                line.SiteID = prefs.DefaultSite;
            }

 

 

Best answer by MichaelShirk

Hey ​@lauraj46 the DefaultSite field is actually defined in a DAC extension, not in the base, UserPreferences DAC. 

See this example where I needed to default a field value to the current user’s default site. 
The DefaultSite field is defined in UserPreferenceExt. 

 

            [PXDefault(typeof(SelectFrom<INSite>
                .LeftJoin<UserPreferences>
                .On<UserPreferenceExt.defaultSite.IsEqual<INSite.siteID>>
                .Where<UserPreferences.userID.IsEqual<AccessInfo.userID.FromCurrent>>),
                PersistingCheck = PXPersistingCheck.Nothing)]

 

This should work for you (using Fluent BQL). 

 


var line = e.Row;
var currentUserID = PXAccess.GetUserID();

var userPref = SelectFrom<UserPreferences>
    .Where<UserPreferences.userID.IsEqual<@P.AsGuid>>
    .View.ReadOnly.Select(Base, currentUserID)
    ?.GetExtension<UserPreferenceExt>();

if (userPref?.DefaultSite != null)
{
    line.SiteID = userPref.DefaultSite;
}

 

 

Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.

4 replies

MichaelShirk
Captain II
Forum|alt.badge.img+5
  • MichaelShirk
  • Captain II
  • Answer
  • July 17, 2025

Hey ​@lauraj46 the DefaultSite field is actually defined in a DAC extension, not in the base, UserPreferences DAC. 

See this example where I needed to default a field value to the current user’s default site. 
The DefaultSite field is defined in UserPreferenceExt. 

 

            [PXDefault(typeof(SelectFrom<INSite>
                .LeftJoin<UserPreferences>
                .On<UserPreferenceExt.defaultSite.IsEqual<INSite.siteID>>
                .Where<UserPreferences.userID.IsEqual<AccessInfo.userID.FromCurrent>>),
                PersistingCheck = PXPersistingCheck.Nothing)]

 

This should work for you (using Fluent BQL). 

 


var line = e.Row;
var currentUserID = PXAccess.GetUserID();

var userPref = SelectFrom<UserPreferences>
    .Where<UserPreferences.userID.IsEqual<@P.AsGuid>>
    .View.ReadOnly.Select(Base, currentUserID)
    ?.GetExtension<UserPreferenceExt>();

if (userPref?.DefaultSite != null)
{
    line.SiteID = userPref.DefaultSite;
}

 

 

Michael Shirk, Pine View Buildings, LLC - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
lauraj46
darylbowman
Chris Hackett
darylbowman
Captain II
Forum|alt.badge.img+15

...the DefaultSite field is actually defined in a DAC extension...

 

The DAC Schema Browser actually indicates this with [Customized]:

Futhermore, if you click on the [Customized] box, it will open a dialog with information about the customization.

Daryl ⚡Freelance Acumatica Developer (MVP🏆) for hire ⏩ linkedin.com/in/darylbowman
lauraj46
Chris Hackett
DipakNilkanth
Pro III
Forum|alt.badge.img+13

Hi ​@lauraj46,

DefaultSiteID is declared under UserPreferenceExt (PX.Objects.dll) ,not in UserPreference DAC.

You can use below code snippet to achieve the same.

var line = e.Row;
var currentUserID = PXAccess.GetUserID();

// Get the UserPreferences record
UserPreferences prefs = PXSelect<UserPreferences,
    Where<UserPreferences.userID, Equal<Required<UserPreferences.userID>>>>
    .Select(Base, currentUserID);

if (prefs != null)
{
    // Access the extension
    var ext = PXCache<UserPreferences>.GetExtension<UserPreferenceExt>(prefs);

    if (ext?.DefaultSite != null)
    {
        line.SiteID = ext.DefaultSite;
    }
}

Hope, it helps!

Dipak Nilkanth || MVP @2025 || https://www.linkedin.com/in/dipak-nilkanth-293591102 || Acumatica Developer
lauraj46
lauraj46
Captain II
Forum|alt.badge.img+8
  • lauraj46
  • Author
  • Captain II
  • July 18, 2025

Thank you ​@MichaelShirk , ​@darylbowman and ​@Nilkanth Dipak for the help!  This all makes sense and worked perfectly.  This community is the best.

Laura  

Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Chris Hackett
Terms & ConditionsCookie settingsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved