Purchase Orders

marwat,

Click on the Tax column | Formula button | select the appropriate operand | put in your tax rate | apply to column or line button | OK

You can also set the tax rate for each supplier when you add the supplier to an item - just like the Supplier Cost, MPQ, Reorder Number, etc... This will enter the tax rate by default when the item is added to a PO..

I cant see a place for tax rate.....so I types in 7% in the box marked tax number. This generated a rate of 1.64% in the box marked tax rate on the front page of the purchase order.....where can I be going wrong?

Marwat

"Glenn Adams [MVP - Retail Mgmt]" wrote:

Marwat.

Go to the line item on the Contents tab of the purchase order, click on the tax column, click the Formula button, change the + to a * and enter your tax rate, select your radio button for this row only or all rows.

Ack! You're right - could have sworn there was a tax rate field there! Guess that's what happens when you post on NyQuil... Sorry!

It's there but not in the Items Properties but in the Items Supplied tab of the Supplier Property screen. From there you can enter a value i.e. 7, before moving the focus to another field you can highlight the value, right click and choose copy. Then right click on the field below that one and choose Paste to all rows. This way you can set the tax rate for all items supplied for a specific supplier.

Rob

"Glenn Adams [MVP - Retail Mgmt]" wrote in message news: snipped-for-privacy@TK2MSFTNGP15.phx.gbl...

This doesn't seem to work either, I can copy, but cant paste the tax value. Nor does the contents tab of the P.O. suggestion work for me either....you'd think there would be a simple way of including this tax in the supplier's profile, I guess I'll add it manually for now. Thank you all for your response

Marwat

"Rob" wrote:

It works but a little tricky, you have to follow the instructions exactly otherwise you won't be able to Paste to all rows. Another way of changing it is to Right Click on the Tax column from the Supplier property screen in the Item Supplied tab and choose Formula. From the drop down list choose Tax Rate and enter the tax rate into the field to the right. Then choose apply changes to all rows and press OK. This only works if all the items are set to 0 otherwise it will add to the existing value.

Rob

I tried the right click on the tax column solution....still nothing, I also tried "set Tax Rate to" Cost (from the drop down box) X 7%. nothing....how can it work on your programme and not mine?

Marwat

"Rob" wrote:

If you are changing the Tax Rate in the Suppliers property try 'Set Tax Rate to: TaxRate + 7' then make sure you have 'Apply formula to all rows in this column' checked

Rob

BINGO !!!......I was entery the % sign in after the 7.....Now it works, thank you for your patient assistance

Marwat

"Rob" wrote: