Need help adding a GL account
Greetings, Just started looking at ofbiz. I created a blank system after a cleanAll with: ./gradlew "ofbiz --load-data readers=seed,seed-initial" loadAdminUserLogin -PuserLoginId=admin I then went in and created my main company via Party / Main / Create New Party Group. I am now trying to add a GL account. I am going to Accounting / Global GL Settings / Navigate Accounts. The label "Gl Account Id" has no field/control next to it. If I fill out the remainder of the fields and click "Add" it tells me missing parameter createGlAccount.glAccountId. I can't figure out how to put an Id there since there is no control / entry field. Sure appreciate any help. Blake McBride
Re: Need help adding a GL account
Hi Blake, For the accounting part in the mid term I'd recommend Sharan's book https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Related+Books Happy new year :) Jacques Le 30/12/2017 à 00:14, Blake McBride a écrit : Greetings, Just started looking at ofbiz. I created a blank system after a cleanAll with: ./gradlew "ofbiz --load-data readers=seed,seed-initial" loadAdminUserLogin -PuserLoginId=admin I then went in and created my main company via Party / Main / Create New Party Group. I am now trying to add a GL account. I am going to Accounting / Global GL Settings / Navigate Accounts. The label "Gl Account Id" has no field/control next to it. If I fill out the remainder of the fields and click "Add" it tells me missing parameter createGlAccount.glAccountId. I can't figure out how to put an Id there since there is no control / entry field. Sure appreciate any help. Blake McBride
Re: Need help adding a GL account
Thanks. It was already on order. Just hoped to get an answer before 1/12/18. On Sat, Dec 30, 2017 at 4:09 AM, Jacques Le Roux < jacques.le.r...@les7arts.com> wrote: > Hi Blake, > > For the accounting part in the mid term I'd recommend Sharan's book > > https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Related+Books > > Happy new year :) > > Jacques > > > > Le 30/12/2017 à 00:14, Blake McBride a écrit : > >> Greetings, >> >> Just started looking at ofbiz. I created a blank system after a cleanAll >> with: >> >> ./gradlew "ofbiz --load-data readers=seed,seed-initial" loadAdminUserLogin >> -PuserLoginId=admin >> >> I then went in and created my main company via Party / Main / Create New >> Party Group. >> >> I am now trying to add a GL account. I am going to Accounting / Global GL >> Settings / Navigate Accounts. The label "Gl Account Id" has no >> field/control next to it. If I fill out the remainder of the fields and >> click "Add" it tells me missing parameter createGlAccount.glAccountId. I >> can't figure out how to put an Id there since there is no control / entry >> field. >> >> Sure appreciate any help. >> >> Blake McBride >> >> >
Re: Need help adding a GL account
Hi Blake, So the screen is a bit confusing because it implies the ability to add an account when in fact it can only edit an existing account by clicking on it from the tree above the edit form. For now, you should create your account using XML data definitions. But perhaps it would be useful to add the ability to add new GL accounts from the user interface and fix the ambiguity in the form (like the add button). Needs some investigation and I'll look into it On Dec 30, 2017 1:20 PM, "Blake McBride" wrote: > Thanks. It was already on order. Just hoped to get an answer before > 1/12/18. > > On Sat, Dec 30, 2017 at 4:09 AM, Jacques Le Roux < > jacques.le.r...@les7arts.com> wrote: > > > Hi Blake, > > > > For the accounting part in the mid term I'd recommend Sharan's book > > > > https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Related+Books > > > > Happy new year :) > > > > Jacques > > > > > > > > Le 30/12/2017 à 00:14, Blake McBride a écrit : > > > >> Greetings, > >> > >> Just started looking at ofbiz. I created a blank system after a > cleanAll > >> with: > >> > >> ./gradlew "ofbiz --load-data readers=seed,seed-initial" > loadAdminUserLogin > >> -PuserLoginId=admin > >> > >> I then went in and created my main company via Party / Main / Create New > >> Party Group. > >> > >> I am now trying to add a GL account. I am going to Accounting / Global > GL > >> Settings / Navigate Accounts. The label "Gl Account Id" has no > >> field/control next to it. If I fill out the remainder of the fields and > >> click "Add" it tells me missing parameter createGlAccount.glAccountId. I > >> can't figure out how to put an Id there since there is no control / > entry > >> field. > >> > >> Sure appreciate any help. > >> > >> Blake McBride > >> > >> > > >
Re: Need help adding a GL account
Thanks! On Sat, Dec 30, 2017 at 4:40 AM, Taher Alkhateeb wrote: > Hi Blake, > > So the screen is a bit confusing because it implies the ability to add an > account when in fact it can only edit an existing account by clicking on it > from the tree above the edit form. For now, you should create your account > using XML data definitions. But perhaps it would be useful to add the > ability to add new GL accounts from the user interface and fix the > ambiguity in the form (like the add button). Needs some investigation and > I'll look into it > > On Dec 30, 2017 1:20 PM, "Blake McBride" wrote: > > > Thanks. It was already on order. Just hoped to get an answer before > > 1/12/18. > > > > On Sat, Dec 30, 2017 at 4:09 AM, Jacques Le Roux < > > jacques.le.r...@les7arts.com> wrote: > > > > > Hi Blake, > > > > > > For the accounting part in the mid term I'd recommend Sharan's book > > > > > > https://cwiki.apache.org/confluence/display/OFBIZ/OFBiz+Related+Books > > > > > > Happy new year :) > > > > > > Jacques > > > > > > > > > > > > Le 30/12/2017 à 00:14, Blake McBride a écrit : > > > > > >> Greetings, > > >> > > >> Just started looking at ofbiz. I created a blank system after a > > cleanAll > > >> with: > > >> > > >> ./gradlew "ofbiz --load-data readers=seed,seed-initial" > > loadAdminUserLogin > > >> -PuserLoginId=admin > > >> > > >> I then went in and created my main company via Party / Main / Create > New > > >> Party Group. > > >> > > >> I am now trying to add a GL account. I am going to Accounting / Global > > GL > > >> Settings / Navigate Accounts. The label "Gl Account Id" has no > > >> field/control next to it. If I fill out the remainder of the fields > and > > >> click "Add" it tells me missing parameter > createGlAccount.glAccountId. I > > >> can't figure out how to put an Id there since there is no control / > > entry > > >> field. > > >> > > >> Sure appreciate any help. > > >> > > >> Blake McBride > > >> > > >> > > > > > >
Re: Need help adding a GL account
Thanks a lot Mike, This is indeed the most used way (disclaimer: I did not check all details, the ideas are right) The UI is more to maintain things once properly set. You can use a similar way with Gradle in R17 and trunk but then plugins replaces hot-deploy and gradlew "ofbiz --load-data readers=mydata" replaces ./ant load-readers "-Ddata-readers=mydata" Refer to README.MD in OFBiz root for more Gradle information, also here https://cwiki.apache.org/confluence/display/OFBIZ/From+Ant+to+Gradle+-+R16.11+version HTH Jacques PS: and while at it, happy new year and best wishes to ALL :) Le 01/01/2018 à 22:03, Mike a écrit : The secret to "seeding" is the demo data. You MUST create custom seed files(s) that matches your requirements, up to and including the general ledger. Only after you have properly seeded your company can you think about adding an ecommerce store. The only practical way to do this is to create XML files that contains the data YOU need, because you WILL be loading it over and over again until you get it right. Forget about using the UI at this point...!! Just tweak the seed data until you get it right. How do you do this? Create a "hot-deploy" directory that contains your SEED data, which is loaded AFTER seed initial. Here is a clue: Clear the logs, and load the full demo. This is the order the demo data is loaded: /opt/apache-ofbiz-16.11.01/framework/security/data/PasswordSecurityDemoData.xml /opt/apache-ofbiz-16.11.01/framework/security/data/SecurityGroupDemoData.xml /opt/apache-ofbiz-16.11.01/framework/security/data/SecurityTypeDemoData.xml /opt/apache-ofbiz-16.11.01/framework/common/data/CommonSecurityGroupDemoData.xml /opt/apache-ofbiz-16.11.01/framework/service/data/ServiceSecurityGroupDemoData.xml /opt/apache-ofbiz-16.11.01/framework/service/data/ServiceDemoData.xml /opt/apache-ofbiz-16.11.01/framework/entityext/data/EntityExtSecurityGroupDemoData.xml /opt/apache-ofbiz-16.11.01/framework/webtools/data/WebtoolsSecurityGroupDemoData.xml /opt/apache-ofbiz-16.11.01/applications/party/data/PartySecurityGroupDemoData.xml /opt/apache-ofbiz-16.11.01/applications/party/data/PartyDemoData.xml /opt/apache-ofbiz-16.11.01/applications/securityext/data/UserDemoData.xml /opt/apache-ofbiz-16.11.01/applications/content/data/ContentSecurityGroupDemoData.xml /opt/apache-ofbiz-16.11.01/applications/content/data/UsersDemoData.xml /opt/apache-ofbiz-16.11.01/applications/content/data/DemoBlogPubPtData.xml /opt/apache-ofbiz-16.11.01/applications/content/data/DemoBlogUsersData.xml /opt/apache-ofbiz-16.11.01/applications/content/data/DemoBlogEntryData.xml /opt/apache-ofbiz-16.11.01/applications/content/data/WebSitePublishPointData.xml /opt/apache-ofbiz-16.11.01/applications/content/data/CompDocData.xml /opt/apache-ofbiz-16.11.01/applications/content/data/ForumDemoData.xml /opt/apache-ofbiz-16.11.01/applications/workeffort/data/WorkEffortSecurityGroupDemoData.xml /opt/apache-ofbiz-16.11.01/applications/workeffort/data/WorkEffortDemoData.xml /opt/apache-ofbiz-16.11.01/applications/product/data/ProductSecurityGroupDemoData.xml /opt/apache-ofbiz-16.11.01/applications/product/data/FacilitySecurityGroupDemoData.xml /opt/apache-ofbiz-16.11.01/applications/product/data/ProductDemoData.xml /opt/apache-ofbiz-16.11.01/applications/manufacturing/data/ManufacturingSecurityGroupDemoData.xml /opt/apache-ofbiz-16.11.01/applications/manufacturing/data/ManufacturingExampleData.xml /opt/apache-ofbiz-16.11.01/applications/accounting/data/AccountingSecurityGroupDemoData.xml /opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoGeneralChartOfAccounts.xml /opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoOrganizationData.xml /opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoGlSetupData.xml /opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoFinAccountData.xml /opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoTaxAuthority.xml /opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoAcctgTransactionData.xml /opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoPaymentsInvoices.xml /opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoAccountingUserData.xml /opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoAssetMaintData.xml /opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoBudgetData.xml /opt/apache-ofbiz-16.11.01/applications/humanres/data/HumanResSecurityGroupDemoData.xml /opt/apache-ofbiz-16.11.01/applications/humanres/data/HumanResDemoData.xml /opt/apache-ofbiz-16.11.01/applications/order/data/OrderSecurityGroupDemoData.xml /opt/apache-ofbiz-16.11.01/applications/order/data/OrderDemoUser.xml /opt/apache-ofbiz-16.11.01/applications/order/data/OrderDemoData.xml /opt/apache-ofbiz-16.11.01/applications/order/data/OrderQuoteDemoData.xml /opt/apache-ofbiz-16.11.01/applications/marketing/data/MarketingSecurityGroupDemoData.xml /opt/apache-ofbiz-16.11.01/applications/marketing/data/SfaSystemPropertyData.xml /opt/apache-ofbiz-16.11.01/
Re: Need help adding a GL account
The secret to "seeding" is the demo data. You MUST create custom seed files(s) that matches your requirements, up to and including the general ledger. Only after you have properly seeded your company can you think about adding an ecommerce store. The only practical way to do this is to create XML files that contains the data YOU need, because you WILL be loading it over and over again until you get it right. Forget about using the UI at this point...!! Just tweak the seed data until you get it right. How do you do this? Create a "hot-deploy" directory that contains your SEED data, which is loaded AFTER seed initial. Here is a clue: Clear the logs, and load the full demo. This is the order the demo data is loaded: /opt/apache-ofbiz-16.11.01/framework/security/data/PasswordSecurityDemoData.xml /opt/apache-ofbiz-16.11.01/framework/security/data/SecurityGroupDemoData.xml /opt/apache-ofbiz-16.11.01/framework/security/data/SecurityTypeDemoData.xml /opt/apache-ofbiz-16.11.01/framework/common/data/CommonSecurityGroupDemoData.xml /opt/apache-ofbiz-16.11.01/framework/service/data/ServiceSecurityGroupDemoData.xml /opt/apache-ofbiz-16.11.01/framework/service/data/ServiceDemoData.xml /opt/apache-ofbiz-16.11.01/framework/entityext/data/EntityExtSecurityGroupDemoData.xml /opt/apache-ofbiz-16.11.01/framework/webtools/data/WebtoolsSecurityGroupDemoData.xml /opt/apache-ofbiz-16.11.01/applications/party/data/PartySecurityGroupDemoData.xml /opt/apache-ofbiz-16.11.01/applications/party/data/PartyDemoData.xml /opt/apache-ofbiz-16.11.01/applications/securityext/data/UserDemoData.xml /opt/apache-ofbiz-16.11.01/applications/content/data/ContentSecurityGroupDemoData.xml /opt/apache-ofbiz-16.11.01/applications/content/data/UsersDemoData.xml /opt/apache-ofbiz-16.11.01/applications/content/data/DemoBlogPubPtData.xml /opt/apache-ofbiz-16.11.01/applications/content/data/DemoBlogUsersData.xml /opt/apache-ofbiz-16.11.01/applications/content/data/DemoBlogEntryData.xml /opt/apache-ofbiz-16.11.01/applications/content/data/WebSitePublishPointData.xml /opt/apache-ofbiz-16.11.01/applications/content/data/CompDocData.xml /opt/apache-ofbiz-16.11.01/applications/content/data/ForumDemoData.xml /opt/apache-ofbiz-16.11.01/applications/workeffort/data/WorkEffortSecurityGroupDemoData.xml /opt/apache-ofbiz-16.11.01/applications/workeffort/data/WorkEffortDemoData.xml /opt/apache-ofbiz-16.11.01/applications/product/data/ProductSecurityGroupDemoData.xml /opt/apache-ofbiz-16.11.01/applications/product/data/FacilitySecurityGroupDemoData.xml /opt/apache-ofbiz-16.11.01/applications/product/data/ProductDemoData.xml /opt/apache-ofbiz-16.11.01/applications/manufacturing/data/ManufacturingSecurityGroupDemoData.xml /opt/apache-ofbiz-16.11.01/applications/manufacturing/data/ManufacturingExampleData.xml /opt/apache-ofbiz-16.11.01/applications/accounting/data/AccountingSecurityGroupDemoData.xml /opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoGeneralChartOfAccounts.xml /opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoOrganizationData.xml /opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoGlSetupData.xml /opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoFinAccountData.xml /opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoTaxAuthority.xml /opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoAcctgTransactionData.xml /opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoPaymentsInvoices.xml /opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoAccountingUserData.xml /opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoAssetMaintData.xml /opt/apache-ofbiz-16.11.01/applications/accounting/data/DemoBudgetData.xml /opt/apache-ofbiz-16.11.01/applications/humanres/data/HumanResSecurityGroupDemoData.xml /opt/apache-ofbiz-16.11.01/applications/humanres/data/HumanResDemoData.xml /opt/apache-ofbiz-16.11.01/applications/order/data/OrderSecurityGroupDemoData.xml /opt/apache-ofbiz-16.11.01/applications/order/data/OrderDemoUser.xml /opt/apache-ofbiz-16.11.01/applications/order/data/OrderDemoData.xml /opt/apache-ofbiz-16.11.01/applications/order/data/OrderQuoteDemoData.xml /opt/apache-ofbiz-16.11.01/applications/marketing/data/MarketingSecurityGroupDemoData.xml /opt/apache-ofbiz-16.11.01/applications/marketing/data/SfaSystemPropertyData.xml /opt/apache-ofbiz-16.11.01/applications/marketing/data/sfaDemoData.xml /opt/apache-ofbiz-16.11.01/applications/commonext/data/CommonExtSecurityGroupDemoData.xml /opt/apache-ofbiz-16.11.01/applications/commonext/data/OfbizSetupSecurityGroupDemoData.xml [end of core company] /opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoProduct.xml /opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoSurvey.xml /opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoRentalShipping.xml /opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoShipping.xml /opt/apache-ofbiz-16.11.01/specialpurpose/ecommerce/data/DemoWebSitePublishPointData.xml /opt/apache-
Re: Need help adding a GL account
Hi Blake I've only just seen this message. You can create your chart of accounts with an blank OFBiz install and seed data. Please see below for some documentation that myself and Craig Parker are working on that should help you. Note that even though the screen says it is in 'Edit mode' it is actually in Add mode so will add new accounts. I've included some instructions of how to setup the basic 5 main account types below: Thanks Sharan - So the first step we need to do is create a Chart of Account Master template in OFBIz. -Select âAccountingâ from the Applications drop down menu -Select âGlobal GL Settingsâ from the Accounting Manager drop down menu (Default screen should be a blank chart of accounts) -Click the âNavigate Accountsâ button An 'Edit GL Account' window will be displayed and the default is Add Mode. Create the main Assets account: -Select âNot Applicableâ for GL Account Type Id -Select âAssetâ for GL Account Class Id -Select âMoneyâ for GL Resource Type Id -Enter âASSETSâ in GL Account Code (NOTE: You might want to give this a code. Using a code will help you structure the account hierarchy in the order you want it to be displayed. Using text defaults to alphabetical order) -Enter âAssetsâ in Account Name -Click âAddâ Create the Liabilities main account Make sure you are still in Add mode or Click âNavigate Accountsâ again (NOTE: If you do a change and you are in update mode, it will update the account that you were previously working on rather than create a new one!) -Select âNot Applicableâ for GL Account Type Id -Select âLiabilityâ for GL Account Class Id -Select âMoneyâ for GL Resource Type Id -Enter âLIABILITIESâ in GL Account Code -Enter âLiabilitiesâ in Account Name -Click âAddâ Create the Owner Equities main account Make sure you are still in Add Mode or Click âNavigate Accountsâ again -Select âNot Applicableâ for GL Account Type Id -Select âEquityâ for GL Account Class Id -Select âMoneyâ for GL Resource Type Id -Enter âOWNER EQUITIESâ in GL Account Code -Enter âOwner Equitiesâ in Account Name -Click âAddâ Create the Revenues main account Make sure you are still in Add Mode or Click âNavigate Accountsâ again -Select âNot Applicableâ for GL Account Type Id -Select âRevenueâ for GL Account Class Id -Select âMoneyâ for GL Resource Type Id -Enter âREVENUESâ in GL Account Code -Enter âRevenuesâ in Account Name -Click âAddâ Create the Administrative Expenses main account Make sure you are still in Add Mode or Click âNavigate Accountsâ again -Select âNot Applicableâ for GL Account Type Id -Select âSelling, General or Administrative Expenseâ for GL Account Class Id -Select âMoneyâ for GL Resource Type Id -Enter âADMINISTRATIVE EXPENSESâ in GL Account Code -Enter âAdministrative Expensesâ in Account Name -Click âAddâ On 2017-12-30 00:14, Blake McBride wrote: > Greetings, > > Just started looking at ofbiz. I created a blank system after a cleanAll > with: > > ./gradlew "ofbiz --load-data readers=seed,seed-initial" loadAdminUserLogin > -PuserLoginId=admin > > I then went in and created my main company via Party / Main / Create New > Party Group. > > I am now trying to add a GL account. I am going to Accounting / Global GL > Settings / Navigate Accounts. The label "Gl Account Id" has no > field/control next to it. If I fill out the remainder of the fields and > click "Add" it tells me missing parameter createGlAccount.glAccountId. I > can't figure out how to put an Id there since there is no control / entry > field. > > Sure appreciate any help. > > Blake McBride >