Hello,
I'm in charge to test OFbiz as ERP and Management software for our company.
I want to use OFbiz for one of our branch providing custom services in a
specific industry so we do not have any specific catalogue of fixed services or
products with fixed prices.
I downloaded and installed correctly apache-ofbiz-18.12.05. It works correctly.
My first question is: where can I find a comprehensive guide to make the right
setup (not installation) of a company management using OFbiz?
I setup the minimal information for the party registered as a company. I've
created also the party that works like tax authority.
I'm following different guides and videos to understand these steps but I've
not got a comprehensive guide including and describing well these steps.
Right now I have to prepare a first sales offer for a client. I've found only
this guide about this
topics:https://cwiki.apache.org/confluence/display/OFBIZ/Sales+Order+Management+Process+Overview
Thus, following this last guide I've understood I have to create a Product
Store before preparing a sales offer.
So I'm following this guide to create a product
store:https://cwiki.apache.org/confluence/display/OFBENDUSER/Product+Stores
From Catalogue Manager I clicked on the button +New Product Store and I filled
the required information. Clicking on update, I got the following long message
error:
The Following Errors Occurred:
Exception thrown while creating the "newEntity" GenericValue:
org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:ProductStore][addToCartRemoveIncompat,Y(java.lang.String)][addToCartReplaceUpsell,Y(java.lang.String)][allowComment,Y(java.lang.String)][allowPassword,N(java.lang.String)][authDeclinedMessage,null()][authErrorMessage,null()][authFraudMessage,null()][autoApproveInvoice,N(java.lang.String)][autoApproveOrder,N(java.lang.String)][autoApproveReviews,N(java.lang.String)][autoInvoiceDigitalItems,N(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,N(java.lang.String)][companyName,SD
Companies(java.lang.String)][createdStamp,2023-06-12
17:10:57.705(java.sql.Timestamp)][createdTxStamp,2023-06-12
17:10:57.692(java.sql.Timestamp)][daysToCancelNonPay,null()][defaultCurrencyUomId,EUR(java.lang.String)][defaultLocaleString,null()][defaultPassword,null()][defaultSalesChannelEnumId,UNKNWN_SALES_CHANNEL(java.lang.String)][defaultTimeZoneString,IT(java.lang.String)][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)][inventoryFacilityId,10000(java.lang.String)][isDemoStore,N(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,2023-06-12
17:10:57.705(java.sql.Timestamp)][lastUpdatedTxStamp,2023-06-12
17:10:57.692(java.sql.Timestamp)][managedByLot,N(java.lang.String)][manualAuthIsCapture,N(java.lang.String)][oldHeaderLogo,null()][oldHeaderMiddleBackground,null()][oldHeaderRightBackground,null()][oldStyleSheet,null()][oneInventoryFacility,Y(java.lang.String)][orderDecimalQuantity,null()][orderNumberPrefix,SERVIZIO(java.lang.String)][payToPartyId,10000(java.lang.String)][primaryStoreGroupId,null()][prodSearchExcludeVariants,Y(java.lang.String)][productStoreId,10010(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,null()][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)][showOutOfStockProducts,N(java.lang.String)][showPricesWithVatTax,N(java.lang.String)][showTaxIsExempt,N(java.lang.String)][splitPayPrefPerShpGrp,Y(java.lang.String)][storeCreditAccountEnumId,FIN_ACCOUNT(java.lang.String)][storeCreditValidDays,null()][storeName,Servizi
- Ufficio
70022_viaVilla25-1SE(java.lang.String)][subtitle,null()][title,null()][usePrimaryEmailUsername,N(java.lang.String)][vatTaxAuthGeoId,IT-BA(java.lang.String)][vatTaxAuthPartyId,10001(java.lang.String)][viewCartOnAdd,N(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO OFBIZ.PRODUCT_STORE
(PRODUCT_STORE_ID, 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_TIME_ZONE_STRING,
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, VISUAL_THEME_ID, STORE_CREDIT_ACCOUNT_ENUM_ID,
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, MANAGED_BY_LOT, SHOW_OUT_OF_STOCK_PRODUCTS,
ORDER_DECIMAL_QUANTITY, ALLOW_COMMENT, STYLE_SHEET, HEADER_LOGO,
HEADER_MIDDLE_BACKGROUND, HEADER_RIGHT_BACKGROUND, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'PRODUCT_STORE'
caused a violation of foreign key constraint 'PROD_STR_VATTXA' for key (IT-BA,10001). The
statement has been rolled back.)) (Error while inserting:
[GenericEntity:ProductStore][addToCartRemoveIncompat,Y(java.lang.String)][addToCartReplaceUpsell,Y(java.lang.String)][allowComment,Y(java.lang.String)][allowPassword,N(java.lang.String)][authDeclinedMessage,null()][authErrorMessage,null()][authFraudMessage,null()][autoApproveInvoice,N(java.lang.String)][autoApproveOrder,N(java.lang.String)][autoApproveReviews,N(java.lang.String)][autoInvoiceDigitalItems,N(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,N(java.lang.String)][companyName,SD
Companies(java.lang.String)][createdStamp,2023-06-12
17:10:57.705(java.sql.Timestamp)][createdTxStamp,2023-06-12
17:10:57.692(java.sql.Timestamp)][daysToCancelNonPay,null()][defaultCurrencyUomId,EUR(java.lang.String)][defaultLocaleString,null()][defaultPassword,null()][defaultSalesChannelEnumId,UNKNWN_SALES_CHANNEL(java.lang.String)][defaultTimeZoneString,IT(java.lang.String)][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)][inventoryFacilityId,10000(java.lang.String)][isDemoStore,N(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,2023-06-12
17:10:57.705(java.sql.Timestamp)][lastUpdatedTxStamp,2023-06-12
17:10:57.692(java.sql.Timestamp)][managedByLot,N(java.lang.String)][manualAuthIsCapture,N(java.lang.String)][oldHeaderLogo,null()][oldHeaderMiddleBackground,null()][oldHeaderRightBackground,null()][oldStyleSheet,null()][oneInventoryFacility,Y(java.lang.String)][orderDecimalQuantity,null()][orderNumberPrefix,SERVIZIO(java.lang.String)][payToPartyId,10000(java.lang.String)][primaryStoreGroupId,null()][prodSearchExcludeVariants,Y(java.lang.String)][productStoreId,10010(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,null()][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)][showOutOfStockProducts,N(java.lang.String)][showPricesWithVatTax,N(java.lang.String)][showTaxIsExempt,N(java.lang.String)][splitPayPrefPerShpGrp,Y(java.lang.String)][storeCreditAccountEnumId,FIN_ACCOUNT(java.lang.String)][storeCreditValidDays,null()][storeName,Servizi
- Ufficio
70022_viaVilla25-1SE(java.lang.String)][subtitle,null()][title,null()][usePrimaryEmailUsername,N(java.lang.String)][vatTaxAuthGeoId,IT-BA(java.lang.String)][vatTaxAuthPartyId,10001(java.lang.String)][viewCartOnAdd,N(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO OFBIZ.PRODUCT_STORE
(PRODUCT_STORE_ID, 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_TIME_ZONE_STRING,
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, VISUAL_THEME_ID, STORE_CREDIT_ACCOUNT_ENUM_ID,
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, MANAGED_BY_LOT, SHOW_OUT_OF_STOCK_PRODUCTS,
ORDER_DECIMAL_QUANTITY, ALLOW_COMMENT, STYLE_SHEET, HEADER_LOGO,
HEADER_MIDDLE_BACKGROUND, HEADER_RIGHT_BACKGROUND, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'PRODUCT_STORE'
caused a violation of foreign key constraint 'PROD_STR_VATTXA' for key (IT-BA,10001). The
statement has been rolled back.)))
How to get out from this situation?Is there a full guide for this setting
process?
What is the error about?
Thanks
Regards
[Collapse](https://localhost:8443/catalog/control/createProductStore#)
Sent with [Proton Mail](https://proton.me/) secure email.
