Claudine, if vcamt includes 10% GST it is 110% of the invoice, so the GST is vacamt/11 = 10%
Albert > On Aug 17, 2017, at 12:20 PM, Claudine Robbins <[email protected]> wrote: > > Only thing I see is missing DEFAULT and BREAK before ENDSW. But I don’t > understand SET VAR vgst = (.vcamt/11) as calculating 10%... And clearly your > INSERT needs a WHERE clause. > > Claudine > > From: [email protected] <mailto:[email protected]> > [mailto:[email protected] <mailto:[email protected]>] On Behalf > Of DB GEOINFO > Sent: Thursday, August 17, 2017 9:01 AM > To: [email protected] <mailto:[email protected]> > Subject: [RBASE-L] - This worked previously as a on click eep but not now > under version X > > Simple problem. Old fashioned. This just calculates a 10% tax except when > less is levied or sometimes zero. Simple but doesn’t work anymore. Nothing > happens. Gst is not updated. How should I re-write it? > > > EEP > *(calc_gst) > *(Y = 10% gst, N = 0 gst, X = manual gst entry) > > SET VAR vgst1 = .CGST > SET VAR vcamt = .CAmt > SET VAR vynx = .GstYN > SET VAR vgst = 0 > SWITCH (.vynx) > CASE 'Y' > SET VAR vgst = (.vcamt/11) > BREAK > CASE 'N' > SET VAR vgst = 0 > BREAK > CASE 'X' > SET VAR vgst = .vgst1 > BREAK > ENDSW > > INSERT INTO Costs (CGst) VALUES (.vgst) > > RECALC VARIABLES > RETURN > > Drake-Brockman Geoinfo Pty Ltd > 404 Great Eastern Highway > Woodbridge, Perth, WA, Australia, 6056 > Tel +61 8 9274 5477 <tel:%2B61%208%209274%205477> > Mob +61427 525952 > Email [email protected] <mailto:[email protected]> > Web www. dbgeoinfo.net.au <http://dbgeoinfo.net.au/> > Dropbox URL: https://www.hightail.com/u/DBGEOINFO > <https://www.hightail.com/u/DBGEOINFO> > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > <http://www.rbase.com/support/usersgroup_guidelines.php> > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > <http://www.rbase.com/support/usersgroup_guidelines.php> > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
