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: > >
