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 |
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. > > |
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
|
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. >>> >>> >>> >> >> >> > > |
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
|
Free forum by Nabble | Edit this page |