BLOG

NEXT STEPS

Archive for the ‘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.

Types Of Invoices in OFBiz

Tuesday, June 28th, 2011

An invoice is a commercial document issued by seller to buyer that enlists the summary of the transaction i.e. quantity, unit price, total of complete purchase, item descriptions, settlement terms, dates, etc. This Ofbiz component supports various Invoice(s) for Accounts payable and Accounts receivable. Let’s find out what are those invoice(s) types are.

Let’s start with AR component. AR supports Sales Invoice(s), Purchase return Invoice(s) and Interest Invoices(s).

1) Sales Invoice(s): The Sales Invoice is where everything comes together. A customer is chosen from the database, or entered as a new customer. Merchandise its detailed by entering non-inventory items or selecting merchandise from inventory. Each Sales invoice may also have a memo attached (e.g., for delivery instructions or other particulars). Once an Invoice is paid it will Debit Accounts Receivable.

2) Purchase Return Invoice(s): In the event of a purchase return, goods are removed from the warehouse to return the goods to the supplier. These will be created for mapping the entries.

3) Interest Invoice(s): Invoices are used to charge clients for overdue invoices.

On the other side of this accounting function, the Ofbiz AP Component supports purchase Invoice(s), customer return Invoice(s), payroll and commission invoice(s).

4) Purchase Invoice(s) : When an invoice is received from one of your regular suppliers, this should be entered in the Ofbiz System as a purchase invoice. Once an Invoice is paid it will Credit Accounts Payable.

5) Customer Return Invoice(s): The reasons a customer may decide to return an item are numerous, and it can be possible only on condition that the terms between our Company and the Customers are discussed, and the return is allowed.

6) Payroll Invoice(s): It could be referred to as ‘The Sum’ total of all compensation that a business must pay to its employees for a set period of time, or by a given date. It is a major expense for most businesses and is almost always deductible as such.

7) Commission Invoice(s): A Commission Invoice is a form of payment to an agent for services rendered.

In the next tutorial I will walk you through various Invoice statuses.

-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