I checked into this and looked at the demoinvoice: demo10000 which has an item sales tax....there the totals look ok?
On Wed, 2009-03-18 at 13:22 +1100, Tristan Blattman wrote: > You're exactly spot on! > > I've been playing around with the invoicing today, and when I tried adding > the GST manually, some unusual totals came up. (I've attached the PDF) > > Basically, it appears to have totalled the manually added sales tax as a > line item, but then added that as sales tax separately again on top of that. > > -Tristan > > -----Original Message----- > From: Sharan-F [mailto:[email protected]] > Sent: Wednesday, 18 March 2009 1:11 PM > To: [email protected] > Subject: RE: GST / VAT posting to GL for reporting and for sales invoices > > > Hi Tristan > > I've been doing some testing today using trunk 755368 and I've got the GST > set up and calculating OK on the Sales Invoices but have an issue with the > postings to the GL. I want to do a bit more testing with the Hotwax Demo > first but havent been able to do that today because some of the demo data > seems to be missing. > > I've got a bit of an idea about what your problem could be. Let me just > describe what I think you are doing and then you can confirm whether I'm > correct or not. > > My assumptions about what you've been doing > 1. You are not using OFBiz e-commerce at all > 2. You are not using OFBiz order entry at all > 3. You've setup a party for your Tax Authority and you have also created a > new Tax Authority under the Tax Authority sub menu in Accounting Manager > > 4. At the moment all you've been doing is using the Invoices Sub menu in > Accounting Manager to create Sales Invoices. > 5. When you create the Sales Invoices you then add the invoice lines where > you input the following details: > Invoice item type (eg Invoice Item Finished Good etc) > Description > Override GL Account Id > Product Id (from your product catalog) > Quantity > > 6. When you view the invoice, the taxable flag for the product line is set > to 'Y' and the tax authority fields are blank > > 7. Your problem is that there are no calculations for GST being performed > and there's no tax appearing on your Sales Invoices. Also there are no tax > amounts posted to the General Ledger. > > Let me know if this describes more or less you've been doing and the > problems you're having. > > If it doesnt then if you could provide a clear step by step guide of your > process (similar to what I've done above) it will help me to understand > things a bit more. > > Thanks > Sharan > > > > Tristan Blattman wrote: > > > > Thanks Sharan! > > > > I'm using the Trunk version from 29th Dec 08. > > > > I'm not sure of the version#, I downloaded as current and the file isn't > > on > > the archive list. > > > > Cheers, > > Tristan > > > > -----Original Message----- > > From: Sharan-F [mailto:[email protected]] > > Sent: Tuesday, 17 March 2009 1:14 PM > > To: [email protected] > > Subject: Re: GST / VAT posting to GL for reporting and for sales invoices > > > > > > Hi Tristan > > > > I'm based in NZ so have got a real interest in what you're doing since it > > applies here too! > > > > I would say that you should beware of the demo data as far the GL postings > > are concerned - as they are not there. For example you will see a demo > > invoice but there will be no corresponding GL entries behind it. To get > > the > > real GL entries on the Hotwax demo you will need to create an order from > > scratch and push it through the system to the invoicing stage. > > > > I did have a go a few months ago at setting up a draft OFBiz configuration > > for NZ and managed to get it configured to include the GST on the Sales > > Orders and Invoices. The GL postings were OK too. > > > > What version of OFBiz are you using? I'd be keen to have a go a doing it > > again with the latest version of OFBiz and give you some feedback if you > > want. > > > > Thanks > > Sharan > > > > > > Tristan Blattman wrote: > >> > >> Hi, > >> > >> I'm implementing an Australian install, and having > >> trouble > >> with getting GST working. > >> > >> We aren't using the ecommerce module, so don't need GST for the > >> storefront > >> app, just for sales invoicing from the management tools. > >> > >> > >> > >> All the invoices I've been able to generate so far are showing only the > >> total excl tax, even though the product (catalog entry) is flagged as > >> taxable and the invoice item line is set to taxable. > >> > >> The line items on the invoices have the Tax Auth Party, Tax Auth Geo ID > >> and > >> Tax Auth Rate Seq Id fields blank when new items are added. > >> > >> > >> > >> I've set up the Tax Authority for Geo Id =AUS > >> > >> GL Account is set to 224100, with Organization Party set to Company > > >> > >> And I've created a tax rate product: > >> > >> Type: Sales Tax > >> > >> Store ID: > >> > >> Category: > >> > >> Title Transfer: > >> > >> Min Item Price: 0 > >> > >> Min Purchase: 0 > >> > >> Tax Shipping: Y > >> > >> Tax Percentage: 10 > >> > >> Tax Promotions: Y > >> > >> From date: 2000-07-01 00:00:00.000 > >> > >> Thru date: > >> > >> Description: 10% GST > >> > >> > >> > >> The customer's addresses are all in Australia, as are our Company > >> addresses. > >> > >> > >> > >> I noticed on the demo site (some time last week) that the sample invoices > >> had sales tax line items on the applicable invoices (Utah Taxman etc), > >> but > >> when I checked the associated GL account on there was no tax recorded in > >> there. Shouldn't these lines be auto-posting to the GL also? > >> > >> > >> > >> Any advice or words of wisdom would be greatly appreciated! > >> > >> Thanks, > >> > >> Tristan > >> > >> > >> > >> > >> > >> > >> > > > > -- > > View this message in context: > > > http://www.nabble.com/GST---VAT-posting-to-GL-for-reporting-and-for-sales-in > > voices-tp22550761p22551426.html > > Sent from the OFBiz - User mailing list archive at Nabble.com. > > > > > > > -- Antwebsystems.com: Quality OFBiz services for competitive rates
