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

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) / New Account doesn´...
Microsoft Dynamics SL (Archived)

New Account doesn´t show on F3-GL detail

(0) ShareShare
ReportReport
Posted on by Community Member

SL 7. I just close year 2011. After that a create a new account and  it is "Active". but when i try to do a new gl detail it doesn't show on the F3 pop up  list.  What could i be missing?

thanks

Carlos
Produce Business

*This post is locked for comments

I have the same question (0)
  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien Microsoft Employee on at

    Hi Carlos,

    Are you trying to find the account in the Journal Transactions screen?  When you F3 in that screen, which PV list shows?  Is it the Master Account List or is it Account List?  If it is Account List, then you have Validate Account Subaccount checked in GL Setup.  Since you have that option checked, you would need to set up Account/Subaccount combinations so that it will show in the PV list.

    Please let me know which PV comes up when you F3 in the Journal Transactions screen.  Thanks.

  • Community Member Profile Picture
    Community Member on at

    Hello Carolyn. It's the 01.010.00 journal transactions screen.  In the detail area. the F3 shows the gltran.acct Field. The PV sows "acctxref_acct", "bcompany.cpnycoa"; 0; 0; 0; 0,  The Validate accoutnt Subaccount is unchecked.  5 days after i posted this, the account showed, What i did was to print preview a Trial Balance and a Detail General ledger report.  .  Is there a proceess between the Account List and the Master Account List?  Where can i see them on SQL?

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien Microsoft Employee on at

    Hello Xcarlos,

    If you validate account subaccount combinations in GL Setup, you will see the Account List.  If you do not, you will see the Master Account List.

    When you added the account, did you use the Chart of Accounts Maintenance screen?  Or did you use another process?  When you add an account in Chart of Accounts maintenance, it should update the Account table in the application database, and the AcctXref table in the system database.  Depending on your authentication method, it will also update some views in the application database.   If the account isn't in the Acctxref table in the system database, it won't show in the PV list in the Journal Transactions screen.  If you find it is missing from Acctxref, usually you just need to make a small change in the Chart of Accounts maintenance screen, save the change, then undo that change and save again.  The Acctxref table should be refreshed.

    Does this answer your question?

  • Community Member Profile Picture
    Community Member on at

    Hi Carolyn - I am running into the same issue and I tried all the solutions you mentioned above.  I also rebuild the triggers, etc and I still can't see the account.  I also checked in standard mode given I know the JE screen is customized.  Any other ideas?  (PS. we are NOT using acct/sub validation and the PV is the master COA; we added the account to the master company in the COA maintenance screen).  Thanks for any help!

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien Microsoft Employee on at

    Hi LBrewster,

    Are you in a SQL or Windows Authenticated database?  Maybe check the following tables in SQL Server Management Studio and see in which table/view the account is missing:

    Application Database:

    Select * from account where acct = 'xxxx'

    Select * from vs_acctxref where acct = 'xxxx'

    System Database:

    Select * from acctxref where acct = 'xxxx'

    Make sure the account is Active.  

    Let me know what you find.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Guess what - I found it.  There was a company in the domain table that didn't exist in the company table.  Once I got rid of it (this company was never used) and rebuilt triggers, and then edited the COA table, saved and changed it back and saved again - I could see the new accounts in the PV again.  Kind of a bummer Microsoft is still charging me for the incident even though they didn't figure it out...

  • Suggested answer
    wahoo Profile Picture
    wahoo 275 on at

    Just ran into this problem and Carolyn's suggestion worked for me .

    "Depending on your authentication method, it will also update some views in the application database.   If the account isn't in the Acctxref table in the system database, it won't show in the PV list in the Journal Transactions screen.  If you find it is missing from Acctxref, usually you just need to make a small change in the Chart of Accounts maintenance screen, save the change, then undo that change and save again.  The Acctxref table should be refreshed."

    Thanks!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February 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