You’re offline. This is a read only version of the page.
User enters the Account Category to the active account number on the chart of Accounts maintenance screen.
But when I run the query against "Account" table, there is no data in the Acct_cat field. Others are showing no problem.
Any help will be highly appreciated.
*This post is locked for comments
Okay... found a workaround way to produce the data N-- needs to go to Accounts maintenance screen > check the Require employee and Require units boxes > Save to produce "Y" in the pj_account table > uncheck 2 boxes and save > to change from "Y" to "N" .
it looks like the program has been changed, I think it used to be default as "N" and it is blank .... MSFT might need to check into this.
I found out the front end screen is pulling from a different table ( pj_account) for the Account Category in the Accounts Maintenance Screen.
It looks like if we need to populate the Category on the frontend , the employ_sw and Units_sw need to entered as N. But where can I populate the data with N?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (