Advanced facility location model
Hi all, In the current model there is possibility to specify only few parameter that describe the inventory items location in a facility(area, aisle, section, level, position). I need to organize possible facility locations with more parameters - 10 for example. Has anybody stumbled upon a similar problem? What would be the best way to extend the existing model to support more location parameters? Thanks in advance, Rashko Rejmer
Re: Advanced facility location model
Hi David, Thanks for the reply. I was thinking of more global and flexible solution, that will give me possibility to add more parameters during production run, but you are right - your approach is faster and easier. Regards, Rashko Rejmer On Fri, 2008-05-23 at 09:36 -0600, David E Jones wrote: > Just add more fields to the FacilityLocation entity. > > -David > > > On May 23, 2008, at 3:47 AM, Rashko Rejmer wrote: > > > Hi all, > > > > In the current model there is possibility to specify only few > > parameter > > that describe the inventory items location in a facility(area, aisle, > > section, level, position). I need to organize possible facility > > locations with more parameters - 10 for example. > > > > Has anybody stumbled upon a similar problem? What would be the best > > way > > to extend the existing model to support more location parameters? > > > > Thanks in advance, > > Rashko Rejmer > > >
Re: Hello, questions about adapting ofbiz to specific needs
Hi khalil, I am not sure if all you need is implemented in OFBiz, but there is "Telecommunications" chapter in "The Data Model Resource Book", Vol 2 book. http://docs.ofbiz.org/display/OFBADMIN/OFBiz+Related+Books You can start your investigation from there and to compare the existing OFBiz data model with this in the book. Hope this helps. Regards, Rashko Rejmer On Fri, 2008-05-23 at 10:52 -0700, skhalil wrote: > First of all, I am new to the world of ofbiz. But from what I have > seen it's > very promising. I am currently preparing a pilot for telecom-specific > needs > and I have some questions :
Custom permissions best practices
Hi, Currently I am working on moving billing account services to the new permissions pattern. https://issues.apache.org/jira/browse/OFBIZ-1811 I was curious about the best practise to customize permission checks. I found in the ML that it is possible to create seca that fetches alternative permissions if there are needed. I was also wandering isn't it better to create separate SecurityPermission records for billing accounts. Something like ACCTG_BILLACT_*. Thanks in advance, Rashko Rejmer
Issue about displaying and reading timestamps
Hi all, I have noticed that all the timestamps that are read from the database are displayed in this format: - yy-MM-dd HH:mm:ss.S with only one sign for milliseconds. the funny thing is that if we read a value from the DB like this 2001-01-01 12:00:00.001 it is rounded to 2001-01-01 12:00:00.1 This issue in visible in this situation(but also in may others): - go to security group FULLADMIN https://demo.hotwaxmedia.com/partymgr/control/EditSecurityGroupUserLogins?groupId=FULLADMIN - then add user to this security group with parameter fromDate = 2001-01-01 12:00:00.001 In the database fromDate parameter is kept this way 2001-01-01 12:00:00.001, but when you try to access it you get 2001-01-01 12:00:00.1. So you are not able anymore to remove this association. I have made example on the demo server with system user login: https://demo.hotwaxmedia.com/partymgr/control/removeUserLoginFromSecurityGroup?userLoginId=system&groupId=FULLADMIN&fromDate=2001-01-01%2012:00:00.1 Regards, Rashko Rejmer
Re: Issue about displaying and reading timestamps
Thanks Adrian for the quick reply. I will create jira for this in a minute. Regards, Rashko Rejmer On Fri, 2008-05-30 at 12:31 -0700, Adrian Crum wrote: > Rashko, > > You are correct. There seems to be a problem with rendering Timestamps - > probably due to localization issues. Open a Jira issue and I'll get to > it sometime soon. > > -Adrian > > Rashko Rejmer wrote: > > Hi all, > > > > I have noticed that all the timestamps that are read from the database > > are displayed in this format: > > - yy-MM-dd HH:mm:ss.S > > with only one sign for milliseconds. > > > > the funny thing is that if we read a value from the DB like this > > 2001-01-01 12:00:00.001 it is rounded to 2001-01-01 12:00:00.1 > > > > This issue in visible in this situation(but also in may others): > > - go to security group FULLADMIN > > https://demo.hotwaxmedia.com/partymgr/control/EditSecurityGroupUserLogins?groupId=FULLADMIN > > - then add user to this security group with parameter fromDate = > > 2001-01-01 12:00:00.001 > > > > In the database fromDate parameter is kept this way 2001-01-01 > > 12:00:00.001, but when you try to access it you get 2001-01-01 > > 12:00:00.1. So you are not able anymore to remove this association. > > > > I have made example on the demo server with system user login: > > https://demo.hotwaxmedia.com/partymgr/control/removeUserLoginFromSecurityGroup?userLoginId=system&groupId=FULLADMIN&fromDate=2001-01-01%2012:00:00.1 > > > > Regards, > > Rashko Rejmer > > > >
Re: minilang question
Hi Carlos, In the action you have this code: You can add expressions to entity-condition element like this You can also combine many condition expressions using element. I am not sure if introduction videos cover this but you can check: http://docs.ofbiz.org/display/OFBTECH/Framework+Introduction+Videos+and +Diagrams Regards, Rashko Rejmer On Mon, 2008-06-02 at 11:07 -0500, Carlos Villavicencio wrote: > Hello, I was reading the exaple component and then in ExampleForms.xml file, > in the ListExamples form, there is an action where it brings data from the > Example table (entity), how I can add conditions like "where" or something > more customized? > > Is there any detailed manual / tutorial with all this things that we > beginners need to start develop in ofbiz. I'm totally lost. > > Thanks in advance.
Manual promotions problem
Hi all, When we apply manual promotion to the shopping cart and then add another item - manual promotions are erased. The same occurs if you try to edit already created order. Is this implemented this way by design or storing already applied manual promotions is missing functionality? Thanks in Advance, Rashko Rejmer
Re: Manual promotions problem
Sorry David, probably my explanation was too short. By "manual promotions" I mean the box that appears in order entry screen when there are promotions, associated to the current store with ProductStorePromoAppl.manualOnly = Y flag. These promotions are not applied automatically to orders. The problem that I have noticed is: Apply manually promotion to an order/shopping cart. Then perform an operation that triggers promotion recreation(adding cart item, changing price, applying another promotion mostly every order/cart change operation). The result is that manually applied promotions are not recreated - they are ignored. E.g if you create an order to which you have manually applied a promotion, and then you try to edit one of the order items of this order(from order summary screen), all manually applied promotions are lost, and you are not able to apply them to the order again. I think that It would be good if manually applied promotions were recreated automatically after every promotion recreation. I was wandering if there are some good reasons not to do this? Regards, Rashko Rejmer On Mon, 2008-06-09 at 12:42 -0600, David E Jones wrote: > What do you mean by a manual promotion? > > What might be easiest is to write a short list of steps to reproduce > and that will help communicate what you're trying to do, what you > expected to happen, and what actually happened. > > -David > > > On Jun 9, 2008, at 12:24 PM, Rashko Rejmer wrote: > > > Hi all, > > > > When we apply manual promotion to the shopping cart and then add > > another > > item - manual promotions are erased. > > The same occurs if you try to edit already created order. > > > > Is this implemented this way by design or storing already applied > > manual > > promotions is missing functionality? > > > > Thanks in Advance, > > Rashko Rejmer > > >
Re: Product Category Hierarchy
Hi Milton, This is not the usual behavior. Probably your category organization is wrong. Maybe this document will help you to organize your catalogs and categories in proper way: http://docs.ofbiz.org/display/OFBENDUSER/Apache+OFBiz+Business+Setup +Guide#ApacheOFBizBusinessSetupGuide-catalogCategoryProductSetup The most important sentence in this part of the document is "...Browse Root (One): this category will be the parent category of all of the top level browse categories for the catalog. It will not be visible to the customer, but it's children will be the main or top-level browse categories." So you have to create one category that will be associated with your catalog as "Browse root". Then you have to create your top level browse categories that should be connected to your browse root category - using ProductCategoryRollup entity. The top level browse categories should not be associated with your catalog. You also can check the demo data. It will help you to get the idea how to create organize your categories. Regards, Rashko Rejmer On Wed, 2008-06-11 at 08:53 -0700, MiltonClark wrote: > I'm working with a large product category hierarchy used for drilling down to > very specific products. I've represented the categories in ProductCategory, > and the hierarchy in ProductCategoryRollup. When I go into the Catalog tab > to use the Browse Catalog window on the left side, all the categories > appear. Is this right? Should only the top categories appear and allow me > to drill down there, or is that only from the actual eCommerce application?
Re: ecommerce category-include screen
Hi, detailScreen is set in product.bsh script. It's value depends of the type of product and also of detailScreen field in Product entity. But if you check product.bsh you will get to all possible values. Regards, Rashko Rejmer On Wed, 2008-06-11 at 21:31 +0200, Grant Edwards wrote: > Hi > > Can someone please point me in the right direction here. Where / how > would I find what ${detailScreen} is referencing. > > In the case of --> name="main-decorator" > location="${parameters.mainDecoratorLocation}", its simple. Just look at > the web.xml. As for ${detailScreen}, I am lost. > > Kind regards > > > Grant Edwards > > > > > > > > > > > > > > > style="head2">${uiLabelMap.ProductCategoryNotFoundforCategoryID} > ${productCategoryId}! > > > > >
Re: ecommerce category-include screen
You can also check category.bsh script. Regards, Rashko Rejmer On Wed, 2008-06-11 at 23:00 +0300, Rashko Rejmer wrote: > Hi, > > detailScreen is set in product.bsh script. > It's value depends of the type of product and also of detailScreen field > in Product entity. But if you check product.bsh you will get to all > possible values. > > Regards, > Rashko Rejmer > > On Wed, 2008-06-11 at 21:31 +0200, Grant Edwards wrote: > > Hi > > > > Can someone please point me in the right direction here. Where / how > > would I find what ${detailScreen} is referencing. > > > > In the case of --> name="main-decorator" > > location="${parameters.mainDecoratorLocation}", its simple. Just look at > > the web.xml. As for ${detailScreen}, I am lost. > > > > Kind regards > > > > > > Grant Edwards > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > style="head2">${uiLabelMap.ProductCategoryNotFoundforCategoryID} > > ${productCategoryId}! > > > > > > > > > > >
Problem with tax recalculation after order item cancellation
Hi all, I have noticed strange behaviour during cancelling order item that posses sales tax adjustments. The status of the item is set to ITEM_CANCELLED and tax adjustments are not removed. Instead of this it is created order header adjustment that compensates order item sales tax adjustments. This was introduced in OFBIZ-461. The reason was that it was not possible to remove OrderAdjustment if one part of the adjustment is already invoiced(OrderAdjustmentBilling is present). After quick shipping the order the tax adjustments for the cancelled order items are ignored and in the invoice is present only the order header tax adjustment that negates the cancelled order item tax adjustments. So the invoice total amount is different from the order total amount. Even if this will be corrected I was wandering if this is the best approach because during order item cancellation it is created only one order header tax adjustment for all order item tax adjustments, without any information about the Tax authorities. The second problem is that order item editing does not follow this pattern. For example if you cancel one order item and then edit the price of another order item, then tax adjustments of the previously cancelled order item(first one) are removed, It is removed also the order header tax adjustment. I was wandering which is the best approach to correct these problems? Any suggestions will be of big help! Regards, Rashko Rejmer
Re: Problem with tax recalculation after order item cancellation
Hi Scott, Thanks a lot about the response. I am interested to get those problems fixed quickly and I will investigate your proposal about updating the OrderAdjustment amount and then I will write again. Regards, Rashko Rejmer On Wed, 2008-06-25 at 23:01 +1200, Scott Gray wrote: > Hi Rashko > > Comments inline, these are just my first thoughts I haven't looked at the > code or entities > > 2008/6/24 Rashko Rejmer <[EMAIL PROTECTED]>: > > > The status of the item is set to ITEM_CANCELLED and tax adjustments are > > not removed. Instead of this it is created order header adjustment that > > compensates order item sales tax adjustments. This was introduced in > > OFBIZ-461. The reason was that it was not possible to remove > > OrderAdjustment if one part of the adjustment is already > > invoiced(OrderAdjustmentBilling is present). > > > Instead of creating these balancing adjustments wouldn't it be ok to just > update the OrderAdjustment with the new tax amount? > > After quick shipping the order the tax adjustments for the cancelled > > order items are ignored and in the invoice is present only the order > > header tax adjustment that negates the cancelled order item tax > > adjustments. So the invoice total amount is different from the order > > total amount. > > > This sounds strange because if the order item was cancelled then there > should have been no OrderAdjustmentBillings which would mean we could have > just deleted the order adjustment and not created the balancing adjustments > in the first place. > > Even if this will be corrected I was wandering if this is the best > > approach because during order item cancellation it is created only one > > order header tax adjustment for all order item tax adjustments, without > > any information about the Tax authorities. > > > It sounds like a work around that could do with a better approach > > The second problem is that order item editing does not follow this > > pattern. For example if you cancel one order item and then edit the > > price of another order item, then tax adjustments of the previously > > cancelled order item(first one) are removed, It is removed also the > > order header tax adjustment. > > > Like I said at the top I can't see why we can't just adjust the amounts on > the existing order adjustments, I can't imagine any need to preserve the > original tax amounts. > > Regards > Scott
Re: Problem with tax recalculation after order item cancellation
Hi Scott and all, Sorry for the late reply. Comments inline: On Wed, 2008-06-25 at 23:01 +1200, Scott Gray wrote: > > The status of the item is set to ITEM_CANCELLED and tax adjustments > are > > not removed. Instead of this it is created order header adjustment > that > > compensates order item sales tax adjustments. This was introduced in > > OFBIZ-461. The reason was that it was not possible to remove > > OrderAdjustment if one part of the adjustment is already > > invoiced(OrderAdjustmentBilling is present). > > > Instead of creating these balancing adjustments wouldn't it be ok to > just > update the OrderAdjustment with the new tax amount? I was wandering if it is not better to exclude all adjustments(tax, promotional) of fully canceled order items, from all order amount calculation methods (getOrderSubTotal, getOrderTotal, ...). This way the canceled items will be present in the order, only to keep history of order changes, and they will not be taken into account in all order amount calculations. In this case there would not be necessary to create any balancing adjustments at all. Regards, Rashko Rejmer
Re: Problem with tax recalculation after order item cancellation
Thanks Scott, I will create Jira for this issue. I also think that the easiest way will be to delete existing adjustments when canceling order item. But I will stick only to changing the amount of all adjustments of the item to 0 because in situations when only part of the item is already shipped then there will be problems because of existing OrderAdjustmentBilling records. Do you think that this approach could be applied to promotional and shipping(if any) adjustments of the canceled order items? Regards, Rashko Rejmer On Tue, 2008-07-01 at 22:22 +1200, Scott Gray wrote: > Hi Rashko > > I still think it would be easier to either delete the adjustment or change > the amount as necessary, mostly because it sounds like the easiest fix and I > can't think of any reason why the original values would need to be > maintained. If there's a good reason to keep them then that's fine, I just > can't think of it. > > Regards > Scott > > 2008/7/1 Rashko Rejmer <[EMAIL PROTECTED]>: > > > Hi Scott and all, > > > > Sorry for the late reply. Comments inline: > > > > On Wed, 2008-06-25 at 23:01 +1200, Scott Gray wrote: > > > > The status of the item is set to ITEM_CANCELLED and tax adjustments > > > are > > > > not removed. Instead of this it is created order header adjustment > > > that > > > > compensates order item sales tax adjustments. This was introduced in > > > > OFBIZ-461. The reason was that it was not possible to remove > > > > OrderAdjustment if one part of the adjustment is already > > > > invoiced(OrderAdjustmentBilling is present). > > > > > > > > > Instead of creating these balancing adjustments wouldn't it be ok to > > > just > > > update the OrderAdjustment with the new tax amount? > > > > I was wandering if it is not better to exclude all adjustments(tax, > > promotional) of fully canceled order items, from all order amount > > calculation methods (getOrderSubTotal, getOrderTotal, ...). This way the > > canceled items will be present in the order, only to keep history of > > order changes, and they will not be taken into account in all order > > amount calculations. > > > > In this case there would not be necessary to create any balancing > > adjustments at all. > > > > Regards, > > Rashko Rejmer > > > >
Re: Problem with tax recalculation after order item cancellation
Yes it is possible. I just have created an example on the demo server: https://demo.hotwaxmedia.com/ordermgr/control/orderview?orderId=WSCO10002 Maybe this should be deprecated. Probably it will be better, to make the service to check if part of the item is already shipped and to allow only the rest of the item quantity to be canceled. Regards, Rashko Rejmer On Tue, 2008-07-01 at 23:02 +1200, Scott Gray wrote: > Is it possible to cancel an order item when part of it has already been > shipped? > > -Scott > > 2008/7/1 Rashko Rejmer <[EMAIL PROTECTED]>: > > > Thanks Scott, > > > > I will create Jira for this issue. I also think that the easiest way > > will be to delete existing adjustments when canceling order item. But I > > will stick only to changing the amount of all adjustments of the item to > > 0 because in situations when only part of the item is already shipped > > then there will be problems because of existing OrderAdjustmentBilling > > records. > > Do you think that this approach could be applied to promotional and > > shipping(if any) adjustments of the canceled order items? > > > > Regards, > > Rashko Rejmer > > > > On Tue, 2008-07-01 at 22:22 +1200, Scott Gray wrote: > > > Hi Rashko > > > > > > I still think it would be easier to either delete the adjustment or > > change > > > the amount as necessary, mostly because it sounds like the easiest fix > > and I > > > can't think of any reason why the original values would need to be > > > maintained. If there's a good reason to keep them then that's fine, I > > just > > > can't think of it. > > > > > > Regards > > > Scott > > > > > > 2008/7/1 Rashko Rejmer <[EMAIL PROTECTED]>: > > > > > > > Hi Scott and all, > > > > > > > > Sorry for the late reply. Comments inline: > > > > > > > > On Wed, 2008-06-25 at 23:01 +1200, Scott Gray wrote: > > > > > > The status of the item is set to ITEM_CANCELLED and tax adjustments > > > > > are > > > > > > not removed. Instead of this it is created order header adjustment > > > > > that > > > > > > compensates order item sales tax adjustments. This was introduced > > in > > > > > > OFBIZ-461. The reason was that it was not possible to remove > > > > > > OrderAdjustment if one part of the adjustment is already > > > > > > invoiced(OrderAdjustmentBilling is present). > > > > > > > > > > > > > > > Instead of creating these balancing adjustments wouldn't it be ok to > > > > > just > > > > > update the OrderAdjustment with the new tax amount? > > > > > > > > I was wandering if it is not better to exclude all adjustments(tax, > > > > promotional) of fully canceled order items, from all order amount > > > > calculation methods (getOrderSubTotal, getOrderTotal, ...). This way > > the > > > > canceled items will be present in the order, only to keep history of > > > > order changes, and they will not be taken into account in all order > > > > amount calculations. > > > > > > > > In this case there would not be necessary to create any balancing > > > > adjustments at all. > > > > > > > > Regards, > > > > Rashko Rejmer > > > > > > > > > > > >
Re: how can I delete items from inventory of ofbiz ??
Hi manoj, Just a quick note: You can create "Physical Inventory Variances" for the item from here: e.g. for the inventory item 9000 https://demo.hotwaxmedia.com/facility/control/EditInventoryItem?inventoryItemId=9000&facilityId=WebStoreWarehouse this will create PhysicalInventory and InventoryItemDetail records that will change the inventory item quantity and also will take care of accounting transactions. Regards, Rashko Rejmer On Wed, 2008-07-02 at 05:16 -0700, manoj_aggarwal84 wrote: > hi all, > > Please tell me, how can I delete items from inventory of ofbiz ? > > Thanks, > manoj
Re: VAT - requirements in different countires - HELP
Hi all, Maybe this is a little bit out of the topic but it is connected to VAT implementation. In Colombia applies Withholding of VAT tax. It is called "retention at the source". Part of calculated VAT adjustments are not payed(retained) by the buyer. The value of the retention at source depends on the relationship between the companies(payee and payer). The order and invoice total amounts should include the full amount of the tax, not only the part that issuer will pay to the tax authority. The invoice also should contain information about the amount of the retained tax amounts. If someone else also have similar needs, I will be glad to get involved in the implementation. Regards, Rashko Rejmer
Opinion about order items cancellation and update processes
Hi, I wanted to ask the community about an opinion regarding the way order item cancellation and update are currently implemented. There are differences between these two processes. Order update: Shopping cart is recreated from the order, then appropriate changes are made and the cart is stored again. Order item cancellation is implemented in shorter way, that IMO is little bit incorrect. For example if you cancel only part of an order item, then all corresponding item adjustments(tax, promotion) are not recalculated. They are created balancing order header adjustments for the difference between the previous and new order adjustment amounts. In this thread was proposed not to create balancing adjustments when cancelling order items: http://markmail.org/message/3yv6etafkqo6fuu2 I think that this shorter implementation was considered and implemented because of the problem with inventory reservations, but IMO in the current implementation inventory reservations are not created in a right way also. E.g if you create order that include promotional order items during order item cancellation all promotional order items are cancelled(with their inventory reservation) and the system creates new promotional items if applicable. In many situations they are created unique promotional items, but with new inventory reservations. I will be very glad if someone can confirm that and propose an idea how these processes(order items cancellation and update) should be implemented in a proper way. Regards, Rashko Rejmer
Re: Opinion about order items cancellation and update processes
Hi Jacques, Thanks for the reply. If you are referring to this particular problem: >From http://markmail.org/message/3yv6etafkqo6fuu2 "The second problem is that order item editing does not follow this pattern. For example if you cancel one order item and then edit the price of another order item, then tax adjustments of the previously cancelled order item(first one) are removed, It is removed also the order header tax adjustment." it is still present. I really want to solve it, but I am kind of confused, because order item cancellation and editing processes behave in completely different way. It is not possible to use these 2 functionalities together(on one order), because the results are unpredictable. I applied a patch for some of the issues here: https://issues.apache.org/jira/browse/OFBIZ-1866 , but the main problem is still there. I think that editing and cancellation of order items are close processes and they should be unified, or at least changed in such a way that they do not act against each other. Any suggestions and comments are really welcome. Thanks again! Regards, Rashko Rejmer On Wed, 2008-07-16 at 13:00 +0200, Jacques Le Roux wrote: > Hi Rashko, > > Just to be sure to follow, has the problem exposed at the end of > http://markmail.org/message/3yv6etafkqo6fuu2 already been fixed ? > > Thanks > > Jacques
Re: Attaching documents to invoices.
Hi, I had the same requirement to attach PDF to the invoice. But I resolved it in a different way. I attached the PDF to the party that receives the invoice(partyIdTo). There is 1 : 1 relation between receiver party and invoice. Regard, Rashko Rejmer On Aug 25, 2008, at 3:59 PM, Technology Investor wrote: I would like to be able to associate a scanned invoice with an invoice entry in the accounting module. In some jurisdictions, a scanned image of the invoice is enough for bookkeeping purposes, and thus it is very attractive to have this ability. I see that in the Content application has a data resource entity. Is it possible to simply add this to the invoice entity to get this functionality? - A
SupplierProduct orderQtyIncrements, unitsIncluded, quantityUomId fields?
Hi, Are this fields only informative fields, I was not able to find any code related to them? I thought that their purpose is to handle situations similar to: - supplier sells 6 Coca-colas in packs, but in inventory we want to record colas separately; - conversion between supplier and purchasing company's UOMs. Im I right? Is there a code that performs such a conversions? Regards, Rashko Rejmer
Re: SupplierProduct orderQtyIncrements, unitsIncluded, quantityUomId fields?
Hi Jacques, Thanks about the pointer. I have read the discussion between Jacopo and David and i thought that there is some code that makes automatic conversion but I was surprised when I couldn't find it. It seems that these fields are only informative. Regards, Rashko Rejmer On Aug 29, 2008, at 4:34 PM, Jacques Le Roux wrote: There have been discussions on this in the past. You should find some information there http://www.nabble.com/forum/Search.jtp?local=y&forum=2740&query=unitsIncluded Jacques From: "Rashko Rejmer" <[EMAIL PROTECTED]> Hi, Are this fields only informative fields, I was not able to find any code related to them? I thought that their purpose is to handle situations similar to: - supplier sells 6 Coca-colas in packs, but in inventory we want to record colas separately; - conversion between supplier and purchasing company's UOMs. Im I right? Is there a code that performs such a conversions? Regards, Rashko Rejmer
Re: SupplierProduct orderQtyIncrements, unitsIncluded, quantityUomId fields?
Hi BJ, I also noticed that there is no OOTB implementation about these problems. Probably the only way to handle packs of cola is to define 2 different products: - one for purchasing - 6 x Cola pack - one for selling - 1 Cola and then to create production run that will produce 6 colas from 1 cola pack. I was thinking that it will be more easy to achieve this, thru mentioned fields. Thanks, Rashko Rejmer On Aug 29, 2008, at 4:29 PM, BJ Freeman wrote: Supplier is where you purchase the product. so this would be how the supplier ships the product to your warehouse. to my knowledge there is no code that takes how the supplier ships it to you and how you sell your product, say each. you many also have pricing for the product as the way the supplier ships it, like case. just my 2 cents Rashko Rejmer sent the following on 8/29/2008 1:45 PM: Hi, Are this fields only informative fields, I was not able to find any code related to them? I thought that their purpose is to handle situations similar to: - supplier sells 6 Coca-colas in packs, but in inventory we want to record colas separately; - conversion between supplier and purchasing company's UOMs. Im I right? Is there a code that performs such a conversions? Regards, Rashko Rejmer
Re: SupplierProduct orderQtyIncrements, unitsIncluded, quantityUomId fields?
Thanks Jacques and BJ, I will use the idea with SECA for producing the product that is sold. Thanks very much for the replies. Regards, Rashko Rejmer On Aug 29, 2008, at 6:49 PM, Jacques Le Roux wrote: From: "Rashko Rejmer" <[EMAIL PROTECTED]> Hi BJ, I also noticed that there is no OOTB implementation about these problems. Probably the only way to handle packs of cola is to define 2 different products: - one for purchasing - 6 x Cola pack - one for selling - 1 Cola and then to create production run that will produce 6 colas from 1 cola pack. I was thinking that it will be more easy to achieve this, thru mentioned fields. Yes, AFAIK it's how it's done. Using a SECA as suggested by BJ sounds a way to automate it for now... Jacques Thanks, Rashko Rejmer On Aug 29, 2008, at 4:29 PM, BJ Freeman wrote: Supplier is where you purchase the product. so this would be how the supplier ships the product to your warehouse. to my knowledge there is no code that takes how the supplier ships it to you and how you sell your product, say each. you many also have pricing for the product as the way the supplier ships it, like case. just my 2 cents Rashko Rejmer sent the following on 8/29/2008 1:45 PM: Hi, Are this fields only informative fields, I was not able to find any code related to them? I thought that their purpose is to handle situations similar to: - supplier sells 6 Coca-colas in packs, but in inventory we want to record colas separately; - conversion between supplier and purchasing company's UOMs. Im I right? Is there a code that performs such a conversions? Regards, Rashko Rejmer
Re: process data before and after Fremarker templats
Hi, The best source of information how to process data with groovy are the groovy files. There are a lot of them in OFBiz. Here are some links that could be useful: http://groovy.codehaus.org/ http://docs.ofbiz.org/display/OFBIZ/OFBiz+Beginner%27s+Development+Guide+Using+Practice+Application - part 2, step - 3 http://docs.ofbiz.org/pages/viewpage.action?pageId=4459 http://docs.ofbiz.org/pages/viewpage.action?pageId=4472 Regards, Rashko Rejmer On Oct 28, 2008, at 12:05 AM, Geotek office wrote: Hello Is there some tutorial for processing data before and after freemarker templates? I know that .groovy files are used for this purpose. Đ¢hee files contains beanshell scripts. If there is some tutorial please share with me. 10x all
Re: Howto clean Form Fields after Form is submitted
Hi, One of the tricks that I have used in such situations is to use parameter-name in form field tag. In this case the name of the field can be different from the parameter that will be passed, and because of this form widget will not fill the field with the old data. Hope this helps Rashko Rejmer On Oct 29, 2008, at 2:50 PM, consolex wrote: ok, this is how i always try get forward, the problem is that i dont understand in which part of the framework (presentation or businesslogic) or at which state of the framework flow the action has to be taken. what variable of the servlet-context do i have to delete? Or what XML-Element is responsible for clearing the data? thx BJ Freeman wrote: Look at how a customer, Employee, person are done in the party component. consolex sent the following on 10/29/2008 3:42 AM: Hi, i built some Demo Application to quickadd a Customer, within ofbiz. I used the FormWidget to do this. The Formdata gets posted to an Event, the Event does the mapping and calls the service. But when it returns to the initial view, where data was collected via the form, the form fields show what was entered previously. How to achieve that the form is empty again. I tried deleting the requestAttributes and requestParameters but without success. thx for helping me have a nice day, Michael :confused::confused: -- View this message in context: http://www.nabble.com/Howto-clean-Form-Fields-after-Form-is-submitted-tp20224461p20226382.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Quote to Sales order.
Hi Brijesh, If you want to create quote adjustment that should be connected to a specific quote item you have to use "Quote Item Seq Id" field. I hope I got you problem right. Regards, Rashko Rejmer On Nov 5, 2008, at 8:55 AM, brijesh m wrote: Hi friends, I have created a quote then added items and adjustments towards it. As it is necessary to add adjustments in Quotes in the form of taxes,shipping charges,etc both per item and on total amount I have used "Corresponding Product Id" field in quote adjustments. But "Corresponding Product Id" seems not working because I won't be able to get any adjustments at per item level. Also when I accepted this quote and created a Sales order corresponding to it, it applies both adjustments which I have mentioned in quote and through the tax authorities (which is somewhat not desirable as it is repeating). Is their any better way to deal with this kind of scenario ? If yes please suggest. Thanks Brijesh M.
Re: Prices incl. VAT
Hi Benni, These fields was removed from product entity. http://markmail.org/message/f2zrcxgczndzndkr http://markmail.org/message/l75ijcbaebkjxubm Regards, Rashko Rejmer On Mar 16, 2009, at 6:53 PM, benni23 wrote: Hi all, I am a little confused with the current implementation status of support for prices including VAT (I am using the 10652 version of opentaps 1.0 release). I followed several instructions I found in this and other forums and some documentation about VAT but did not manage to get things to work. What I did is to create a TaxAuthority and respective TaxAuthorityProductRate and set the store to show prices with VAT and assigned it the respective Geo and TaxAuth Ids. I did not make use of categories here as from my understanding those categories are only needed if different rates need to be supported on product level (this could be necessary for example in Germany where there exist different rates for different types of products). The behaviour I got was that the tax rate was applied to all products, which is exactly what I wanted. So far so good. The problem is that the price is only shown correctly on the product detail page and not the minicart or the shopping cart screenlet and even the final order screen shows prices excluding the configured VAT. It seems to me that VAT support is not consistently implemented. But maybe I miss something and this is just a configuration error. For example I did not set the fields "Tax Category", "Tax Duty Code" or "Tax VAT Code" on any product. I only set the field "taxable" to true. Maybe those fields are required by some price or adjustment calculation service? What are these fields used for? I feel that VAT documentation is rather bad here. Can anyone clearify please? These are the documents I read abotu VAT so far: http://docs.ofbiz.org/display/OFBTECH/OFBiz%27s+Tax+Authority+Data+Model http://docs.ofbiz.org/display/OFBIZ/VAT http://www.nabble.com/Creating-price-rules-for-a-country-with-VAT-value-td21954459.html#a22005169 http://www.nabble.com/Sales-Tax-Setup-td20230294.html#a20438576 The posts in the mailing list show that there are some unresolved issues regarding proper VAT setup. Has anyone succeeded in setting up prices including VAT in the ecommerce store? regards, Benni -- View this message in context: http://www.nabble.com/Prices-incl.-VAT-tp22541235p22541235.html Sent from the OFBiz - User mailing list archive at Nabble.com.
GLAccountGroup* entities
Hi all, Is someone using these entities? GLAccountGroup GlAccountGroupType GLAccountGroupMember I have to implement special Gl accounts grouping and I intended to use these entities for this purpose, but I got confused of their structure. GlAccountGroup entity has glAccountGroupTypeId field and GlAccountGroupMember entity also has this field that is part of the pk. I tried to find any information about these entities but they was introduced 4 years ago and couldn't find anything related. Thanks in advance! Rashko Rejmer
Re: GLAccountGroup* entities
David, Jacques, Thank you very much for your responses. These entities are exactly what I need, I need second structure of GL accounts. One(the main one) that is organized using parent-child relationship, gl account type, classes and second one that uses the same GL accounts but organize them in completely different way. I was just wandering why it is introduced a restriction one GL account to be part of just one group type, but I am ok with this restriction, so I will use these entities. Thanks again. Regards, Rashko Rejmer On Mar 17, 2009, at 10:18 PM, David E Jones wrote: On Mar 17, 2009, at 1:12 PM, Jacques Le Roux wrote: As a side note, also GlAccountClass and GlAccountType (though less to the point) are also used for grouping acounts (maybe not in the way you are looking for) Best answer about that so far http://markmail.org/message/hrbdnxoazvcfdpdb They are used to classify accounts, but the main way of "grouping" accounts is through the account hierarchy using the parent account ID on GlAccount itself (ie implements an hierarchy, not a graph). Also here is an old explanation, for GlAccountClass usage, by Si who is the original author of that http://lists.ofbiz.org/pipermail/svn/2006-March/003542.html You mean Si is the original author of that comment? Well... maybe... But I have no ideas for GLAccountGroup usage, maybe yes, for what you are looking for... The basic idea behind GlAccountGroup is to have a structure where an account can be in more than one group (as opposed to the main account hierarchy where an account can only be under one other account). However, there is the restriction that an account can only be in one group per group type (which is why the PK is setup as-is). In cases like this sometimes the demo data is the most useful way to see how it works. The demo data I put together for that, and part of the reason I created those entities, is in the UsTaxAccountGroups.xml file. That use of groups allow you to configure different accounts for different tax form fields and then the totals of those different accounts for each field (group) can be summed up for the tax reporting. -David From: "Rashko Rejmer" Hi all, Is someone using these entities? GLAccountGroup GlAccountGroupType GLAccountGroupMember I have to implement special Gl accounts grouping and I intended to use these entities for this purpose, but I got confused of their structure. GlAccountGroup entity has glAccountGroupTypeId field and GlAccountGroupMember entity also has this field that is part of the pk. I tried to find any information about these entities but they was introduced 4 years ago and couldn't find anything related. Thanks in advance! Rashko Rejmer
Re: how to create Product price for multiple countries????
Hi Kamaraswamy, It depends how you want to organize your stores, catalogs, categories and products. For example you can have different prices for a product, if you define product store group for every country. The second solution will be to use price rules. You can define price rules for a product based on category or catalog. Check the implementation of PriceServices.checkPriceCondition method to get an idea how to define you price rules. Regards, Rashko Rejmer On Mar 25, 2009, at 12:38 PM, Kumaraswamy nandipati wrote: thanks for your reply Jacques. But, I will show my product price in USD only across all the countries and the product price is different for each country. Currently I am using only one product store. Here I created multiple countries(catalogs). Here, For example, a product XYZ which is available for all the countries. But its price is different from each other country(catalog). Here, to maintain different prices , Am I need to create XYZ_country1, XYZ_country2, XYZ_country3 like this and create prices individually? Is this the correct solution? or Any other solution for this by creating only one product(XYZ only) and associate country specific prices to this product. Is this functionality available in ofbiz??? -- Thanks, Kumaraswamy.N 91-9866805250. On Wed, Mar 25, 2009 at 3:03 PM, Jacques Le Roux < jacques.le.r...@les7arts.com> wrote: http://docs.ofbiz.org/display/OFBENDUSER/Product+Stores You set prices in different currencies in your products and you set a store for each currency used Jacques From: "Kumaraswamy nandipati" Hi., I had one product which need to be displayed in multiple countries and the price varies from country to country. Am I required to maintain new productId for same product in each country and add product price individually? OR Is there any alternative for this?(like country specific prices for a single productId) -- Thanks in Advance, Kumaraswamy.N 91-9866805250.
Re: adding column to an entity with out touching original entitymodel.xml
Hi Aswath, You can try ... entity> There are plenty of examples in the code. e.g. applications/commonext/entitydef/entitymodel.xml Regards, Rashko Rejmer On 9 Oct 2009, at 17:01, aswath narayana wrote: Hello, I am planning to add a column to an Entity, say TaxAuthority. Is there any other way to add the column without touching the original entitymodel.xml. The reason I am asking is for ease of development and customization * I can keep my changes in a different file * I can still get the latest ofbiz sources without having to worry about merging/conflicts Thanks -Aswath
Re: Assigning Party to catalog
Hi Alexander, I suppose that you get this error because the party that you are trying to associate to pixelfiles_fotos catalog is missing Vendor role. You have to add this role to the party before you try to assign it to the catalog. Go to party profile and assign Vendor role to it. https://demo.ofbiz.org/partymgr/control/viewroles?partyId=10011 Regards, Rashko Rejmer On 11 Oct 2009, at 17:24, Alexander1893 wrote: Hi all, I tried to assign a party as a "vendor" to a catalog using "Add Product Catalog Parties" under "catalog > parties". This is what I get: The Following Errors Occurred: ERROR: Could not complete the Add ProdCatalog To Party [file:/#:/##/##/ofbiz/ofbiz-trunk/applications/product/script/org/ ofbiz/product/catalog/CatalogServices.xml#addProdCatalogToParty] process [problem creating the newEntity value: Error while inserting: [GenericEntity:ProdCatalogRole][createdStamp,2009-10-11 16:19:50.484(java.sql.Timestamp)][createdTxStamp,2009-10-11 16:19:50.421(java.sql.Timestamp)][fromDate,2009-10-11 16:19:50.484(java.sql.Timestamp)][lastUpdatedStamp,2009-10-11 16:19:50.484(java.sql.Timestamp)][lastUpdatedTxStamp,2009-10-11 16:19:50.421(java.sql.Timestamp)][partyId,10011(java.lang.String)] [prodCatalogId,pixelfiles_fotos(java.lang.String)] [roleTypeId,VENDOR(java.lang.String)][sequenceNum,null()] [thruDate,null()] (SQL Exception while executing the following:INSERT INTO OFBIZ.PROD_CATALOG_ROLE (PARTY_ID, ROLE_TYPE_ID, PROD_CATALOG_ID, FROM_DATE, THRU_DATE, SEQUENCE_NUM, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'PROD_CATALOG_ROLE' caused a violation of foreign key constraint 'PCATRLE_PTYRLE' for key (10011,VENDOR). The statement has been rolled back.))] Can anyone help? Thanks in advance. Alexander -- View this message in context: http://www.nabble.com/Assigning-Party-to-catalog-tp25843806p25843806.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Adding menu items to leftbar in sfa
Hi Pierre, You can check leftbar screen here applications/marketing/widget/sfa/ CommonScreens.xml In this screen there are 2 screenlets: "Quick Add Contact" and "Quick Add Lead". If you want to remove these screenlets you can just comment them. Then you can add your own content to this screen. Regards, Rashko Rejmer On 12 Oct 2009, at 15:56, Pierre Smits wrote: Dear all, Currently in the leftbar menu of the SFA there are some small forms for adding contacts and leads. I want to replace those with a list of shortcuts. These shortcuts can contain hyperlinks to urls within ofbiz and outside of ofbiz. How do I do this? Regards, Pierre
Re: Need help on service definition
Hi Weixue, I also have noticed that such feature would be really handy. Recently I had a problem with group services. I wanted to create group service that consists of two existing ofbiz services, but the second one was expecting a parameter with different name than the first one was passing as out parameter. Actually I resolved the problem by implementing third service that was just renaming the parameter, but this was just a trick. Actually for solving your problem you can try similar thing - to use ensurePartyRole service for partyId and roleTypeIdTo and then to create small wrapper service(something like ensureFromPartyRole) that will just change parameter names and then will call ensurePartyRole service. It will be good to have an functionality that renames out parameters or looks for parameter with different name in such specific situations(secas, group services, ecas). Something like: Regards, Rashko Rejmer On 20 Oct 2009, at 15:08, Weixue Zhang wrote: I want to implement below business logic which is a little different from current partymgr implementation: 1.Setup below relationship between two parties: partyIdFrom: party1 partyIdTo: party2 roleTypeIdFrom: EMPLOYEE roleTypeIdTo: ORGANIZATION_ROLE 2. before doing above, the system need to AUTOMATICALLY set EMPLOYEE role to party1 and ORGANIZATION_ROLE to party2 if they are not set. I attempted to set createPartyRole service as an action of createPartyRelationship service in seca, but it doesn't work because there are no parameters partyId and roleTypeId for createPartyRole services. Above business logic is just for an example, actually I have met many other similar cases in development. When writing services, we are not quite certain which services will be chained through SECA later, and it's hard to make possible chained services have same parameter names (e.g. one service needs a parameter named partyId, other services may need the same parameter but named partyIdFrom). So I think a mechanism that can set parameters again before calling will provide more flexibility and improve reuse of existing services. Could someone tell me if such mechanism exists in Ofbiz or how I can resolve above problem? Many thanks, -Weixue.
Re: Relationship tab in Party Management
Hello Naveen, Party Relationship tab is the exact place for fulfilling your example. There you can create relationship between two parties. For example you can check here: https://demo.ofbiz.org/partymgr/control/EditPartyRelationships?partyId=DemoCustAgent There you can find example relationship of type agent between DemoCustAgent and DemoCustCompany parties. You have to remember that before creating any relationship, the parties should posses the roles that you will use. Another important thing is "is A" field that actually represents the relation type(in this example agent). Regards, Rashko Rejmer On 21 Oct 2009, at 14:54, naveenchanda wrote: Dear All, I would like to know, the exact usage of Relationship tab under the Party. could any one explain me, the steps to use this functionality. How can i relate one role with another ? For e.g. if i create a person such as Testperson than how can i identify this person is a Customer or Vendor or he is belonging to a partygroup. Please explain me. Thanks and Regards, Naveen Chanda -- View this message in context: http://n4.nabble.com/Relationship-tab-in-Party-Management-tp275993p275993.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Question about Billing Accounts
Hi all, Jacopo, I have noticed couple of issues that are connected to billing accounts, but I am not so familiar with accounting processes and I want to ask couple of question(maybe Jacopo would give me answers). 1. After the recent re-factoring of billing accounts every order that is created and payed with billing account is associated to this particular account. The invoice for this order is associate to the account too. I was wondering how the payment for this invoice should be applied to the invoice and billing account: - only to the billing account; - to the billing account and invoice; - only to the invoice; I think that the payment should be applied to the both, but I am not sure. 2. What is the meaning of the term "billing account available balance"? The method that calculates this value (getBillingAccountAvailableBalance) performs this formula: availableBalance = accountLimit - accountBalance; so if they are created orders with amount 200$, payed via billing account(but the payments are not received yet) and the account limit is 1$ availableBalance = 200$ = 1(limit) - 9800(billing account balance); Is this correct? I mean the name of this value. 3. What is the meaning of the term "billing account net balance"? 4. What is the meaning of the term "amount available to capture"? The comment of the method that calculates this amount is: "Returns the amount of the billing account which could be captured" the only place that this method is used is while payments are applied to billing and there is a comment: "when creating a new PaymentApplication, check if there is sufficient balance in the billing account" but the method performs this formula: availableToCapture = accountLimit - accountNetBalance If we use the mentioned situation: availableToCapture = 1; because the accountNetBalance = 0; I think that this is a little bit confusing. Sorry about the big amount of the questions but if someone can clarify to me these terms, that are accepted in OFBiz, maybe I would be able to create some issues, that would improve the billing accounts behavior. Regards, Rashko Rejmer -- View this message in context: http://www.nabble.com/Question-about-Billing-Accounts-tf4056081.html#a11521720 Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Question about Billing Accounts
Hi Jacopo, BIG thanks about explanations. Now I have clear picture about the billing account re-factoring. >I don't think we should use the >BillingAccountWorker.getBillingAccountBalance(...) call (in >InvoiceServices at line 2348) and we have to probably change it to >BillingAccountWorker.getBillingAccountBalance(...) >Do you have a chance to try to apply this change? I will try to review this part of the code. I will create Jira issue for this. >a) if you receive a payment for an invoice (i.e. the invoice is already >in the system, and is associated to the billing account) you can simply >apply it to the invoice as usual (the system will automatically >associate it to the billing account as well) I have tried this and the problem is that the system doesn't associate the payment to the billing account. I will try to review why this is happening and if I figured out I will create an issue too. It will be great if I can help you with billing account re-factoring process. Thanks again, Rashko Rejmer -- View this message in context: http://www.nabble.com/Question-about-Billing-Accounts-tf4056081.html#a11538064 Sent from the OFBiz - User mailing list archive at Nabble.com.
Invoice items editing and removing
Hi, I have a question about editing invoice items. It is possible to edit or remove invoices items when the status of the invoice is "INVOICE_IN_PROCESS". So we can change the product invoice items quantity, price etc., but if the item has child items(e.g tax items that are calculated by % of the item sub-total) their amounts are not recalculated depending of changed parent item total amount. I was willing to ask if this is made intentionally(e.g accountant to have ability manually to change every amount of the invoice items) or this ability is not yet implemented in OFBiz? Regards, Rashko Rejmer -- View this message in context: http://www.nabble.com/Invoice-items-editing-and-removing-tf4341196.html#a12366250 Sent from the OFBiz - User mailing list archive at Nabble.com.
One invoice for many orders payed with different billing accounts problem
Hi all, I was faced with a problem while creating invoice from few orders. I made a research in the ml and found that DB of OFBiz fully supports this functionality. The only problem is that there is no such a implementation. I implemented my own method that creats invoice for all open orders in a billing account. Then I tried to generalize my implementation and to created so functional method that will be able to create one invoice for couple of orders, no matter how they were payed. And here is the problem. Because of the DB relation between BillingAccount and Invoice entities(invoice.billingAccountId field) there is no possibility to create invoice for 2 orders that are payed with 2 different billing accounts. I will be glad if someone give me some suggestions how to workarround this problem. Regards, Rashko Rejmer -- View this message in context: http://www.nabble.com/One-invoice-for-many-orders-payed-with-different-billing-accounts-problem-tf4416614.html#a12597253 Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: More Confusion
Hi Skip, I don't know if this might help. Do you have financials component in your hot-deploy folder? I have encountered the same issue and the problem was because Financials component have different approach for handling payments with billing accounts. I my case the problem was that the opentaps service captureBillingAccountPayments (com.opensourcestrategies.financials.accounts.BillingAccountServices) overrides the existing OFBiz service with the same name. These services have complately different logic - the ofbiz one don't create payment but opentaps creates. Regards, Rashko Rejmer -- View this message in context: http://www.nabble.com/More-Confusion-tf4427228.html#a12635900 Sent from the OFBiz - User mailing list archive at Nabble.com.
RE: Billing Accounts
Hi Skip, I also noticed this problem and maybe this will help you. If you create order that is payed with billing account(BA) then in OrderPaymentPreference entity is created record with status PAYMENT_NOT_RECEIVED. The account balance is calculated considering this entries and payments that are applied to the billing account, but are not applied to the invoice. Everything is OK if you create order, then invoice it, then create payment and apply it only to the BA(the best UI is throught the new form and service that Jacopo created recently r574962 - https://demo.hotwaxmedia.com/accounting/control/BillingAccountPayments?billingAccountId=9010) and then use the capture ability from the BA -> invoices screen to apply this payment to the invoice too. In that case the the BA balance behaves as it should. This is because capture ability invokes the service "processCaptureSplitPayment" that takes care to update the status of the OrderPaymentPreference entries(changes it to PAYMENT_RECEIVED). The problem is if you apply payments to the invoice from another UI(E.g https://demo.hotwaxmedia.com/accounting/control/editPaymentApplications?paymentId=demo1) the OrderPaymentPreference record is not updated - so BA balance is wrong. I was willing to fix this but had no time to do it. Regards, Rashko Rejmer -- View this message in context: http://www.nabble.com/Billing-Accounts-tf4438293.html#a12665336 Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Billing Accounts
Hi Jacopo, Yes, you are right. If you apply payment only to the billing account everything is OK. If you apply it to the invoice that is associated to the billing account the updatePaymenetApplication method will automatically apply this payment to the BA too. So the problem appear if you fill only invoiceId field too. Regards, Rashko Rejmer On Sat, 2007-09-15 at 09:20 +0200, Jacopo Cappellato wrote: > Rashko, > > is it possible that the error you are seeing, when applying a payment to > a billing account using the generic screen, is happening only if you > fill both the invoiceId and billingAccountId fields and submit the form? > If you just fill the billingAccountId field it should work as expected. > > Could you please confirm if my guess is right? > > Jacopo > > > Rashko Rejmer wrote: > > Hi Skip, > > > > I also noticed this problem and maybe this will help you. If you create > > order that is payed with billing account(BA) then in OrderPaymentPreference > > entity is created record with status PAYMENT_NOT_RECEIVED. The account > > balance is calculated considering this entries and payments that are applied > > to the billing account, but are not applied to the invoice. > > Everything is OK if you create order, then invoice it, then create payment > > and apply it only to the BA(the best UI is throught the new form and service > > that Jacopo created recently r574962 - > > https://demo.hotwaxmedia.com/accounting/control/BillingAccountPayments?billingAccountId=9010) > > and then use the capture ability from the BA -> invoices screen to apply > > this payment to the invoice too. In that case the the BA balance behaves as > > it should. This is because capture ability invokes the service > > "processCaptureSplitPayment" that takes care to update the status of the > > OrderPaymentPreference entries(changes it to PAYMENT_RECEIVED). > > > > The problem is if you apply payments to the invoice from another UI(E.g > > https://demo.hotwaxmedia.com/accounting/control/editPaymentApplications?paymentId=demo10000) > > the OrderPaymentPreference record is not updated - so BA balance is wrong. > > > > I was willing to fix this but had no time to do it. > > > > Regards, > > Rashko Rejmer > >
Order payed with few billing accounts
Hi all, I wanted to ask the community for opinion about ability orders/invoices to be payed with multiple billing accounts. I research the ml and jira and found that there are different points of view on this topic(https://issues.apache.org/jira/browse/OFBIZ-682). Now I have to implement ability to pay order with more then one billing accounts and to be able to create invoice from orders that are payed with different billing accounts. Now I have to implement ability to pay order with more then one billing accounts and to be able to create invoice from orders that are payed with different billing accounts. Personally, I am inclined to agree with Si's opinion that it is be better if billingAccountId field is located at OrderPaymentPreference entity to achieve this ability. I was wondering what are the disadvantages of this idea. I will be happy if you share your opinion on this with me. Regards, Rashko Rejmer -- View this message in context: http://www.nabble.com/Order-payed-with-few-billing-accounts-tf4466514.html#a12735296 Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Order payed with few billing accounts
Hi Jonathon, Thanks for repaying on this post. > Adding billingAcountId to OrderPaymentPreference should be the easiest way to > go about it. > I can't remember what I added for OrderPaymentPreference. But I do remember > that I REALLY liked > how there can be multiple OrderPaymentPreference(s) per OrderHeader, multiple > ways to pay for an > order. I am glad to hear that someone has achieved such a functionality before with the same idea. So I will try to accomplish it the same way. > I can't see any disadvantage to this solution. You will likely have to do > some core/important > changes to PaymentGatewayServices.java, I think. I am aware of this problem. I was looking at PaymentGatewayServices.java and yes there will be need to change the logic in few services. > The only disadvantage, possibly, is that there > might be considerable "change propagation" effort if there are a lot of other > codes that ASSUME > there's only one billing account per order. Yes this is problem and I will try to find all these places. Now I can't remember such places except the code that is related to billing accounts. Do you have any idea how to handle creation of one invoice for orders that are payed with different BA. The problem is DB relation between BillingAccount and Invoice entities(invoice.billingAccountId field). Thanks a lot, Rashko Rejmer
Offline payment applied to billing account
I wanted to ask about the snippet of code in InvoiceServices.createInvoiceForOrder(lines 760-791) method that creates payment applications for payments, received before creation of invoice. Parameter billingAccountId is passed to the service createPaymentApplication. So every payment that was received before creation of invoice is applied to the created invoice and billing account(if the invoice was paid with BA and another payment method E.g offline payment). I will give example: 1. Create invoice for 100 $; 2. Pay the invoice with billing account(40$) and with offline payment method(the rest - 60$); 3. Receive Offline payment for 40$ before creation of invoice(orderview screen); 4. Quick ship entire order; Now received offline payment is applied to invoice and billing account. I know that this situation doesn't affect billing account available balance but I was curious if this is right or not. Thanks, Rashko Rejmer -- View this message in context: http://www.nabble.com/Offline-payment-applied-to-billing-account-tf4721638.html#a13498972 Sent from the OFBiz - User mailing list archive at Nabble.com.
Rounding problem
I wanted to ask about weird situation that I noticed. I created an order and at the order view screen I noticed that there is difference between the order grand total and the components of the order Items SubTotal = $183.91 Total Other Order Adjustments = -$18.39 Total Shipping and Handling = $10.70 Total Sales Tax = $12.54 Sum is $188.76 __ Total Due = $188.75 The difference is of 0.01$ Firsth i thought that there is no big problem but then i created 2 difference invoices for this order and the sum of the invoices was also $188.76 I think that this difference is because of different concepts for invoice and order rounding. I wanted to ask if this is normal and how OFBiz is supposed to handle that kind of rounding problems.
Re: Rounding problem
Hi Scott, The problem occurs in very very specific orders. Here are the EXACT steps: Start creating order with DemoCustCompany party Add to cart - GZ-1000 x 5 - GZ-1001 x 5 Then create 2 ship groups for the order - for each of the ship groups chose the second shipping address(US-CA) of the DemoCustCompany party Then move to the second shipping group one of the items GZ-1000 or GZ-1001. Then use shipment method for the first shipping group - "UPS Guaranteed Next Day - $10.70" and for the second shipping group "No shipping" Pay the order with whatever you want(but use only ONE payment method). Do NOT add any additional parties. Create the order. The total amount of the order should be 188.75(this is with clean copy of ofbiz, after run install).If this is the third order you create with this party then you might get different grand total, because the promos are over and there aren`t any more of them. Then "Quick ship entire order". The sum of the two invoices is 188.76 but the order grand total is 188.75 I created example on the demo server - order WSCO10009 with invoices CI7, CI8 https://demo.hotwaxmedia.com/ordermgr/control/orderview?orderId=WSCO10009 I will be glad to hear your opinion about this situation. I have investigated this very deeply and I have idea why this is happening but I wanted first to know if this is a bug or not. Rashko Rejmer On Fri, 2007-12-07 at 07:43 +1300, Scott Gray wrote: > Hi Rashko > > I think you'll find it's some sort of rounding error in the order code > which will need to be tracked down. If you don't have time to look, > could you provide some steps to possibly reproduce on a demo install > and I'll take a look when I get a chance. > > Thanks > Scott > > On 07/12/2007, Rashko Rejmer <[EMAIL PROTECTED]> wrote: > I wanted to ask about weird situation that I noticed. > I created an order and at the order view screen I noticed that > there is > difference between the order grand total and the components of > the order > > Items SubTotal = $183.91 > Total Other Order Adjustments = -$18.39 > Total Shipping and Handling = $10.70 > Total Sales Tax = $12.54 > Sum is $188.76 > __ > Total Due = > $188.75 > > The difference is of 0.01$ > Firsth i thought that there is no big problem but then i > created 2 > difference invoices for this order and the sum of the invoices > was also > $188.76 > I think that this difference is because of different concepts > for > invoice and order rounding. > I wanted to ask if this is normal and how OFBiz is supposed to > handle > that kind of rounding problems. > >
Re: Rounding problem
Skott, I think that you are right. I was investigating Order total and order components(Items SubTotal, Total Other Order Adjustments, Total Shipping and Handling, Total Sales Tax) rounding. When order tax adjustments are calculated they are rounded for every item. Exactly what you provided - 6.497 + 1.04 = 7.537 (rounded 7.54) - 4.997 (rounded 5.00) I saw your commit that changed that - r602011 but when order grand total is calculated then tax adjustments are rounded together - 6.497 + 1.04 + 4.997 = 12.534 (12.53) this is performed in OrderReadHelper.getOrderItemsTotal I was willing to check also how ShoppingCart.getGrandTotal calculates order total before order creation. About the second problem I also think that it is impossible to solve it in usual way. When invoice total is calculated, the tax items are calculated separately and rounded after that, so the rounding that was made in the order(on the order item basis) is lost. On the other side(exactly what you said) if the order is invoiced to few invoices then there will be situations when the tax roundings will be inaccurate. I very loved your idea about additional adjustment to the invoice that will correct the final amount. Can somebody give me some suggestions how to implement that? I will continue with investigation. Regards, Rashko Rejmer On Fri, 2007-12-07 at 19:10 +1300, Scott Gray wrote: > Hi Rashko > > There seems to be 2 issues going on here, one can be fixed the other > can't. > > The order total is correct at 188.75 but the tax total is incorrect: > 4.997 + 6.497 + 1.04 = 12.534 (rounded 12.53) not 12.54 > That can be fixed, I'll commit it shortly. > > The other issue is that the order is then split into 2 invoices: > Tax on invoice #1: 6.497 + 1.04 = 7.537 (rounded 7.54) > Tax on invoice #2: 4.997 (rounded 5.00) > Total tax for both invoices = 12.54 as opposed to the order tax total > which should be 12.53 > This one I have no idea how to fix, whenever you split a single order > into multiple invoices there is always the potential for this to > happen because the tax is rounded more often (once for each invoice as > opposed to once for the entire order). > The only option I can see is to incorrectly round the tax (or create > some sort of tax adjustment) on the invoices so that they stay in sync > with the order total. > > What do you think? > > Regards > Scott > > On 07/12/2007, Rashko Rejmer <[EMAIL PROTECTED]> wrote: > Hi Scott, > > The problem occurs in very very specific orders. Here are the > EXACT > steps: > Start creating order with DemoCustCompany party > Add to cart > - GZ-1000 x 5 > - GZ-1001 x 5 > > Then create 2 ship groups for the order - for each of the ship > groups > chose the second shipping address(US-CA) of the > DemoCustCompany party > Then move to the second shipping group one of the items > GZ-1000 or > GZ-1001. > Then use shipment method for the first shipping group - "UPS > Guaranteed > Next Day - $10.70" and for the second shipping group "No > shipping" > Pay the order with whatever you want(but use only ONE payment > method). > Do NOT add any additional parties. > Create the order. > The total amount of the order should be 188.75(this is with > clean copy > of ofbiz, after run install).If this is the third order you > create with > this party then you might get different grand total, because > the promos > are over and there aren`t any more of them. > > Then "Quick ship entire order". > > The sum of the two invoices is 188.76 but the order grand > total is > 188.75 > > I created example on the demo server - order WSCO10009 with > invoices > CI7, CI8 > > > https://demo.hotwaxmedia.com/ordermgr/control/orderview?orderId=WSCO10009 > > I will be glad to hear your opinion about this situation. > I have investigated this very deeply and I have idea why this > is > happening but I wanted first to know if this is a bug or not. > > Rashko Rejmer > > > On Fri, 2007-12-07 at 07:43 +1300, Scott Gray wrote: > > Hi Rashko > > > > I think you'll find it's some sort of rounding error in the > order code > > which will need to be tracked down. If you don't have time > to look,
Re: What is a NSF retry in terms of Payment Authorization
Maybe this will help: http://en.wikipedia.org/wiki/Non-sufficient_funds Regards, Rashko Rejmer On Thu, 2008-01-10 at 20:00 +0530, Vikas Mayur wrote: > Can any one point to a relevant document ? > > Thanks, > -- Vikas
Re: Product - Supplier relationship
The entity you are looking for should be SupplierProduct entity. https://demo.hotwaxmedia.com/webtools/control/FindGeneric?entityName=SupplierProduct&find=true&VIEW_SIZE=50&VIEW_INDEX=0 https://demo.hotwaxmedia.com/catalog/control/EditProductSuppliers?productId=GZ-1000 Regards, Rashko Rejmer On Wed, 2008-01-16 at 12:38 -0800, Ritz123 wrote: > Hi, > > Can someone please point me to the table which links products with its > supplier? > > Also, seems like when you create the product, one cannot specify either the > supplier directly or add the party with the supplier role. Isnt that > absolutely required? At least in my application, a product needs to have a > supplier and a manufacturer.
Re: Product - Supplier relationship
In r607072 the label from ProductTabBar was changed from "Supplier" to "Vendor Product". Is this made intentionally or by mistake? Regards, Rashko Rejmer On Wed, 2008-01-16 at 12:38 -0800, Ritz123 wrote: > Hi, > > Can someone please point me to the table which links products with its > supplier? > > Also, seems like when you create the product, one cannot specify either the > supplier directly or add the party with the supplier role. Isnt that > absolutely required? At least in my application, a product needs to have a > supplier and a manufacturer.
Re: Gift card processor error
Hi Rupinder, If you want to avoid this error you have to create financial account with the same Fin Account Code as the gift card number. https://demo.hotwaxmedia.com/accounting/control/EditFinAccount You need positive and sufficient fin account balance. To achieve this create deposit or adjustment transaction to the fin account: https://demo.hotwaxmedia.com/accounting/control/EditFinAccountTrans?finAccountId=1 Hope this helps. Regards, Rashko Rejmer On Wed, 2008-01-16 at 23:14 -0800, Rupinder wrote: > Hi, > While using gift card as a payment method for doing payments in ecommerce > application, I m getting the following errors: > > "The Following Occurred: > > Problem connecting to payment processor; we will continue to retry and > notify you by email." > > > Plz reply as soon as possible.
Re: Gift card processor error
Hi Rupinder, I think that you have created fin account that has the same account code as the gift card that you use during the check out process. You get the second error because you do not have sufficient fin account balance to cover the amount of the order that you want to create. You have to create fin account transaction(of type Adjustment or Deposit) with greater amount than the order that you want to create. You can create fin account transaction from Accounting -> Financial Account -> chose your fin account -> Transactions -> add Adjustment or Deposit transaction. Regards, Rashko Rejmer On Thu, 2008-01-17 at 23:06 -0800, Rupinder wrote: > Hi, > I am getting another error when using gift card as a payment method for > doing payments in ecommerce > application: > > "Error in authOrderPayments service: > org.ofbiz.service.GenericServiceException: Could not commit transaction for > service [authOrderPayments] call: Roll back error, could not commit > transaction, was rolled back instead because of: Service Error > [authOrderPaymentPreference]: Error processing payment authorization: > org.ofbiz.base.util.GeneralException: Problems invoking payment processor! > Will retry later. Order ID is: [WSCO10092 (Service target threw an > unexpected exception (null)) (Could not commit transaction for service > [authOrderPayments] call: Roll back error, could not commit transaction, was > rolled back instead because of: Service Error [authOrderPaymentPreference]: > Error processing payment authorization: > org.ofbiz.base.util.GeneralException: Problems invoking payment processor! > Will retry later. Order ID is: [WSCO10092 (Service target threw an > unexpected exception (null)))" > > Plz help > > > Rashko Rejmer wrote: > > > > Hi Rupinder, > > > > If you want to avoid this error you have to create financial account > > with the same Fin Account Code as the gift card number. > > https://demo.hotwaxmedia.com/accounting/control/EditFinAccount > > > > You need positive and sufficient fin account balance. > > To achieve this create deposit or adjustment transaction to the fin > > account: > > https://demo.hotwaxmedia.com/accounting/control/EditFinAccountTrans?finAccountId=1 > > > > Hope this helps. > > > > Regards, > > Rashko Rejmer > > > > > > On Wed, 2008-01-16 at 23:14 -0800, Rupinder wrote: > >> Hi, > >> While using gift card as a payment method for doing payments in ecommerce > >> application, I m getting the following errors: > >> > >> "The Following Occurred: > >> > >> Problem connecting to payment processor; we will continue to retry and > >> notify you by email." > >> > >> > >> Plz reply as soon as possible. > > > > > > >
Re: Gift card processor error
Hi Rupinder, Could you tell me if you are using the OFBiz demo data? If you have customized data it is possible that you have to correct some of your settings(e.g product store settings etc.). First it depends for witch store you are creating the order. If you are using the OFBiz E-Commerce Store here you can find the list of services that will be used for authorization and capturing of the gift card payments: https://demo.hotwaxmedia.com/catalog/control/EditProductStorePaySetup?productStoreId=9000 Authorization: ofbGcAuthorize service Capturing: ofbGcProcessor service The best way is to go through the code of these services. This way you will be familiar with all required settings to get successful GC payment processing. The second place where you have to make settings if you are using your data(not OFBiz demo data) is "Product Store Financial Account Settings" screen: https://demo.hotwaxmedia.com/catalog/control/EditProductStoreFinAccountSettings?productStoreId=9000 Here you should have one record with "Fin Account Type Id" = Gift Certificate. Require Pin Code = Y/N - if set to Y the gift card pin code will be compared to fin account pin code(they should be equal) Steps to use GC with OFBiz demo data: After you create GC for a party(e.g for DemoCustCompany) with Card Number: 12345 and Pin Number:123 then: - Create Financial Account: https://demo.hotwaxmedia.com/accounting/control/EditFinAccount Fin Account Type Id = Gift Certificate Status = Active Fin Account Code = 12345 Fin Account Pin = 123 - Create Fin Account Transaction: https://demo.hotwaxmedia.com/accounting/control/EditFinAccountTrans?finAccountId=10010 Fin Account Trans Type Id = Deposit Amount = 1000 (this amount should be grated that the order total) After that Fin Account available balance will be 1000. You can check this here: https://demo.hotwaxmedia.com/accounting/control/EditFinAccount?finAccountId=1 - field "Available Balance". Then you are ready to create order and to specify the GC as a payment method. Hope this helps. Regards, Rashko Rejmer On Mon, 2008-01-21 at 03:02 -0800, Rupinder wrote: > I am again getting the error. > > Can you plz tell me the steps or procedure in detail, for creating and using > gift card. > > Starting from beginning: > I have created a gift card for a user, with the following: > Card Number: 12345 > Pin Number:123 > > Now what are the next steps, Please tell in detail if possible. > > > Rashko Rejmer wrote: > > > > Hi Rupinder, > > > > I think that you have created fin account that has the same account code > > as the gift card that you use during the check out process. > > > > You get the second error because you do not have sufficient fin account > > balance to cover the amount of the order that you want to create. > > > > You have to create fin account transaction(of type Adjustment or > > Deposit) with greater amount than the order that you want to create. > > You can create fin account transaction from > > Accounting -> Financial Account -> chose your fin account -> > > Transactions -> add Adjustment or Deposit transaction. > > > > Regards, > > Rashko Rejmer > > > > > > On Thu, 2008-01-17 at 23:06 -0800, Rupinder wrote: > >> Hi, > >> I am getting another error when using gift card as a payment method for > >> doing payments in ecommerce > >> application: > >> > >> "Error in authOrderPayments service: > >> org.ofbiz.service.GenericServiceException: Could not commit transaction > >> for > >> service [authOrderPayments] call: Roll back error, could not commit > >> transaction, was rolled back instead because of: Service Error > >> [authOrderPaymentPreference]: Error processing payment authorization: > >> org.ofbiz.base.util.GeneralException: Problems invoking payment > >> processor! > >> Will retry later. Order ID is: [WSCO10092 (Service target threw an > >> unexpected exception (null)) (Could not commit transaction for service > >> [authOrderPayments] call: Roll back error, could not commit transaction, > >> was > >> rolled back instead because of: Service Error > >> [authOrderPaymentPreference]: > >> Error processing payment authorization: > >> org.ofbiz.base.util.GeneralException: Problems invoking payment > >> processor! > >> Will retry later. Order ID is: [WSCO10092 (Service target threw an > >> unexpected exception (null)))" > >> > >> Plz help > >> > >> > >> Rashko Rejmer wrote: > >> > > >> > Hi Rupinder, > >
Re: Adding quantity for items in inventory
Hi Rupinder, Maybe you do not have record in SupplierProduct entity for the product that you want to purchase. E.g if you want to purchase GZ-1000 product - you can do this on Vendor Product screen: https://localhost:8443/catalog/control/EditProductSuppliers?productId=GZ-1000 Supplier: User, external Regards, Rashko Rejmer On Mon, 2008-01-28 at 02:16 -0800, Rupinder wrote: > Hi, > As you suggested, I am trying to create purchase order to receive inventory. > But I am not aware of how to create a purchase order. > > While creating a purchase order, what should be the values of these options: > > Internal Organization: > Supplier: > User Login Id: > > I am asking so because I am getting the following error when adding a > product to the order: > "This product cannot be purchased from the chosen supplier for the given > quantity and currency. (SupplierProduct not found)" > > I have selected the following options for the above listed fields: > > Internal Organization: Sales > Supplier: User, external > User Login Id:sehwag > > Note: sehwag is a user with role type "supplier". > > On next screen I have selected Currency as "CAD". > > Plz help > > > vijay Si wrote: > > > > You can create purchase order for the item to be received in the > > inventory. > > Then goto [Facilities]-->[Receive Inventory] and metion the po number. > > > > You can also directly receive based on product id but this method cannot > > be > > tracked directly in the accounting module. > > Also see to it that you receive the inventory in the facility that is tied > > with your e-commerce store. > > > > > > On Jan 28, 2008 12:45 PM, Rupinder <[EMAIL PROTECTED]> wrote: > > > >> > >> Hi > >>I am trying to add products in inventory. But I am not able to find > >> any > >> option for specifying the quantity for the products. So now when placing > >> order from ecommerce application, getting the following error: > >> > >> "Sorry, we do not have enough (you tried 1) of the product (product ID: > >> 204-075) in stock, not adding to cart. Please try a lower quantity, try > >> again later, or call customer service for more information." > >> > >> Please suggest a proper procedure to add a product in the inventory. > >> > >> -- > >> View this message in context: > >> http://www.nabble.com/Adding-quantity-for-items-in-inventory-tp15129592p15129592.html > >> Sent from the OFBiz - User mailing list archive at Nabble.com. > >> > >> > > > > >
Re: Adding quantity for items in inventory
Hi Rupinder, I believe that you had created order with different currency than that set in accounting preferences of the facility owner. E.g if you receive inventory in WebStoreWarehouse facility - it's owner is Company party that has Base Currency = USD https://demo.hotwaxmedia.com/accounting/control/AdminMain?organizationPartyId=Company then the system is trying to convert order currency to USD you need to set Foreign Exchange Rates for the facility owner (Company) https://demo.hotwaxmedia.com/accounting/control/updateFXConversion >From Currency: your currency To Currency: USD Rate: . Regards, Rashko Rejmer On Mon, 2008-01-28 at 04:41 -0800, Rupinder wrote: > I have successfuly created a "purchase order". But now when receiving a > Purchase order, I am getting the following error: > "org.ofbiz.base.util.GeneralException: Error rendering screen > [component://product/widget/facility/FacilityScreens.xml#ReceiveInventory]: > org.ofbiz.base.util.GeneralException: Error rendering screen > [component://product/widget/facility/CommonScreens.xml#CommonFacilityDecorator]: > org.ofbiz.entity.transaction.GenericTransactionException: The current > transaction is marked for rollback, not beginning a new transaction and > aborting current operation; the rollbackOnly was caused by: Error in > simple-method [Convert UOM values > [file:/E:/ofbiz/framework/common/script/org/ofbiz/common/CommonServices.xml#convertUom]]: > ; [UOM Conversion Relationship Not Found] " > > > > > Rashko Rejmer wrote: > > > > Hi Rupinder, > > > > Maybe you do not have record in SupplierProduct entity for the product > > that you want to purchase. > > E.g if you want to purchase GZ-1000 product - you can do this on Vendor > > Product screen: > > https://localhost:8443/catalog/control/EditProductSuppliers?productId=GZ-1000 > > > > Supplier: User, external > > > > Regards, > > Rashko Rejmer > > > > > > On Mon, 2008-01-28 at 02:16 -0800, Rupinder wrote: > >> Hi, > >> As you suggested, I am trying to create purchase order to receive > >> inventory. > >> But I am not aware of how to create a purchase order. > >> > >> While creating a purchase order, what should be the values of these > >> options: > >> > >> Internal Organization: > >> Supplier: > >> User Login Id: > >> > >> I am asking so because I am getting the following error when adding a > >> product to the order: > >> "This product cannot be purchased from the chosen supplier for the given > >> quantity and currency. (SupplierProduct not found)" > >> > >> I have selected the following options for the above listed fields: > >> > >> Internal Organization: Sales > >> Supplier: User, external > >> User Login Id:sehwag > >> > >> Note: sehwag is a user with role type "supplier". > >> > >> On next screen I have selected Currency as "CAD". > >> > >> Plz help > >> > >> > >> vijay Si wrote: > >> > > >> > You can create purchase order for the item to be received in the > >> > inventory. > >> > Then goto [Facilities]-->[Receive Inventory] and metion the po number. > >> > > >> > You can also directly receive based on product id but this method > >> cannot > >> > be > >> > tracked directly in the accounting module. > >> > Also see to it that you receive the inventory in the facility that is > >> tied > >> > with your e-commerce store. > >> > > >> > > >> > On Jan 28, 2008 12:45 PM, Rupinder <[EMAIL PROTECTED]> wrote: > >> > > >> >> > >> >> Hi > >> >>I am trying to add products in inventory. But I am not able to find > >> >> any > >> >> option for specifying the quantity for the products. So now when > >> placing > >> >> order from ecommerce application, getting the following error: > >> >> > >> >> "Sorry, we do not have enough (you tried 1) of the product (product > >> ID: > >> >> 204-075) in stock, not adding to cart. Please try a lower quantity, > >> try > >> >> again later, or call customer service for more information." > >> >> > >> >> Please suggest a proper procedure to add a product in the inventory. > >> >> > >> >> -- > >> >> View this message in context: > >> >> > >> http://www.nabble.com/Adding-quantity-for-items-in-inventory-tp15129592p15129592.html > >> >> Sent from the OFBiz - User mailing list archive at Nabble.com. > >> >> > >> >> > >> > > >> > > >> > > > > > > >
Re: Higher Lever Accounts Missing in Default COA report
Hi Enrique, I think that this is not exactly a bug, but only missing demo data. I noticed that committers are creating demo data to GlAccountOrganization entity only when there is need for testing newly implemented features. So probably soon these accounts will be associated to the "Company" party too :) Regards, Rashko Rejmer *Hello*, I was reviewing the default Chart of Accounts report/view through the following path in Ofbiz trunk build: General Ledger -> SetUp -> Chart of Accounts. I noticed some of the higher level accounts don't appear in the default view e.g.: 20 [liablility account], 30 [equity account] are not there, whereas some of the other higher level accounts are visible: 10 [Assets account], 40 [sales account]I wounder if this is a bug or am I missing something here? Thanks in advance. * Enrique*
Shipping adjustments proration
Hi, I noticed that if a sales order is meant to be shipped with few ship groups then every shipment adjustment is prorated to the all invoices that are created(they are created separate invoices for every ship group). Isn't it more accurate every specific invoice to include only shipping adjustments that are applicable for invoiced items? Regards, Rashko Rejmer
Re: Communicating auth info while calling services through runSync
Hi, Maybe you can pass the userLogin GV to the IN Map. E.g.: dispatcher.runSync("setPaymentStatus", UtilMisc.toMap("userLogin", userLogin, ..... Regards, Rashko Rejmer On Mon, 2008-02-04 at 13:24 -0800, Deepaks wrote: > I have been trying to access certain services through runSync and am unable > to get through. > > I always get "You must be logged in to complete the [create a EntityName] > process." though I have turned auth=false just to test it out. But I think > it should have authentication turned on anyways. So is there any way I can > pass on user information into it? > > Thanks in advance > > PS: Basically, its part of moving an application to ZK interface. I have > built a form, then creating a context map and calling runSync.
Re: How we can edit the fields in
Hi, You can find a lot of examples how to do that in the code. You just have to override the name of the field(from the service). E.g. if you want to hide field that is as an IN parameter to the service: So this field will not appear in your form. The same with adding different content to the field. Regards, Rashko Rejmer On Thu, 2008-02-07 at 05:18 -0800, Ajey wrote: > Hi, > > I'm facing a problem, many of the places in XML Forms, there has been used. > I'm quite unable to edit the fields coming from this . Can anyone please > help e while customizing the fields of this. > > Please tell me the steps in a bit detail that from where i can customize > this. > Thanx, > > Ajey. >
Re: Rounding problem
Hi Evangelina, Thread that may help you: http://ofbiz.markmail.org/message/72j6aakesmglucrs?q=jacopo+gl+posting Regards, Rashko Rejmer On Wed, 2008-02-13 at 15:09 -0800, Evangelina Bowman wrote: > Hello Scott and Rashko, > > I'm having the same issue with the rounding of the taxes. This is affecting > my GL postings. My total debit amount (Accounts Receivable for $30.35) does > not match my total credit (Sales of $27.98 plus sales tax of $2.36 = > $30.34). I'm off by a penny. The GL transaction does not post since debits > and credits must match. > > Thanks, > Evangelina Bowman > > > Rashko Rejmer wrote: > > > > Skott, > > > > I think that you are right. > > I was investigating Order total and order components(Items SubTotal, > > Total Other Order Adjustments, Total Shipping and Handling, Total Sales > > Tax) rounding. > > > > When order tax adjustments are calculated they are rounded for every > > item. > > Exactly what you provided > > - 6.497 + 1.04 = 7.537 (rounded 7.54) > > - 4.997 (rounded 5.00) > > I saw your commit that changed that - r602011 > > > > but when order grand total is calculated then tax adjustments are > > rounded together > > - 6.497 + 1.04 + 4.997 = 12.534 (12.53) > > this is performed in OrderReadHelper.getOrderItemsTotal > > > > I was willing to check also how ShoppingCart.getGrandTotal calculates > > order total before order creation. > > > > About the second problem I also think that it is impossible to solve it > > in usual way. > > When invoice total is calculated, the tax items are calculated > > separately and rounded after that, so the rounding that was made in the > > order(on the order item basis) is lost. > > On the other side(exactly what you said) if the order is invoiced to few > > invoices then there will be situations when the tax roundings will be > > inaccurate. > > I very loved your idea about additional adjustment to the invoice that > > will correct the final amount. Can somebody give me some suggestions how > > to implement that? > > > > I will continue with investigation. > > > > Regards, > > Rashko Rejmer > > > > On Fri, 2007-12-07 at 19:10 +1300, Scott Gray wrote: > >> Hi Rashko > >> > >> There seems to be 2 issues going on here, one can be fixed the other > >> can't. > >> > >> The order total is correct at 188.75 but the tax total is incorrect: > >> 4.997 + 6.497 + 1.04 = 12.534 (rounded 12.53) not 12.54 > >> That can be fixed, I'll commit it shortly. > >> > >> The other issue is that the order is then split into 2 invoices: > >> Tax on invoice #1: 6.497 + 1.04 = 7.537 (rounded 7.54) > >> Tax on invoice #2: 4.997 (rounded 5.00) > >> Total tax for both invoices = 12.54 as opposed to the order tax total > >> which should be 12.53 > >> This one I have no idea how to fix, whenever you split a single order > >> into multiple invoices there is always the potential for this to > >> happen because the tax is rounded more often (once for each invoice as > >> opposed to once for the entire order). > >> The only option I can see is to incorrectly round the tax (or create > >> some sort of tax adjustment) on the invoices so that they stay in sync > >> with the order total. > >> > >> What do you think? > >> > >> Regards > >> Scott > >> > >> On 07/12/2007, Rashko Rejmer <[EMAIL PROTECTED]> wrote: > >> Hi Scott, > >> > >> The problem occurs in very very specific orders. Here are the > >> EXACT > >> steps: > >> Start creating order with DemoCustCompany party > >> Add to cart > >> - GZ-1000 x 5 > >> - GZ-1001 x 5 > >> > >> Then create 2 ship groups for the order - for each of the ship > >> groups > >> chose the second shipping address(US-CA) of the > >> DemoCustCompany party > >> Then move to the second shipping group one of the items > >> GZ-1000 or > >> GZ-1001. > >> Then use shipment method for the first shipping group - "UPS > >> Guaranteed > >> Next Day - $10.70" and for the second shipping group "No > >> shipping" > >> Pay the order with whatever you want(but use only
LayoutWorker.returnByteBuffer missing
Hi, I've noticed that in r587433 - LayoutWorker.returnByteWrapper was removed and references to this method in PartySimpleEvents.xml file were changed with reverences to LayoutWorker.returnByteBuffer that is missing. Regards, Rashko Rejmer
RE: zero dollar product
Hi William, The logic that is implemented behind invoice creation is that if we create few invoices from one order then shipping and global taxes are prorated between each invoice. The implementation of the createInvoiceForOrder service does proration this way: if the product store oprion prorate shipping == Y then the amount of shipping will be calculated on invoice sub total basis. In your case invoice sub total is = 0 so the shipping charge is not included in the invoice. One quick solution will be to turn off the prorate shipping option in your product store. In this case shipping charges will be included in the first invoice that will be created from your order. Hope this helps Regards, Rashko Rejmer wperng wrote: > > Could you give me the screen shot of your order detail page ? I just found > the issue (https://issues.apache.org/jira/browse/OFBIZ-207) in Jira. I > hope > someone can be assigned to fix it. > > Thanks > > William > > -Original Message- > From: Bilgin Ibryam [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 27, 2008 4:48 PM > To: user@ofbiz.apache.org > Subject: Re: zero dollar product > > > Hi William, > > Why you decided that the amount is not captured correctly? Can yo > reproduce > it on demo server? > > When you choose credit card for payment method, during order creation the > total amount(including shipment)is authorized. Then in order view screen > (payment section) you can see the authorization and capture the amount. > You > will also see the open amount (not authorized amount) which is usually 0. > May be you get confused with this zero amount? > > I just tested, you can capture only shipments... > > Regards, > Bilgin Ibryam > -- > View this message in context: > http://www.nabble.com/zero-dollar-product-tp15698743p15724177.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > > > > -- View this message in context: http://www.nabble.com/zero-dollar-product-tp15698743p15806262.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Withholding tax in OFBiz
Hi all, I have to configure the system to be able to apply withholding tax. Does anybody have experience with such a task? In my situation I need to issue sales invoice. The order and invoice total amounts should include the full amount of the tax, not only the part that issuer will pay to the tax authority. The invoice also should contain information about the amount of the withholding tax. I have tried to achieve this by creating 2 TaxAuthorityRateProduct records: one for the full tax, and the second with negative percentage to handle withheld tax. In this situation GL posting is correct but the problem is that the order and invoice total amounts do not include withheld tax amount. Would someone provide a pointer how to deal with this problem? Is there better way to handle withholding taxes in OFBiz? Regards, Rashko Rejmer
Re: Withholding tax in OFBiz
Hi, I decided to give my question another try. I have not succeeded with withholding tax configuration. I am starting to think that it is not possible to achieve this in OFBiz without additional development, but I still think that I am missing something. Can someone confirm that it is not possible to apply withholding tax in OFBiz? Any comments or suggestions would be greatly appreciated. Regards, Rashko Rejmer On Wed, 2008-03-19 at 13:58 +0200, Rashko Rejmer wrote: > Hi all, > > I have to configure the system to be able to apply withholding tax. Does > anybody have experience with such a task? > > In my situation I need to issue sales invoice. The order and invoice > total amounts should include the full amount of the tax, not only the > part that issuer will pay to the tax authority. The invoice also should > contain information about the amount of the withholding tax. > > I have tried to achieve this by creating 2 TaxAuthorityRateProduct > records: one for the full tax, and the second with negative percentage > to handle withheld tax. In this situation GL posting is correct but the > problem is that the order and invoice total amounts do not include > withheld tax amount. > > Would someone provide a pointer how to deal with this problem? Is there > better way to handle withholding taxes in OFBiz? > > Regards, > Rashko Rejmer >