Re: Entering Tax Inc prices in Misc Invoices

Gary:

Actually the Discount percentage would have to be less than the tax rate. For 
example, if the Price including tax is $100 and the tax rate is 10%, then the 
Discount percentage would need to be .0909:

   $100 - .0909($100) = $90.91   the price before tax.

Then:  $90.91 + .10($90.91) = $100   the total price.

The Discount percentage for your tax rate can be calculated.

Good luck!

Ray Hearl
Infotech Strategies


In a message dated Fri, 7 Jul 2000  3:30:37 PM Eastern Daylight Time, "Greg 
Wieczorek" <wieczog@versifit.com> writes:

<< Gary

Before you try the modification angle, try having the user enter the amount
as sold on the line along with a discount percent equal to the tax
percentage. Tax should then be calculated on the 'discounted' amount.

Regards
----- Original Message -----
From: <Gary.Brown@appliedchemicals.com>
To: <jbausers-l@midrange.com>
Sent: Thursday, July 06, 2000 6:03 PM
Subject: Entering Tax Inc prices in Misc Invoices


>
>
> We have cash vans on the road calling into customers.
> The van driver will negotiate a price for a product (including tax) with
the
> customer.
> The van driver writes the product and including tax value on his cash sale
> docket.
> The docket comes back to head office to be keyed into the JBA  SYS21 via
Misc
> Invoice with stock update (15/OEP).
>
> At the moment before processing each docket the order processing people
have to
> sit down with a calculator and manually calculate the ex tax price so that
they
> can enter that into the system.
>
> They would like to be able to key the including tax price in and the
system
> automatically split it into the Ex tax price + tax ('After all, is not the
AS400
> just a big calculator' was one comment we got).
>
> We can not use a price list as these are essentially cash sales and most
> customers will not have an account set-up and the van driver is getting as
much
> as he can for the product, so for the same product he might sell to one
customer
> for $15 and the next customer he sells for $20.
>
> All products are setup on the Item master file with the appropriate tax
code.
>
> We are on v3.5.2b service pack 2
>
> Any ideas on how we can meet the order processing depts request gratefully
> accepted.
>
> Thanks,
> Gary Brown
>
>
> +---
> | This is the JBA Software Users Mailing List!
> | To submit a new message send your mail to JBAUSERS-L@midrange.com.
> | To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
JBAUSERS-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner: doug333@aol.com.
> +---
>

+---
| This is the JBA Software Users Mailing List!
| To submit a new message send your mail to JBAUSERS-L@midrange.com.
| To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
| To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: doug333@aol.com.
+---
 >>


+---
| This is the JBA Software Users Mailing List!
| To submit a new message send your mail to JBAUSERS-L@midrange.com.
| To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
| To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: doug333@aol.com.
+---