Re: setting up TAX in ofbiz

2017-08-30 Thread Rajesh Mallah
I wonder why a query on a table should be run looking for rows where the primary key of table is null. the sole filter on the below query on ProductStore is: WHERE ((PRODUCT_STORE_ID IS NULL)) Note: this query is just run *before* looking in the ProductPrice table. more context here: https://pa

Re: setting up TAX in ofbiz

2017-08-30 Thread Rajesh Mallah
Hi Arun , I checked PartyAcctgPreference which was USD and changed it to INR yesterday only. After changes i do logout and login and restart the tomcat to ensure there are no caching issues. ofbiz_redgrape=> SELECT PTYACCPREF.PARTY_ID, PTYACCPREF.BASE_CURRENCY_UOM_ID, PTYGROUP.GROUP_NAME, PTYRO

Re: setting up TAX in ofbiz

2017-08-30 Thread Arun Patidar
Hello Rajesh, ProductStore and PartyAcctgPreference entities also have fields to store currency UOM. -- Thanks & Regards --- Arun Patidar Manager, Enterprise Software Development HotWax Systems Pvt Ltd. www.hotwaxsystems.com On Thu, Aug 31, 2017 at 9:17 AM, Rajesh Mallah wrote: > looks lik

UI improvement scope for excessively wide rows.

2017-08-30 Thread Rajesh Mallah
In many screens it is observed that there are series of non-breakable UI elements that occupy aggregate horizontal space exceeding the available space on screen. As a result the right-most columns are seen only on scrolling the content to left. the problem is more pronounced in themes that have a

Re: UI improvement for tables in OFBiz

2017-08-30 Thread Rajesh Mallah
Hi Jacques/List , Further, for mini/micro applications that absorb relatively less update information from teams on move (say e.g. opportunity status update from front-line sales team, status update from delivery courier fleet etc) it makes sense to use bootstrap/equivalent . But i feel such ap

Re: setting up TAX in ofbiz

2017-08-30 Thread Rajesh Mallah
looks like too many messages has already been exchanged in past at various point in time. http://ofbiz.markmail.org/search/?q=changing+default+currency#query:changing%20default%20currency it will be beneficial to new users if it is given attention . regds mallah. On Thu, Aug 31, 2017 at 8:01

Re: setting up TAX in ofbiz

2017-08-30 Thread Rajesh Mallah
@Deepak , @Rishi / List , Additional SQL tracing reveals that the ProductPricing entities are being queried with CURRENCY_UOM_ID=USD and hence the USD pricing is being picked up. I am not sure why USD currency is being picked. I have changed in almost all places including properties file. -- ./

Re: UI improvement for tables in OFBiz

2017-08-30 Thread Jacques Le Roux
Le 28/08/2017 à 08:24, Rajesh Mallah a écrit : Hi Nitish , I feel bootstrap is a mobile first framework and is primarily meant for creating ui that looks great in large and small screens. Given the kind of application Ofbiz is , it is difficult to imagine much core usage in mobile space as mos

Re: setting up TAX in ofbiz

2017-08-30 Thread Rajesh Mallah
thanks Jacques , i used it just now. On Wed, Aug 30, 2017 at 9:57 PM, Jacques Le Roux < jacques.le.r...@les7arts.com> wrote: > Yes, look in webtools for export > > Jacques > > > > Le 30/08/2017 à 18:02, Rajesh Mallah a écrit : > >> Hi Rishi , >> >> I am doing almost all functions using the UI onl

Re: setting up TAX in ofbiz

2017-08-30 Thread Rajesh Mallah
Hi Deepak , as specifically asked the, ProductPrice dump is below grepped for the said productID Please note that the pricing for entity2 is being picked up when we attempt to add the item (productID=1) to invoice. Pls suggest which other entity dump shall be useful for debugging

Re: setting up TAX in ofbiz

2017-08-30 Thread Jacques Le Roux
Yes, look in webtools for export Jacques Le 30/08/2017 à 18:02, Rajesh Mallah a écrit : Hi Rishi , I am doing almost all functions using the UI only Is it possible to export selected entities created using Web-UI to xml ? I am going to create a new product now and see how it does. regds ma

Re: setting up TAX in ofbiz

2017-08-30 Thread Rajesh Mallah
Hi Rishi / List , I did create a new product in same category and set its price and average price in INR . I took care to select the currency as INR . (everything using the UI only) still the price is picked a 0 which i try to add the new product as an invoice item. regds mallah. On Wed, Au

Re: setting up TAX in ofbiz

2017-08-30 Thread Rajesh Mallah
Hi Rishi , I am doing almost all functions using the UI only Is it possible to export selected entities created using Web-UI to xml ? I am going to create a new product now and see how it does. regds mallah. On Wed, Aug 30, 2017 at 9:14 PM, Rishi Solanki wrote: > Rajesh, > > IMO, what Dee

Re: setting up TAX in ofbiz

2017-08-30 Thread Rajesh Mallah
Hi Everyone , I am referring to old thread message: http://markmail.org/message/kwygn6w2tmfzvtbv In my case also i see that the Base Currency: USD in screen IN : Applications > Accounting > Organization GL Settings > Setup with no means of updating it. In said thread it is suggested to update

Re: setting up TAX in ofbiz

2017-08-30 Thread Rishi Solanki
Rajesh, IMO, what Deepak is suggesting seems correct, please try with different product or share the xml data setup you did for the product you are trying to add tax. May some extra setup/price override the behavior or incorrect setup for tax. Data will help us to diagnose and reply. Rishi Sol

Re: Theme Language and Timezone Video tutorial

2017-08-30 Thread Todd Thorner
Thanks very much for helping to make OFBiz more accessible to the world. On 17-08-30 04:53 AM, Deepak Dixit wrote: We have uploaded new video related to "Theme Language and Timezone" prepared by Pranay Pandey. Description: Learn how to navigate through Apache OFBiz application for setting user

Re: setting up TAX in ofbiz

2017-08-30 Thread Rajesh Mallah
> > Hi Rajesh, > > I think you try with a different product also. It is possible that > ProductPrice data is not correct/sufficient for the selected product and > system is not picking the correct price. Hi Deepak , I saw a currency related issue. I added a price with USD currency the price was

Re: setting up TAX in ofbiz

2017-08-30 Thread Deepak Nigam
Thanks, Pranay. Sure I'll have a look into OFBiz Wiki for the same. Thanks & Regards -- Deepak Nigam Technical Consultant/Team Lead HotWax Systems www.hotwaxsystems.com On Wed, Aug 30, 2017 at 5:37 PM, Pranay Pandey < pranay.pan...@hotwaxsystems.com> wrote: > Hi Deepak, > > Thanks for providing

Re: setting up TAX in ofbiz

2017-08-30 Thread Deepak Nigam
Hi Rajesh, I think you try with a different product also. It is possible that ProductPrice data is not correct/sufficient for the selected product and system is not picking the correct price. Thanks & Regards -- Deepak Nigam Technical Consultant/Team Lead HotWax Systems www.hotwaxsystems.com On

Re: setting up TAX in ofbiz

2017-08-30 Thread Pranay Pandey
Hi Deepak, Thanks for providing these details. It's good material to go in a document on OFBiz Wiki if doesn't exist already. Best regards, Pranay Pandey On Wed, Aug 30, 2017 at 2:34 PM, Deepak Nigam < deepak.ni...@hotwaxsystems.com> wrote: > Hi Rajesh, > > Most of the mentioned requirements ca

Re: Theme Language and Timezone Video tutorial

2017-08-30 Thread Pranay Pandey
Thanks for your help Deepak. Best regards, Pranay Pandey www.hotwaxsystems.com www.hotwax.co On Wed, Aug 30, 2017 at 5:23 PM, Deepak Dixit wrote: > We have uploaded new video related to "Theme Language and Timezone" > prepared by Pranay Pandey. > > Description: > Learn how to navigate through A

Theme Language and Timezone Video tutorial

2017-08-30 Thread Deepak Dixit
We have uploaded new video related to "Theme Language and Timezone" prepared by Pranay Pandey. Description: Learn how to navigate through Apache OFBiz application for setting user preferences for application UI theme, language, time zone and locate, view user/party profile. Here is the youtube an

Re: setting up TAX in ofbiz

2017-08-30 Thread Rajesh Mallah
Some more progress: I was able to apply taxes to demo products using new tax authority . The incremental steps i did were: (1) setup "Categories" , "Association" , "Product Rates" for the new tax authority in Accounting --> Tax Auth . Rite now the problem is when i add "Items" in invoice

Re: setting up TAX in ofbiz

2017-08-30 Thread Rajesh Mallah
Consider the Invoice: https://demo-trunk.ofbiz.apache.org/accounting/control/invoiceOverview?invoiceId=CI2 The product in question does not belong to any taxable category , i wanted to know how taxes are being applied to it. Product Categories: https://demo-trunk.ofbiz.apache.org/catalog/contro

Re: setting up TAX in ofbiz

2017-08-30 Thread Rajesh Mallah
Hi Deepak , Thanks for the useful demo data. I went through it and could understand mostly, although perfect assimilation will take some time owing to my current level in the learning curve. :-) my current hurdle is follows and would appreciate help. I have configured a new product upto a stage

Re: setting up TAX in ofbiz

2017-08-30 Thread Deepak Nigam
Hi Rajesh, Most of the mentioned requirements can be fulfilled by setting up data in entities like TaxAuthorityCategory and TaxAuthorityRateProduct, as the OFBiz tax engine internally uses data from these entities to perform tax calculations. Please refer to the following set of demo data. It can

Re: setting up TAX in ofbiz

2017-08-30 Thread Rajesh Mallah
Thanks , Paul's reply did help , and I saw taxes getting automatically added after the product was included in a extra category of type *Tax* . I named to the category as "Taxable Products" for time being (as suggested). regds mallah. On Wed, Aug 30, 2017 at 1:56 PM, Jacques Le Roux < jacque

Re: setting up TAX in ofbiz

2017-08-30 Thread Jacques Le Roux
You are doing very well comparing to some others ;) Jacques Le 30/08/2017 à 09:36, Rajesh Mallah a écrit : thanks. I hope i finally reach the mundane state soon. regds mallah. On Wed, Aug 30, 2017 at 1:03 PM, Jacques Le Roux < jacques.le.r...@les7arts.com> wrote: This http://markmail.org/

Live Ship Estimates

2017-08-30 Thread james
Team - I am trying to figure out live shipping estimates with Ofbiz. I see that I can set up the system to use live estimates from UPS and Fedex. In the store set up I can define what I want the uplift to be. I have a few questions. 1. Typically we do not have weight or dimensions at the time

Our New OFBiz Website is Live!

2017-08-30 Thread Sharan Foga
Hi Everyone A quick note to let you all know that our new OFBiz website is live! Huge, huge thanks and kudos to everyone who contributed ideas, gave feedback and supported the effort. :-) Thanks Sharan

Re: [Updates] - OFBiz tutorial restructuring & release specific tutorial

2017-08-30 Thread Swapnil Mane
Thank you Jacques for your kind words. Yes, agree, we should prune the old comments. For https://issues.apache.org/jira/browse/OFBIZ-7145, I was planning to close this today, with some comments. Thanks again! :-) - Best Regards, Swapnil M Mane On Wed, Aug 30, 2017 at 12:58 PM, Jacques Le Roux

Re: setting up TAX in ofbiz

2017-08-30 Thread Rajesh Mallah
thanks. I hope i finally reach the mundane state soon. regds mallah. On Wed, Aug 30, 2017 at 1:03 PM, Jacques Le Roux < jacques.le.r...@les7arts.com> wrote: > This http://markmail.org/message/esl5ou2zo4x2lt3l :D > > You should do more research in the ML archives ;) > > Jacques > > > > Le 30/08/

Re: setting up TAX in ofbiz

2017-08-30 Thread Jacques Le Roux
This http://markmail.org/message/esl5ou2zo4x2lt3l :D You should do more research in the ML archives ;) Jacques Le 30/08/2017 à 08:22, Rajesh Mallah a écrit : Hi , Can someone point me to a useful documentation on setting up taxation. Expectations : (1) tax % should be allowed to be specifi

Re: [Updates] - OFBiz tutorial restructuring & release specific tutorial

2017-08-30 Thread Jacques Le Roux
Hi Swapnil, I did not read it all, but sounds like we definitely have something helpful for all new comers (not only trunk) :) Thank you again to all who participated to the effort. Ah, I  think we need to prune the obsolete comments in trunk version Should we  not close https://issues.apache

Re: setting up TAX in ofbiz

2017-08-30 Thread Rajesh Mallah
Creating an invoice for a Democustomer in demo data set does meet most of the expectations. The point is (at this moment) setting ofbiz is not a cakewalk :-( I wish there were some blogs that could spoon feed me :-) and which would cover the entire cycle. I have customers' waiting for quotes and i

Re: why re-entry of description/price while adding invoice item?

2017-08-30 Thread Rajesh Mallah
Kindly ignore above email. It appears so because the form does not get pre-filled. But added items do bear descriptions and prices. sorry for the noise. regds mallah. On Wed, Aug 30, 2017 at 12:09 PM, Rajesh Mallah wrote: > Hi , > > While creating invoice on adding an invoice item , > Why ar