I only presented a possible way to execute your scenario in OFBiz, there may be some better/alternate solution though. As I said before you will need an Item adjustment for sales tax to be able to generate a sales tax line item on Invoice. From there you would be able to post accounting transaction to the gl account related to sales tax. I believe you only need to figure out how to create the item adjustment (OrderAdjustment record) for sales tax.
Regards Vikas On May 30, 2012, at 5:14 PM, Nandani Aggarwal wrote: > But with reference to my second post in this thread , my problem was to see > tax transaction (along with other transactions) in an invoice provided that > sales tax (VAT or CST etc) is already included in product price. > > > Regards > Nandani > > On Wed, May 30, 2012 at 4:45 PM, Vikas Mayur <[email protected]> wrote: > >> No, it won't because sales tax is not charged on the order. >> >> Regards >> Vikas >> >> On May 30, 2012, at 4:11 PM, Nandani Aggarwal wrote: >> >>> Vikas, >>> >>> Thank a lot ,What ever you explained is absolutely correct but by doing >>> taxable = 'N' and taxPromotions to 'N' are you able to see tax >> transaction >>> in your invoice which shows the amount paid to tax authority.? >>> >>> Regards >>> Nandani >>> >>> On Wed, May 30, 2012 at 2:51 PM, Vikas Mayur <[email protected]> >> wrote: >>> >>>> Nandani, >>>> >>>> I have never tested this use case before and was curious to know how >> this >>>> works so I did few test by placing a sales order for product WG-1111 and >>>> DemoCustomer (note: the shipping address of this demo customer is Utah >> and >>>> OFBiz demo data have a tax authority setup for this state. I only did >> one >>>> change in the TaxAuthorityRateProduct entity by setting the attribute >>>> taxPromotions to 'N') from demo data once by setting the taxable flag on >>>> this product to 'Y' (although keeping it null is same) and once by >> setting >>>> the flag to 'N' . When taxable flag is 'N' the item was exempted from >> sales >>>> tax and when it is 'Y' or Null the sales tax for item is aded to the >> cart >>>> or order grand total. >>>> >>>> You may need to check your tax authority setup i.e. whether you have >>>> allowed tax on shipping and/or promotion. I doubt tax amount you are >> seeing >>>> in the grand total is either calculated on shipping and/or promotion. >>>> >>>> Below is code snip from the service calcTax in TaxAuthorityServices >> Class >>>> and conditional check on taxable flag determines whether the item >> should be >>>> tax exempted or not. >>>> >>>> if (product != null && (product.get("taxable") == null || >>>> (product.get("taxable") != null && >>>> product.getBoolean("taxable").booleanValue()))) { >>>> taxable = taxable.add(itemAmount); >>>> } >>>> >>>> HTH >>>> >>>> Regards >>>> Vikas >>>> >>>> On May 29, 2012, at 11:05 AM, Nandani Aggarwal wrote: >>>> >>>>> Thank a lot for help and such a nice and simple explanation of answers. >>>>> >>>>> I tried your solutions with taxable field value as "Y"and "N" both.But >> in >>>>> both cases in shoppingcart.java (cart.getTotalSalesTax()) returns tax >>>> value >>>>> and (cart.getGrandTotal()) adds this tax in price(already including tax >>>>> value). >>>>> >>>>> I changed (cart.getGrandTotal()) so that it doesn't include tax but >>>> during >>>>> order creation it adds tax amount to total amount.It adds Order >>>>> adjustments (like discounts or tax).So should i change there as well or >>>>> there is another simple solution to it. >>>>> >>>>> >>>>> - Regards >>>>> Nandani >>>>> >>>>> On Mon, May 28, 2012 at 10:37 PM, Vikas Mayur <[email protected]> >>>> wrote: >>>>> >>>>>> Inline >>>>>> >>>>>> Regards >>>>>> Vikas >>>>>> >>>>>> On May 28, 2012, at 8:59 PM, Nandani Aggarwal wrote: >>>>>> >>>>>>> Thanks a lot for reply. >>>>>>> >>>>>>> I am facing some problem in maintaining sales tax transactions.In my >>>>>> case , >>>>>>> on my ecommerce site i am displaying products including tax, >>>>>>> Problem : >>>>>>> 1. I am displaying product with price including tax.So when order is >>>>>> placed >>>>>>> and invoice is created then tax transactions display tax amount on >>>> price( >>>>>>> already including tax). >>>>>>> For example : Product "A" is displayed at price Rs100 (Price :90 + >> tax >>>> : >>>>>>> 10). >>>>>>> But on invoice transactions are : >>>>>>> Sales Transactions - Rs100 >>>>>>> Tax Transactions - RS 10 >>>>>>> Making Invoice Total - Rs110.(which is wrong)Invoice total should be >> Rs >>>>>>> 100/- >>>>>>> I want grand total should be sum of product's subtotal. >>>>>> >>>>>> Check the 'taxable' field on Product entity, I think setting it to 'N' >>>> on >>>>>> individual products should exempt the product from further sales tax. >>>>>> >>>>>>> >>>>>>> 2. If i want to Apply discount on price excluding tax and then >> display >>>>>>> final amount (Price - discount) + tax. >>>>>>> But in ofbiz i am unable to display such price and grandtotal. >>>>>>> >>>>>>> Any idea , how above problems can be handled.? >>>>>> >>>>>> Discount and Tax should be created as Order Adjustments to display the >>>>>> prices in the manner you mentioned. >>>>>> >>>>>> I haven't done any testing but I think there may be solution OOTB with >>>>>> some minor modifications where required. >>>>>> >>>>>> Lets take your example for instance. Product 'A' displayed price is >> Rs. >>>>>> 100 (Actual product price is 90 & tax is 10). Lets say you want to >> give >>>> Rs. >>>>>> 20 discount on the product price which means that your order total >> will >>>> be >>>>>> Rs. 80 with product price after discount as Rs. 70 (since discount is >>>>>> applied after excluding tax from product price) & a total sales tax of >>>> Rs. >>>>>> 10. >>>>>> >>>>>> Instead of Rs. 20 discount, you may give a discount including the >> sales >>>>>> tax on the price displayed to customer. >>>>>> >>>>>> Final Product Price = Price Displayed - (Discount + Tax) = 100 - (20 + >>>> 10) >>>>>> = 70 >>>>>> >>>>>> You may then apply the tax on the product price (note you don't need >> to >>>>>> set the 'taxable' flag I mentioned above) in such a manner that tax >>>> amount >>>>>> is added back to the order total. >>>>>> >>>>>> Item Sub Total = Rs. 100 >>>>>> Discount = Rs. 30 >>>>>> Sales Tax = Rs. 10 >>>>>> >>>>>> Order Total = Rs. 80 >>>>>> >>>>>> HTH >>>>>> >>>>>>> I want correct transaction details on my invoice.It should include >>>>>> discount >>>>>>> , tax and sales information. >>>>>>> Tax is added in product price itself.Tax is not included in final >> order >>>>>>> amount. >>>>>>> >>>>>>> Thanks >>>>>>> Nandani >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> On Mon, May 28, 2012 at 8:34 PM, Vikas Mayur <[email protected]> >>>>>> wrote: >>>>>>> >>>>>>>> Yes, I need to keep all the related transactions so that income >> sheet >>>>>>>> reflect the correct net income. For all the sales tax (sales taxes >>>>>> could be >>>>>>>> at country/state/county/city level) & COGS (for different items) >>>>>>>> transaction entry detail records, I just created one detail record >> for >>>>>> each. >>>>>>>> >>>>>>>> Regards >>>>>>>> Vikas >>>>>>>> >>>>>>>> On May 28, 2012, at 7:46 PM, Nandani Aggarwal wrote: >>>>>>>> >>>>>>>>> Nice Approach , Are you also handling tax related transactions so >>>> that >>>>>>>>> actual or final revenue can be generated or determined which may >>>>>> include >>>>>>>>> COGS,Discount,Tax(Sales Tax , CST , VAT etc). >>>>>>>>> >>>>>>>>> Thanks >>>>>>>>> Nandani >>>>>>>>> >>>>>>>>> On Mon, May 28, 2012 at 5:37 PM, Vikas Mayur <[email protected] >>> >>>>>>>> wrote: >>>>>>>>> >>>>>>>>>> Pierre, >>>>>>>>>> >>>>>>>>>> The approach actually worked, moreover I don't need separate >>>> accounts >>>>>>>> as I >>>>>>>>>> can associate the existing accounts of the parent company to other >>>>>>>> parties >>>>>>>>>> like wholesale and retail etc. As a test, I have placed a sales >>>> order >>>>>>>> with >>>>>>>>>> product GZ-2644 with 3 Qty for a wholesale party and quick ship >>>> entire >>>>>>>>>> order which resulted in 4 accounting transactions namely Sales >>>>>> Invoice, >>>>>>>>>> Sales Shipment, Incoming Payment & Payment Applied. To setup the >>>>>> income >>>>>>>>>> sheet for wholesale party, I manually created all the required >>>>>>>> transactions >>>>>>>>>> (I believe I just needed Sales Invoice & Sales Shipment >>>> transactions) >>>>>>>> and >>>>>>>>>> transaction details. That is it. I think I now need to write some >>>> code >>>>>>>> so >>>>>>>>>> that such transactions could be created automatically. Sorry, I >>>> tested >>>>>>>> this >>>>>>>>>> on my local copy so you may not be able to see it on demo :) >>>>>>>>>> >>>>>>>>>> Your idea of setting up a separate instance for these external >>>> parties >>>>>>>>>> seems good but I believe the other approach which I used is >> easier. >>>>>> Let >>>>>>>> me >>>>>>>>>> know if you have any thoughts. >>>>>>>>>> >>>>>>>>>> Regards >>>>>>>>>> Vikas >>>>>>>>>> >>>>>>>>>> On May 28, 2012, at 12:51 PM, Vikas Mayur wrote: >>>>>>>>>> >>>>>>>>>>> Hi Pierre, >>>>>>>>>>> >>>>>>>>>>> Thanks for your help and your interest in the topic. I am >> currently >>>>>>>>>> testing business transaction and their related accounting >>>> transactions >>>>>>>> with >>>>>>>>>> the OFBiz demo data along with my custom party data of Wholesale, >>>>>> Retail >>>>>>>>>> channels. >>>>>>>>>>> >>>>>>>>>>> For instance when an invoice is captured for a sales order, you >>>> would >>>>>>>>>> have various accounting transactions corresponding to this >> business >>>>>>>>>> transaction (Invoice is being captured) like account receivables, >>>>>> COGS, >>>>>>>>>> discounts, general sales etc. The transactions with OFBiz demo >> data >>>>>> are >>>>>>>>>> currently posted to correct account but they are registered to >>>>>>>> 'Company' - >>>>>>>>>> the parent organization. >>>>>>>>>>> >>>>>>>>>>> After doing some of these tests and how the transactions are >>>> posted, >>>>>> I >>>>>>>>>> think I would need two things to be able to generate income sheet >>>> per >>>>>>>>>> distribution channel. >>>>>>>>>>> >>>>>>>>>>> 1. Create separate revenue accounts for each distribution >> channels, >>>>>>>> they >>>>>>>>>> can be setup as subsidiary ledger accounts similar to the existing >>>>>> demo >>>>>>>>>> data. For example, the hierarchy of accounts for SALES would look >>>> like >>>>>>>> this. >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> Revenue >>>>>>>>>>> >>>>>>>>>> | >>>>>>>>>>> >>>>>>>>>> Sales >>>>>>>>>>> >>>>>>>>>> | >>>>>>>>>>> >>>>>>>>>> ------------------------------------------------------------- >>>>>>>>>>> | >>>>>>>>>> | | >>>>>>>>>>> General Sales General Sales >>>>>>>>>> Wholesale General Sales Retail >>>>>>>>>>> >>>>>>>>>>> where 'General Sales' account transaction would be registered to >>>>>>>>>> 'Company' - the parent organization. >>>>>>>>>>> >>>>>>>>>>> 2. Create duplicate accounting transactions for each revenue >>>> account >>>>>>>> in >>>>>>>>>> such a manner that these transactions are registered to Wholesale >>>> (If >>>>>>>> the >>>>>>>>>> sale was made to WholeSalers), Retail (If the sale was made to >>>>>>>> Retailers) >>>>>>>>>> etc. This would require additional code so that system can lookup >>>> the >>>>>>>> 'Bill >>>>>>>>>> To Customer' and automatically create all the required duplicate >>>>>>>>>> transactions. >>>>>>>>>>> >>>>>>>>>>> Once all the transactions are posted, I should be able to >> generate >>>> a >>>>>>>>>> consolidated income sheet (this already works OOTB) for Company >> and >>>>>>>>>> separate income sheet per distribution channel. >>>>>>>>>>> >>>>>>>>>>> Let me know if you see any issues with this approach. >>>>>>>>>>> >>>>>>>>>>> Regards >>>>>>>>>>> Vikas >>>>>>>>>>> >>>>>>>>>>> On May 25, 2012, at 7:24 PM, Pierre Smits wrote: >>>>>>>>>>> >>>>>>>>>>>> Vikas, >>>>>>>>>>>> >>>>>>>>>>>> If the distribution channels are truly independent organisation >>>>>>>> (meaning >>>>>>>>>>>> legally) you should set up for each one a different instance of >>>>>> OFBiz, >>>>>>>>>>>> whereby the distribution channels buys from the company and >> sells >>>> to >>>>>>>>>> their >>>>>>>>>>>> customers. Otherwise there might appear a conflict of interest. >>>>>>>>>>>> >>>>>>>>>>>> If otherwise the distribution channels are like daughter >> companies >>>>>> or >>>>>>>>>>>> subsidiaries (and accounting, et all is done by the company) you >>>>>> could >>>>>>>>>>>> (should?) link them in one instance to the company like >>>> departments >>>>>>>> and >>>>>>>>>>>> create separate costcenters for each. Subsequently create for >> each >>>>>> the >>>>>>>>>> set >>>>>>>>>>>> of accounts regarding turnover, discount and cogs and connect >>>> those >>>>>> to >>>>>>>>>> the >>>>>>>>>>>> costcenters. >>>>>>>>>>>> >>>>>>>>>>>> In order to capture for each you could then create a sales >> channel >>>>>> for >>>>>>>>>> each >>>>>>>>>>>> (catalog, categories and if nessesary stores) and apply for >> each >>>>>>>>>>>> distribution channel the various price, promotion and shipping >>>> rules >>>>>>>> in >>>>>>>>>>>> their respective sales channel. >>>>>>>>>>>> >>>>>>>>>>>> Finally, and this is something I haven't tested yet, you should >>>> map >>>>>>>> the >>>>>>>>>>>> earlier defined fico accounts to the categories in each sales >>>>>> channel >>>>>>>> in >>>>>>>>>>>> ProductCategoryGLAccount in FICO. See example below. >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>> >>>>>>>> >>>>>> >>>> >> https://demo-trunk.ofbiz.apache.org:8443/accounting/control/GlAccountAssignment?organizationPartyId=Company >>>>>>>>>>>> >>>>>>>>>>>> That should do the trick. But like I said, I haven't tested it >>>> yet. >>>>>>>>>>>> >>>>>>>>>>>> One thing I am also not certain about is how sales transactions >>>> will >>>>>>>> be >>>>>>>>>>>> handled by OFBiz when generated by a Sales Backoffice for each >>>> when >>>>>>>> the >>>>>>>>>>>> scenario described above is in place. >>>>>>>>>>>> >>>>>>>>>>>> Good luck with your endeavours and keep us posted how you will >>>>>>>>>> eventually >>>>>>>>>>>> get to your optimal solution. >>>>>>>>>>>> >>>>>>>>>>>> Regards, >>>>>>>>>>>> >>>>>>>>>>>> Pierre >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> 2012/5/25 Vikas Mayur <[email protected]> >>>>>>>>>>>> >>>>>>>>>>>>> Hi Pierre, >>>>>>>>>>>>> >>>>>>>>>>>>> Thanks for your response. Yes, you are absolutely correct. I >>>> should >>>>>>>> be >>>>>>>>>>>>> able to see the income sheet of the company (parent >> organization) >>>>>> as >>>>>>>>>> well >>>>>>>>>>>>> as the income sheet per distribution channel. >>>>>>>>>>>>> >>>>>>>>>>>>> Regards >>>>>>>>>>>>> Vikas >>>>>>>>>>>>> >>>>>>>>>>>>> On May 25, 2012, at 2:36 PM, Pierre Smits wrote: >>>>>>>>>>>>> >>>>>>>>>>>>>> Hi Vikas, >>>>>>>>>>>>>> >>>>>>>>>>>>>> Just to get a greater understanding of the challenge you're >>>>>> facing, >>>>>>>> I >>>>>>>>>> am >>>>>>>>>>>>>> understanding that the distribution channels operate as >>>>>> independent >>>>>>>>>>>>>> organisations and not as internal departments. And that the >>>>>>>>>> distributors, >>>>>>>>>>>>>> wholesales and retailers are associated to the distribution >>>>>>>> channels. >>>>>>>>>> And >>>>>>>>>>>>>> that sales is done thru the distribution channels, but that >> the >>>>>>>>>>>>>> transactions of the sale need to be registered with the >> company >>>>>>>>>> combined >>>>>>>>>>>>>> with commission calculations per distribution channel. >>>>>>>>>>>>>> >>>>>>>>>>>>>> Am I correct in assuming that's what you're saying? >>>>>>>>>>>>>> >>>>>>>>>>>>>> Regards, >>>>>>>>>>>>>> >>>>>>>>>>>>>> Pierre >>>>>>>>>>>>>> >>>>>>>>>>>>>> 2012/5/25 Vikas Mayur <[email protected]> >>>>>>>>>>>>>> >>>>>>>>>>>>>>> Hi, >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> I am working for a customer and he is looking to setup a >> chart >>>> of >>>>>>>>>>>>> accounts >>>>>>>>>>>>>>> for his organization. I have mentioned below a brief >>>> description >>>>>> of >>>>>>>>>> the >>>>>>>>>>>>>>> business of this customer, his requirements and a possible >>>>>> solution >>>>>>>>>>>>> that I >>>>>>>>>>>>>>> think would meet his needs. Please take a look and also >> through >>>>>> the >>>>>>>>>> Q's >>>>>>>>>>>>>>> below :), if you know anything then let me know. Thanks in >>>>>> advance >>>>>>>>>> !!! >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Business Overview: >>>>>>>>>>>>>>> A parent organization with several divisions like R&D, Sales >> & >>>>>>>>>>>>> Marketing, >>>>>>>>>>>>>>> Operations, Administration etc. and employees. The company >>>>>> (parent >>>>>>>>>>>>>>> organization) only sell its products through a number of >>>>>>>> distribution >>>>>>>>>>>>>>> channels (they also call them as revenue channels & profit >>>>>> centers) >>>>>>>>>> like >>>>>>>>>>>>>>> wholesale, distributor. retail etc. The company will give >> them >>>> a >>>>>>>>>> certain >>>>>>>>>>>>>>> commission (as per the agreement) on every sale. The >>>> distribution >>>>>>>>>>>>> channels >>>>>>>>>>>>>>> are not the divisions of the company and does not have any >>>>>>>> employees >>>>>>>>>>>>>>> either. The company will have a number of warehouses >> (probably >>>>>>>> shared >>>>>>>>>>>>> among >>>>>>>>>>>>>>> the distribution channels) to fulfill the orders. >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Requirement: >>>>>>>>>>>>>>> The company need to generate a separate income sheet for each >>>>>>>>>>>>> distribution >>>>>>>>>>>>>>> channels so that they know the net income by each channel. >> They >>>>>>>> also >>>>>>>>>>>>> need a >>>>>>>>>>>>>>> consolidated GL totals (generate a consolidated income >>>> statement) >>>>>>>>>> and a >>>>>>>>>>>>>>> balance sheet report for the company. >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Solution: >>>>>>>>>>>>>>> Distribution Channel Setup >>>>>>>>>>>>>>> The distribution channels are organizations (although not >>>>>> internal >>>>>>>> to >>>>>>>>>>>>> the >>>>>>>>>>>>>>> Company) and will be setup as party group in the system. For >>>>>>>> example >>>>>>>>>>>>> there >>>>>>>>>>>>>>> will be party group for wholesale, distributor & retail each. >>>>>> There >>>>>>>>>>>>> would >>>>>>>>>>>>>>> be a number of wholesalers, distributors and retailers who >> will >>>>>>>> sell >>>>>>>>>> the >>>>>>>>>>>>>>> products of the company and they will also be setup as party >>>>>> group >>>>>>>>>> with >>>>>>>>>>>>> a >>>>>>>>>>>>>>> party relationship to wholesale, distributor & retail party >>>> group >>>>>>>>>>>>>>> respectively. >>>>>>>>>>>>>>> GL Account & Chart of Accounts Setup >>>>>>>>>>>>>>> I looked through the demo GL setup and Chart of Accounts >>>> template >>>>>>>>>> data >>>>>>>>>>>>> in >>>>>>>>>>>>>>> OFBiz, was very helpful. I know that an account can be used >> by >>>>>> one >>>>>>>> or >>>>>>>>>>>>> more >>>>>>>>>>>>>>> internal organization but have doubts about how to associate >>>> the >>>>>>>>>> account >>>>>>>>>>>>>>> and how the transaction would be posted to the correct >> account. >>>>>>>>>> Sorry, >>>>>>>>>>>>>>> haven't looked through the code in detail. >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> There will be number of accounts but lets say we have three >>>>>>>> accounts, >>>>>>>>>>>>> 3000 >>>>>>>>>>>>>>> - Sales, 3010 - Discount on Sale, 3020 - COGS. The net income >>>>>> will >>>>>>>> be >>>>>>>>>>>>>>> [Total of Sales - (Total Discount on Sale + Total COGS)]. >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Q1. Do I need to associate the above accounts to the parent >>>>>> company >>>>>>>>>> OR >>>>>>>>>>>>> to >>>>>>>>>>>>>>> each distribution channel OR both? Default mappings? >>>>>>>>>>>>>>> Q2. Do I need separate accounts for the parent company and >> each >>>>>>>>>>>>>>> distribution channels? Lets say the 4 different Sales account >>>> for >>>>>>>> the >>>>>>>>>>>>>>> parent and three distribution channels? Don't think so. >>>>>>>>>>>>>>> Q3. Any other thing I should be concerned about, like the >>>> shared >>>>>>>>>>>>> warehouse >>>>>>>>>>>>>>> by all the distribution channels? >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Regards >>>>>>>>>>>>>>> Vikas >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>> >>>>>>>> >>>>>> >>>>>> >>>> >>>> >> >>
