No Sales Tax transactions are being posted to the GL

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

No Sales Tax transactions are being posted to the GL

Sharan-F
Hi

There seems to be a problem with Sales Tax transactions. It looks as if none of them are being posted to the General Ledger.  What I mean here is that a Sales Order and its corresponding Sales Invoice will be created and show all the Sales Tax calculated correctly but when the accounting transactions are created and posted – no transactions are created to any of the Sales Tax accounts.

I've done some tests today on the Hotwax Demo and have included the details of my tests below if you need to view the details or want to try and re-produce the problem.

Test 1: Order Entry Route (Invoice and Sales Order are on Hotwax Demo)
I created a Sales Order (WSCO10000) using the Order Entry Module. Details are as follows:
    Customer = Demo Customer
    Product = GZ-9290 His/Her Gizmo
    Total Sales Tax = $5.72
    Payment Received (via 'Receive Payment' button and specified Cash).
    Did a 'Quick Ship Entire Order' and Invoice (CI2) was generated

If you click on the CI2 invoice number and look at the accounting transactions at the bottom of the screen – there are no transactions for any of the Sales tax amounts or accounts (224153 or 224000)  which should total 5.72.

Test 2: E-Commerce Route (Invoice and Sales Order are on Hotwax Demo)
I logged into the ecommerce store as DemoCustomer and created a Sales Order (WSCO10001). Details are as follows:
    Customer = DemoCustomer
    Product =  GZ-1004 Rainbow Gizmo
    Total Sales Tax = $1.52
    Payment received (via 'Receive Payment' button and specified Cash)
    Did a 'Quick Ship Entire Order' and Invoice (CI3) was generated

If you click on the CI3 invoice number and look at the accounting transactions at the bottom of the screen – there are no transaction for any fo the sales tax amounts or accounts (224153 or 224000) which should total $1.52

Test 3: Manual Sales Invoice Route (Invoice is on Hotwax Demo)
I created a Sales Invoice (CI4)  using the Invoices sub menu from Accounting Manager. Details are as follows:
    Customer = DemoCustomer
    Product = GZ-1001 Nan Gizmo
    Manual Sales Tax = $10 (note taxable flag set to 'N' and override GL account to 224000)
    Saved invoice details then changed status to 'Approved' and then 'Sent' to generate the accounting transactions. The accounting details show that nothing has been posted to 224000.
 
I've also looked at the Trial Balance report and there was nothing showing in any of the Sales Tax accounts.

Thanks
Sharan
Reply | Threaded
Open this post in threaded view
|

Re: No Sales Tax transactions are being posted to the GL

Jacques Le Roux
Administrator
Hi Sharan,

Thanks for all details! Was this working before ?

Jacques

From: "Sharan-F" <[hidden email]>

>
> Hi
>
> There seems to be a problem with Sales Tax transactions. It looks as if none
> of them are being posted to the General Ledger.  What I mean here is that a
> Sales Order and its corresponding Sales Invoice will be created and show all
> the Sales Tax calculated correctly but when the accounting transactions are
> created and posted – no transactions are created to any of the Sales Tax
> accounts.
>
> I've done some tests today on the Hotwax Demo and have included the details
> of my tests below if you need to view the details or want to try and
> re-produce the problem.
>
> Test 1: Order Entry Route (Invoice and Sales Order are on Hotwax Demo)
> I created a Sales Order (WSCO10000) using the Order Entry Module. Details
> are as follows:
>    Customer = Demo Customer
>    Product = GZ-9290 His/Her Gizmo
>    Total Sales Tax = $5.72
>    Payment Received (via 'Receive Payment' button and specified Cash).
>    Did a 'Quick Ship Entire Order' and Invoice (CI2) was generated
>
> If you click on the CI2 invoice number and look at the accounting
> transactions at the bottom of the screen – there are no transactions for any
> of the Sales tax amounts or accounts (224153 or 224000)  which should total
> 5.72.
>
> Test 2: E-Commerce Route (Invoice and Sales Order are on Hotwax Demo)
> I logged into the ecommerce store as DemoCustomer and created a Sales Order
> (WSCO10001). Details are as follows:
>    Customer = DemoCustomer
>    Product =  GZ-1004 Rainbow Gizmo
>    Total Sales Tax = $1.52
>    Payment received (via 'Receive Payment' button and specified Cash)
>    Did a 'Quick Ship Entire Order' and Invoice (CI3) was generated
>
> If you click on the CI3 invoice number and look at the accounting
> transactions at the bottom of the screen – there are no transaction for any
> fo the sales tax amounts or accounts (224153 or 224000) which should total
> $1.52
>
> Test 3: Manual Sales Invoice Route (Invoice is on Hotwax Demo)
> I created a Sales Invoice (CI4)  using the Invoices sub menu from Accounting
> Manager. Details are as follows:
>    Customer = DemoCustomer
>    Product = GZ-1001 Nan Gizmo
>    Manual Sales Tax = $10 (note taxable flag set to 'N' and override GL
> account to 224000)
>    Saved invoice details then changed status to 'Approved' and then 'Sent'
> to generate the accounting transactions. The accounting details show that
> nothing has been posted to 224000.
>
> I've also looked at the Trial Balance report and there was nothing showing
> in any of the Sales Tax accounts.
>
> Thanks
> Sharan
>
> --
> View this message in context: http://www.nabble.com/No-Sales-Tax-transactions-are-being-posted-to-the-GL-tp22589554p22589554.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>


Reply | Threaded
Open this post in threaded view
|

Re: No Sales Tax transactions are being posted to the GL

Sharan-F
Hi Jacques

Yes this was working before but I'm not entirely sure when it stopped working.

I think the last time I did a full test of the Sales Invoicing accounting transactions was in November last year when I started putting together the list of default accounting transactions for the Wiki.
http://docs.ofbiz.org/display/OFBIZ/Default+Accounting+Transactions

Do you know if anything has changed in the Tax / VAT Setup over the last few months?

Thanks
Sharan
jacques.le.roux wrote
Hi Sharan,

Thanks for all details! Was this working before ?

Jacques

From: "Sharan-F" <sharan.foga@gmail.com>
>
> Hi
>
> There seems to be a problem with Sales Tax transactions. It looks as if none
> of them are being posted to the General Ledger.  What I mean here is that a
> Sales Order and its corresponding Sales Invoice will be created and show all
> the Sales Tax calculated correctly but when the accounting transactions are
> created and posted – no transactions are created to any of the Sales Tax
> accounts.
>
> I've done some tests today on the Hotwax Demo and have included the details
> of my tests below if you need to view the details or want to try and
> re-produce the problem.
>
> Test 1: Order Entry Route (Invoice and Sales Order are on Hotwax Demo)
> I created a Sales Order (WSCO10000) using the Order Entry Module. Details
> are as follows:
>    Customer = Demo Customer
>    Product = GZ-9290 His/Her Gizmo
>    Total Sales Tax = $5.72
>    Payment Received (via 'Receive Payment' button and specified Cash).
>    Did a 'Quick Ship Entire Order' and Invoice (CI2) was generated
>
> If you click on the CI2 invoice number and look at the accounting
> transactions at the bottom of the screen – there are no transactions for any
> of the Sales tax amounts or accounts (224153 or 224000)  which should total
> 5.72.
>
> Test 2: E-Commerce Route (Invoice and Sales Order are on Hotwax Demo)
> I logged into the ecommerce store as DemoCustomer and created a Sales Order
> (WSCO10001). Details are as follows:
>    Customer = DemoCustomer
>    Product =  GZ-1004 Rainbow Gizmo
>    Total Sales Tax = $1.52
>    Payment received (via 'Receive Payment' button and specified Cash)
>    Did a 'Quick Ship Entire Order' and Invoice (CI3) was generated
>
> If you click on the CI3 invoice number and look at the accounting
> transactions at the bottom of the screen – there are no transaction for any
> fo the sales tax amounts or accounts (224153 or 224000) which should total
> $1.52
>
> Test 3: Manual Sales Invoice Route (Invoice is on Hotwax Demo)
> I created a Sales Invoice (CI4)  using the Invoices sub menu from Accounting
> Manager. Details are as follows:
>    Customer = DemoCustomer
>    Product = GZ-1001 Nan Gizmo
>    Manual Sales Tax = $10 (note taxable flag set to 'N' and override GL
> account to 224000)
>    Saved invoice details then changed status to 'Approved' and then 'Sent'
> to generate the accounting transactions. The accounting details show that
> nothing has been posted to 224000.
>
> I've also looked at the Trial Balance report and there was nothing showing
> in any of the Sales Tax accounts.
>
> Thanks
> Sharan
>
> --
> View this message in context: http://www.nabble.com/No-Sales-Tax-transactions-are-being-posted-to-the-GL-tp22589554p22589554.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>

Reply | Threaded
Open this post in threaded view
|

Re: No Sales Tax transactions are being posted to the GL

Karim Rahimpur
Hi Sharan,

There are two simple methods defined in GeneralLedgerServices.xml:

- createAcctgTransForSalesInvoice
- createAcctgTransForPurchaseInvoice

For sales invoices there are these conditions (rev. 756371) that filter
out tax related invoice items:

    <condition-expr field-name="invoiceItemTypeId" operator="not-equals"
value="INV_SALES_TAX"/>
    <condition-expr field-name="invoiceItemTypeId" operator="not-equals"
value="ITM_SALES_TAX"/>

and for purchase invoices you'll find analogously:

    <condition-expr field-name="invoiceItemTypeId" operator="not-equals"
value="PINV_SALES_TAX"/>
    <condition-expr field-name="invoiceItemTypeId" operator="not-equals"
value="PITM_SALES_TAX"/>

If you comment these lines the tax items will also enter the transaction.

I'm wondering why tax items are filtered there by 'default' ...

Regards,
Karim


Sharan-F wrote:

> Hi Jacques
>
> Yes this was working before but I'm not entirely sure when it stopped
> working.
>
> I think the last time I did a full test of the Sales Invoicing accounting
> transactions was in November last year when I started putting together the
> list of default accounting transactions for the Wiki.
> http://docs.ofbiz.org/display/OFBIZ/Default+Accounting+Transactions
>
> Do you know if anything has changed in the Tax / VAT Setup over the last few
> months?
>
> Thanks
> Sharan
>
> jacques.le.roux wrote:
>  
>> Hi Sharan,
>>
>> Thanks for all details! Was this working before ?
>>
>> Jacques
>>
>> From: "Sharan-F" <[hidden email]>
>>    
>>> Hi
>>>
>>> There seems to be a problem with Sales Tax transactions. It looks as if
>>> none
>>> of them are being posted to the General Ledger.  What I mean here is that
>>> a
>>> Sales Order and its corresponding Sales Invoice will be created and show
>>> all
>>> the Sales Tax calculated correctly but when the accounting transactions
>>> are
>>> created and posted – no transactions are created to any of the Sales Tax
>>> accounts.
>>>
>>> I've done some tests today on the Hotwax Demo and have included the
>>> details
>>> of my tests below if you need to view the details or want to try and
>>> re-produce the problem.
>>>
>>> Test 1: Order Entry Route (Invoice and Sales Order are on Hotwax Demo)
>>> I created a Sales Order (WSCO10000) using the Order Entry Module. Details
>>> are as follows:
>>>    Customer = Demo Customer
>>>    Product = GZ-9290 His/Her Gizmo
>>>    Total Sales Tax = $5.72
>>>    Payment Received (via 'Receive Payment' button and specified Cash).
>>>    Did a 'Quick Ship Entire Order' and Invoice (CI2) was generated
>>>
>>> If you click on the CI2 invoice number and look at the accounting
>>> transactions at the bottom of the screen – there are no transactions for
>>> any
>>> of the Sales tax amounts or accounts (224153 or 224000)  which should
>>> total
>>> 5.72.
>>>
>>> Test 2: E-Commerce Route (Invoice and Sales Order are on Hotwax Demo)
>>> I logged into the ecommerce store as DemoCustomer and created a Sales
>>> Order
>>> (WSCO10001). Details are as follows:
>>>    Customer = DemoCustomer
>>>    Product =  GZ-1004 Rainbow Gizmo
>>>    Total Sales Tax = $1.52
>>>    Payment received (via 'Receive Payment' button and specified Cash)
>>>    Did a 'Quick Ship Entire Order' and Invoice (CI3) was generated
>>>
>>> If you click on the CI3 invoice number and look at the accounting
>>> transactions at the bottom of the screen – there are no transaction for
>>> any
>>> fo the sales tax amounts or accounts (224153 or 224000) which should
>>> total
>>> $1.52
>>>
>>> Test 3: Manual Sales Invoice Route (Invoice is on Hotwax Demo)
>>> I created a Sales Invoice (CI4)  using the Invoices sub menu from
>>> Accounting
>>> Manager. Details are as follows:
>>>    Customer = DemoCustomer
>>>    Product = GZ-1001 Nan Gizmo
>>>    Manual Sales Tax = $10 (note taxable flag set to 'N' and override GL
>>> account to 224000)
>>>    Saved invoice details then changed status to 'Approved' and then
>>> 'Sent'
>>> to generate the accounting transactions. The accounting details show that
>>> nothing has been posted to 224000.
>>>
>>> I've also looked at the Trial Balance report and there was nothing
>>> showing
>>> in any of the Sales Tax accounts.
>>>
>>> Thanks
>>> Sharan
>>>
>>> --
>>> View this message in context:
>>> http://www.nabble.com/No-Sales-Tax-transactions-are-being-posted-to-the-GL-tp22589554p22589554.html
>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>
>>>
>>>      
>>
>>
>>    
>
>  
Reply | Threaded
Open this post in threaded view
|

Re: No Sales Tax transactions are being posted to the GL

Sharan-F
Hi Karim

Thanks for looking into it for me.

I wonder if this has been done in preparation for the changes that are to be implemented for VAT. I'll follow up with Jacques about this.

In the meantime anyone using the OFBiz accounting module will need to change these filters otherwise the general ledger wont reflect what has been actually produced on the invoice (and in business terms the invoice is a legal tax document).

Thanks
Sharan



Karim Rahimpur wrote
Hi Sharan,

There are two simple methods defined in GeneralLedgerServices.xml:

- createAcctgTransForSalesInvoice
- createAcctgTransForPurchaseInvoice

For sales invoices there are these conditions (rev. 756371) that filter
out tax related invoice items:

    <condition-expr field-name="invoiceItemTypeId" operator="not-equals"
value="INV_SALES_TAX"/>
    <condition-expr field-name="invoiceItemTypeId" operator="not-equals"
value="ITM_SALES_TAX"/>

and for purchase invoices you'll find analogously:

    <condition-expr field-name="invoiceItemTypeId" operator="not-equals"
value="PINV_SALES_TAX"/>
    <condition-expr field-name="invoiceItemTypeId" operator="not-equals"
value="PITM_SALES_TAX"/>

If you comment these lines the tax items will also enter the transaction.

I'm wondering why tax items are filtered there by 'default' ...

Regards,
Karim


Sharan-F wrote:
> Hi Jacques
>
> Yes this was working before but I'm not entirely sure when it stopped
> working.
>
> I think the last time I did a full test of the Sales Invoicing accounting
> transactions was in November last year when I started putting together the
> list of default accounting transactions for the Wiki.
> http://docs.ofbiz.org/display/OFBIZ/Default+Accounting+Transactions
>
> Do you know if anything has changed in the Tax / VAT Setup over the last few
> months?
>
> Thanks
> Sharan
>
> jacques.le.roux wrote:
>  
>> Hi Sharan,
>>
>> Thanks for all details! Was this working before ?
>>
>> Jacques
>>
>> From: "Sharan-F" <sharan.foga@gmail.com>
>>    
>>> Hi
>>>
>>> There seems to be a problem with Sales Tax transactions. It looks as if
>>> none
>>> of them are being posted to the General Ledger.  What I mean here is that
>>> a
>>> Sales Order and its corresponding Sales Invoice will be created and show
>>> all
>>> the Sales Tax calculated correctly but when the accounting transactions
>>> are
>>> created and posted – no transactions are created to any of the Sales Tax
>>> accounts.
>>>
>>> I've done some tests today on the Hotwax Demo and have included the
>>> details
>>> of my tests below if you need to view the details or want to try and
>>> re-produce the problem.
>>>
>>> Test 1: Order Entry Route (Invoice and Sales Order are on Hotwax Demo)
>>> I created a Sales Order (WSCO10000) using the Order Entry Module. Details
>>> are as follows:
>>>    Customer = Demo Customer
>>>    Product = GZ-9290 His/Her Gizmo
>>>    Total Sales Tax = $5.72
>>>    Payment Received (via 'Receive Payment' button and specified Cash).
>>>    Did a 'Quick Ship Entire Order' and Invoice (CI2) was generated
>>>
>>> If you click on the CI2 invoice number and look at the accounting
>>> transactions at the bottom of the screen – there are no transactions for
>>> any
>>> of the Sales tax amounts or accounts (224153 or 224000)  which should
>>> total
>>> 5.72.
>>>
>>> Test 2: E-Commerce Route (Invoice and Sales Order are on Hotwax Demo)
>>> I logged into the ecommerce store as DemoCustomer and created a Sales
>>> Order
>>> (WSCO10001). Details are as follows:
>>>    Customer = DemoCustomer
>>>    Product =  GZ-1004 Rainbow Gizmo
>>>    Total Sales Tax = $1.52
>>>    Payment received (via 'Receive Payment' button and specified Cash)
>>>    Did a 'Quick Ship Entire Order' and Invoice (CI3) was generated
>>>
>>> If you click on the CI3 invoice number and look at the accounting
>>> transactions at the bottom of the screen – there are no transaction for
>>> any
>>> fo the sales tax amounts or accounts (224153 or 224000) which should
>>> total
>>> $1.52
>>>
>>> Test 3: Manual Sales Invoice Route (Invoice is on Hotwax Demo)

>>> I created a Sales Invoice (CI4)  using the Invoices sub menu from
>>> Accounting
>>> Manager. Details are as follows:
>>>    Customer = DemoCustomer
>>>    Product = GZ-1001 Nan Gizmo
>>>    Manual Sales Tax = $10 (note taxable flag set to 'N' and override GL
>>> account to 224000)
>>>    Saved invoice details then changed status to 'Approved' and then
>>> 'Sent'
>>> to generate the accounting transactions. The accounting details show that
>>> nothing has been posted to 224000.
>>>
>>> I've also looked at the Trial Balance report and there was nothing
>>> showing
>>> in any of the Sales Tax accounts.
>>>
>>> Thanks
>>> Sharan
>>>
>>> --
>>> View this message in context:
>>> http://www.nabble.com/No-Sales-Tax-transactions-are-being-posted-to-the-GL-tp22589554p22589554.html
>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>
>>>
>>>      
>>
>>
>>    
>
>