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}}
- The files should be changed to reference tax zone instead of tax authorit=
y: configureGL.ui, creditMemo.ui, customer.ui, invoice.ui, itemtax.ui, pros=
pect.cpp, returnAuthorization.ui, salesOrder.ui, selectOrderForBilling.ui, =
shipTo.ui,taxBreakdown.ui, transferOrder.ui, vendor.ui, vendorAddress.ui, w=
arehouse.ui
+ 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 "Default=
TaxAuthority" should be renamed "DefaultTaxZone."  The following files that=
reference this metric should be changed to accommodate the name chang are =
configureGL.cpp and warehouse.cpp.
+ 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.
  =

  =3D=3D=3D Tax Classes =3D=3D=3D
  A Tax Class window will be created that lists tax classes.  It will be lo=
cated in the Accounting > Tax menu.  New and edit buttons will open the Tax=
Class window in new and edit mode respectively.
@@ -289, +289 @@

  =

  There should be a right click option to drill down to view the voucher wi=
ndow from the selected row.
  =

+ =3D=3D=3D Quote =3D=3D=3D
+ The query on the standard quote form will need to be modified to referenc=
e tax zone instead of tax authority.
+ =

  =3D=3D Batch Manager Changes =3D=3D
  TBA
  =

@@ -321, +324 @@

  =

  }}}
  =3D=3D Custom Widget Changes =3D=3D
+ The xcombobox widget needs to include to new types: TaxZones and TaxClass=
es, which should draw from the taxzone and taxclass tables respectively.
- Do we expect to modify existing custom widgets to support the windows des=
cribed above?
- =

- What new custom widgets will we need? Will they be derived from existing =
widgets? What behavior do we expect from them?
  =

  =3D=3D Schema Changes =3D=3D
  =3D=3D=3D New Tables =3D=3D=3D
@@ -403, +404 @@

  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);
  ALTER TABLE cohead ADD COLUMN cohead_taxzone_id integer REFERENCES taxzon=
e (taxzone_id);
- ALTER TABLE crmacct ADD COLUMN crmacct_taxzone_id integer REFERENCES taxz=
one (taxzone_id);
  ALTER TABLE custinfo ADD COLUMN custinfo_taxzone_id integer REFERENCES ta=
xzone (taxzone_id);
  ALTER TABLE invchead ADD COLUMN invchead_taxzone_id integer REFERENCES ta=
xzone (taxzone_id);
  ALTER TABLE itemtax ADD COLUMN itemtax_taxzone_id integer REFERENCES taxz=
one (taxzone_id);
@@ -439, +439 @@

  =

  =

  =3D=3D Stored Procedure Changes =3D=3D
- What stored procedures do we expect to create, eliminate, or change?
+ 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
+  * copyinvoice
+  * copyitem
+  * copyso
+  * copytransferorder
+  * createbillingheader
+  * deletetaxauthority
+  * getfreighttaxselection
+  * getitemtaxtype
+  * gettaxselection (delete)
+  * postbillingselection
+  * postbillingselectionconsolidated
+  * selectforbilling
+  * selectuninvoicedshipment
+ =

  =

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