Re: Failure in create operation for entity [SalesInvoiceItemFact]
Hi, you are right, this solved the problem. Thanks for the hint. regards, Benni Jacopo Cappellato-4 wrote: Hi, this is an error caused by the missing configuration of the bi (business intelligence) component. You still have probably this line in the entityengine.xml file (where the delegator is defined): group-map group-name=org.ofbiz.olap datasource- name=localderbyolap/ this is the db (Derby) where the bi entities are created. In particular you should have a record with id _NF_ in the DateDimension entity (in localderbyolap): if you add the record (I don't know why it is missing) the error should disappear. Or you can just disable the automatic trigger by removing the following line from the ofbiz-component.xml file of the accounting component: service-resource type=eca loader=main location=servicedef/ secas_olap.xml/ This will solve your issue. Jacopo On Apr 1, 2009, at 9:53 PM, benni23 wrote: Hi, I have a problem with the quickShipEntireOrder function (I am using ofbiz trunk 755618). For an order created in the webshop I suddenly get the following error: ERROR 23503: INSERT on table 'SALES_INVOICE_ITEM_FACT' caused a violation of foreign key constraint 'SIIF_INVDATE' for key (_NF_). Furthermore I have the jdbc Driver of the Derby DB in the stacktrace althoug I configured the entity engine to use postgres: delegator name=default entity-model-reader=main entity-group-reader=main entity-eca-reader=main distributed-cache-clear-enabled=false group-map group-name=org.ofbiz datasource- name=mei_postgres/ group-map group-name=org.ofbiz.olap datasource-name=localderbyolap/ /delegator delegator name=default-no-eca entity-model-reader=main entity-group-reader=main entity-eca-reader=main entity-eca-enabled=false distributed-cache-clear-enabled=false group-map group-name=org.ofbiz datasource- name=mei_postgres/ group-map group-name=org.ofbiz.olap datasource-name=localderbyolap/ /delegator My store settings are as follows: ProductStore productStoreId=9000 storeName=Meilenkontor Webstore companyName=Meilenkontor title=Meilenkontor Meilenshop subtitle=Shop your miles away payToPartyId=Meilenkontor daysToCancelNonPay=30 manualAuthIsCapture=N prorateShipping=N prorateTaxes=Y viewCartOnAdd=N autoSaveCart=N autoApproveReviews=N isDemoStore=N isImmediatelyFulfilled=N inventoryFacilityId=MEIKO_WAREHOUSE01 oneInventoryFacility=Y checkInventory=Y reserveInventory=Y reserveOrderEnumId=INVRO_FIFO_REC requireInventory=N balanceResOnOrderCreation=N orderNumberPrefix=WS defaultLocaleString=de_DE defaultCurrencyUomId=EUR defaultSalesChannelEnumId=WEB_SALES_CHANNEL allowPassword=Y explodeOrderItems=N checkGcBalance=N retryFailedAuths=Y headerApprovedStatus=ORDER_APPROVED itemApprovedStatus=ITEM_APPROVED digitalItemApprovedStatus=ITEM_APPROVED headerDeclinedStatus=ORDER_REJECTED itemDeclinedStatus=ITEM_REJECTED headerCancelStatus=ORDER_CANCELLED itemCancelStatus=ITEM_CANCELLED authDeclinedMessage=There has been a problem with your method of payment. Please try a different method or call customer service. authFraudMessage=Your order has been rejected and your account has been disabled due to fraud. authErrorMessage=Problem connecting to payment processor; we will continue to retry and notify you by email. visualThemeId=MULTIFLEX usePrimaryEmailUsername=N requireCustomerRole=N autoInvoiceDigitalItems=Y reqShipAddrForDigItems=Y showCheckoutGiftOptions=Y selectPaymentTypePerItem=N showPricesWithVatTax=N showTaxIsExempt=N vatTaxAuthGeoId=DEU vatTaxAuthPartyId=FIN_HAM enableAutoSuggestionList=N enableDigProdUpload=N prodSearchExcludeVariants=Y autoOrderCcTryExp=Y autoOrderCcTryOtherCards=Y autoOrderCcTryLaterNsf=Y storeCreditValidDays=90 autoApproveInvoice=Y autoApproveOrder=Y shipIfCaptureFails=Y addToCartRemoveIncompat=Y addToCartReplaceUpsell=Y splitPayPrefPerShpGrp=Y lastUpdatedStamp=2009-04-01 18:08:19.687 lastUpdatedTxStamp=2009-04-01 18:08:19.453 createdStamp=2009-02-27 17:41:18.671 createdTxStamp=2009-02-27 17:41:18.343 / The stacktrace reads: ERROR 23503: INSERT on table 'SALES_INVOICE_ITEM_FACT' caused a violation of foreign key constraint 'SIIF_INVDATE' for key (_NF_). The statement has been rolled back. org.apache.derby.iapi.error.StandardException.newException(Unknown Source) org.apache.derby.impl.sql.execute.ForeignKeyRIChecker.doCheck(Unknown Source)
Re: How to do Shipment for Sales Order
Actually there is no Action box at all. Also I cannot receive more payments (the link is not there), it means payment is fully received. Also I can see an accounting transaction (Incoming Payment) (Cash debit, A/R credit). Regarding my general note about rollback. I had figured out that I had to define some GL accounts mapping etc. But my point was that if a transaction is rolled back, it should be completely rolled back. In my case GL transaction was rolled back but payment was received. (if GL transaction was rolled back payment receival should also be rolled back). In this way the data integerety is lost because payment received and GL transaction couldn't be generated (for whatever reason). Regards Muhammad Aamir On Tue, Mar 31, 2009 at 3:05 PM, Jacques Le Roux jacques.le.r...@les7arts.com wrote: As Sharan explained, looks like you did not enter the rigth amount, maybe because of a separator issue ? Jacques From: Muhammad Aamir m...@aamir.pk Thanks a lot for replying. I tried what you said. However, when I tried to receive the payment and entered the amount as cash and pressed save button, it gave me following error: Failed to create Payment: Cannot get the ProductStore for the order header I clicked the back button and review the Sales order. Product store was there in the header, and I noticed the following in the Payment History box: A new line in status history: Received - 2009-03-29 18:24:47.106 By - [admin] and Max Amount: 10.00 Max Amount: 1000 [Received] Also, there is not accounting transaction or invoice created after that. Regards Muhammad Aamir On Sun, Mar 29, 2009 at 8:44 AM, Sharan-F sharan.f...@gmail.com wrote: Hi Muhammad The default OFBiz Sales Order process is based on the customer paying you before you ship the products. This means that normally for a standard Sales Order the 'Quick Ship Entire Order' button will not be displayed in the action box until you have flagged that you have received the payment from the customer. (Note: There are some cases where the button is displayed but you need to have setup an billing agreement in OFBiz for that customer.) Why dont you try this test: 1. Create a Sales Order 2. Approve the Sales Order 3. Press the 'Receive Payment' button on the Sales Order Screen 4. Enter that you have received the full Sales Order amount in Cash 5. Go back to the Sales Order screen 6. You should find that the 'Quick Ship Entire Order' button is now displayed in the Action box Hope this helps. Thanks Sharan jacques.le.roux wrote: Attachments are not going through on Apache MLs. You may create a Jira issue or attach on the Nabble forum Jacques From: Muhammad Aamir m...@aamir.pk OFBiz trunk. On Thu, Mar 26, 2009 at 11:12 PM, Jacques Le Roux jacques.le.r...@les7arts.com wrote: Are you sure you are using plain *Apache OFBiz* and not one of its forks (ie Opentaps or Neogia) ? Jacques From: Muhammad Aamir m...@aamir.pk Thanks Pratik for the response. There is no such link, actually Action box is not there where I could find it. (Note: the screen shot is attached in first mail) Regards On Wed, Mar 25, 2009 at 7:54 AM, Pratik Khera pratik.kh...@hotwaxmedia.comwrote: Hello Aamir , There is a Label named as Quick Ship Entire Order in Order View Screens on Order Detail Page.You can ship your order from here itself.Also there will be an option named as New Shipment For Ship Group, you can also ship your order from here. Regards Pratik Khera Muhammad Aamir wrote: I created a sales order and then approved, but I couldn't figure out how to ship to order items. There is no link in Sales Order screen for the shipment. (However I noticed that the inventory item have been reserved for the order/shipment). Regards Muhammad Aamir -- View this message in context: http://www.nabble.com/How-to-do-Shipment-for-Sales-Order-tp22694492p22764663.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Issue Inventory Item
I had a look at that feature, this is to transfer inventory item and not to consume. For example a stationary store in an organization issues some inventory to some department (for office use). In this way inventory item is not transferred but being consumed by that department. Regards Muhammad Aamir On Tue, Mar 31, 2009 at 3:15 PM, Jacques Le Roux jacques.le.r...@les7arts.com wrote: Look for facility transfer (Inventory Xfers in menus) Jacques From: Muhammad Aamir m...@aamir.pk In organization not only you sale but you issue items internally as well, for example a certain store issue stationary to all internal departments. How can we do this issuance in ofbiz? Thanks
Re: ofbiz external login problem
If you are creating a back-end application, you can try by copying another controller file. Ecommerce controller has some events different from back end application events. I don't guess anything else from the info you gave. Bilgin On Mar 31, 2009, at 11:45 AM, farouk alhassan wrote: All I have done is use the create-component ant target to create a new component in the hot-deploy directory. Then I have moved the ecommerce controller.xml to replace the generated file. Then all I am doing is overriding the screens as I change them to suit my needs. So technically, I am only changing the views. The only change in the web.xml is to change the storeID. I also allowed /product context to be used to view products which was absent in my revision. (bug)
Re: ofbiz external login problem
The problem is not actually with the ecommerce applivcation or the component I have created. The problem is with other applications specifically the catalog manager and party manger and I am sure I left them as they were. The system is a demo server (for showcase ) so I can give you access to see it for yourself. --- On Fri, 4/3/09, Bilgin Ibryam bibr...@iguanait.com wrote: From: Bilgin Ibryam bibr...@iguanait.com Subject: Re: ofbiz external login problem To: user@ofbiz.apache.org Date: Friday, April 3, 2009, 1:38 AM If you are creating a back-end application, you can try by copying another controller file. Ecommerce controller has some events different from back end application events. I don't guess anything else from the info you gave. Bilgin On Mar 31, 2009, at 11:45 AM, farouk alhassan wrote: All I have done is use the create-component ant target to create a new component in the hot-deploy directory. Then I have moved the ecommerce controller.xml to replace the generated file. Then all I am doing is overriding the screens as I change them to suit my needs. So technically, I am only changing the views. The only change in the web.xml is to change the storeID. I also allowed /product context to be used to view products which was absent in my revision.(bug)
Re: Issue Inventory Item
On Apr 3, 2009, at 11:18 AM, Muhammad Aamir wrote: I had a look at that feature, this is to transfer inventory item and not to consume. For example a stationary store in an organization issues some inventory to some department (for office use). In this way inventory item is not transferred but being consumed by that department. I think this should be a Requirement with type Internal Requirement, but not sure if there is OOTB functionality for issueing items. If you are looking for a fast solution, you can use Inventory Item Variance feature for issueing items. This might not be right way though...it is also possible to assign different GL accounts for these reasons Bilgin
re: r755534 breaks balance sheet Income statement
Hi Adrian Did you have any luck with this over the weekend? Would it be possible to email me the fix? Thank you Rees From: Rees Watkins gat.of...@yahoo.co.uk To: user@ofbiz.apache.org Sent: Friday, 27 March, 2009 9:52:37 Subject: Re: r755534 breaks balance sheet Income statement Hi Adrian If you are able to fix balance sheet and income statement that will be fantastic - thanks. No value figures are appearing on Income statement - not sure if this the same issue. Cheers Rees From: Adrian Crum adri...@hlmksw.com To: user@ofbiz.apache.org Sent: Thursday, 26 March, 2009 17:28:37 Subject: Re: r755534 breaks balance sheet Income statement I will look into this over the weekend. -Adrian
debugging -
Hi I am debugging some ofbiz code in the eclipse debugger. The service createMaintsFromTimeInterval keeps firing and so another thread is activated. This is disruptive because the area I am debugging loses debug focus. Is it possible to turn this timed event off? If I am not using fixed assets do I need to run this service at all? Thanks Rees
Code generation
Hi All, I use ArgoUML to model travel service in NeogiaOfbiz. My question is how can i generate the code from th UML model (format .xmi). Is it with eclipse plugins or other thing like lutingenerator. And if with lutingenerator, how can i use it? Thks best regards. Lahmar. -- View this message in context: http://www.nabble.com/Code-generation-tp22865416p22865416.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Code generation
lahmar a écrit : Hi All, I use ArgoUML to model travel service in NeogiaOfbiz. My question is how can i generate the code from th UML model (format .xmi). Is it with eclipse plugins or other thing like lutingenerator. And if with lutingenerator, how can i use it? Thks best regards. Lahmar. lahmar, this is neogia specific, please use neogia mailing list for don't create noise on ofbiz mailing. thanks
Re: Issue Inventory Item
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Normal accounting is Departments have budgets to by office supplies. they then effectively buy from other departments. This would be then a PO with a order all within the company. so the product is bought(consumed) and shipped to a department. So you set up Accounts for each department which the PO are placed against. I have not implemented this so it is just a general statement. Muhammad Aamir sent the following on 4/3/2009 1:18 AM: I had a look at that feature, this is to transfer inventory item and not to consume. For example a stationary store in an organization issues some inventory to some department (for office use). In this way inventory item is not transferred but being consumed by that department. Regards Muhammad Aamir On Tue, Mar 31, 2009 at 3:15 PM, Jacques Le Roux jacques.le.r...@les7arts.com wrote: Look for facility transfer (Inventory Xfers in menus) Jacques From: Muhammad Aamir m...@aamir.pk In organization not only you sale but you issue items internally as well, for example a certain store issue stationary to all internal departments. How can we do this issuance in ofbiz? Thanks -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJ1eSXrP3NbaWWqE4RAhupAJ42c1zRTwbQWpbbiClmk7As3YF+2ACfW2pX q50VIVw2EVJR5+32S6wUW5M= =VedE -END PGP SIGNATURE-
Re: debugging -
Simply kill the job in Webtools/job list (look for pending status) Jacques From: Rees Watkins gat.of...@yahoo.co.uk Hi I am debugging some ofbiz code in the eclipse debugger. The service createMaintsFromTimeInterval keeps firing and so another thread is activated. This is disruptive because the area I am debugging loses debug focus. Is it possible to turn this timed event off? If I am not using fixed assets do I need to run this service at all? Thanks Rees
Re: r755534 breaks balance sheet Income statement
Rees, Sorry, I got pulled away to work on something else. I'll have time for sure this weekend. -Adrian Rees Watkins wrote: Hi Adrian Did you have any luck with this over the weekend? Would it be possible to email me the fix? Thank you Rees From: Rees Watkins gat.of...@yahoo.co.uk To: user@ofbiz.apache.org Sent: Friday, 27 March, 2009 9:52:37 Subject: Re: r755534 breaks balance sheet Income statement Hi Adrian If you are able to fix balance sheet and income statement that will be fantastic - thanks. No value figures are appearing on Income statement - not sure if this the same issue. Cheers Rees From: Adrian Crum adri...@hlmksw.com To: user@ofbiz.apache.org Sent: Thursday, 26 March, 2009 17:28:37 Subject: Re: r755534 breaks balance sheet Income statement I will look into this over the weekend. -Adrian
Re: debugging -
Just cancel it from the Job Manager in Webtools. -Adrian Rees Watkins wrote: Hi I am debugging some ofbiz code in the eclipse debugger. The service createMaintsFromTimeInterval keeps firing and so another thread is activated. This is disruptive because the area I am debugging loses debug focus. Is it possible to turn this timed event off? If I am not using fixed assets do I need to run this service at all? Thanks Rees
Difference between OFBiz developement version and binary release of ofbiz
Dear members, I am new to the OFBiz.I am learning OFBiz through docs of OFBiz.In that I didn't get the following things. 1.Difference between OFBiz developement version and binary release of ofbiz 2.What is SVN clint.what is the use of it.How to install it. 3. http://www.nabble.com/file/p22877092/OFBiz%2Bdataflow.jpg I am not able to understand the above diagram properly Please help me -- View this message in context: http://www.nabble.com/Difference-between-OFBiz-developement-version-and-binary-release-of-ofbiz-tp22877092p22877092.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Could use some insight for the Manufacturing component/Production Run..productId
Thanks Jacopo. On Thu, Apr 2, 2009 at 10:15 PM, Jacopo Cappellato jacopo.cappell...@hotwaxmedia.com wrote: Hmmm... yes it looks a bit strange. I am wondering if this is related to the work that was done to enhance the way configurations are managed in the system. I don't know much about the details of this but if I am not wrong Bilgin worked on it, and if he is reading this he may provide some hints. Jacopo On Apr 2, 2009, at 3:10 AM, cjhorton wrote: Hi Everyone, I am looking for some insight about something in the Manufacturing component. This isn't a bug, complaint, critique, or issue, but rather just a roadblock in me understanding this stuff. On the ecommerce site I created four orders for configurable PCs. The first three were for identical configurations(2 Gb RAM, 500 Gb HDD, 2nd 500 Gb HDD, modem, and NIC). The fourth was a barebones system with just 1 Gb RAM and a 250 Gb HDD. When I log into the back office and go into the Manufacturing Component and do the lookup for Production Runs I get the information below for the four orders: Production Run Name Product ID QuantityStatus Start Date Description Facility ID 1 Configurable PC-PC assembly 1 1 Created 2009-04-01 13:12:36.518WebStoreWarehouse 10004 Configurable PC-PC assembly 1 5 Created 2009-04-01 13:48:31.877WebStoreWarehouse 10008 Configurable PC-PC assembly 1 3 Created 2009-04-01 13:50:09.294WebStoreWarehouse 10012 Configurable PC-PC assembly 10003 1 Created 2009-04-01 13:57:40.320WebStoreWarehouse If I look at the Order Manager for each order, the productIds are 1, 10001, 10002, and 10003 respectively. I looked in the manufacturing controller and from what I can tell the table above is getting its information from the 'WorkEffortAndGoods view entity which gets information from Work Effort and WorkEffortGoodStandard. My question is: Why does the WorkEffortGoodStandard use the productid 1 for the first three production runs instead their productids(1, 10001, and 10002)? ***If I look in the Product entity, the productIds 1, 10001, and 10002 all use the configId 10003 and the productId 10003 uses configId 10004. It seems that the productId 1 was the first occurence of this configuration so... is it using this for any future work efforts that need to manufacture this? And if so, why not use the productIds as I asked above?** Thank you! -- View this message in context: http://www.nabble.com/Could-use-some-insight-for-the-Manufacturing-component-Production-Run..productId-tp22834772p22834772.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Difference between OFBiz developement version and binary release of ofbiz
On Fri, Apr 3, 2009 at 3:54 PM, sun_arb rsivakumarmc...@gmail.com wrote: Dear members, I am new to the OFBiz.I am learning OFBiz through docs of OFBiz.In that I didn't get the following things. You will want to start with everything on this page here: http://docs.ofbiz.org/display/OFBADMIN/Apache+OFBiz+Getting+Started First, check out the getting Started and get OFBiz up and running. Then, check out the Beginner's Development Guide. 1.Difference between OFBiz developement version and binary release of ofbiz Development(trunk) version is up to date meaning it has new features, fixes, and etc. There will be a new release version soon(search the ML for more information), but you should really use the trunk version now. 2.What is SVN clint.what is the use of it.How to install it. The answer to this question is well beyond the scope of this email, and the following can answer this better than I ever could: http://svnbook.red-bean.com/ 3. http://www.nabble.com/file/p22877092/OFBiz%2Bdataflow.jpg I am not able to understand the above diagram properly Please help me Check out this link: http://docs.ofbiz.org/display/OFBTECH/Framework+Introduction+Videos+and+Diagrams and then check out the transcriptions here: http://docs.ofbiz.org/pages/viewpageattachments.action?pageId=4369 David discusses everything on that diagram. Welcome to OFBiz!
Re: How to do Shipment for Sales Order
It is ok now. It was all about Sales Channel. I was choosing POS Channel. When I selected Web Channel, Action box appeared. Stil have no idea about channels and how to configure them. Thanks On Fri, Apr 3, 2009 at 11:15 AM, Muhammad Aamir m...@aamir.pk wrote: Actually there is no Action box at all. Also I cannot receive more payments (the link is not there), it means payment is fully received. Also I can see an accounting transaction (Incoming Payment) (Cash debit, A/R credit). Regarding my general note about rollback. I had figured out that I had to define some GL accounts mapping etc. But my point was that if a transaction is rolled back, it should be completely rolled back. In my case GL transaction was rolled back but payment was received. (if GL transaction was rolled back payment receival should also be rolled back). In this way the data integerety is lost because payment received and GL transaction couldn't be generated (for whatever reason). Regards Muhammad Aamir On Tue, Mar 31, 2009 at 3:05 PM, Jacques Le Roux jacques.le.r...@les7arts.com wrote: As Sharan explained, looks like you did not enter the rigth amount, maybe because of a separator issue ? Jacques From: Muhammad Aamir m...@aamir.pk Thanks a lot for replying. I tried what you said. However, when I tried to receive the payment and entered the amount as cash and pressed save button, it gave me following error: Failed to create Payment: Cannot get the ProductStore for the order header I clicked the back button and review the Sales order. Product store was there in the header, and I noticed the following in the Payment History box: A new line in status history: Received - 2009-03-29 18:24:47.106 By - [admin] and Max Amount: 10.00 Max Amount: 1000 [Received] Also, there is not accounting transaction or invoice created after that. Regards Muhammad Aamir On Sun, Mar 29, 2009 at 8:44 AM, Sharan-F sharan.f...@gmail.com wrote: Hi Muhammad The default OFBiz Sales Order process is based on the customer paying you before you ship the products. This means that normally for a standard Sales Order the 'Quick Ship Entire Order' button will not be displayed in the action box until you have flagged that you have received the payment from the customer. (Note: There are some cases where the button is displayed but you need to have setup an billing agreement in OFBiz for that customer.) Why dont you try this test: 1. Create a Sales Order 2. Approve the Sales Order 3. Press the 'Receive Payment' button on the Sales Order Screen 4. Enter that you have received the full Sales Order amount in Cash 5. Go back to the Sales Order screen 6. You should find that the 'Quick Ship Entire Order' button is now displayed in the Action box Hope this helps. Thanks Sharan jacques.le.roux wrote: Attachments are not going through on Apache MLs. You may create a Jira issue or attach on the Nabble forum Jacques From: Muhammad Aamir m...@aamir.pk OFBiz trunk. On Thu, Mar 26, 2009 at 11:12 PM, Jacques Le Roux jacques.le.r...@les7arts.com wrote: Are you sure you are using plain *Apache OFBiz* and not one of its forks (ie Opentaps or Neogia) ? Jacques From: Muhammad Aamir m...@aamir.pk Thanks Pratik for the response. There is no such link, actually Action box is not there where I could find it. (Note: the screen shot is attached in first mail) Regards On Wed, Mar 25, 2009 at 7:54 AM, Pratik Khera pratik.kh...@hotwaxmedia.comwrote: Hello Aamir , There is a Label named as Quick Ship Entire Order in Order View Screens on Order Detail Page.You can ship your order from here itself.Also there will be an option named as New Shipment For Ship Group, you can also ship your order from here. Regards Pratik Khera Muhammad Aamir wrote: I created a sales order and then approved, but I couldn't figure out how to ship to order items. There is no link in Sales Order screen for the shipment. (However I noticed that the inventory item have been reserved for the order/shipment). Regards Muhammad Aamir -- View this message in context: http://www.nabble.com/How-to-do-Shipment-for-Sales-Order-tp22694492p22764663.html Sent from the OFBiz - User mailing list archive at Nabble.com.
