GST / VAT posting to GL for reporting and for sales invoices
Locked
GST / VAT posting to GL for reporting and for sales invoices
 
|
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 |
|
|
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
|
RE: GST / VAT posting to GL for reporting and for sales invoices
|
|
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:[hidden email]] Sent: Tuesday, 17 March 2009 1:14 PM To: [hidden email] 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. |
Re: GST / VAT posting to GL for reporting and for sales invoices
|
|
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1 this is the first commit Mon Dec 29 00:16:58 2008 New Revision: 729837 this is the last commit Mon Dec 29 22:14:41 2008 New Revision: 730051 so that is the range or your version. Tristan Blattman sent the following on 3/16/2009 8:43 PM: > 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:[hidden email]] > Sent: Tuesday, 17 March 2009 1:14 PM > To: [hidden email] > 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 >> >> >> >> >> >> >> > Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJv1Z/rP3NbaWWqE4RAu4QAJ4rQI91CSzxEKtBfAmvfNVos/kQpgCgtK1m 8o2vaGs4vq5F3AhVzgzJoj8= =DI/J -----END PGP SIGNATURE----- |
Re: GST / VAT posting to GL for reporting and for sales invoices
Administrator
|
In reply to this post by Tristan Blattman
Quick answer: did you put "Show prices with VAT tax included" on in your store ?
Jacques From: "Tristan Blattman" <[hidden email]> > 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 > > > > > > |
|
|
In reply to this post by Tristan Blattman
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
|
RE: GST / VAT posting to GL for reporting and for sales invoices
|
|
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:[hidden email]] Sent: Wednesday, 18 March 2009 1:11 PM To: [hidden email] 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:[hidden email]] > Sent: Tuesday, 17 March 2009 1:14 PM > To: [hidden email] > 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: > > voices-tp22550761p22551426.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > > > -- View this message in context: http://www.nabble.com/GST---VAT-posting-to-GL-for-reporting-and-for-sales-in voices-tp22550761p22571704.html Sent from the OFBiz - User mailing list archive at Nabble.com. |
RE: GST / VAT posting to GL for reporting and for sales invoices
|
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:[hidden email]] > Sent: Wednesday, 18 March 2009 1:11 PM > To: [hidden email] > 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:[hidden email]] > > Sent: Tuesday, 17 March 2009 1:14 PM > > To: [hidden email] > > 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 |
RE: GST / VAT posting to GL for reporting and for sales invoices
|
|
There are no items or Tax Auth attached to those line items though. Wasn't
this just a manually produced sample to show the invoicing function? -----Original Message----- From: Hans Bakker [mailto:[hidden email]] Sent: Wednesday, 18 March 2009 2:07 PM To: [hidden email] Subject: RE: GST / VAT posting to GL for reporting and for sales invoices 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:[hidden email]] > Sent: Wednesday, 18 March 2009 1:11 PM > To: [hidden email] > 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:[hidden email]] > > Sent: Tuesday, 17 March 2009 1:14 PM > > To: [hidden email] > > Subject: Re: GST / VAT posting to GL for reporting and for sales > > > > > > 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 > >> 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: > > > > > voices-tp22550761p22551426.html > > Sent from the OFBiz - User mailing list archive at Nabble.com. > > > > > > > -- Antwebsystems.com: Quality OFBiz services for competitive rates |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |