BLOG

NEXT STEPS

Archive for the ‘HotWax Media’ Category

OFBiz Tutorial: Assign GlAccount to Organization

Wednesday, January 5th, 2011

Building off my last OFBiz tutorial, I will demonstrate how to Assign GlAccount to Internal Organization. Its an act of defining the Chart Of Accounts (CoA) for given internal organization. The same GlAccount can be assigned to one or more then one internal organizations. For example, the global CoA may contain 100 different GlAccounts but only 20 need to be used for your specific business. This means you need to only create assignments for GlAccounts you actively want to use.

Go to the “Accounting Manager” application and click on the “ Organization Gl Settings ” Menu.

Ofbiz-tutorial-Organization-1

List of avialable Internal Organization will be displayed. To manage Internal Organization accounting setup, click on Setup button. On the next screen select Chart of Accounts tab.

ofbiz-tutorial-Organization-2

To assign GlAccount, select GlAccount from drop down and just click on create assignment tab.

ofbiz-tutorial-Organization-3

The bottom part of screen shows all GlAccounts assigned to the internal organization.

ofbiz-tutorial-Organization-4

Stay tuned, for upcoming Ofbiz tutorials to learn how you can use open source ERP for managing your business.

- Anil

Anil Patel is Chief Development Officer at HotWax Media as well as an OFBiz project committer, PMC member, and active community contributor. He also studies karate! Anil will join other HotWax Media employees and advisors in periodically posting thoughts here related to OFBiz, eCommerce, ERP, and related topics.

2010 Sign Off From HotWax Media

Friday, December 31st, 2010

enterprise-ecommerce-new-year

As we reach the end of 2010 I find myself spending a little bit of extra time reflecting on the past 12 months, and wanted to share some thoughts.

First of all, we’re extremely lucky to have an incredible staff of people positioned all around the world who work passionately day and night, quite literally. It’s these inspired individuals who consistently generate quality enterprise ecommerce business solutions that ensure HotWax Media will always deliver on the assurances we make. To every one of you who came up with an innovative solution to a problem we were facing, worked through the night to hit a deadline, set your alarm for 3AM to get up for a conference call with someone on the other side of the world, or just put your heart into delivering the best, highest quality work you could, I thank you. I am proud of the dedication and continuous improvement we represent together as a team.

We work hard to deliver top shelf solutions for our customers, and HotWax Media is fortunate to have been involved with so many great companies, in so many exceptional projects this past year. On behalf of everyone in the company I would like to say thank you to the many outstanding organizations and extraordinary people we’ve worked with this year. From Scarpa North America and Black Diamond Equipment to Anytime Costumes, ALX, TWP, High West, Champion, and others (you know who you are), we appreciate the opportunity to work with you and your organizations. The great personal relationships we forge through our business associations are a tremendous incentive to keep our partnerships not only professional, but also enjoyable for both sides. It’s all about the bottom line, and we continue to have a great time getting there.

As we look forward, I’m thrilled to think about everything HotWax Media has on the horizon for 2011. In a matter of days we’ll launch a full ecommerce web store called PrepareWise.com, which features Wise Foods food storage products, and there are similar projects lined up and in development through 2011. We have another large product deployment as well during the first week in January, and the work load looks to be hot and heavy throughout the year. When one enjoys what he does — and we do — it’s great to be busy and in demand. For that I am very thankful.

Our commitment is to continue to deliver the best enterprise ecommerce solutions available today at prices that make a preacher want to kick out a stained glass window. That’s what we do, and I think most anyone we’ve encountered along the way can confirm the fact that we love doing it.

I wish you all health and happiness going into the tweens. Happy New Year, and here’s to an amazing, fulfilling, prosperous 2011!

Mike Bates is CEO at HotWax Media and will join other HotWax Media employees and advisers in periodically posting thoughts here related to OFBiz, eCommerce, ERP, and related topics.
Mike Bates - OFBiz Expert

OFBiz Tutorial: Associating Product with Multiple Categories

Wednesday, December 8th, 2010

Building off of other OFBiz catalog manager tutorials that have been posted earlier, today we will look into how you can associate a product with multiple categories.  This will be broken down into two sections: adding a product into a category, and then updating the product category association.

Add Product to a Category

Let’s first talk about prerequisite for managing this part of the catalog:

The user must at least have the role of catalog manager.  There are other roles that they can have that encompass catalog management, but they must have the ability to go here and manage this content.

The data must be setup so that the product’s association type is modeled correctly in the system.  Basically what this is saying is that some association types, while they may look like they would fit in here, will not have the product show up correctly on the front end if you do not do this properly.

Now that we know that – let’s discuss associating a product with a category.

Go to the “Catalog” component and click on the “Advanced Search” Button within “Search Products”.

ofbiz-tutorial-cross-sell-1

Fill in the search values on the “Find” screen and click on the “Find” button.

Ofbiz Tutorial Cross Sell 2

A list of products will be displayed based on the search criterion.

Ofbiz Tutorial Cross Sell 3

Click on any of the products and the “Edit Product” page of the selected product will get displayed.

Ofbiz Tutorial Cross Sell 4

Click on the “Categories” tab.

categories-tab

Fill in the following details in the “Add Category for this Product” form :
category-look-up

  1. Category
    • Select “Category” from look up which contains following information :
      • Product category Type Id
      • Primary Parent Category Id
      • Category Name
      • Description
      • Show In Select
  2. From Date
  3. To Date
  4. Comments
  5. Sequence Number
  6. Quantity

category-fields

Click on the “Add” button after entering the information.

add-button

At this point the added “Category” will be displayed in “Categories” section with the following details:

  • Category
  • From Date
  • To Date
  • Comments
  • Sequence Number
  • Quantity

categories-section

Update Product Category Association

Now that you can add product to a category, let’s discuss how you can edit this information in OFBiz. The prerequisites are exactly the same as for adding product to a category except to edit it, you need to have the product associated with a category.

Here are the steps for updating the product category association:

Go to the “Catalog” component and click on the “Advanced Search” Button within “Search Products”.

ofbiz-tutorial-cross-sell-1

Fill in the search values on the “Find” screen and click on the “Find” button.

Ofbiz Tutorial Cross Sell 2

A list of the products will be displayed based on the search criterion.

Ofbiz Tutorial Cross Sell 3

Click on any of products and the “Edit Product” page of the selected product will get displayed.

Ofbiz Tutorial Cross Sell 4

Click on the “Categories” tab.
categories-tab

Following details will be displayed in “Categories” section of added category:

  • Category
  • From Date
  • To Date
  • Comments
  • Sequence Number
  • Quantity

categories-section

Update existing category details.

category-update

Click on the “Update” button to save the details.

ofbiz-tutorial-cross-sell-11a

Use the “Delete” button to delete the category association – if necessary.

delete-button

Now your updated category details will be displayed on the “Categories” section of “Category Members” page.

More OFBiz tutorials to come in the not too distant future – stay tuned!

Tim Ruppert is Chief Operating Officer at HotWax Media, an OFBiz service provider, as well as an OFBiz project committer and active community member. Tim will join other HotWax Media employees and advisers in periodically posting thoughts here related to OFBiz, eCommerce, ERP, and related topics.

OFBiz Tutorial: Adding GlAccount to Chart of Accounts

Monday, November 22nd, 2010

Today we will be diving into how one can add GLAccount to Chart of Accounts (CoA) in OFBiz using UI tools. Before you try the steps listed in this OFBiz tutorial, make sure you have a user account with Account Manager role assigned to it.

Go to the “Accounting Manager” application and click on the “Global GL Settings ” menu and then select “Chart of Accounts”, Existing GLAccount list will be shown.

A user can add a New GLAccount to CoA by clicking on the Navigate Accounts tab. The screen shows CoA in a tree structure.

The bottom part of the screen has a form for adding and editing GLAccount.

Fill in the required information for the new GLAccount, click on the “Add” button to add the GLAccount to your CoA. The new GlAccount will be added in Chart of Accounts, you can view it in the CoA tree.

Moving towards the Next Step which is editing GLAccount, Select GLAccount from CoA tree, GLAccount will be available for editing in edit form below the tree. Make necessary changes and save.

Stay tuned with the OFBiz tutorial to get more examples for your own Business Domain.

-Anil.

Anil Patel is Chief Development Officer at HotWax Media as well as an OFBiz project committer, PMC member, and active community contributor. He also studies karate! Anil will join other HotWax Media employees and advisors in periodically posting thoughts here related to OFBiz, eCommerce, ERP, and related topics.

Ofbiz Accounting: Setup Chart Of Accounts

Wednesday, November 10th, 2010

In this OFBiz tutorial I will walk through the process of setting up OFBiz accounting. It starts with building your Chart of Accounts (CoA). As you might already know, OFBiz comes with sample CoA. In case you find it overwhelming, I have listed below a simpler version of a CoA that will get you started.

?View Code LANGUAGE
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
<entity-engine-xml> 
<GlAccount glAccountId="1000" accountName="Cash in Bank and on Hand" accountCode="Cash in Bank and on Hand" glAccountClassId="CASH_EQUIVALENT" glAccountTypeId="CURRENT_ASSET" postedBalance="0.0"/> 
<GlAccount glAccountId="1200" accountName="Accounts Receivable" accountCode="Accounts Receivable" glAccountClassId="CURRENT_ASSET" glAccountTypeId="ACCOUNTS_RECEIVABLE" postedBalance="0.0"/> 
<GlAccount glAccountId="1210" accountName="AR Unapplied Payments" accountCode="AR Unapplied Payments" glAccountClassId="CURRENT_ASSET" glAccountTypeId="ACCREC_UNAPPLIED" postedBalance="0.0"/> 
<GlAccount glAccountId="1400" accountName="Inventory" accountCode="Inventory" glAccountClassId="INVENTORY_ASSET" glAccountTypeId="INVENTORY_ACCOUNT" postedBalance="0.0"/> <GlAccount glAccountId="1700" accountName="Accumulated Depreciation" accountCode="Accumulated Depreciation" glAccountClassId="ACCUM_DEPRECIATION" glAccountTypeId="FIXED_ASSET" postedBalance="0.0"/>
<GlAccount glAccountId="2000" accountName="Accounts Payable" accountCode="Accounts Payable" glAccountClassId="CURRENT_LIABILITY" glAccountTypeId="ACCOUNTS_PAYABLE" postedBalance="0.0"/> 
<GlAccount glAccountId="2001" accountName="AP Unapplied Payments" accountCode="AP Unapplied Payments" glAccountClassId="CURRENT_LIABILITY" glAccountTypeId="ACCPAYABLE_UNAPPLIED" postedBalance="0.0"/> <GlAccount glAccountId="2002" accountName="Uninvoiced Item Receipts" accountCode="Uninvoiced Item Receipts" glAccountClassId="CURRENT_LIABILITY" glAccountTypeId="CURRENT_LIABILITY" postedBalance="0.0"/> 
<GlAccount glAccountId="2010" accountName="Sales Tax Payable" accountCode="Sales Tax Payable" glAccountClassId="CURRENT_LIABILITY" glAccountTypeId="CURRENT_LIABILITY" postedBalance="0.0"/> 
<GlAccount glAccountId="3000" accountName="Owners Equity And Net Worth" accountCode="Owners Equity And Net Worth" glAccountClassId="EQUITY" glAccountTypeId="" postedBalance="0.0"/> <GlAccount glAccountId="4600" accountName="Merchandise Sales" accountCode="Merchandise Sales" glAccountClassId="REVENUE" glAccountTypeId="" postedBalance="0.0"/> 
<GlAccount glAccountId="4830" accountName="Sale Discounts" accountCode="Sale Discounts" glAccountClassId="CONTRA_REVENUE" glAccountTypeId="" postedBalance="0.0"/> 
<GlAccount glAccountId="4840" accountName="Sales returns and Allowances" accountCode="Sales returns and Allowances" glAccountClassId="CONTRA_REVENUE" glAccountTypeId="" postedBalance="0.0"/> 
<GlAccount glAccountId="5100" accountName="Merchandise Cost" accountCode="Merchandise Cost" glAccountClassId="COGS_EXPENSE" postedBalance="0.0"/> 
<GlAccount glAccountId="5150" accountName="Shipping Cost" accountCode="Shipping Cost" glAccountClassId="COGS_EXPENSE" postedBalance="0.0"/> 
<GlAccount glAccountId="5400" accountName="Depreciation Expense" accountCode="Depreciation Expense" glAccountClassId="DEPRECIATION" glAccountTypeId="" postedBalance="0.0"/> 
<GlAccount glAccountId="7300" accountName="Office Expense" accountCode="Office Expense" glAccountClassId="SGA_EXPENSE" glAccountTypeId="" postedBalance="0.0"/> 
<GlAccount glAccountId="7340" accountName="Mesc Expense" accountCode="Telephone Expense" glAccountClassId="SGA_EXPENSE" glAccountTypeId="" postedBalance="0.0"/> 
</entity-engine-xml>

If you are planning to accept credit cards from your customers then you should consider adding the following GL Accounts:

?View Code LANGUAGE
1
2
3
4
5
6
7
8
<entity-engine-xml> 
<GlAccount glAccountId="1220" accountName="AR Merchant Account Visa M/C" parentGlAccountId="1200" accountCode="AR Merchant Account Visa M/C" glAccountClassId="CURRENT_ASSET" glAccountTypeId="MRCH_STLMNT_ACCOUNT" postedBalance="0.0"/> 
<GlAccount glAccountId="1230" accountName="AR Paypal" parentGlAccountId="1200" accountCode="AR Paypal" glAccountClassId="CURRENT_ASSET" glAccountTypeId="MRCH_STLMNT_ACCOUNT" postedBalance="0.0"/> 
<GlAccount glAccountId="1240" accountName="AR Bank Checks" parentGlAccountId="1200" accountCode="AR Bank Checks" glAccountClassId="CURRENT_ASSET" glAccountTypeId="MRCH_STLMNT_ACCOUNT" postedBalance="0.0"/> 
<GlAccount glAccountId="1250" accountName="AR Google Checkout" parentGlAccountId="1200" accountCode="AR Google Checkout" glAccountClassId="CURRENT_ASSET" glAccountTypeId="MRCH_STLMNT_ACCOUNT" postedBalance="0.0"/> 
<GlAccount glAccountId="1260" accountName="AR American Express" parentGlAccountId="1200" accountCode="AR American Express" glAccountClassId="CURRENT_ASSET" glAccountTypeId="MRCH_STLMNT_ACCOUNT" postedBalance="0.0"/>
 <GlAccount glAccountId="1270" accountName="AR Discover" parentGlAccountId="1200" accountCode="AR Discover" glAccountClassId="CURRENT_ASSET" glAccountTypeId="MRCH_STLMNT_ACCOUNT" postedBalance="0.0"/> 
</entity-engine-xml>

This simple list of GL Accounts will get you started, but you will obviously need to put together a plan with your accountant or otherwise make the final decision for yourself on the GL Accounts that are best suited for your own business. In my next post, I’ll walk you through the process of assigning GL Accounts to the business entity and thereafter how to setup GL Account defaults to enable automatic GL posting of Payments, Invoices, Inventory and related activities. Good luck.

- Anil

Anil Patel is Chief Development Officer at HotWax Media as well as an OFBiz project committer, PMC member, and active community contributor. He also studies karate! Anil will join other HotWax Media employees and advisors in periodically posting thoughts here related to OFBiz, eCommerce, ERP, and related topics.