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" <[email protected]> >>> >>>> 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. >>>> >>>> >>>> >>> >>> >>> >> >> > > -- View this message in context: http://www.nabble.com/No-Sales-Tax-transactions-are-being-posted-to-the-GL-tp22589554p22633249.html Sent from the OFBiz - User mailing list archive at Nabble.com.
