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.
>
>
>
--
View this message in context:
http://www.nabble.com/GST---VAT-posting-to-GL-for-reporting-and-for-sales-invoices-tp22550761p22571704.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
