Ok. Now i understand. Overall it is a *yes* to the multi-account approach in the exact way described above, but additionally with multiple debit-accounts also per SSS rate. With this it is easy to calculate. An existing drawback is the JIRA issue you mentioned, because due to that it is not possible to post to multiple Tax-Accounts out of a single Tax-Authority. Like the description mentions, its necessary to be able to post to a tax-Account by Product Category.
Maybe it is possible to simply create multiple tax-Authorities per SSS-Rate (nested ones) as a workaround? Freundliche Grüsse Adrian Stern unchained - web solutions [email protected] +41 79 292 83 47 On Wed, Nov 12, 2014 at 3:46 PM, Pierre Smits <[email protected]> wrote: > Hi Adrian, > > See my comments inline. > > Regards, > > Pierre Smits > > *ORRTIZ.COM <http://www.orrtiz.com>* > Services & Solutions for Cloud- > Based Manufacturing, Professional > Services and Retail & Trade > http://www.orrtiz.com > > On Wed, Nov 12, 2014 at 3:03 PM, Adrian Stern <[email protected]> > wrote: > > > Hi Pierre > > > > I'm in the process of reading this book. So far i'm half way trough and > it > > did clarify most of my configuration issues. > > The main issue lies in the internal workings of ofbiz which are not > > documented too well. > > > > Also there is a bit of a language barriere, which may be the main reason > > for me asking back. > > > > *For example:* > > Total VAT applicable turnover: 100 > > Total VAT collected: 8 > > Total VAT due (100 + 8) x 6% = 6.42 > > > > I know what those names mean and what the values represent. But i'm not > > entierly sure if i have access (do they exist in ofbiz?) to those values > to > > work with. As far as i know there is only one value available which would > > be "Total VAT collected" - i believe this represents the GlAccount where > > the VAT billed to the customer is posted to.(Tax Authority GlAccount) > > As to the other one, "Total VAT applicable turnover" - where would this > be > > stored? In what way would i access it? > > > > This would be equivalent to the gl account that you use to register your > sales to. > > > > > > *Second:* > > > > Since there is more than one SSS rate involved i cannot post all the VAT > > collected to the same account, because i have to calculate the "Total VAT > > due" for only certain transactions. > > For Example: > > > > - *rateA*: Beer without alcohol: SSS is 0.1 > > - *rateB*: Beer with alcohol: SSS is 3.7 > > > > Thats the Reason for my previous example with the Accounts per SSS rate: > > > > - Total VAT applicable turnover *rateA*: 100 > > - Total VAT collected *rateA*: 8 > > - Total VAT due *rateA* (100+8) x 0.1% = x.zy > > - ------------------------------------------------------------------- > > - Total VAT applicable turnover *rateB*: 50 > > - Total VAT collected *rateB*: 2.5 > > - Total VAT due *rateB* (100+2.5) x 3.7% = x.zy > > > > Thus my idea of creating one Tax-Account per SSS rate to which all "VAT > > collected" will be postet in regards to the SSS rate they need to be > > further processed with. > > > > It seems to me that your predicament is equivalent to the following JIRA > issue: https://issues.apache.org/jira/browse/OFBIZ-5403 > > > > > > For now i'm seeking a viable approach to later implemet the SSS Tax. If i > > had those three accounts per SSS rate: *applicable turnover*, > *collected*, > > *due* i could calculate *due* by turnover and collected and as you > > mentioned reset those two accounts to 0 while keeping *due* until the end > > of the period. > > > > Have a look at balance and income statement generated by your OFBiz > implementation. > > > > > > > Freundliche Grüsse > > > > Adrian Stern > > unchained - web solutions > > > > [email protected] > > +41 79 292 83 47 > > > > On Wed, Nov 12, 2014 at 9:07 AM, Pierre Smits <[email protected]> > > wrote: > > > > >
