TDSUSLocalization

Contents 1 US Professional Localization Pack Overview 1.1 US Professional Localization Modules 2 Release Notes 3 Accessing the US Professional Localization Pack 4 Configuring the US Professional Localization Pack 4.1 Configuring the US Professional Localization Pack 4.2 Configuring the Professional Localization for a new client 4.3 Configuring the chart of accounts for an existing client 4.3.1 Loading the accounts 4.3.2 Importing the accounts 5 Configuring Check Printing 6 Configuring the Business print forms 7 Configuring Your Financial Reports 8 Configuring Your Schedule C Tax Report 9 Design Documentation

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:

• US Professional Localization Pack version 1.1.0 (Updated Release 1)

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:

• Configure Openbravo ERP to use the US chart of accounts
• Configure Check Printing
• Configure the US State sales taxes
• Configure the US Business Print Forms
• Configure the US Schedule C Tax Summary report

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:

• If you have not yet set up the clients and organizations for your enterprise, follow these steps.
• If you have already set up the clients and organizations for your enterprise but have not included accounting follow these steps You will then need to perform additional tasks to configure the business print forms, tax summary report and sales tax rates.

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

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

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:

• Go to --> Application Dictionary --> Windows, tabs and Fields
• Search for “Purchase Invoice” window
• Go to Tabs, Search for “Header” tab
• Go to Fields, Search for “EM_APRM_Addpayment” in column field and disable Active check box

• Search for “Payment proposal” window
• Go to Tabs, Search for “Header” tab
• Go to Fields, Search for “EM_APRM_Process_Proposal” in column field and disable Active check box

• Search for “Payment out” window
• Go to Tabs, Search for “Header” tab
• Go to Fields, Search for “EM_Aprm_Add_Scheduledpayments” in column field and disable Active check box

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:

• Log in as the client administrator, using the account you created during Initial Client Setup
• Navigate to Financial Management || Accounting || Setup || Document Types
• Search for the set of Document Types that begin with 'US'
• You will be making some settings on each of the US localized document types. Let's start with US AR Invoice. You will want to set Document Category to 'AR Invoice' and check the Sales Transaction and Default checkboxes. When you are done, the US AR Invoice Document Type should look like the following:

• Make a similar set of changes to US Goods Shipment, setting Document Category to 'Material Delivery' and checking the Sales Transaction and Default checkboxes.
• Now go to US Sales Order, which has a few additional settings to make. Set Document Category to Sales Order, and check the Sales Transaction and Default checkboxes. Then set SO Sub Type to 'Standard Order'. Finally, set Document Type for Invoice to 'US AR Invoice' and Document Type for Shipment to 'US Goods Shipment'. When you have finished these changes, US Sales order should look like the following:

• For the remaining US localized document types, you only need to set the Document Category and check the Default checkbox. The correct values for Document Category are as follows:

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

• Balance Sheet and Profit and Loss: Balance sheet and PL structure
• Cash Flow Statement: Cash Flow Statement

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.

• First log into Openbravo using the administrator role for your new client (not System Administrator).
• Then navigate to General Setup || Process Scheduling || Process Request
• Click on the 'New' button to start a new Process Request.
• Select the 'Create Schedule C Tax Report' process and set it to 'Run Immediately'. Click OK.
• With the completion of that process, your Schedule C Tax report has been created
• Your final step in configuring Schedule C Tax Report is to restructure the account lines using the Openbravo Tree Control. Follow the instructions below in order to perform this restructuring:

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

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:

Design Documentation

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