View source | Discuss this page | Page history | Printable version   

TDSUSLocalization

Contents

US Professional Localization Pack Overview

The "Professional" Localization Pack for United States contains a rich set of functionality that allow companies doing business in the US to operate efficiently because it allows:

  1. to get Openbravo ERP as well as localized features for the US translated into US English
  2. to operate with a US-centric General Chart of Accounts
  3. to have a more robust set of business forms and reports, such as Purchase Invoices and Packing lists.
  4. to have US State Sales tax definitions as well as Schedule C summary tax reporting
  5. to include additional financial and sales/procurement reports catered to a US business audience
  6. to support check printing, leveraging the new Openbravo Advanced Payables and Receivables module


A subset of modules is available for the US Community Localization. If you would like more information about the US Community Localization, please look here US English Community Localization Pack

Please note that there are also a set of translation changes that go with this Localization Pack. These changes have been contributed back to Openbravo core and should be available in Openbravo 2.50 MP21.

The "Professional" Localization Pack for US requires an Openbravo Commercial License in order to install.

The "Professional" Localization Pack also requires installation of the Advanced Payables and Receivables module. More information about this module can be found here.


US Professional Localization Modules

Feature Description
Community Localization
Chart of Accounts US localization of Chart of Accounts
US English Language Pack Translation of the help, descriptions and messages to US English
Setup for US Banking Eg. ABA & Swift codes
US State Sales Tax Setup A reference set of US state sales tax definitions for four states
Professional Localization
Community Localization Pack This pack, with the Chart of Accounts and other community features, is bundled with Professional
Simple Check Printing Single check per page with simple tracking
Payables/Aged Payables A simplified Accounts Payable report depicting the aging of each payable.
Receivables/Aged Receivables A simplified Accounts Receivable report depicting the aging of each receivable.
Balance Sheet
Income/P&L Statement
Cash Flow Statement
Cash Flow Statement Wizard A wizard to assist in configuring your Cash Flow Statement
Standard Reports Purchase orders, Sales Order Acknowledgment, AR and AP invoices, Packing list, Goods receipt
Taxes: Income Tax Summary Reporting Schedule C Tax Summary Report
Taxes: 1099 Report 1099 Tax report
Sales and Procurement Reports Open purchase orders, open sales orders, goods received
Not Yet Available
Purchase Price Variance Account An automated accounting of variances between the purchase price and cost of goods.
Taxes: Income Tax Data Export Export tax summary data, for importing into tax software

Release Notes

EN_us Professional version 1.1.0:


Accessing the US Professional Localization Pack

The US localization pack is a module, which you can access via the central repository. It consists of a file called org.openbravo.localization.us-1.0.x.obx (.obx is the standard file extension for Openbravo ERP extension modules. Please see the modules page for the latest version of the obx).

  1. Log into Openbravo ERP in the System Administrator role.
  2. From the Application Menu, select General Setup > Application > Module Management.
  3. Click Add Modules. The list of modules available to install appears.
  4. Navigate to the US Community Localization Pack.
  5. Click Install Now.
  6. A confirmation box appears. Click Continue to proceed with the installation. The license agreement appears.
  7. Click I accept the license agreement.
  8. Click Continue. Your selected module appears in the list of installed modules.
  9. Click Rebuild now. A new window appears showing the rebuild in progress.
  10. When the rebuild is complete, you must choose an option for how to restart Openbravo ERP. You can choose from the following:
    • Restart the servlet container: this will restart Tomcat and reload the application.
    • Reload the context: this will reload only the context(s) that have changed.
    • Take no action: does not reload any part of the application. Select this option if you want to manually restart Openbravo ERP later.
  11. Click Continue.

Configuring the US Professional Localization Pack

Once you have installed the localization pack, you need to configure the modules that have been installed:


Configuring the US Professional Localization Pack

The process for performing the configuration steps depends on how your instance of Openbravo ERP has been configured so far:


Configuring the Professional Localization for a new client

If you have not yet configured the clients and organizations for your enterprise, you can automatically set up the US chart of accounts, and import sales tax definitions, business forms and other data, during the client setup process. Before you begin, make sure that you have installed the US localization pack, rebuilt the system and restarted Openbravo ERP.

  1. Log into Openbravo ERP with a systems administrator role.
  2. From the Application menu select General Setup > Client > Initial Client Setup.
  3. Complete the client information fields as required.
  4. Select the include accounting checkbox.
  5. In the Reference Data section, select the chart of accounts option, Tax Rules and Categories, the localized document types for Print Forms and any datasets required for Advanced Payables and Receivables module. See the image below.
  6. Click OK

InitClientSetup.png

Configuring the chart of accounts for an existing client

If you have already configured the clients and organizations for your enterprise and want to apply the US chart of accounts, you must import the accounts .csv file that is included in the module, using the import data process.The chart of accounts .csv file is usually placed in the folder /module/org.openbravo.localization.us.community.coa/referenceData within your file system.

Tax definition data must be loaded either when initializing your organization or by using the Enterprise Module Management screen. Please see the Release Notes for more information.

The localized document types for Print forms may also be applied through the Initial Organization Setup menu item or the Enterprise module management menu item.


Loading the accounts

  1. Log into Openbravo ERP using the Client admin account.
  2. From the Application menu, select Master Data Management > Import Data > Import File Loader.
  3. Click Browse. From the dialog box that opens, navigate the .csv file you want to import.
  4. Click Open.
  5. From the Format File menu select Accounting - Accounts.
  6. Select the Header First Line checkbox.
  7. Details of the accounts to be imported appear in the lower half of the window.
  8. Click Process.


Importing the accounts

View larger
  1. Log into Openbravo ERP using the Client admin account.
  2. From the Application menu, select Master Data Management > Import Data > Import Account.
  3. Click New.
  4. From the Client menu, select your client.
  5. From the Accounting Element menu, select the name of the account tree.
  6. In the Name field, type a name for the import process.
  7. In the Search key field, type a short expression that you can use for this import process.
  8. Click Import Accounts. Openbravo imports the account schema information into the database tables.

Configuring Check Printing

The US Professional Localization pack includes Check printing functionality. In order to utilize these forms, some additional configuration work is required.

Please perform the following steps:

Login as System administrator and execute the following:




Configuring the Business print forms

The US Professional Localization pack includes localized and more robust examples of Sales Order, Purchase Invoices, Packing lists and so on. In order to utilized these forms, some additional configuration work is required.

Document Types

Please follow these steps in configuring the US localized Openbravo Document types:

USARInvoiceConfigured.png

USSalesOrderConfigured.png


- US Purchase Order - category 'Purchase Order'
- US AP Invoice - category 'AP Invoice'
- US AP Credit Memo - category 'AP Credit Memo'
- US AR Credit Memo - category 'AR Credit Memo'
- US Goods Receipt - category 'Material Receipt'


Logo

It is quite easy to change the logo on the forms. To update the logo, replace the file 'logo.png' in the module directory org.openbravo.localization.us.printforms/config/images. The image for your logo should be 197 x 55.

Configuring Your Financial Reports

Once you have completed the configuration tasks listed above, you will have the US Localized Chart of Accounts configured. This includes all of the detail and summary accounts needed for your Financial reports.

However, to be able to report on this information, you must utilize the Openbravo Report Wizard to configure your Financial Reports, including the Balance Sheet, the Profit and Loss, and the Cash Flow Statement.

For a step-by-step process on creating the Financial Reports, please visit:

Other accounting reports may be set up using the User Defined Account Report wizard. For more information, please visit: User Defined Accounting Reports


Configuring Your Schedule C Tax Report

There is some additional configuration that must be performed in order to configure your Schedule C Tax Report.

Before you do this step, your Schedule C tree will appear as follows:
View larger




To navigate to the appropriate window in which you will restructure your Schedule C account tree, you must first log into Openbravo. Then, follow this navigation path: Financial Management || Accounting || Analysis Tools || Tax Summary Report Setup


Steps:

  1. On the top of the window toolbar, click on the icon ‘Tree’
  2. Expand the Schedule C account tree
  3. Hover over account line you want to move
  4. Right click & hold
  5. Drag & Drop in desired location


You will want to repeat the above steps until your Schedule C account tree looks like this:
View larger

Design Documentation

To view design documents related to the US Localization effort, please visit the following repository: Project Designs

Retrieved from "http://forge.openbravo.com/plugins/mwiki/index.php/TDSUSLocalization"

This page has been accessed 34,499 times. This page was last modified on 29 June 2011, at 17:27. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.