Historians believe that in newspost
<
[email protected]> on Fri, 11 Jul 2003,
L_Smith said:
I have become vat registered. I sell about 100 items all of which have
vat code N for not registered and need to be changed to S for
standard. Is there a way of doing this in one, rather than one hundred, operations?
Login as administrator and go Filke/Utilities/Export and select the item
list. It should now go into an excel file. Globally alter the
appropriate column.
That's the easy bit. The possible difficult bit is re-importing them
back in as they need to be in an IIF format - details about how to
achieve this are in the help under importing data.
I have not done any of this so can only suggest the way to do it.
Whatever you do - BACK UP first.
One final thought there may already be a QB utility program out there to
do this simply.
Good luck
Duncan
--
I love deadlines. I especially like the whooshing noise they make as
they go flying by.
Duncan Clark
GeneSys Ltd.