[
https://issues.apache.org/jira/browse/OFBIZ-416?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12754760#action_12754760
]
Jacques Le Roux commented on OFBIZ-416:
---------------------------------------
Hi David,
This patch is far too big and too old now. But I hope to continue on analysis
and design using David's HEMP method on this subject. It looks really
appropriate.
> Preliminary implementation of GST/VAT for review
> ------------------------------------------------
>
> Key: OFBIZ-416
> URL: https://issues.apache.org/jira/browse/OFBIZ-416
> Project: OFBiz
> Issue Type: Improvement
> Components: order, specialpurpose/ecommerce
> Affects Versions: SVN trunk
> Reporter: David Garrett
> Assignee: Jacques Le Roux
> Priority: Minor
> Attachments: vat-03-061128-r478251.patch
>
>
> I have attached a patch against ofbiz SVN rev 465130 - 18 Oct 06.
> The purpose is to show progress toward a GST/VAT implementations and
> importantly to get early feedback.
>
> The implementation is done in ecommerce and concentrates primarily on the
> cart, the adjustments and creating an order. (More to come.)
>
> The display of the cart and order contents are done to varying degrees. In
> addition a few of the promotions have been tested primarily GWP and order
> discount seem OK. I have not got to the Invoice yet.
>
> The approach taken is to base the implementation on the exTax price. I have
> tried and looked at both. There are pros and cons for working based on incTax
> or exTax pricing .... I believe that exTax is probably better. The display
> price is used but reference to promotions etc I have based on
> basePrice/unitPrice.
> PLEASE NOTE: the implementation is NOT ready for production and has a massive
> amount of notes and comments to myself. These will be fixed and cleaned up
> shortly. The reason for the release at this stage is that it was starting to
> generate a little bit of discussion off the list.
> Implementation
> ==============
> The demo data can primarily be seen from the ecommerce/data ... the AU files.
> See the questions below.
> The key definitions are as follows:
> <TaxAuthorityRateType taxAuthorityRateTypeId="GST_TAX" description="Goods
> and Services Tax"/>
> <TaxAuthorityRateType taxAuthorityRateTypeId="VAT_TAX" description="Value
> Added Tax"/>
>
> <OrderAdjustmentType description="GST Tax" hasTable="N"
> orderAdjustmentTypeId="GST_TAX" parentTypeId=""/>
> <OrderAdjustmentType description="VAT Tax" hasTable="N"
> orderAdjustmentTypeId="VAT_TAX" parentTypeId=""/>
> <OrderAdjustmentType description="Gst Tax on Adjustment" hasTable="N"
> orderAdjustmentTypeId="OTHER_GST_TAX" parentTypeId=""/>
> <OrderAdjustmentType description="VAT Tax on Adjustment" hasTable="N"
> orderAdjustmentTypeId="OTHER_VAT_TAX" parentTypeId=""/>
> <OrderAdjustmentType description="Gst Tax on Shipping" hasTable="N"
> orderAdjustmentTypeId="SHIPPING_GST_TAX" parentTypeId=""/>
> <OrderAdjustmentType description="VAT Tax on Shipping" hasTable="N"
> orderAdjustmentTypeId="SHIPPING_VAT_TAX" parentTypeId=""/>
> <TaxAuthorityRateProduct taxAuthorityRateSeqId="9050" taxAuthGeoId="AUS"
> taxAuthPartyId="AUS_ATO" taxAuthorityRateTypeId="GST_TAX"
> productStoreId="9000AU"
> productCategoryId="" titleTransferEnumId="" minItemPrice="0.00"
> minPurchase="0.00" taxShipping="Y" taxPercentage="10"
> defaultOrderAdjTypeId="GST_TAX"
> shippingOrderAdjTypeId="SHIPPING_GST_TAX" otherOrderAdjTypeId="OTHER_GST_TAX"
> fromDate="2001-05-13 00:00:00.001" thruDate=""
> description="Australian GST Tax"/>
> The GST or VAT is recorded separately for each of the key types the
> item->VAT_TAX the SHIPPING_ADJUSTMENT->SHIPPING_VAT_TAX and the "Other"
> Adjustments->OTHER_VAT_TAX
> Other Adjustments attached to an item still require further testing.
> ### The patch defaults to mysql. You may need to change this/
>
> Testing
> =======
> The easiest test is to add productId= GST10 to the cart and create an order
> (either ecommerce or ordermgr) ... the display starts OK then not fully
> implemented (this is not the problem I am chasing at the moment). As best I
> can tell the cart is being created correctly with the correct
> OrderAdjustments. OrderItemAdjustments are not all functioning correctly at
> the moment.
>
> Next order 11 x GST10 ... get a free gift ... seems to work
>
> Next order 1 x GST10PROMO (in PROMOTIONS category) ... price rules seem to
> work OK
>
> Problem ... SPECIAL_PROMOTION ... add code 9021 ... problem comes from the
> pricing basis in getSubTotalForPromotions(...) which uses
> getDisplayItemSubTotal
>
>
> Questions
> =========
> ** Can I use this patch to implement VAT/GST now?
> No. Not yet. This is a VERY early release to show the direction being taken.
> ** Why are there so many changes? What is all this AU and GST stuff.
> To test the GST/VAT I have created a store(9000AU) which implements the
> Australian(AU) implementation of VAT called Goods & Services Tax(GST). In
> order to achieve this there is a lot of demo data that has been created which
> implements ProductPrices, Promotions, Payments, UiLabels etc.
> The WebSiteId in web.xml is not changed at the moment and the default store
> is overwritten as 9000AU.
> Other TaxAuthorities may also be created later.
> ** Isn't GST just another VAT? Why not just implement VAT?
> Yes this is correct. This is probably the way things will go ... with
> customisations based on taxAuthGeoId. HOWEVER I do need things like "GST Tax"
> type descriptions on the orderItem display. So in the short term this GST
> implementation will remain. Call me selfish but I want it to work out of the
> box for me.
> Next Steps
> ==========
> * Address any feedback
> * Get the cart to order process working particulary for the orderItem
> adjustments and promotions
> * The cart internally seems correct So ... get the display of the data
> showing what the user would expect.
> * Focus on getting VAT into the Invoice
> * Address any feedback
> Hope it helps. All feedback/criticism welcome.
>
> David G
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
