Wiki Change:

omfgppc
2009-03-10
2013-03-08
  • omfgppc
    omfgppc
    2009-03-10

    You have subscribed to a wiki page or wiki category on "xTuple" for change =
    notification.

    The "EnhancedTaxInternationalization" page has been changed by jrogelstad:

      A Tax Zone window will be created to create and edit tax zone records as =
    pictured.  Tax Zones should be unique and blank entries should not be allow=
    ed.
      =

       . {{attachment:taxZone.png|taxArea.png}}
    + =

      Several files should be changed to reference tax zone instead of tax auth=
    ority including: configureGL.ui, creditMemo.ui, customer.ui, invoice.ui, it=
    emtax.ui, prospect.cpp, returnAuthorization.ui, salesOrder.ui, selectOrderF=
    orBilling.ui, shipTo.ui,taxBreakdown.ui, transferOrder.ui, vendor.ui, vendo=
    rAddress.ui, warehouse.ui
      =

      The metric for global default tax authority internally stored as "!Defaul=
    tTaxAuthority" should be renamed "!DefaultTaxZone."  The files that referen=
    ce this metric should be changed to accommodate the name change are configu=
    reGL.cpp and warehouse.cpp.
    @@ -398, +399 @@

      COMMENT ON COLUMN taxcum.taxcum_taxass_id IS 'The id of the parent tax as=
    signment.';
      COMMENT ON COLUMN taxcum.taxcum_cumulative_taxass_id IS 'The id of the ta=
    x assignment whose calculation will be added to the parent base price.';
      }}}
    - =

      The following tables will need to be updated to include a taxzone column =
    as such:
    + =

      {{{
      ALTER TABLE cmhead ADD COLUMN cmhead_taxzone_id integer REFERENCES taxzon=
    e (taxzone_id);
      ALTER TABLE cobmisc ADD COLUMN cobmisc_taxzone_id integer REFERENCES taxz=
    one (taxzone_id);
    @@ -418, +419 @@

      ALTER TABLE vohead ADD COLUMN vohead_taxzone_id integer REFERENCES taxzon=
    e (taxzone_id);
      ALTER TABLE whsinfo ADD COLUMN whsinfo_taxzone_id integer REFERENCES taxz=
    one (taxzone_id);
      }}}
    - =

      These same tables should be populated with the existing taxauth_id into t=
    he taxzone_id on their respective records.  Finally, the taxauth_id on the =
    tables listed above should be dropped, with the exception of taxreg (tax re=
    gistration).
    - =

    - =

      =

      What privileges do we need?
      ||||<style=3D"text-align: center;">'''Privileges for feature''' ||
    @@ -440, +438 @@

      =

      =3D=3D Stored Procedure Changes =3D=3D
      The following functions will need to be altered to reference tax zone ins=
    tead of tax authority.  The old function should be renamed and replaced whe=
    re used in the application:
    + =

       * changecmheadtaxauth
       * changecobtaxauth
       * changeinvoicetaxauth
       * changequotetaxauth
       * changesotaxauth
       * changetotaxauth
    -  =

    + =

      The following functions need to be altered to reference the tax zone id i=
    nstead of tax authority id:
    + =

       * convertcustomertoprospect
       * convertprospecttocustomer
       * convertquote
    @@ -465, +465 @@

       * selectforbilling
       * selectuninvoicedshipment
      =

    - =

      =3D=3D Performance Considerations =3D=3D
      How will this feature impact the performance of the application overall?
      =