Item Tax Rate for Supplier in HQ

"Jason" ha scritto nel messaggio news: snipped-for-privacy@TK2MSFTNGP14.phx.gbl...

From Supplier | Item you can change directly the value (but you must be in maintenance mode into hq).

otherwise with trigger (disable recursive trigger into your server):

CREATE TRIGGER trChangeSupplierItemTax ON SupplierList AFTER INSERT,UPDATE

UPDATE SupplierList SET TaxRate = Tax.TaxRate /* or percentage? */ FROM inserted JOIN Item ON inserted.ItemID = Item.ID JOIN ItemTax ON Item.TaxID = ItemTax.ID JOIN Tax ON ItemTax.TaxID01 = Tax.ID WHERE SupplierList.TaxRate Tax.TaxRate

antonio

"Jason" ha scritto nel messaggio news:% snipped-for-privacy@TK2MSFTNGP09.phx.gbl...

Now I can't try ... (I have no RMS in this computer...)

Antonio

Hi All,

How do I set (default) the Supplier Tax Rate for an Item in HQ. When you go into HQ Manager -> Supplier -> Items Supplied there is a Tax Rate Column but it is greyed out and I cannot change it. How do I set it to be a specific or default value?

I can set the default tax rate for an item and for a store but not for the supplier - which is the problem because it appears that when a PO is raised in HQ the tax rate is populated from this supplier item tax rate (which I don't know how to change).

I could change the rate directly in the table with SQL but should I have to? Surely there is another way as I would have to run the sql query to change the tax rate everytime I create a new item and add it to a supplier. I could probably use a trigger but I was hoping I didn't have to go to that extreme.

Any help much appreciated,

Jason.

Antonio,

Thanks for the trigger I will give it a go as it is probably the best option.

I have tried the Maintenance Mode in HQ but I still can't edit the tax rate field from Supplier -> Items Supplied :-( Is there some other setting I need?

Thanks,

Jason.

Antonio, Glenn

Todd from MS says this is listed as a "known issue" and is being investigated. I guess I will have to use a trigger until we have a resolution.

Thanks for your help.

Jason.