BLOG

NEXT STEPS

Archive for the ‘Apache OFBiz’ Category

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.

OFBiz Tutorial – Turning Products On or Off

Monday, May 23rd, 2011

There are a number of reasons that a product or product variant (size, color, etc) may need to be removed from the front end of the site, but we don’t want to remove the product from the system entirely.  This could range from availability, inventory, or seasonal nature of products, or even more specific reasons to your business.  Luckily, OfBiz makes this process very simple, and allows us to set very specific introduction and discontinuation dated on products, right down to the individual variants of the products.  In this OFBiz tutorial we will walk you through this process to show you how it is done.

To be able to set these introduction and discontinuation dates, the user must be at least a Catalog Manager in the system, and we should already have products set up in the system.

Execution Steps

  1. Go to “Catalog” component and click on “Products” tab.
    ofbiz-tutorial-products-on-off-1sm
  2. Fill in details in search fields on “Find” page and click on “Find” button.
    ofbiz-tutorial-products-on-off-2sm
  3. System would display the list of existing products based on search inputs.
    ofbiz-tutorial-products-on-off-3sm
  4. Click on any of the “Product Id” from the list of various products displayed on Find page.
  5. Product Detail will be displayed on “Edit Product” page.
  6. ofbiz-tutorial-products-on-off-4sm

  7. Click on “Dates” tab.
    ofbiz-tutorial-products-on-off-5sm
  8. Enter the “Introduction Date” to enable the product display or to turn on the product.
    ofbiz-tutorial-products-on-off-6Lg
  9. Enter the “Sales Discontinuation Thru Date” to discontinue and turn of the product display on the ecommerce storefront.
    ofbiz-tutorial-products-on-off-7sm
  10. Click on “Update Product” button.
    ofbiz-tutorial-products-on-off-8

Expected Outcome

  • If the “Introduction Date” is a future date then product display will be turned off till the date specified.
  • If “Introduction Date” is not specified or it is a past date then product display will be turned on for the store front.
  • The changes will get reflected on Edit Product page.
  • Product will be displayed or removed from storefront.

–Chris Gaughan—

chris-gaughan

Chris Gaughan is an OfBiz Designer specializing in Client Training and Support for HotWax Media.

OFBiz Tutorial – Price Rules

Monday, May 16th, 2011

OFBiz Tutorial – Managing Security Groups

Monday, May 9th, 2011

OFBiz Tutorials – Looking Up Orders

Friday, March 25th, 2011