ISO-3166 - Codes for the representation of names of countries and their subdivisions
Hello team, *Bottom line:* I suggest that either we should use alpha-2/alpha-3 or we can use all of them and make them configurable as per business requirement. *Story:* As per the ISO-3166 standard for country and subdivision codes. There are three types of codes alpha-2, alpha-3 and numeric. Different countries are using a different standard as per there administration policy. It may be either alpha-2, alpha-3 or numeric. In the current system, we are using mixed-format like somewhere alpha-2 and somewhere alpha-3. We should fix this for example: Example India country: ISO-3166-1 alpha-2=IN ISO-3166-1 alpha-3= IND alpha-numeric=356 Indian state: Maharastra ISO-3166-2 =IN-MH ISO-3166-1 alpha-3=MH alpha-numeric= NA In OFBiz India: IN(ISO-3166-1 alpha-2) Indian state: Maharastra MH(ISO-3166-1 alpha-3) United States USA(alpha-3) United States: New York NY(alpha-3) Here are some reference: https://www.iso.org/obp/ui/#iso:code:3166:IN https://en.wikipedia.org/wiki/ISO_3166-2:IN Kind Regards, Vaibhav Jain Senior Enterprise Software Engineer *HotWax Systems* *Enterprise open source experts* cell: 782 834 1900 http://www.hotwaxsystems.com
Re: Moving Average Inventory
Hello James, *cogsMethodId *column of *PartyAcctgPreferance *entity is used to define the COGS method There are four COGS methods are defined in the OFBiz - LIFO - FIFO - Average cost - Inventory item cost *ProductAverageCost* entity is used to store the average cost of a product and product average cost is updated every time whenever inventory is received. Hope that help Cheers! Vaibhav Jain Sr. Enterprise Software Engineer HotWax Systems m: 782-834-1900 e: vaibhav.j...@hotwaxsystems.com On Tue, Aug 28, 2018 at 6:44 PM wrote: > Thank you. Is there a table that shows me whats remaining in inventory > and what COGS it will go out at when sold? So in my example below after > the sale of 100 units on 10-5 I have 50 remaining at an average costs of > $10.50 which is different than the original $10 I paid for those items. > > > Original Message > Subject: Re: Moving Average Inventory > From: Yashwant Dhakad > Date: Tue, August 28, 2018 5:34 am > To: user@ofbiz.apache.org > > Hi James, > You can find the average cost of the product on this screen > < > https://demo-trunk.ofbiz.apache.org/facility/control/InventoryAverageCosts?facilityId=WebStoreWarehouse > >. > If you receive the inventory of the product then average cost is > automatically calculated by updateProductAverageCostOnReceiveInventory > service. > > Thanks & Regards > -- > Yashwant Dhakad > > > On Tue, Aug 28, 2018 at 5:39 PM wrote: > > > Team I am trying to follow where the moving average inventory for an > > item is stored in the system so I can track that things are calculating > > correctly. Here is an example: > > > > On 10-1 I have a beginning inventory of 100 units @ $10 > > On 10-3 I receive a purchase order of 100 units @ $11 > > > > So we have ($1000+$1100)/200 - Moving Average is $10.50 and we have 200 > > units at that costs > > > > > > I would assume the system calculates the inventory valuation prior to > > each sell to get an accurate Costs of Goods Sold > > > > On 10-5 we have a sale of 100 units. The Costs of Goods Sold should go > > out at $10.50 > > > > This leaves us 50 units @ 10.50 (Where does Of biz store this?) > > > > On 10-6 we receive a purchase order of 100 units @10.80 > > > > We now calculate our new moving average as ((50 * > > 10.50)+(100*10.80)/150) = $10.70 (Where does Ofbiz store this) > > > > On 10-7 we sell 50 units and our Costs of Goods Sold should go out @ > > $10.70 > > > > Where in Ofbiz can I see the storing of the perpetual moving average? > > > > Thanks, > > > > James > > > > >
Re: GST rates on the basis of product price or price range
Hello Rishi, I am working on the GST of India. One of the business rules of the GST is like: - Tax is applied on the basis of HSN code which is managed using ProductCategory entity - Same HSN code may have different GST rate on the basis of price - Goods of sale value not exceeding Rs. 1000 per piece would be taxed at 5% and the goods of sale value exceeding Rs. 1000 per piece would be taxed at 12%. As per the GST rules and existing data model price range should be maintained in *TaxAuthorityRateProduct* entity instead of using *ProductCategory* entity. One of the solutions is we can extend the *TaxAuthorityRateProduct* entity and introduce a new column *maxItemPrice. *Now, *minItemPrice* and* maxItemPrice *columns can be used to filter the records on the basis of the price range. Please suggest can we extend the entity or do we have any other/better solution to manage this scenario. Vaibhav Jain Sr. Enterprise Software Engineer HotWax Systems m: 782-834-1900 e: vaibhav.j...@hotwaxsystems.com On Tue, Aug 21, 2018 at 11:20 PM Rishi Solanki wrote: > Vaibhav, > Instead of trying to fetch product on field value, go for creating > categories for your need and make product members of them. > For example you may create categories 0-100, 101-200, 201-300 of type > OTHER_SEARCH type as many as you want. Finally associate the products with > desired categories. After that you fetching would be easy at code level. > > It will take time to setup but data fetching would be easy and configurable > easily (may be you can use some triggers to associate) > > -- > Rishi Solanki > Sr Manager, Enterprise Software Development > HotWax Systems Pvt. Ltd. > Direct: +91-9893287847 > http://www.hotwaxsystems.com > www.hotwax.co > > > On Tue, Aug 21, 2018 at 2:42 PM Vaibhav Jain < > vaibhav.j...@hotwaxsystems.com> > wrote: > > > Hello all, > > > > *Business case:* > > Goods and Service Tax is India allow to apply different tax rates on > > the same product/product category on the basis of product > > price(transactional value). > > > > *Problem: In fetching data for a specific price range* > > > >- In OFBiz the *TaxAuthorityRateProduct* entity is used to define the > >tax rates for any product category. > >- *TaxAuthorityRateProduct*.*minItemPrice* can be used to manage > >different tax rates on the basis of the product price but it is > > difficult > >to fetch the data on the basis of a specific price range using single > >column(minItemPrice) > > > > > > Vaibhav Jain > > Sr. Enterprise Software Engineer > > HotWax Systems > > m: 782-834-1900 e: vaibhav.j...@hotwaxsystems.com > > >
GST rates on the basis of product price or price range
Hello all, *Business case:* Goods and Service Tax is India allow to apply different tax rates on the same product/product category on the basis of product price(transactional value). *Problem: In fetching data for a specific price range* - In OFBiz the *TaxAuthorityRateProduct* entity is used to define the tax rates for any product category. - *TaxAuthorityRateProduct*.*minItemPrice* can be used to manage different tax rates on the basis of the product price but it is difficult to fetch the data on the basis of a specific price range using single column(minItemPrice) Vaibhav Jain Sr. Enterprise Software Engineer HotWax Systems m: 782-834-1900 e: vaibhav.j...@hotwaxsystems.com
Re: changing header in order export pdf
Hello Rajesh, Deepak I think we can improve the code as well, if we don't get the GENERAL_LOCATION, we can use a PRIMARY_LOCATION as an alternate, always. PRIMARY_LOCATION is also used in some of the cases instead of GENERAL_LOCATION. Vaibhav Jain Sr. Enterprise Software Engineer HotWax Systems m: 782-834-1900 e: vaibhav.j...@hotwaxsystems.com On Mon, May 14, 2018 at 1:44 PM Rajesh Mallah <mallah.raj...@gmail.com> wrote: > Thanks Deepak. > > regds > mallah >
Re: Multiple Warehouse Item Reservation
Hello James, IMO, It is a data configuration issue. Please make sure that following data is configured properly: 1. "oneInventoryFacility" should be "N" for the respective product store. 2. Product store should have an association with both the facility in "ProductStoreFacility" entity. HTH! Thanks & Regards Vaibhav Jain Sr. Enterprise Software Engineer HotWax Systems m: 782-834-1900 e: vaibhav.j...@hotwaxsystems.com On Thu, May 3, 2018 at 7:05 AM, <ja...@productive1.com> wrote: > We have two warehouses and just noticed the system is only reserving to > the default warehouse and backordering product even when I have it in > another warehouse. Is this how the system is suppose to behave. > Shouldn't it try and reserve it from the default warehouse and then the > other warehouses if default warehouse has zero stock.? > > Thanks, > > James >
Re: [MODERATE EMAIL] calculate the seniority of an employee
Hello Nada, The given information is not sufficient to answer the question. Can you please share more info? Thanks & Regards Vaibhav Jain Sr. Enterprise Software Engineer HotWax Systems m: 782-834-1900 e: vaibhav.j...@hotwaxsystems.com <desiree.jenkin...@hotwax.co> On Thu, Mar 1, 2018 at 12:10 PM, Aditya Sharma < aditya.sha...@hotwaxsystems.com> wrote: > Hi Nada, > > If your question is to calculate how much time an employee served the > organization. You can use fromDate & thruDate in Employment entity to > calculate it. You can also view this information in HR component > https://demo-trunk.ofbiz.apache.org/humanres/control/ListEmployments? > partyId=DemoEmployee > > HTH > > Thanks and Regards, > > *Aditya Sharma* | Enterprise Software Engineer > HotWax Commerce <http://www.hotwax.co/> by HotWax Systems > <http://www.hotwaxsystems.com/> > > <https://www.linkedin.com/in/aditya-sharma-78291810a/> > > On Mon, Feb 26, 2018 at 11:35 AM, Deepak Dixit <deepak.dixit@hotwaxsystems. > com> wrote: > > > Hi Nada, > > > > Your email has been moderated > > Please subscribe mailing list http://ofbiz.apache.org/mailing-lists.html > > > > Thanks & Regards > > -- > > Deepak Dixit > > www.hotwaxsystems.com > > www.hotwax.co > > > > -- Forwarded message -- > > From: nada <nassima-dhaiman2...@hotmail.com> > > To: user@ofbiz.apache.org > > Cc: > > Bcc: > > Date: Sun, 25 Feb 2018 12:27:48 -0700 (MST) > > Subject: calculate the seniority of an employee > > Hello, I need to calculate the seniority of an employee, can you give me > > the > > steps for that.I use Intellij IDEA. Thank you. I'm using OFBiz for the > > first > > time. > > > > > > > > -- > > Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html > > >
Re: Selling and Buying In Differnt Units of Measurements
Hello James, OFBiz does not have support to buy or sell the product in multiple quantity UOM. This topic is already discussed before in the community. In OFBiz there is a support of marketing package in which we can assemble and decompose the product to trade the product in multiple UOM. While using marketing package we need to maintain same product multiple times for different UOM. There is a drawback of using marketing package that we need to maintain same product multiple times for different UOM. You need to do the custom changes to achieve the support of multiple UOM. Here are some links to some of the reference previous discussions. http://ofbiz.markmail.org/message/wnvkuyfubn6dewzc <http://ofbiz.markmail.org/message/wnvkuyfubn6dewzc?q=selling+uom> http://ofbiz.markmail.org/message/l25duvbuuhspohyv http://ofbiz.markmail.org/message/7vala7xcgcs5nb4n The high-level design proposed for multiple quantity UOM 1. We can use SupplierProduct entity to manage products in various UOM for the same supplier. 2. Inventory of the product is maintained in the lowest quantity UOM. 3. At the time of sales, quantity UOM is managed for tagging and sales will happen by UOM conversion. Hope this will help ☺ Vaibhav Jain Sr. Enterprise Software Engineer HotWax Systems m: 782-834-1900 e: vaibhav.j...@hotwaxsystems.com <desiree.jenkin...@hotwax.co> On Thu, Mar 1, 2018 at 3:45 PM, Rishi Solanki <rishisolan...@gmail.com> wrote: > Please look for the Product.quantityIncluded and related code. An example > product setup with id WG-9943, on purchase you can select the quantity UOM. > On selecting the quantity UOM it will add more than one quantity into the > cart. > > HTH! > > Rishi Solanki > Sr Manager, Enterprise Software Development > HotWax Systems Pvt. Ltd. > Direct: +91-9893287847 > http://www.hotwaxsystems.com > www.hotwax.co > > On Wed, Feb 28, 2018 at 10:07 PM, <ja...@productive1.com> wrote: > > > > > Can ofbiz buy in one unit of measure and sell in another unit of > > measure. For example: > > > > 1 Buy product GZ-1000 in case quantity in which each case includes 12 > > eaches > > > > So I buy quantity of 1 > > > > However when I receive it since I sell it in eaches ...I receive > > quantity of 12 > > > > Is there a way of doing this without having to have to different > > products? > > > > Thanks, > > > > James > > >
Re: Inventory - Moving Average
Hello James, If you are looking for COGS methods of inventory valuation then *cogsMethodId* of *PartyAcctgPreference* entity defines the valuation method. *cogsMethodId* for average costing of Inventory valuation is *COGS_AVG_COST* I hope that this will help you :) Vaibhav Jain Sr. Enterprise Software Engineer HotWax Systems m: 782-834-1900 e: vaibhav.j...@hotwaxsystems.com <desiree.jenkin...@hotwax.co> On Thu, Jan 25, 2018 at 1:57 PM, <ja...@productive1.com> wrote: > Inventory Valuation. We have selection Average Costing. Where can I > see the average costs of a product. How is it calculated in the system? > > > Original Message > Subject: Re: Inventory - Moving Average > From: Vaibhav Jain <vaibhav.j...@hotwaxsystems.com> > Date: Wed, January 24, 2018 10:17 pm > To: user@ofbiz.apache.org > > Hello James, > > What do you mean by "Moving average costs"? > > Vaibhav Jain > Sr. Enterprise Software Engineer > HotWax Systems > m: 782-834-1900 e: vaibhav.j...@hotwaxsystems.com > <desiree.jenkin...@hotwax.co> > > On Thu, Jan 25, 2018 at 4:23 AM, <ja...@productive1.com> wrote: > > > > > Does anyone know where I can find the moving average costs for each of > > the products in Ofbiz? What about how the system calculates moving > > average and how it is affected by returns from customers and returns to > > vendor? > > > > Thanks, > > > > James > > >
Re: Inventory - Moving Average
Hello James, What do you mean by "Moving average costs"? Vaibhav Jain Sr. Enterprise Software Engineer HotWax Systems m: 782-834-1900 e: vaibhav.j...@hotwaxsystems.com <desiree.jenkin...@hotwax.co> On Thu, Jan 25, 2018 at 4:23 AM, <ja...@productive1.com> wrote: > > Does anyone know where I can find the moving average costs for each of > the products in Ofbiz? What about how the system calculates moving > average and how it is affected by returns from customers and returns to > vendor? > > Thanks, > > James >
Re: Order Allocation
Hello James, We can enhance data model to handle the scenarios defined above: *FacilityAssoc* facilityId* facilityIdTo* facilityAssocTypeId* fromDate* thruDate sequenceNo (For Ex: A facility have more than one alternate facility then seqneceNum is used for sequencing) *FacilityAssocType* facilityAssocTypeId* description Please share your thoughts on this. Thanks & Regards Vaibhav Jain Hotwax Systems, vaibhav.j...@hotwaxsystems.com On Tue, Dec 12, 2017 at 7:27 PM, <ja...@productive1.com> wrote: > > I have a scenario where I have 2 warehouses. I always want to ship > products from the nearest warehouse to the client. How does ofbiz > handle order allocation of product on sales orders to a specific > warehouse. Can we set up customers to get products from a specific > warehouse? > > Thanks, > > James >
Re: The following required parameter is missing: [getInventoryAvailableByFacility.facilityId])
Hello Javier, FacilityId is required attribute while we fetch inventory according to the facility using getInventoryAvailableByFacility. Please check why *facilityId* is missing when you hit the request. For quick references: 1) Productfacility data may be missing. 2) ownerPartyId may be missing in Facility entity. Thanks & Regards, Vaibhav Jain Hotwax Systems, vaibhav.j...@hotwaxsystems.com On Sun, Dec 3, 2017 at 8:04 PM, Javier H. <droin...@gmail.com> wrote: > Hello > > In webstore I can search for products, but when I enter the product page I > get this error, in /ecommerce/products/product_ID. > > Say that getInventoryAvailableByFacility.facilityId is missing, but the > product has assigned a Facility, Party and has stock. > > What else could I review in the product to correct this error? > > Best regards. > > org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering > screen [component://ecommerce/widget/CatalogScreens.xml#product]: > org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering > screen [component://ecommerce/widget/CommonScreens.xml#main-decorator]: > org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering > screen [component://ecommerce/widget/CatalogScreens.xml#productdetail]: > java.lang.IllegalArgumentException: Error running script at location > [component://order/groovyScripts/entry/catalog/ProductDetail.groovy]: > org.apache.ofbiz.service.ServiceValidationException: The following > required parameter is missing: [getInventoryAvailableByFacility.facilityId] > (Error running script at location [component://order/ > groovyScripts/entry/catalog/ProductDetail.groovy]: > org.apache.ofbiz.service.ServiceValidationException: The following > required parameter is missing: [getInventoryAvailableByFacility.facilityId]) > (Error rendering screen [component://ecomm > erce/widget/CatalogScreens.xml#productdetail]: > java.lang.IllegalArgumentException: > Error running script at location [component://order/ > groovyScripts/entry/catalog/ProductDetail.groovy]: > org.apache.ofbiz.service.ServiceValidationException: The following > required parameter is missing: [getInventoryAvailableByFacility.facilityId] > (Error running script at location [component://order/ > groovyScripts/entry/catalog/ProductDetail.groovy]: > org.apache.ofbiz.service.ServiceValidationException: The following > required parameter is missing: [getInventoryAvailableByFacility.facilityId])) > (Error rendering screen [component://ecommerce/widget/ > CommonScreens.xml#main-decorator]: > org.apache.ofbiz.widget.renderer.ScreenRenderException: > Error rendering screen > [component://ecommerce/widget/CatalogScreens.xml#productdetail]: > java.lang.IllegalArgumentException: Error running script at location > [component://order/groovyScripts/entry/catalog/ProductDetail.groovy]: > org.apache.ofbiz.service.ServiceValidationExcep > tion: The following required parameter is missing: [ > getInventoryAvailableByFacility.facilityId] (Error running script at > location [component://order/groovyScripts/entry/catalog/ProductDetail.groovy]: > org.apache.ofbiz.service.ServiceValidationException: The following > required parameter is missing: [getInventoryAvailableByFacility.facilityId]) > (Error rendering screen > [component://ecommerce/widget/CatalogScreens.xml#productdetail]: > java.lang.IllegalArgumentException: Error running script at location > [component://order/groovyScripts/entry/catalog/ProductDetail.groovy]: > org.apache.ofbiz.service.ServiceValidationException: The following > required parameter is missing: [getInventoryAvailableByFacility.facilityId] > (Error running script at location [component://order/ > groovyScripts/entry/catalog/ProductDetail.groovy]: > org.apache.ofbiz.service.ServiceValidationException: The following > required parameter is missing: [getInventoryAvailableByFacilit > y.facilityId]))) >
Re: Two companies with the same warehouse.
Hello Javier, You don't need 2 OFBiz installation. Inventory Item has an attribute ownerPartyId which is used to define the ownership of product if multiple companies are using single facility/warehouse. It might happen that all use cases of inventory ownerPartyId are not working OOTB. For initial setup, you can use two different virtual facilities/warehouse for different companies(It is also recommended). This is working OOTB. If you want to manage inventory of multiple companies in one facility then this can be handled using ownerPartyId attribute of inventoryItem entity. Thanks & Regards, Vaibhav Jain Hotwax Systems, vaibhav.j...@hotwaxsystems.com On Mon, Dec 4, 2017 at 2:46 PM, Javier H. <droin...@gmail.com> wrote: > > > On 2017-12-04 06:35, Vaibhav Jain <vaibhav.j...@hotwaxsystems.com> wrote: > > Hello Javier, > > > > Please check comments inline. > > > > With Ofbiz it's possible to have two companies that share the same > > > warehouse? > > > > > Yes it is possible. > > > > > > > > For example, Company A buys 100 chairs and stores them. > > > > > > One day the company B has an order for a customer of 20 chairs but only > > > has 10 in stock. > > > > > > Can Ofbiz generate an Order Invoice to company A (which has 100 units) > of > > > 10 chairs so that the order can be delivered ?. Also, can company A > > > generate a Sales Invoice of 10 chairs for company B? > > > > > > And the same process for the inverse, that is: > > > > > > Company B buys 100 tables. > > > > > > One day the company A needs 30 tables, but its stock is 0. Could I use > 30 > > > of the stock of company B? And that automatically generated an Order > > > Invoice in company A and a Sales Invoice in company B? > > > > > > Is this possible with Ofbiz? If possible, do I need to create a plugin > for > > > it? > > > > > Yes it is possible with OFBiz. You don't need any plugin for this. All > you > > need to do is data setup only. > > > > If company A want to trade with company B then company B should be the > > customer of company A, vice versa is applicable for the second case. > > > > > > > Best regards > > > > > > Hello Vaibhav Jain, > > Thank you very much. > > Do I need to have 2 Ofbiz installations? > > Best regards >
Re: Two companies with the same warehouse.
Hello Javier, Please check comments inline. With Ofbiz it's possible to have two companies that share the same > warehouse? > Yes it is possible. > > For example, Company A buys 100 chairs and stores them. > > One day the company B has an order for a customer of 20 chairs but only > has 10 in stock. > > Can Ofbiz generate an Order Invoice to company A (which has 100 units) of > 10 chairs so that the order can be delivered ?. Also, can company A > generate a Sales Invoice of 10 chairs for company B? > > And the same process for the inverse, that is: > > Company B buys 100 tables. > > One day the company A needs 30 tables, but its stock is 0. Could I use 30 > of the stock of company B? And that automatically generated an Order > Invoice in company A and a Sales Invoice in company B? > > Is this possible with Ofbiz? If possible, do I need to create a plugin for > it? > Yes it is possible with OFBiz. You don't need any plugin for this. All you need to do is data setup only. If company A want to trade with company B then company B should be the customer of company A, vice versa is applicable for the second case. > Best regards >
Re: Verify Multicurrency Flow
Hello Akash, A transaction can be posted either in home currency or foreign currency. So, If incoming payment is posted in customer currency then outgoing payment should be posted in supplier(respected party) currency. OR Both incoming and outgoing payment should be posted in home currency. Thanks & Regards -- Vaibhav Jain Hotwax Systems, vaibhav.j...@hotwaxsystems.com On Tue, Oct 24, 2017 at 10:51 AM, Akash Jain <akash.j...@hotwaxsystems.com> wrote: > Thanks Vaibhav for your reply! > > comment inline.. > > Thanks and Regards > -- > Akash Jain > > On Tue, Oct 24, 2017 at 10:24 AM, Vaibhav Jain < > vaibhav.j...@hotwaxsystems.com> wrote: > > > Hello Akash, > > > > > > >>Just want to confirm that, is it expected behaviour OR incoming payment > > >>transactions should also be posted in company currency (USD) for SO. > > If the transactions are recorded in home currency, the rate at which the > > foreign currency is exchanged should be recorded as well. > > OR > > You need to record the transaction in the foreign currency itself when > you > > maintain the balance of the concerned account in foreign currency. > > > > There are also stored origAmount and origCurrencyUomId along with amount > and currencyUomId for all the transactions, so, conversion rate can be > calculated at any moment. > > > > > > Thanks & Regards > > -- > > > > Vaibhav Jain > > Hotwax Systems, > > vaibhav.j...@hotwaxsystems.com > > > > On Mon, Oct 23, 2017 at 11:18 AM, Akash Jain < > akash.j...@hotwaxsystems.com > > > > > wrote: > > > > > Hello All, > > > > > > I have verified multi-currency flow for SO and PO, here is the detail: > > > > > > PO: Company currency is USD and Supplier currency is EUR, then, > > > -- order created in supplier currency > > > -- inventory cost of products are company currency after receiving > > > products. > > > -- invoice created in supplier currency > > > -- payment created in supplier currency > > > -- accounting transactions (for Purchase Invoice, Outgoing Payment and > > > Payment > > > Applied types) posted in company currency. > > > > > > I think this flow is working as expected, please confirm? > > > > > > SO: Company currency is USD and Customer currency is EUR, then, > > > -- order created in customer currency > > > -- invoice created in customer currency > > > -- payment created in customer currency > > > -- accounting transactions (for Sales Invoice and Payment Applied > types) > > > posted in company currency. > > > -- accounting transactions for *Incoming Payment* type posted in > > *customer* > > > currency. > > > > > > Just want to confirm that, is it expected behaviour OR incoming payment > > > transactions should also be posted in company currency (USD) for SO. > > > > > > Thanks in advance for your reply! > > > > > > Thanks and Regards > > > -- > > > Akash Jain > > > www.hotwaxsystems.com > > > www.hotwax.co > > > > > >
Re: Verify Multicurrency Flow
Hello Akash, >>Just want to confirm that, is it expected behaviour OR incoming payment >>transactions should also be posted in company currency (USD) for SO. If the transactions are recorded in home currency, the rate at which the foreign currency is exchanged should be recorded as well. OR You need to record the transaction in the foreign currency itself when you maintain the balance of the concerned account in foreign currency. Thanks & Regards -- Vaibhav Jain Hotwax Systems, vaibhav.j...@hotwaxsystems.com On Mon, Oct 23, 2017 at 11:18 AM, Akash Jain <akash.j...@hotwaxsystems.com> wrote: > Hello All, > > I have verified multi-currency flow for SO and PO, here is the detail: > > PO: Company currency is USD and Supplier currency is EUR, then, > -- order created in supplier currency > -- inventory cost of products are company currency after receiving > products. > -- invoice created in supplier currency > -- payment created in supplier currency > -- accounting transactions (for Purchase Invoice, Outgoing Payment and > Payment > Applied types) posted in company currency. > > I think this flow is working as expected, please confirm? > > SO: Company currency is USD and Customer currency is EUR, then, > -- order created in customer currency > -- invoice created in customer currency > -- payment created in customer currency > -- accounting transactions (for Sales Invoice and Payment Applied types) > posted in company currency. > -- accounting transactions for *Incoming Payment* type posted in *customer* > currency. > > Just want to confirm that, is it expected behaviour OR incoming payment > transactions should also be posted in company currency (USD) for SO. > > Thanks in advance for your reply! > > Thanks and Regards > -- > Akash Jain > www.hotwaxsystems.com > www.hotwax.co >
Re: Implementing GST tax in Ofbiz - CGST , SGST , IGST
Please check inline On Thu, Oct 12, 2017 at 8:43 PM, Rajesh Mallah <mallah.raj...@gmail.com> wrote: > Thanks Vaibhav for the notes regarding the HSN . Currently we are not > handling > HSN in our installation as most of our products are under same hsn. > I am just curious to know how you can calculate tax without using HSN code. Is there any way to calculate tax without HSN code. > Although > The handling of ORIG_LOCATION and DEST_LOCATION has been done. > Great > > As we know GST in India is based on ORIG_LOCATION and DEST_LOCATION > and is currently it is the only tax. > > But in a general situation where you have "GST like" taxes and some other > taxes > also say "Education Cess" (now defunct,i think) there needs to be an > option to > Thanks for the make me remeber about about "CESS". Yes we need to entertain "CESS" as well. > have custom logic association with different kind of taxes and was the > concern which > i had raised. > Not able to get your point. Can you please elaborate? > > regds > mallah > > > > > > > On Thu, Oct 12, 2017 at 11:25 AM, Vaibhav Jain < > vaibhav.j...@hotwaxsystems.com> wrote: > > > Hello Rajesh/Everyone, > > > > GST(India) can be implemented in OFBiz as follow: > > > > After GST tax will apply on the basis of HSN code of product not on the > > product directly. So we can associate HSN code with tax slab in > > ProductCategoryRollup entity like > > > > > parentProductCategoryId="TAX_SLAB" fromDate="2017-07-01 12:00:00.0" > > sequenceNum="1"/> > > > > As we need to define tax slab, ProductCategory entity can be used to > > categorise the tax slabs like > > > > > productCategoryTypeId="TAX_CATEGORY" description="5.00 %" > > categoryName="5.00 %"/> > > > > Now tax slab is associated with HSN. So, product will be associated with > > HSN code in ProductCategoryMember entity like > > > > productId="" > > fromDate="2001-01-01 12:00:00.000"/> > > > > All the HSN code can be stored in ProductCategory entity > > > > > productCategoryTypeId="HSN_CATEGORY" categoryName="XX" > > description="Cheese and curd"/> > > > > Tax authority can be stored in PartyTaxAuthInfo entity like > > > > > taxAuthPartyId="IGST" fromDate="2017-06-01 00:00:00.0" isNexus="Y" > > partyTaxId="XGSTINXXX"/> > > > taxAuthPartyId="CGST" fromDate="2017-06-01 00:00:00.0" isNexus="Y" > > partyTaxId="XGSTINXXX"/> > > > taxAuthPartyId="IN-AN_UTGST" fromDate="2017-06-01 00:00:00.0" isNexus="Y" > > partyTaxId="XGSTINXXX"/> > > > taxAuthPartyId="IN-AP_SGST" fromDate="2017-06-01 00:00:00.0" isNexus="Y" > > partyTaxId="XGSTINXXX"/> > > > > GST can be configurable in OFBiz using ProductStoreTaxSetting entity > > We can write a separate service to calculate GST and configure at > > ProductStore level using taxServiceName attribute of > ProductStoreTaxSetting > > entity. > > > > Just for Info > > Right now In PO and SO OFBiz does not entertain both SHIP_ORIG_LOCATION > and > > SHIP_DESTINATION_LOCATION. We need to introduce this as well to calculate > > the GST. > > > > Thanks & Regards > > > > Vaibhav Jain > > Hotwax Systems, > > vaibhav.j...@hotwaxsystems.com > > > > On Mon, Oct 9, 2017 at 8:13 PM, Rajesh Mallah <mallah.raj...@gmail.com> > > wrote: > > > > > Hi , > > > > > > I need help regarding how to apply taxes broadly based on the > > > fact whether the supplier and consumer are in same state or not. > > > > > > We are able to apply taxes based on GEO ID of the customer but > > > what is really required is the below: > > > > > > If Supplier.state == Customer.state > > > add adjustment SGST @ X% > > > add adjustment CGST @ X% > > > else > > > add adjustment IGST @ X+X% > > > > > > > > > where: > > > CGST --> Central Goods & Services Tax > > > SGST --> State Goods & Services Tax > > > IGST --> Integrated Goods & Services Tax > > > > > > > > > Any help on this regard is solicited. > > > > > > > > > regds > > > mallah. > > > > > >
Re: Implementing GST tax in Ofbiz - CGST , SGST , IGST
Hello Rajesh/Everyone, GST(India) can be implemented in OFBiz as follow: After GST tax will apply on the basis of HSN code of product not on the product directly. So we can associate HSN code with tax slab in ProductCategoryRollup entity like As we need to define tax slab, ProductCategory entity can be used to categorise the tax slabs like Now tax slab is associated with HSN. So, product will be associated with HSN code in ProductCategoryMember entity like All the HSN code can be stored in ProductCategory entity Tax authority can be stored in PartyTaxAuthInfo entity like GST can be configurable in OFBiz using ProductStoreTaxSetting entity We can write a separate service to calculate GST and configure at ProductStore level using taxServiceName attribute of ProductStoreTaxSetting entity. Just for Info Right now In PO and SO OFBiz does not entertain both SHIP_ORIG_LOCATION and SHIP_DESTINATION_LOCATION. We need to introduce this as well to calculate the GST. Thanks & Regards Vaibhav Jain Hotwax Systems, vaibhav.j...@hotwaxsystems.com On Mon, Oct 9, 2017 at 8:13 PM, Rajesh Mallah <mallah.raj...@gmail.com> wrote: > Hi , > > I need help regarding how to apply taxes broadly based on the > fact whether the supplier and consumer are in same state or not. > > We are able to apply taxes based on GEO ID of the customer but > what is really required is the below: > > If Supplier.state == Customer.state > add adjustment SGST @ X% > add adjustment CGST @ X% > else > add adjustment IGST @ X+X% > > > where: > CGST --> Central Goods & Services Tax > SGST --> State Goods & Services Tax > IGST --> Integrated Goods & Services Tax > > > Any help on this regard is solicited. > > > regds > mallah. >
Re: Inventory Transfer Feature
Hello Deepak, Thanks Suraj for the reference. I also tried running these process and here are my findings. We are using inventory xfer for inventory transfer feature but we do not create any shipment. All the records are stored in InventoryTransfer entity. We do not hit *accounting* while creating inventory transfer. Am I missing something or do we need to include these processes as well? Thanks and Regards Vaibhav Jain Hotwax Systems, vaibhav.j...@hotwaxsystems.com On Wed, Aug 30, 2017 at 11:41 AM, Deepak Nigam < deepak.ni...@hotwaxsystems.com> wrote: > Thanks, Suraj. > > Thanks & Regards > -- > Deepak Nigam > Technical Consultant/Team Lead > HotWax Systems > www.hotwaxsystems.com > > On Sat, Aug 26, 2017 at 10:31 AM, Suraj Khurana < > suraj.khur...@hotwaxsystems.com> wrote: > > > Hi Deepak, > > > > Please see my comments inline. > > > > > > On Sat, Aug 26, 2017 at 10:18 AM, Deepak Nigam < > > deepak.ni...@hotwaxsystems.com> wrote: > > > > > Hello All, > > > > > > Do we have the support of features described below OTTB? > > > > > > 1) Inventory transfer from one warehouse to another warehouse. > > > > > > > Yes, in the facility detail screen, you will find Inventory Xfers menu > > which willl lead to transfer inventory with one warehouse to another. > > > > > > > 2) Inventory transfer from one location to another, within the same > > > warehouse. > > > > > > > Yes, in the facility detail screen, you will find Stock Moves option > which > > will help to transfer stock from one location to another within the same > > facility. > > > > > > > > > > If these features are available then please guide me to use them. > > > > > > Thanks in advance. > > > > > > > > > > > > > > > Thanks & Regards > > > -- > > > Deepak Nigam > > > Technical Consultant/Team Lead > > > HotWax Systems > > > www.hotwaxsystems.com > > > > > > > HTH. > > -- > > Thanks and Regards, > > *Suraj Khurana* | Sr. Enterprise Software Engineer > > >
Re: Inventory transfer in OFBiz
> Hello All, > > While doing inventory transfer, it creates a new *InventoryItem* record > in which *transferred quantity* is reflected in *ATP* and *QOH* if this > facility/inventory transfer is in *Completed *status*, *otherwise > transferred quantity is reflected in *QOH* and *ATP* will be ZERO (as the > transfer is not completed yet). > > First Que: Does this *QOH* needs to be updated at this time or after > successful inventory transfer i.e. at the time when *ATP* increased. > I did findings and found that the system is working fine in the case of updated QOH. 1. Requested :- a) In requested status ATP and QOH of *From Facility/From Location *is decresed by *xferQuantity *and *QOH* of *To Facility/To location *is increasesd by xferQunatity. This QOH is keeping the record of xferQuantity for further. b) Inventory valuation will also working fine as AQT is not affected and inventory valuation is done by AQT. c) When status transfer inventory is changed from requested -> Completed then ATP is increased equal to QOH for respective inventory item record. d) If transfer inventory item is cancelled then trasfer is cancelled but system generate a new inventory item record with *From Facility/From location *and xferQuantity.So it is also fine. > Now when we transfer inventory, the *accountingQuantityTotal* field of > *InventoryItem* entity is always ZERO. There is no reflection of *ATP*/ > *QOH* in *accountingQuantityTotal*. > I did findings on this one then found that it is a bug in the current system. When we transfer inventory from one facility to another facility then *accounting quantity transfer* will not affect. This will create following issues in the system. 1. *Accounting quantity total *will mismatch with the original quantity in the facility which shows wrong result when we calculate facility specific inventory valuation. 2. Inventory reservation also throws an error in some specific case like when AQT of respective product is zero in the specific facility from when reservation happens. I am raising an issue for that on JEERA.Here is the referance for that https://issues.apache.org/jira/browse/OFBIZ-9464 > > Please suggest, am I doing something wrong or is it a flaw/Gap in the > current system. > > Thanks & Regards > -- > Vaibhav Jain > Hotwax Systems, > vaibhav.j...@hotwaxsystems.com >
Inventory transfer in OFBiz
Hello All, While doing inventory transfer, it creates a new *InventoryItem* record in which *transferred quantity* is reflected in *ATP* and *QOH* if this facility/inventory transfer is in *Completed *status*, *otherwise transferred quantity is reflected in *QOH* and *ATP* will be ZERO (as the transfer is not completed yet). First Que: Does this *QOH* needs to be updated at this time or after successful inventory transfer i.e. at the time when *ATP* increased. Now when we transfer inventory, the *accountingQuantityTotal* field of *InventoryItem* entity is always ZERO. There is no reflection of *ATP*/*QOH* in *accountingQuantityTotal*. Please suggest, am I doing something wrong or is it a flaw/Gap in the current system. Thanks & Regards -- Vaibhav Jain Hotwax Systems, vaibhav.j...@hotwaxsystems.com
Re: COGS costing method is not supported Error
Hello Shweta, Please check the records of "InventoryItem" entity for your sales order. If "accountingQuantityTotal" field is *ZERO *for respective inventory item then it will throw this error. Why? Because, at the time of item issuances, GL postings are done in " *INVENTORY_ACCOUNT*" account. And system takes "accountingQuantityTotal" into consideration to calculate postings to be done in "INVENTORY_ACCOUNT". And when system gets accountingQuantityTotal = 0, it returns error. Thanks & Regards -- Vaibhav Jain Hotwax Systems, vaibhav.j...@hotwaxsystems.com On Thu, Feb 16, 2017 at 10:52 AM, Paul Foxworthy <p...@cohsoft.com.au> wrote: > Hi Shweta, > > Were you able to solve the problem? > > Cheers > > Paul Foxworthy > > On 12 January 2017 at 17:02, Paul Foxworthy <p...@cohsoft.com.au> wrote: > > > Hi Shweta, > > > > OK. Check the owners of the relevant inventory item or items. Are they > > Company too, or another party without accounting prefs? > > > > If that doesn't help, I suggest you add some logging > > to applications/accounting/minilang/ledger/GeneralLedgerServices.xml to > > discover the value of cogsMethodId. > > > > So about here: > > > > http://svn.apache.org/viewvc/ofbiz/trunk/applications/ > > accounting/minilang/ledger/GeneralLedgerServices.xml?view=markup#l1054 > > > > after the party accounting preferense have been fetched, add a line like > > > > > /> > > > > Hope that helps. > > > > Cheers > > > > Paul > > > > > > > > On 9 January 2017 at 14:46, shwetacf <shw...@kustommade.com> wrote: > > > >> It is for a company only. And the owner is Company. > >> > >> > >> Thanks > >> Shweta > >> > >> > >> > >> -- > >> View this message in context: http://ofbiz.135035.n4.nabble. > >> com/COGS-costing-method-is-not-supported-Error-tp4700827p4700882.html > >> Sent from the OFBiz - User mailing list archive at Nabble.com. > >> > > > > > > > > -- > > Coherent Software Australia Pty Ltd > > PO Box 2773 > > Cheltenham Vic 3192 > > Australia > > > > Phone: +61 3 9585 6788 <+61%203%209585%206788> > > Web: http://www.coherentsoftware.com.au/ > > Email: i...@coherentsoftware.com.au > > > > > > -- > Coherent Software Australia Pty Ltd > PO Box 2773 > Cheltenham Vic 3192 > Australia > > Phone: +61 3 9585 6788 > Web: http://www.coherentsoftware.com.au/ > Email: i...@coherentsoftware.com.au >
Re: SCIPIO ERP: a modern OFBiz fork
Hello Paul, It is amazing. Congrats. Best regards Vaibhav Jain <vaibhav.j...@hotwaxsystems.com> Hotwax Systems <http://www.hotwaxsystems.com/> On Tue, Jun 7, 2016 at 10:30 AM, Pranay Pandey < pranay.pan...@hotwaxsystems.com> wrote: > Its' admin/scipio > > But now it's not working, userLogin got disabled due failed attempts. > > > Best regards, > > Pranay Pandey > HotWax Systems > http://www.hotwaxsystems.com/ > > On Tue, Jun 7, 2016 at 10:29 AM, Pranay Pandey < > pranay.pan...@hotwaxsystems.com> wrote: > > > Okay never mind, got it- > > > > > > Best regards, > > > > Pranay Pandey > > HotWax Systems > > http://www.hotwaxsystems.com/ > > > > On Tue, Jun 7, 2016 at 10:22 AM, Pranay Pandey < > > pranay.pan...@hotwaxsystems.com> wrote: > > > >> Great job Paul and team. > >> > >> Can we we review the demo website backend? Is there any demo login that > >> can be used? > >> > >> Best regards, > >> > >> Pranay Pandey > >> HotWax Systems > >> http://www.hotwaxsystems.com/ > >> > >> On Mon, Jun 6, 2016 at 8:29 PM, Paul Piper <p...@ilscipio.com> wrote: > >> > >>> Hey everyone, > >>> > >>> > >>> > >>> we just launched http://www.scipioerp.com a modern ERP & E-Commerce > >>> solution > >>> based on Apache OFBiz. Among our changes are: > >>> > >>> > >>> > >>> * New: templating toolkit (standardization of html in > freemarker > >>> & > >>> widgets) > >>> > >>> o Includes new standardizes elements > >>> > >>> * New: Foundation CSS based Backoffice themes > >>> > >>> o Metro (a modern admin theme) > >>> > >>> o Base (an unstyled foundation theme) > >>> > >>> * New: Modern E-Commerce theme > >>> > >>> o Foundation-Shop > >>> > >>> * New: Modern e-Commerce store > >>> > >>> o Demo: https://ce.scipioerp.com/shop > >>> > >>> o Several Bugfixes > >>> > >>> o Code clean-up > >>> > >>> o Migration of templates to templating toolkit > >>> > >>> * New: Modern backoffice applications > >>> > >>> o Demo: <https://ce.scipioerp.com/admin> > >>> https://ce.scipioerp.com/admin > >>> > >>> o Migration to templating toolkit > >>> > >>> o Simplification & standardization of UI Elements > >>> > >>> o New & Updated screens > >>> > >>> o Various bug-fixes > >>> > >>> o Update on all menus (so that they are coherent & understandable) > >>> > >>> * Various Bugfixes to the framework > >>> > >>> * Groovy file rewrites > >>> > >>> * Label fixes > >>> > >>> * General code clean-up > >>> > >>> * Updated rendering engine > >>> > >>> * Full solr integration > >>> > >>> > >>> > >>> The package is released as open-source under the Apache License and > >>> available for download here: https://github.com/ilscipio/scipio-erp > >>> > >>> > >>> > >>> I hope you enjoy our effort and are as excited as we are. Feel free to > >>> join > >>> our community: http://forum.scipioerp.com/ > >>> > >>> > >>> > >>> A complete developer documentation is available here: > >>> > http://www.scipioerp.com/community/developer/installation-configuration/ > >>> > >>> > >>> > >>> Kind regards, > >>> > >>> Paul > >>> > >>> > >>> > >>> P.S.: The project is compatible with OFBiz 14 at the moment and has > been > >>> tested with other OFBiz version as well. For more information, refer to > >>> our > >>> migration guide: > >>> > >>> > http://www.scipioerp.com/community/developer/installation-configuration/ofbi > >>> z-migration/ > >>> < > http://www.scipioerp.com/community/developer/installation-configuration/ofbiz-migration/ > > > >>> > >>> > >>> > >>> --- > >>> > >>> Paul Piper > >>> > >>> Geschäftsführer > >>> > >>> > >>> > >>> > >>> > >>> Web: <http://www.ilscipio.com/> http://www.ilscipio.com > >>> > >>> Tel: (+49) 611-94589441 > >>> > >>> Mobil: (+49) 176-63283066 > >>> > >>> Fax: (+49) 611-94589449 > >>> > >>> eMail: <mailto:p...@ilscipio.com> p...@ilscipio.com > >>> > >>> > >>> > >>> > >>> > >>> ilscipio GmbH > >>> > >>> Am Drosselschlag 7 > >>> > >>> D-35452 Heuchelheim > >>> > >>> Germany > >>> > >>> > >>> > >>> > >> > > >
Re: {MARKETING] New OFBiz Logo for Website
Hello all, I also like the second one Best regards Vaibhav Jain <vaibhav.j...@hotwaxsystems.com> Hotwax Systems <http://www.hotwaxsystems.com/> On Sun, May 29, 2016 at 3:07 PM, Sharan-F <sharan.f...@gmail.com> wrote: > Hi > > I agree with Pierre in that our logo is about our brand and it could have > been absolutely anything but it just so happens that we chose to use a > word. > The main thing is that when people see the logo – they associate it with > OFBiz. > > For the new website, I included the logo re-branding in the scope because > it > was something quick and easy to do. The general feedback seems to be that > people like the 2nd option. > > I'm pretty flexible so if someone else from the community wants to work on > changing the logo to something different to what I've proposed then that's > fine – I can hand over that task. The main thing is that I really need to > know quickly so that I don't spend any more time on it. > > Thanks > Sharan > > > > -- > View this message in context: > http://ofbiz.135035.n4.nabble.com/MARKETING-New-OFBiz-Logo-for-Website-tp4681769p4681782.html > Sent from the OFBiz - User mailing list archive at Nabble.com. >
Request to join as a contributor
I have filled the ICLA and enlisted on people.apache.org <https://people.apache.org/unlistedclas.html>. My confluence user detail to become a contributor: Full Name: Vaibhav Jain userName: vaibhav.jain Email : vaibhav.j...@hotwaxsystems.com Mobile No. : 7828341900 Best regards Vaibhav Jain <vaibhav.j...@hotwaxsystems.com> Hotwax Systems <http://www.hotwaxsystems.com/>
