Accounting/Tax

[David Deacon]

Hi
I have written a small accounts package

My problem is that i have set the GST in qrys as the following
AmountDue: 1.1*([unitprice]*[Quantity]*(1-[Discount])-([CreditUnits]))

This works great, now my design mistake is that i want the user to
choose if they are GST registed or not.

My thoughts are create a field [GST], HOWEVER when i do this and place
it as

AmountDue: [GST]*([unitprice]*[Quantity]*(1-[Discount])-([CreditUnits]))

THE return value is the amount of GST not the Totla including GST.

Has anyone made an accounts package and can ofer me some solutions?

DD
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Roger]

I assume this
AmountDue: 1.1*([unitprice]*[Quantity]*(1-[Discount])-([CreditUnits]))
means that your GST is 10 % ?

is your [GST] here .1 or 10 ?
AmountDue: [GST]*([unitprice]*[Quantity]*(1-[Discount])-([CreditUnits]))

try either
AmountDue: (1+[GST])*([unitprice]*[Quantity]*(1-[Discount])-([CreditUnits]))

or
AmountDue: (100+[GST])/100*([unitprice]*[Quantity]*(1-[Discount])-
([CreditUnits]))
David Deacon <da**********@bigpond.com.au> wrote in message news:<40***********************@news.frii.net>...

Hi
I have written a small accounts package

My problem is that i have set the GST in qrys as the following
AmountDue: 1.1*([unitprice]*[Quantity]*(1-[Discount])-([CreditUnits]))

This works great, now my design mistake is that i want the user to
choose if they are GST registed or not.

My thoughts are create a field [GST], HOWEVER when i do this and place
it as

AmountDue: [GST]*([unitprice]*[Quantity]*(1-[Discount])-([CreditUnits]))

THE return value is the amount of GST not the Totla including GST.

Has anyone made an accounts package and can ofer me some solutions?

DD
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[David Deacon]

Hi Roger
thanks for your input the following works great, however if i want the
GST to be zero rather that 10% in this query, it is making the whole
expression zero
AmountDue:
(Nz(1+[GST10]))*([unitprice]*[Quantity]*(1-[Discount])-([CreditUnits]))
Any Ideas

My ultimate goal
My thoughts are that i have a chkboxYN the user decides if they are GST
[10%] or not =0

Regards
DD

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[David Deacon]

Ok i have fixed the latest dilema by way of following

AmountDue:
((Nz(1+[GST10]))*([unitprice]*[Quantity]*(1-[Discount])-([CreditUnits]))
)
Extra brackets
Now i can have 0 or 10%
Thanks to all who helped
DD

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Roger]

is [gst10] = 0 or is it = null ?
it must be null...it is the only way that expression can be 0
null + anything - anything * anything / anything always equals null

try
(1+nz([GST10],0))*([unitprice]*[Quantity]*(1-[Discount])-([CreditUnits]))

David Deacon <da**********@bigpond.com.au> wrote in message news:<40***********************@news.frii.net>...

Hi Roger
thanks for your input the following works great, however if i want the
GST to be zero rather that 10% in this query, it is making the whole
expression zero
AmountDue:
(Nz(1+[GST10]))*([unitprice]*[Quantity]*(1-[Discount])-([CreditUnits]))
Any Ideas

My ultimate goal
My thoughts are that i have a chkboxYN the user decides if they are GST
[10%] or not =0

Regards
DD

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!