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.
