Thanks for the lesson Albert! Shows to go you how little I know… ~Claudine
From: [email protected] [mailto:[email protected]] On Behalf Of Albert Berry Sent: Thursday, August 17, 2017 2:36 PM To: [email protected] Subject: Re: [RBASE-L] - This worked previously as a on click eep but not now under version X 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]<mailto:[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]] 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 -- 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]<mailto:[email protected]>. For more options, visit 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]<mailto:[email protected]>. For more options, visit 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]<mailto:[email protected]>. For more options, visit 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.
