OFBiz › OFBiz - User

VAT - Where is it stored?

‹ Previous Topic Next Topic ›
 
classic Classic list List threaded Threaded
♦
♦
 2 messages Options
Vinu Varghese-2
Reply | Threaded
Open this post in threaded view
♦
♦
|

VAT - Where is it stored?

Vinu Varghese-2
Hi all,

I am trying to create a Product store, I checked 'Show prices with VAT
tax included' = Y, and then it asked for Vat tax Auth geo id and Vat tax
auth party id, I selected from the lookup window, upon updating the
product store, it threw and exception

Error while updating:
[GenericEntity:ProductStore][addToCartRemoveIncompat,Y(java.lang.String)][addToCartReplaceUpsell,Y(java.lang.String)][allowPassword,Y(java.lang.String)][authDeclinedMessage,null()][authErrorMessage,null()][authFraudMessage,null()][autoApproveInvoice,Y(java.lang.String)][autoApproveOrder,Y(java.lang.String)][autoApproveReviews,N(java.lang.String)][autoInvoiceDigitalItems,Y(java.lang.String)][autoOrderCcTryExp,Y(java.lang.String)][autoOrderCcTryLaterMax,null()][autoOrderCcTryLaterNsf,Y(java.lang.String)][autoOrderCcTryOtherCards,Y(java.lang.String)][autoSaveCart,N(java.lang.String)][balanceResOnOrderCreation,N(java.lang.String)][checkGcBalance,N(java.lang.String)][checkInventory,Y(java.lang.String)][companyName,Avg(java.lang.String)][createdStamp,2009-02-12
16:39:28.419(java.sql.Timestamp)][createdTxStamp,2009-02-12
16:39:28.372(java.sql.Timestamp)][daysToCancelNonPay,null()][defaultCurrencyUomId,USD(java.lang.String)][defaultLocaleString,null()][defaultPassword,null()][defaultSalesChannelEnumId,null()][digProdUploadCategoryId,null()][digitalItemApprovedStatus,ITEM_APPROVED(java.lang.String)][enableAutoSuggestionList,N(java.lang.String)][enableDigProdUpload,N(java.lang.String)][explodeOrderItems,N(java.lang.String)][headerApprovedStatus,ORDER_APPROVED(java.lang.String)][headerCancelStatus,ORDER_CANCELLED(java.lang.String)][headerDeclinedStatus,ORDER_REJECTED(java.lang.String)][headerLogo,null()][headerMiddleBackground,null()][headerRightBackground,null()][inventoryFacilityId,MyRetailStore(java.lang.String)][isDemoStore,Y(java.lang.String)][isImmediatelyFulfilled,N(java.lang.String)][itemApprovedStatus,ITEM_APPROVED(java.lang.String)][itemCancelStatus,ITEM_CANCELLED(java.lang.String)][itemDeclinedStatus,ITEM_REJECTED(java.lang.String)][lastUpdatedStamp,2009-02-12
16:41:52.183(java.sql.Timestamp)][lastUpdatedTxStamp,2009-02-12
16:41:52.089(java.sql.Timestamp)][manualAuthIsCapture,N(java.lang.String)][oneInventoryFacility,Y(java.lang.String)][orderNumberPrefix,null()][payToPartyId,null()][primaryStoreGroupId,_NA_(java.lang.String)][prodSearchExcludeVariants,Y(java.lang.String)][productStoreId,10003(java.lang.String)][prorateShipping,Y(java.lang.String)][prorateTaxes,Y(java.lang.String)][reqReturnInventoryReceive,null()][reqShipAddrForDigItems,Y(java.lang.String)][requireCustomerRole,N(java.lang.String)][requireInventory,N(java.lang.String)][requirementMethodEnumId,PRODRQM_NONE(java.lang.String)][reserveInventory,Y(java.lang.String)][reserveOrderEnumId,null()][retryFailedAuths,Y(java.lang.String)][selectPaymentTypePerItem,N(java.lang.String)][setOwnerUponIssuance,null()][shipIfCaptureFails,Y(java.lang.String)][showCheckoutGiftOptions,Y(java.lang.String)][showPricesWithVatTax,Y(java.lang.String)][showTaxIsExempt,Y(java.lang.String)][splitPayPrefPerShpGrp,Y(java.lang.String)][storeCreditValidDays,null()][storeName,AVG(java.lang.String)][styleSheet,null()][subtitle,AVG(java.lang.String)][title,AVG
STORE(java.lang.String)][usePrimaryEmailUsername,N(java.lang.String)][vatTaxAuthGeoId,DEU(java.lang.String)][vatTaxAuthPartyId,10010(java.lang.String)][viewCartOnAdd,N(java.lang.String)]
(SQL Exception while executing the following:UPDATE
lbivory.PRODUCT_STORE SET PRIMARY_STORE_GROUP_ID=?, STORE_NAME=?,
COMPANY_NAME=?, TITLE=?, SUBTITLE=?, PAY_TO_PARTY_ID=?,
DAYS_TO_CANCEL_NON_PAY=?, MANUAL_AUTH_IS_CAPTURE=?, PRORATE_SHIPPING=?,
PRORATE_TAXES=?, VIEW_CART_ON_ADD=?, AUTO_SAVE_CART=?,
AUTO_APPROVE_REVIEWS=?, IS_DEMO_STORE=?, IS_IMMEDIATELY_FULFILLED=?,
INVENTORY_FACILITY_ID=?, ONE_INVENTORY_FACILITY=?, CHECK_INVENTORY=?,
RESERVE_INVENTORY=?, RESERVE_ORDER_ENUM_ID=?, REQUIRE_INVENTORY=?,
BALANCE_RES_ON_ORDER_CREATION=?, REQUIREMENT_METHOD_ENUM_ID=?,
ORDER_NUMBER_PREFIX=?, DEFAULT_LOCALE_STRING=?,
DEFAULT_CURRENCY_UOM_ID=?, DEFAULT_SALES_CHANNEL_ENUM_ID=?,
ALLOW_PASSWORD=?, DEFAULT_PASSWORD=?, EXPLODE_ORDER_ITEMS=?,
CHECK_GC_BALANCE=?, RETRY_FAILED_AUTHS=?, HEADER_APPROVED_STATUS=?,
ITEM_APPROVED_STATUS=?, DIGITAL_ITEM_APPROVED_STATUS=?,
HEADER_DECLINED_STATUS=?, ITEM_DECLINED_STATUS=?,
HEADER_CANCEL_STATUS=?, ITEM_CANCEL_STATUS=?, AUTH_DECLINED_MESSAGE=?,
AUTH_FRAUD_MESSAGE=?, AUTH_ERROR_MESSAGE=?, STYLE_SHEET=?,
HEADER_LOGO=?, HEADER_MIDDLE_BACKGROUND=?, HEADER_RIGHT_BACKGROUND=?,
USE_PRIMARY_EMAIL_USERNAME=?, REQUIRE_CUSTOMER_ROLE=?,
AUTO_INVOICE_DIGITAL_ITEMS=?, REQ_SHIP_ADDR_FOR_DIG_ITEMS=?,
SHOW_CHECKOUT_GIFT_OPTIONS=?, SELECT_PAYMENT_TYPE_PER_ITEM=?,
SHOW_PRICES_WITH_VAT_TAX=?, SHOW_TAX_IS_EXEMPT=?, VAT_TAX_AUTH_GEO_ID=?,
VAT_TAX_AUTH_PARTY_ID=?, ENABLE_AUTO_SUGGESTION_LIST=?,
ENABLE_DIG_PROD_UPLOAD=?, PROD_SEARCH_EXCLUDE_VARIANTS=?,
DIG_PROD_UPLOAD_CATEGORY_ID=?, AUTO_ORDER_CC_TRY_EXP=?,
AUTO_ORDER_CC_TRY_OTHER_CARDS=?, AUTO_ORDER_CC_TRY_LATER_NSF=?,
AUTO_ORDER_CC_TRY_LATER_MAX=?, STORE_CREDIT_VALID_DAYS=?,
AUTO_APPROVE_INVOICE=?, AUTO_APPROVE_ORDER=?, SHIP_IF_CAPTURE_FAILS=?,
SET_OWNER_UPON_ISSUANCE=?, REQ_RETURN_INVENTORY_RECEIVE=?,
ADD_TO_CART_REMOVE_INCOMPAT=?, ADD_TO_CART_REPLACE_UPSELL=?,
SPLIT_PAY_PREF_PER_SHP_GRP=?, LAST_UPDATED_STAMP=?,
LAST_UPDATED_TX_STAMP=?, CREATED_STAMP=?, CREATED_TX_STAMP=? WHERE
PRODUCT_STORE_ID=? (ORA-02291: integrity constraint
(LBIVORY.PROD_STR_VATTXA) violated - parent key not found

Any idea what could have went wrong?

regards
Vinu

--
........................................
<signature>
   <full-name> Vinu Varghese </full-name>
   <company-email> [hidden email] </company-email>
   <company-website> www.x-minds.org </company-website>
   <big-words>
    Success always occurs in private, and failure in full view.
    </big-words>
   <company-name-big>
\/      ._ _   o  ._    _|   _
/\  ~~  | | |  |  | |  (_|  _\                                                        
    </company-name-big>
</signature>


Eric DE MAULDE
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: VAT - Where is it stored?

Eric DE MAULDE
Hi,

To configure the tax system:
- create a party : the tax authority, with the right role
- create a tax authoriry (in accounting) with this party and the geo id
- configure your store with VAT (tax auth party + geo id)
- if your tax authority include a category, add products in this category


Eric
----- Original Message -----
From: "Vinu Varghese" <[hidden email]>
To: <[hidden email]>
Sent: Thursday, February 12, 2009 12:18 PM
Subject: VAT - Where is it stored?


Hi all,

I am trying to create a Product store, I checked 'Show prices with VAT
tax included' = Y, and then it asked for Vat tax Auth geo id and Vat tax
auth party id, I selected from the lookup window, upon updating the
product store, it threw and exception

Error while updating:
[GenericEntity:ProductStore][addToCartRemoveIncompat,Y(java.lang.String)][addToCartReplaceUpsell,Y(java.lang.String)][allowPassword,Y(java.lang.String)][authDeclinedMessage,null()][authErrorMessage,null()][authFraudMessage,null()][autoApproveInvoice,Y(java.lang.String)][autoApproveOrder,Y(java.lang.String)][autoApproveReviews,N(java.lang.String)][autoInvoiceDigitalItems,Y(java.lang.String)][autoOrderCcTryExp,Y(java.lang.String)][autoOrderCcTryLaterMax,null()][autoOrderCcTryLaterNsf,Y(java.lang.String)][autoOrderCcTryOtherCards,Y(java.lang.String)][autoSaveCart,N(java.lang.String)][balanceResOnOrderCreation,N(java.lang.String)][checkGcBalance,N(java.lang.String)][checkInventory,Y(java.lang.String)][companyName,Avg(java.lang.String)][createdStamp,2009-02-12
16:39:28.419(java.sql.Timestamp)][createdTxStamp,2009-02-12
16:39:28.372(java.sql.Timestamp)][daysToCancelNonPay,null()][defaultCurrencyUomId,USD(java.lang.String)][defaultLocaleString,null()][defaultPassword,null()][defaultSalesChannelEnumId,null()][digProdUploadCategoryId,null()][digitalItemApprovedStatus,ITEM_APPROVED(java.lang.String)][enableAutoSuggestionList,N(java.lang.String)][enableDigProdUpload,N(java.lang.String)][explodeOrderItems,N(java.lang.String)][headerApprovedStatus,ORDER_APPROVED(java.lang.String)][headerCancelStatus,ORDER_CANCELLED(java.lang.String)][headerDeclinedStatus,ORDER_REJECTED(java.lang.String)][headerLogo,null()][headerMiddleBackground,null()][headerRightBackground,null()][inventoryFacilityId,MyRetailStore(java.lang.String)][isDemoStore,Y(java.lang.String)][isImmediatelyFulfilled,N(java.lang.String)][itemApprovedStatus,ITEM_APPROVED(java.lang.String)][itemCancelStatus,ITEM_CANCELLED(java.lang.String)][itemDeclinedStatus,ITEM_REJECTED(java.lang.String)][lastUpdatedStamp,2009-02-12
16:41:52.183(java.sql.Timestamp)][lastUpdatedTxStamp,2009-02-12
16:41:52.089(java.sql.Timestamp)][manualAuthIsCapture,N(java.lang.String)][oneInventoryFacility,Y(java.lang.String)][orderNumberPrefix,null()][payToPartyId,null()][primaryStoreGroupId,_NA_(java.lang.String)][prodSearchExcludeVariants,Y(java.lang.String)][productStoreId,10003(java.lang.String)][prorateShipping,Y(java.lang.String)][prorateTaxes,Y(java.lang.String)][reqReturnInventoryReceive,null()][reqShipAddrForDigItems,Y(java.lang.String)][requireCustomerRole,N(java.lang.String)][requireInventory,N(java.lang.String)][requirementMethodEnumId,PRODRQM_NONE(java.lang.String)][reserveInventory,Y(java.lang.String)][reserveOrderEnumId,null()][retryFailedAuths,Y(java.lang.String)][selectPaymentTypePerItem,N(java.lang.String)][setOwnerUponIssuance,null()][shipIfCaptureFails,Y(java.lang.String)][showCheckoutGiftOptions,Y(java.lang.String)][showPricesWithVatTax,Y(java.lang.String)][showTaxIsExempt,Y(java.lang.String)][splitPayPrefPerShpGrp,Y(java.lang.String)][storeCreditValidDays,null(
 )][storeName,AVG(java.lang.String)][styleSheet,null()][subtitle,AVG(java.lang.String)][title,AVG
STORE(java.lang.String)][usePrimaryEmailUsername,N(java.lang.String)][vatTaxAuthGeoId,DEU(java.lang.String)][vatTaxAuthPartyId,10010(java.lang.String)][viewCartOnAdd,N(java.lang.String)]
(SQL Exception while executing the following:UPDATE
lbivory.PRODUCT_STORE SET PRIMARY_STORE_GROUP_ID=?, STORE_NAME=?,
COMPANY_NAME=?, TITLE=?, SUBTITLE=?, PAY_TO_PARTY_ID=?,
DAYS_TO_CANCEL_NON_PAY=?, MANUAL_AUTH_IS_CAPTURE=?, PRORATE_SHIPPING=?,
PRORATE_TAXES=?, VIEW_CART_ON_ADD=?, AUTO_SAVE_CART=?,
AUTO_APPROVE_REVIEWS=?, IS_DEMO_STORE=?, IS_IMMEDIATELY_FULFILLED=?,
INVENTORY_FACILITY_ID=?, ONE_INVENTORY_FACILITY=?, CHECK_INVENTORY=?,
RESERVE_INVENTORY=?, RESERVE_ORDER_ENUM_ID=?, REQUIRE_INVENTORY=?,
BALANCE_RES_ON_ORDER_CREATION=?, REQUIREMENT_METHOD_ENUM_ID=?,
ORDER_NUMBER_PREFIX=?, DEFAULT_LOCALE_STRING=?,
DEFAULT_CURRENCY_UOM_ID=?, DEFAULT_SALES_CHANNEL_ENUM_ID=?,
ALLOW_PASSWORD=?, DEFAULT_PASSWORD=?, EXPLODE_ORDER_ITEMS=?,
CHECK_GC_BALANCE=?, RETRY_FAILED_AUTHS=?, HEADER_APPROVED_STATUS=?,
ITEM_APPROVED_STATUS=?, DIGITAL_ITEM_APPROVED_STATUS=?,
HEADER_DECLINED_STATUS=?, ITEM_DECLINED_STATUS=?,
HEADER_CANCEL_STATUS=?, ITEM_CANCEL_STATUS=?, AUTH_DECLINED_MESSAGE=?,
AUTH_FRAUD_MESSAGE=?, AUTH_ERROR_MESSAGE=?, STYLE_SHEET=?,
HEADER_LOGO=?, HEADER_MIDDLE_BACKGROUND=?, HEADER_RIGHT_BACKGROUND=?,
USE_PRIMARY_EMAIL_USERNAME=?, REQUIRE_CUSTOMER_ROLE=?,
AUTO_INVOICE_DIGITAL_ITEMS=?, REQ_SHIP_ADDR_FOR_DIG_ITEMS=?,
SHOW_CHECKOUT_GIFT_OPTIONS=?, SELECT_PAYMENT_TYPE_PER_ITEM=?,
SHOW_PRICES_WITH_VAT_TAX=?, SHOW_TAX_IS_EXEMPT=?, VAT_TAX_AUTH_GEO_ID=?,
VAT_TAX_AUTH_PARTY_ID=?, ENABLE_AUTO_SUGGESTION_LIST=?,
ENABLE_DIG_PROD_UPLOAD=?, PROD_SEARCH_EXCLUDE_VARIANTS=?,
DIG_PROD_UPLOAD_CATEGORY_ID=?, AUTO_ORDER_CC_TRY_EXP=?,
AUTO_ORDER_CC_TRY_OTHER_CARDS=?, AUTO_ORDER_CC_TRY_LATER_NSF=?,
AUTO_ORDER_CC_TRY_LATER_MAX=?, STORE_CREDIT_VALID_DAYS=?,
AUTO_APPROVE_INVOICE=?, AUTO_APPROVE_ORDER=?, SHIP_IF_CAPTURE_FAILS=?,
SET_OWNER_UPON_ISSUANCE=?, REQ_RETURN_INVENTORY_RECEIVE=?,
ADD_TO_CART_REMOVE_INCOMPAT=?, ADD_TO_CART_REPLACE_UPSELL=?,
SPLIT_PAY_PREF_PER_SHP_GRP=?, LAST_UPDATED_STAMP=?,
LAST_UPDATED_TX_STAMP=?, CREATED_STAMP=?, CREATED_TX_STAMP=? WHERE
PRODUCT_STORE_ID=? (ORA-02291: integrity constraint
(LBIVORY.PROD_STR_VATTXA) violated - parent key not found

Any idea what could have went wrong?

regards
Vinu

--
........................................
<signature>
   <full-name> Vinu Varghese </full-name>
   <company-email> [hidden email] </company-email>
   <company-website> www.x-minds.org </company-website>
   <big-words>
    Success always occurs in private, and failure in full view.
    </big-words>
   <company-name-big>
\/      ._ _   o  ._    _|   _
/\  ~~  | | |  |  | |  (_|  _\
    </company-name-big>
</signature>



Free forum by Nabble Edit this page