BLOG

NEXT STEPS

Posts Tagged ‘OFBiz development’

OfBiz Invoice Processing Workflow Explained

Monday, July 18th, 2011

OfBiz-Invoice-Accounting

In this issue we’ll discuss Invoice statuses and the Invoice processing workflow supported in the Apache Ofbiz Accounting application. Like other business documents/objects in Ofbiz, Invoices are an important part of the broader Ofbiz system, and changes to its status have direct impact on General Ledger (GL), billing accounts, payments and other accounting functions. Of all statuses, the ‘Ready’ and ‘Paid’ status are unique in that they trigger GL transactions.

As you read this article please keep one very important thing in mind about Ofbiz, it’s designed and built to be fully customizable. Like most other workflows in Ofbiz, OOTB workflow for Invoice processing is very flexible and should be easy to use for most enterprises. If your business uses different statuses (and processing workflow), don’t worry, customizing workflow is very easy.

Now coming back to the Invoice status.

In-Processes: When an Invoice is created it’s always in ‘In-Process’ status. A user can add/edit invoice items and update other invoice attributes like billing party or due date, without impacting any other part of system. This is comparable to a ‘Work-In-Progress’ or ‘Draft’ status you might have used in other workflows.

Approved: Move an Invoice to ‘Approved’ status when you are done preparing (discuss and review), and the Invoice is ready to be finalized. Once in ‘Approved’ status an Invoice cannot be edited. In the event you need to make any updates to an Invoice, it needs to be moved to the ‘In-Processes’ status.

Sent: There’s little flexibility after an invoice is sent. An Invoice can be moved to ‘Sent’ status from ‘In-Processes’ or ‘Approved’ status. Given the flexibility, use of this status in Invoice processing workflow is open for interpretation. It can be used to support the “Sent for Approval” or “Sent to Customer” step in workflow. An Invoice in ‘In-Process’ status can be moved to “Sent” status to support the “Sent for Approval” step in workflow. Alternatively, we can Approve the invoice and then move it to ‘Sent’ status, marking it as “Sent to Customer.”

Ready: An Approved invoice can be moved to Ready status and is a very important step in workflow. Moving an Invoice into Ready status triggers the process of posting the Invoice to GL. What happens on the GL side of the system is governed by Organizations Accounting Preferences and the GL setup.

Paid: Somewhere between creating an Invoice and moving it into ready status, an organization may receive payment (for AR invoices) or send payment (for AP invoices). Once Payment is received (or sent) and applied to the Invoice, and the total amount of payment applications covers the Invoice grand total, the Invoice can then to be moved into Paid status. Moving the Invoice to Paid status triggers GL transactions. A valid status change after the Ready status is ‘Paid’, ‘Write Off’ or ‘Cancel’.

Write Off: If an accounting manager sets the invoice status as ‘Write Off’, then the Invoice becomes non-collectible in the system.

Canceled: An Invoice in ‘Ready’ status can canceled. Any Invoice cancellation event triggers the reversal of the related GL transaction entries and the Payment application, though the Invoice will remain in the system as non-editable.

- 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.

HotWax Media’s Solutions to Project Management Challenges

Thursday, June 3rd, 2010
Contegix – Partners: Atlassian
In business, like in life, forging partnerships is never an easy thing to do.  As we’ve discussed in previous posts, our partnership with Contegix has made a profound impact on the companies with which we work and how we provide the greatest impact to our customers.
After working with rudimentary collaboration tools – read: not integrated – we went out and purchased a suite of tools that were supposed to solve many of our project management and company workflow challenges.  After working with this software package (no need to name names) for a year and spending countless hours working with their professional services team and our business team, we were unable to make this software even close to the worth the investment.  We learned from our mistakes and took this one to Contegix!
When we did our original research into the project management space, one of the contenders was the Atlassian suite of tools – but just didn’t measure up to the potential promised from the other tool.  In the time between doing our initial evaluation, and the when the competition failed to live up to it’s promise, the Atlassian tools surged forward – and Contegix backed them as their solution to our problems we were facing.
From protecting access to applications and source code to managing documents and documentation – from showing SVN changesets to performing code review – from project management to development workflows – Atlassian has delivered an extensible set of applications that we can build a solid foundation on for our customers and internal teams alike.  Preparing for our next set of posts, the tools we are using at this moment are:
1. Crowd – centralized single sign on – permissions and access – easily pluggable to a variety of applications
2. Confluence – document management and collaboration
3. FishEye – real time reporting of source code repository changes
4. Crucible – code and document review
5. JIRA – project management and tracking
In this post, I had planned on going into detail about our Atlassian support partner, Customware, but we’ll save that for next post.

Atlassian

In business, like in life, forging partnerships is never an easy thing to do.  As we’ve discussed in previous posts, our partnership with Contegix has made a profound impact on the companies with which we work and how we provide the greatest impact to our customers.  Most of you who follow this blog know by now that HotWax Media specializes in OFBiz development.  However, these project management tools can be used no matter what platform you choose to develop in.

After working with rudimentary collaboration tools – read: not integrated – we went out and purchased a suite of tools that were supposed to solve many of our project management and company workflow challenges.  After working with this software package (no need to name names) for a year and spending countless hours working with their professional services team and our business team, we were unable to make this software even close to the worth the investment.  We learned from our mistakes and took this one to Contegix!

When we did our original research into the project management space, one of the contenders was the Atlassian suite of tools – but just didn’t measure up to the potential promised from the other tool.  In the time between doing our initial evaluation, and the when the competition failed to live up to it’s promise, the Atlassian tools surged forward – and Contegix backed them as their solution to our problems we were facing.

From protecting access to applications and source code to managing documents and documentation – from showing SVN changesets to performing code review – from project management to development workflows – Atlassian has delivered an extensible set of applications that we can build a solid foundation on for our customers and internal teams alike.  Preparing for our next set of posts, the tools we are using at this moment are:

  1. Crowd – centralized single sign on – permissions and access – easily pluggable to a variety of applications
  2. Confluence – document management and collaboration
  3. FishEye – real time reporting of source code repository changes
  4. Crucible – code and document review
  5. JIRA – project management and tracking

In this post, I had planned on going into detail about our Atlassian support partner, Customware, but we’ll save that for next post.

-Tim

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 advisors in periodically posting thoughts here related to OFBiz, eCommerce, ERP, and related topics.

OFBiz Tutorial – How to fulfill a sales order that has more than one ship group

Friday, April 23rd, 2010

In our last OFBiz tutorial by Jacopo we learned how to place a sales order comprising of multiple ship groups. Lets carry on with this OFBiz development tutorial and learn how to fulfill a sales order containing more than one ship group which is yet another interesting feature present OOTB.

The items in the ship group may differ from the previous tutorial and is not important though but in general the tutorial will present you with a step by step guide to fulfill a sales order.

Lets get started assuming that you have a very basic knowledge of warehouse.

The first step is to select a warehouse.

OFBiz Tutorial - Sales Order - Step 1

Select a warehouse from the drop-down and click on the submit button. Go to Picking tab to see the orders for picking.

OFBiz Tutorial - Sales Order - Step 2

The screen displays a list of orders that are in approved status. An order may require stock move prior to picking. There are a total of 4 grouping methods available OOTB to group the orders for picking namely: Group by Shipping Method, Group by Warehouse Area, Group by Number of Order Items and Zero grouping.

Lets just stick to zero grouping method i.e. when no grouping method is selected. From the screen below (part of the above screen) we find that order is not ready for picking yet and needs a stock move.

Stock move is moving inventory from a bulk location to a primary/pick location where a picker can actually pick the inventory items.

OFBiz Tutorial - Sales Order - Step 3

You cannot create a picklist until and unless order is ready for picking. Lets do the required stock move first.

OFBiz Tutorial - Sales Order - Step 4

Once we complete the stock move, the screen will show that no other stock move is required.

OFBiz Tutorial - Sales Order - Step 5

Lets go back to the picking screen and see whether the order is now ready for picking or not.

OFBiz Tutorial - Sales Order - Step 6

Now the order is ready for picking (see the second column) and we can create the picklist as well. After creating the picklist, we need to pick the order. This can be done through Manage Picklist screen.

OFBiz Tutorial - Sales Order - Step 7

Once the order is picked, change the status from the drop-down to Picked.

OFBiz Tutorial - Sales Order - Step 8

The order picking is now complete. Lets move further and learn how to pack the order. Click on Packing tab. On the packing screen, enter the order ID (left most) and the ship group ID (Right most) in the input box. The ship group though defaults to 00001 and you may only need to change it if you are packing the order for a different ship group other then 00001.

Click on Pack Order button. This will show the items that need to be packed for ship group 00001.

OFBiz Tutorial - Sales Order - Step 9

Click on Pack Item button. This will pack all the items in a single package and will show the number of package and items in these packages.

OFBiz Tutorial - Sales Order - Step 10

Click on Complete button. This will complete the packing of order for ship group 00001. A shipment and an invoice will be generated.

OFBiz Tutorial - Sales Order - Step 11

Now lets try to print the shipping label that can be affixed on this package. For this click on the shipment ID link and then go to Route Segments tab.

OFBiz Tutorial - Sales Order - Step 12

Click on Confirm Shipment with UPS button to confirm the shipment with UPS. Once the shipment is confirmed, a new button “Accept UPS Shipment Confirmation” will appear on the screen.

OFBiz Tutorial - Sales Order - Step 13

Click this button and the shipping label will be received from the UPS.

OFBiz Tutorial - Sales Order - Step 14

The shipping label can be viewed from View Label Image button and once printed can be affixed on each package.

You can now perform the same steps to pack items for ship group 00002. Once the order is packed for both ship groups the status of order will change to Completed.

OFBiz Tutorial - Sales Order - Step 15

This accomplishes the fulfillment of the order.

Vikas Mayur is a dynamic OFBiz developer working for HotWax Media as a Director of Software Development in India.  He works in web based application and ERP software using OFBiz, which is a top level project of Apache Software Foundation.

Enterprise E-Commerce and ERP: Common Questions Series Part 2

Thursday, April 8th, 2010

enterprise-ecommerce

For HotWax Media an Apache OFBiz development firm, 2010 is delivering a great batch of new open source e-commerce and ERP projects. Whether from existing clients looking to invest in system enhancements or new clients ready to invest after a cautious 2009, HotWax Media is seeing a good deal of activity in the form of active projects and a healthy sales pipeline.

Along with a boost in free cash flow, this activity continues to generate great input from clients, which fits in nicely with my ongoing series discussing common questions related to open source e-commerce and ERP projects.

Enterprise eCommerce and ERP projects can have a lot of moving pieces. As businesses grow, old systems can limit potential. It can be painful for businesses to identify these limitations and understand the impact they are having on current profitability and future growth. At HotWax Media, it is our mission help our clients understand these problems, and then to make the problems go away.

Let’s dive into the next round of common questions and talk about answers. The answers here are meant to be relatively short and sweet. If you are looking for additional detail or are more interested in learning how HotWax Media can help you optimize your e-commerce and ERP for your business, contact us without delay!

The first questions pertains to both existing and new businesses who want to take a measured approach:

1. Can we do this in phases?

Yes. HotWax Media implements e-commerce and ERP systems using Apache OFBiz. OFBiz consists of a complete set of individual ERP applications, including a robust e-commerce system. The data model in OFBiz, furthermore, allows HotWax Media to account for just about anything that is going on in a given legacy system, and integrate where needed in order to facilitate a phased approach.

For example, if your business is running on NetSuite, but you want a better e-commerce solution, phase 1 of your project can consist of an affordable, powerful B2C e-commerce site upgrade that is completely integrated with your NetSuite back end. In subsequent phases, you can replace NetSuite completely — at your own pace, in discrete, manageable steps.

The second question usually comes from clients who have been burned in the past by irresponsible promises from proprietary software vendors:

2. Can we customize the system (without blowing our budget)?

Yes. As I mentioned above, HotWax Media implements ERP systems using Apache OFBiz. OFBiz is meant to be customized. As part of a standard OFBiz ERP implementation, HotWax Media works with clients to understand the nuances of their business requirements and workflows, and then implements a system that accommodates those specific needs.

It amazes me to hear from clients, as I have repeatedly, that they paid for an expensive proprietary ERP system only to learn later that it could not do what they needed it to do. And by the way, they do not own the system, and they are on the hook to pay recurring licensing fees in order to keep using it. Never mind the principle of it all — strategically, that sucks.

The nature of open source software in general, and of Apache OFBiz specifically, is to be transparent and customizable. My general statement to clients is, “If we can define a consistent set of requirements together, we can absolutely make OFBiz meet those requirements.”

The final question applies to everyone:

3. How many different companies will we need to work with in order to implement our system?

One. HotWax Media. We offer a complete set of e-commerce and ERP implementation services, ranging from business analysis through graphic design and UI to development and testing. We provide the project management and collaboration tools to accommodate all aspects of the project, and we will even handle hardware, infrastructure and hosting in partnership with our colleagues at Contegix.

Keeping your project under one roof improves quality and saves money. It’s that simple.

Feel free to let us know if you have other common questions you would like to see addressed in this series, or contact us today to learn more about how HotWax Media can help you build and grow your e-commerce business.

View my previous post where I covered other commonly asked questioned about Enterprise E-Commerce and ERP deployment or expansion.

- Mike

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

The HotWax Media Way: Infrastructure and Tools to Support OFBiz Open Source eCommerce and ERP Development

Friday, March 5th, 2010

Tools OFBiz Development

In my first set of posts, I had the opportunity to describe a bit about what has been going on at HotWax Media – with a focus on our involvement in the OFBiz development community and the impact it made during 2009. While I’m looking forward to getting back to discussing what HotWax will be championing in OFBiz in 2010, I’d like to take a break from OFBiz and tell you a bit about HotWax Media and what makes us and our process different from the other options out there.

To kick things off, I’d like to discuss something near and dear to my heart – the partnerships that we make and the people we choose to make them with. Over the past few years, we have made decisions that have provided us with the ability to focus on running our business and serving our customers instead of trying to become the masters of all things in all spaces. Focus, in other words.

For many years, along with the help of a choice system administrator or two, I spent a chunk of time, every day, maintaining and upgrading our IT infrastructure. As we merged companies and grew our staff of OFBiz developers, this became increasingly difficult for me to manage – all the while wishing I was spending more time with our customers. At that time, we had migrated all of our customers’ hosted solutions over to Contegix, and one of the companies we merged with was using them to run their organization already – so it seemed like a natural fit. The rest is history! Contegix has simplified our business by making hosting and infrastructure first class and very easy.

While I will spend more time focusing on the intricacies of our partnership with Contegix in subsequent posts, by becoming our source for infrastructure decision making, and by modeling processes that we respect and appreciate, Contegix has helped us to acquire partnerships that have made additional efficiency gains. They brought their other partners to the table in order to help us focus and realize the potential of our business. From working with the Atlassian collaboration to helping us maximize that software by bringing in the experts on integration and collaboration at CustomWare, we have been able to refine our processes to reflect the level of quality all customers deserve.

Stay tuned to the next set of posts to learn more about the our processes, our partners, and how they work together to provide solutions for our customers. Here are the high level points to take away:

1. Contegix – Beyond Managed Hosting and Infrastructure Support.
2. Atlassian - Amazing Efficiency Tools.
3. CustomWare - Integration and Collaboration Solutions.
4. Our Process – Agile Development Processes Honed to Work in a Distributed, Multi-Cultural, Development Environment.

- Tim

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