View source | View content page | Page history | Printable version   

Projects:DEFINING SUB ACCT FOR BP PRODUCT/Technical Specifications

Contents

DEFINING A NEW ACCOUNT PER BUSINESS PARTNER & PRODUCT

Technical Specification Document


Purpose of the Project

The purpose of this project is to enhance OB ERP application to setup new sub-accounts for each type of Business Partner(Customer/Vendor) and Product.

Introduction

This technical specifications document outlines the implementation of distinct new sub-accounts per each type of Business Partner(Customer or Vendor) and Product. The new requirement is to implement a new feature which will allow the user to configure the system to automatically create a separate account for every Business Partner (Customer / Vendor) and Product.To configure this feature, go to General Setup > Enterprise > Organization > Org Schema.

Technical Implementation

User Interface Implementation:

Creating a numbering sequence

Database Changes

According to the requirement the new table columns need to be added in ad_org_acctschema

  1. IsBPNewAccount character(1)
  2. IsProductNewAccount character(1)
  3. Ad_Sequence_BP_Id character varying(32)
  4. Ad_Sequence_PR_Id character varying(32)
  5. Acct_length numeric(10)
  6. Subacct_length numeric(10)

Configuring the Application Dictionary


* C_BPARTNER_TRG:


In the existing system when create a Business Partner(customer or Vendor),The trigger C_BPARTNER_TRG will be raised to set the default accounts for a newly created Business Partner(customer or Vendor). According to the new requirement when create a Business Partner(customer or Vendor),The trigger C_BPARTNER_TRG will be raised to set the sub accounts for a newly created Business Partner(customer or Vendor).

Trigger changes:


*M_PRODUCT_TRG:


In the existing system when create a Product,The trigger M_PRODUCT_TRG will be raised to set the default accounts for a newly created Product. According to the new requirement when create a Product,The trigger M_PRODUCT_TRG will be raised to set the sub accounts for a newly created Product.

Trigger changes:

Open Discussion Items

Closed Discussion Items

Retrieved from "http://wiki.openbravo.com/wiki/Projects:DEFINING_SUB_ACCT_FOR_BP_PRODUCT/Technical_Specifications"

This page has been accessed 5,911 times. This page was last modified on 8 June 2012, at 05:27. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.