Changing Suppliers for Many Items

Posted by Paul on May 29, 2007, 3:53 pm

Please log in for more thread options

Is there a quick and accurate way to change suppliers for groups of items?
Such as making all items in one Department or Department Code to be supplied
by a specific distributor?

Currently, most of my items do NOT have supplier which makes a Purchase
Order impossible.

Thanks.

Posted by Terrible Tom on May 29, 2007, 8:02 pm

Please log in for more thread options

You could use a query.

ALWAYS BACKUP FIRST.

Something like:

UPDATE Item SET SupplierID = X WHERE DepartmentID = Y
This will not update the SupplierList table.

In another thread, this query was recommended for updating the SupplierList
table:
INSERT INTO SupplierList ( SupplierID, ItemID, ReorderNumber)
SELECT Supplier.ID, Item.ID, Item.ItemLookupCode FROM Item, Supplier
WHERE Supplier.Code = '<SUPPLIERCODE>'

You could use:
SELECT * FROM Supplier
- to find the Supplier IDs

SELECT * from Department
- to find the Department IDs

ALWAYS BACKUP FIRST.

Tom
--
Stop fishing for e-mail

"Paul" wrote:

> Is there a quick and accurate way to change suppliers for groups of items?

> Such as making all items in one Department or Department Code to be supplied

> by a specific distributor?

> Currently, most of my items do NOT have supplier which makes a Purchase

> Order impossible.

> Thanks.

Posted by convoluted on May 29, 2007, 8:31 pm

Please log in for more thread options

You run the risk that not all the items in a specific department belong to
the same supplier and you'll screw up your data; you're probably better off
adding the supplier manually; or maybe jot down a list of hot sellers without
a supplier assigned and then using a query that will limit the update to just
those items...for example, there's five items you want to update, they have
the following item lookup codes: 234532, 123412, 346345, 2345234, and
3453244.

first backup your database
the query would be
update item
set supplierid = X
where itemlookupcode in ('234532', '123412', '346345', '2345234', '3453244');

Use Tom's query to find the supplier ID and department ID to use;
also consider running a SELECT query first to see which items will be
affected by the UPDATE query.
SELECT * from item where DepartmentID = Y

hope this helps..........

"Paul" wrote:

> Is there a quick and accurate way to change suppliers for groups of items?

> Such as making all items in one Department or Department Code to be supplied

> by a specific distributor?

> Currently, most of my items do NOT have supplier which makes a Purchase

> Order impossible.

> Thanks.

Posted by Jeff @ Check Point Software on May 30, 2007, 1:58 am

Please log in for more thread options

: quoted-printable

Paul,

As TT and Convoluted mentioned, this can get real nasty if done wrong.

How about trying something different? Run the attached report for what =
was _sold_ recently and start with them. You can modify the info by =
double clicking the ILC. Start with last week or 2, then work back for =
2 weeks before that. You can also run the report for items that you =
have sold out of and you need it now. At the same time of selecting the =
vendor for the product, you can setup your mins and re-order points too.

After that, run a PO using the same timeframe you selected on the =
report.

Worry about the rest of the products at a later date

--=20

Jeff=20
Check Point Software

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

You must be using Outlook Express/Windows Mail or some other type of =
newsgroup reader to
see and download the file attachment(s). If you are not using a reader, =
follow
the link below to setup Outlook Express. Click on "Open with =
newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

Is there a quick and accurate way to change suppliers for groups of =
items? =20
Such as making all items in one Department or Department Code to be =
supplied=20
by a specific distributor?

Currently, most of my items do NOT have supplier which makes a =
Purchase=20
Order impossible.

Thanks.
------=_NextPart_001_12A3_01C7A244.D6321230
Content-Type: text/html;
        charset="utf-8"
Content-Transfer-Encoding: quoted-printable

=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8">
<META content=3D"MSHTML 6.00.6000.16441" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#008000>Paul,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>As TT and Convoluted mentioned, this can get =
real nasty=20
if done wrong.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>How about trying something different?  =
Run the=20
attached report for what was _sold_ recently and start with them.  =
You can=20
modify the info by double clicking the ILC.  Start with last week =
or 2,=20
then work back for 2 weeks before that.  You can also run the =
report for=20
items that you have sold out of and you need it now. At the same time of =

selecting the vendor for the product, you can setup your mins and =
re-order=20
points too.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>After that, run a PO using the =
same timeframe you=20
selected on the report.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Worry about the rest of the products at a =
later=20
date</FONT></DIV>
<DIV><BR>-- <BR><BR>Jeff <BR>Check Point Software</DIV>
<DIV> </DIV>
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D</DIV>
<DIV> </DIV>
<DIV>You must be using Outlook Express/Windows Mail or some other type =
of=20
newsgroup reader to<BR>see and download the file attachment(s).  If =
you are=20
not using a reader, follow<BR>the link below to setup Outlook =
Express. =20
Click on "Open with newsreader"<BR>under the MS Retail Management System =
on the=20
right.</DIV>
<DIV> </DIV>
<DIV><A=20
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A><BR>=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
<BR></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Paul" <<A=20
=
.com</A>>=20
wrote in message <A=20
=
A4058-D8C2-4E2D-AA51-81C38C460DCE@microsoft.com</A>...</DIV>Is=20
there a quick and accurate way to change suppliers for groups of =
items? =20
<BR>Such as making all items in one Department or Department Code to =
be=20
supplied <BR>by a specific distributor?<BR><BR>Currently, most of my =
items do=20
NOT have supplier which makes a Purchase <BR>Order=20
impossible.<BR><BR>Thanks.</BLOCKQUOTE></BODY></HTML>

------=_NextPart_001_12A3_01C7A244.D6321230--

------=_NextPart_000_12A2_01C7A244.D6321230
Content-Type: application/octet-stream;
        name="Custom - Items - Movement with On Hand and Reorder Number.qrp"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
        filename="Custom - Items - Movement with On Hand and Reorder Number.qrp"

//--- Report Summary --- //

Begin ReportSummary
ReportType =3D reporttypeItems
ReportTitle =3D "Item Movement Report with On Hand and Re-Order =
Number"
PageOrientation =3D pageorientationLandscape
ShowDateTimePicker =3D False
OutLineMode =3D True
Groups =3D 0
GroupDescription =3D ""
DisplayLogo =3D True
LogoFileName =3D "MyLogo.bmp"
ProcedureCall =3D ""
PreQuery1 =3D "IF EXISTS (SELECT TABLE_NAME FROM =
INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME =3D 'ViewItemMovement') DROP =
VIEW ViewItemMovement"
PreQuery2 =3D <BEGIN>
=20
CREATE VIEW ViewItemMovement AS
SELECT Department.Name AS DepartmentName,
        Category.Name AS CategoryName,
        Supplier.SupplierName AS SupplierName,
        Item.ItemLookupCode AS ItemLookupCode,
        Item.Description AS ItemDescription,
        Item.Quantity AS OnHand,
        SupplierList.ReorderNumber AS ReorderNumber,
        Item.LastSold AS LastSold,
        Item.LastReceived AS LastReceived,
        Item.Cost AS Cost,
        Item.ReorderPoint AS ReorderPoint,
        Item.RestockLevel AS RestockLevel,
        InventoryTransferLog.Type AS Type,
        0 AS QuantitySold,
        ISNULL (InventoryTransferLog.Quantity, 0) AS Quantity,
        0 AS PriceSold,
        0 AS CostSold,
        InventoryTransferLog.DateTransferred AS DateTransferred,
        1 AS Moved,
        CASE InventoryTransferlog.Type WHEN 2 THEN =
InventoryTransferLog.ReferenceID ELSE NULL END AS TransactionNumber
=20
FROM InventoryTransferLog=20
        LEFT JOIN Item ON InventoryTransferLog.ItemID =3D Item.ID
        LEFT JOIN Department ON Item.DepartmentID =3D Department.ID
        LEFT JOIN Category ON Item.CategoryID =3D Category.ID
        LEFT JOIN Supplier ON Item.SupplierID =3D Supplier.ID
        LEFT JOIN SupplierList ON Item.SupplierID =3D SupplierList.SupplierID =
AND Item.ID =3D SupplierList.ItemID

=20
UNION ALL =20

SELECT Department.Name AS DepartmentName,
        Category.Name AS CategoryName,
        Supplier.SupplierName AS SupplierName,
        Item.ItemLookupCode AS ItemLookupCode,
        Item.Description AS ItemDescription,
        Item.Quantity AS OnHand,
        SupplierList.ReorderNumber AS ReorderNumber,
        Item.LastSold AS LastSold,
        Item.LastReceived AS LastReceived,
        Item.Cost AS Cost,
        Item.ReorderPoint AS ReorderPoint,
        Item.RestockLevel AS RestockLevel,
        99 AS Type,
        ISNULL (TransactionEntry.Quantity, 0) AS QuantitySold,
        0 AS QuantityTransferred,
        ISNULL (TransactionEntry.Price, 0) AS PriceSold,
        ISNULL (TransactionEntry.Cost, 0) AS CostSold,
        [Transaction].Time AS DateTransferred,
        CASE WHEN [Transaction].Time IS NULL THEN 0 ELSE 1 END AS =
Moved,
        [Transaction].TransactionNumber AS TransactionNumber
=20
FROM Item
        LEFT JOIN TransactionEntry ON TransactionEntry.ItemID =3D Item.ID
        LEFT JOIN Department ON Item.DepartmentID =3D Department.ID LEFT =
JOIN Category ON Item.CategoryID =3D Category.ID
        LEFT JOIN [Transaction] ON =
TransactionEntry.TransactionNumber =3D [Transaction].TransactionNumber
        LEFT JOIN Supplier ON Item.SupplierID =3D Supplier.ID
        LEFT JOIN SupplierList ON Item.SupplierID =3D SupplierList.SupplierID =
AND Item.ID =3D SupplierList.ItemID

<END>

TablesQueried =3D "FROM ViewItemMovement LEFT JOIN Supplier ON =
ViewItemMovement.SupplierName =3D Supplier.SupplierName"
SelCriteria =3D ""

GroupBy =3D "ViewItemMovement.ItemLookupCode, =
ViewItemMovement.LastSold, ViewItemMovement.LastReceived, =
ViewItemMovement.Cost,ViewItemMovement.ReorderPoint, =
ViewItemMovement.RestockLevel,Supplier.SupplierName, =
ViewItemMovement.DepartmentName, ViewItemMovement.CategoryName, =
ViewItemMovement.ItemDescription, ViewItemMovement.ReorderNumber, =
ViewItemMovement.OnHand"

SortOrder =3D ""
End ReportSummary

//--- Title Rows ---//

Begin TitleRow
Text =3D "<Store Name>"
Font =3D "Arial"
FontBold =3D True
FontSize =3D 16
Color =3D "Blue"
End TitleRow

Begin TitleRow
Text =3D "<Report Title>"
Font =3D "Arial"
FontBold =3D True
FontSize =3D 12
Color =3D "Black"
End TitleRow

Begin TitleRow
Text =3D "Generated On <Report Date>"
Font =3D "Arial"
FontBold =3D True
FontSize =3D 10
Color =3D "Black"
End TitleRow

Begin TitleRow
Text =3D "Designed and/or modified by Microsoft Corp. and/or Check =
Point Software"
Font =3D "Arial"
FontBold =3D False
FontSize =3D 8
Color =3D "Black"
End TitleRow

//--- Filters ---//

Begin Filter
FieldName =3D "ViewItemMovement.DateTransferred"
FilterOp =3D reportfilteropGreaterEqual
FilterLoLim =3D "<MonthStart>"
FilterHilim =3D "<Today>"
End Filter

//--- Columns ---//

Begin Column
FieldName =3D "ViewItemMovement.ItemLookupCode"
DrillDownFieldName =3D "Item.ItemLookupCode"
DrillDownReportName =3D ""
Title =3D "ILC"
VBDataType =3D vbString
Formula =3D ""
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 1200
GroupMethod =3D groupmethodNone
ColFormat =3D ""
ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
FieldName =3D "ViewItemMovement.DepartmentName"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Department"
VBDataType =3D vbString
Formula =3D "ViewItemMovement.DepartmentName"
ColHidden =3D True
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 1500
GroupMethod =3D groupmethodNone
ColFormat =3D ""
ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
FieldName =3D "ViewItemMovement.CategoryName"
DrillDownFieldName =3D "Category.Name"
DrillDownReportName =3D ""
Title =3D "Category"
VBDataType =3D vbString
Formula =3D ""
ColHidden =3D True
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 1500
GroupMethod =3D groupmethodNone
ColFormat =3D ""
ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
FieldName =3D "ViewItemMovement.ItemDescription"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Description"
VBDataType =3D vbString
Formula =3D ""
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 2500
GroupMethod =3D groupmethodNone
ColFormat =3D ""
ColAlignment =3D flexAlignLeftCenter
End Column

Begin Column
FieldName =3D "ViewItemMovement.OnHand"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "On Hand"
VBDataType =3D vbString
Formula =3D ""
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 800
GroupMethod =3D groupmethodNone
ColFormat =3D ""
ColAlignment =3D flexAlignRightCenter
End Column

Begin Column
FieldName =3D "QtySold"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Qty Sold"
VBDataType =3D vbString
Formula =3D "SUM(ViewItemMovement.QuantitySold)"
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 800
GroupMethod =3D groupmethodSum
ColFormat =3D ""
ColAlignment =3D flexAlignRightCenter
End Column

Begin Column
FieldName =3D "ViewItemMovement.ReorderPoint"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Reorder"
VBDataType =3D vbDouble
Formula =3D ""
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 800
GroupMethod =3D groupmethodNone
ColFormat =3D "###"
End Column

Begin Column
FieldName =3D "ViewItemMovement.RestockLevel"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Restock"
VBDataType =3D vbDouble
Formula =3D ""
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 800
GroupMethod =3D groupmethodNone
ColFormat =3D "###"
End Column

Begin Column
FieldName =3D "Sales"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Sales"
VBDataType =3D vbCurrency
Formula =3D "SUM(ViewItemMovement.QuantitySold * =
ViewItemMovement.PriceSold)"
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 1100
GroupMethod =3D groupmethodSum
ColFormat =3D ""
End Column

Begin Column
FieldName =3D "ViewItemMovement.LastSold"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Last Sold"
VBDataType =3D vbDate
Formula =3D ""
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 1100
GroupMethod =3D groupmethodMax
ColFormat =3D ""
End Column

Begin Column
FieldName =3D "ViewItemMovement.Cost"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Cost Each"
VBDataType =3D vbCurrency
Formula =3D ""
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 1100
GroupMethod =3D groupmethodSum
ColFormat =3D ""
End Column

Begin Column
FieldName =3D "CostSold"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Cost Sold"
VBDataType =3D vbCurrency
Formula =3D "SUM(ViewItemMovement.QuantitySold * =
ViewItemMovement.CostSold)"
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 1100
GroupMethod =3D groupmethodSum
ColFormat =3D ""
End Column

Begin Column
FieldName =3D "ViewItemMovementQuantity"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Non Sale"
VBDataType =3D vbString
Formula =3D "SUM(ViewItemMovement.Quantity)"
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 800
GroupMethod =3D groupmethodSum
ColFormat =3D ""
ColAlignment =3D flexAlignRightCenter
End Column

Begin Column
FieldName =3D "ViewItemMovement.LastReceived"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Last Recvd"
VBDataType =3D vbDate
Formula =3D ""
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 1100
GroupMethod =3D groupmethodMax
ColFormat =3D ""
End Column

Begin Column
FieldName =3D "PurchaseOrder"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "PO Movement"
VBDataType =3D vbDouble
Formula =3D "SUM(CASE WHEN Type =3D 1 THEN ISNULL(Quantity, 0) ELSE 0 =
END) "
ColHidden =3D True
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 1300
GroupMethod =3D groupmethodSum
ColFormat =3D "###"
End Column

Begin Column
FieldName =3D "Supplier.SupplierName"
DrillDownFieldName =3D "Supplier.SupplierName"
DrillDownReportName =3D ""
Title =3D "Primary Supplier"
VBDataType =3D vbString
Formula =3D ""
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 2500
GroupMethod =3D groupmethodNone
ColFormat =3D ""
ColAlignment =3D flexAlignRightCenter
End Column

Begin Column
FieldName =3D "ViewItemMovement.ReorderNumber"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Reorder #"
VBDataType =3D vbString
Formula =3D ""
ColHidden =3D False
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 1200
GroupMethod =3D groupmethodNone
ColFormat =3D ""
ColAlignment =3D flexAlignRightCenter
End Column

Begin Column
FieldName =3D "OfflineMovement"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Offline Movement"
VBDataType =3D vbDouble
Formula =3D "SUM(CASE WHEN Type =3D 2 OR Type =3D 3 OR Type =3D 4 =
THEN ISNULL(Quantity, 0) ELSE 0 END) "
ColHidden =3D True
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 1710
GroupMethod =3D groupmethodSum
ColFormat =3D "###"
End Column

Begin Column
FieldName =3D "Adjusted"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Adjusted"
VBDataType =3D vbDouble
Formula =3D "SUM(CASE WHEN Type =3D 5 OR Type =3D 6 THEN =
ISNULL(Quantity, 0) ELSE 0 END) "
ColHidden =3D True
ColNotDisplayable =3D False
FilterDisabled =3D False
ColWidth =3D 1200
GroupMethod =3D groupmethodSum
ColFormat =3D "###"
End Column

Begin Column
FieldName =3D "ViewItemMovement.DateTransferred"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Date"
VBDataType =3D vbDate
Formula =3D ""
ColHidden =3D True
ColNotDisplayable =3D True
FilterDisabled =3D False
ColWidth =3D 1100
GroupMethod =3D groupmethodNone
ColFormat =3D ""
End Column

Begin Column
FieldName =3D "ViewItemMovement.Moved"
DrillDownFieldName =3D ""
DrillDownReportName =3D ""
Title =3D "Moved"
VBDataType =3D vbBoolean
Formula =3D ""
ColHidden =3D True
ColNotDisplayable =3D True
FilterDisabled =3D False
ColWidth =3D 1100
GroupMethod =3D groupmethodNone
ColFormat =3D ""
End Column
------=

Posted by Paul on May 30, 2007, 11:23 am

Please log in for more thread options

Thanks for the help by all.

After trying to do it on my own using the minimalist SQL knowledge that I
have, I managed to add a Supplier to groups/departments of items without a
problem. Then, when I tried to add those items into the SupplierList I added
all items to EACH Supplier instead of just moving them to the ONE they were
supposed to be listed as.

At the moment, I'm leaning towards Jeff's recommendation. I keep hoping for
something easy like a cut and paste as you might in an Excel spreadsheet.

Paul

"Jeff @ Check Point Software" wrote:

> Paul,

> As TT and Convoluted mentioned, this can get real nasty if done wrong.

> How about trying something different? Run the attached report for what was

_sold_ recently and start with them. You can modify the info by double clicking
the ILC. Start with last week or 2, then work back for 2 weeks before that.
You can also run the report for items that you have sold out of and you need it
now. At the same time of selecting the vendor for the product, you can setup
your mins and re-order points too.

> After that, run a PO using the same timeframe you selected on the report.

> Worry about the rest of the products at a later date

> --

> Jeff

> Check Point Software

> =====================================================

> You must be using Outlook Express/Windows Mail or some other type of newsgroup

reader to

> see and download the file attachment(s). If you are not using a reader, follow

> the link below to setup Outlook Express. Click on "Open with newsreader"

> under the MS Retail Management System on the right.

> http://tinyurl.com/75bgz

> =====================================================

> Is there a quick and accurate way to change suppliers for groups of items?

> Such as making all items in one Department or Department Code to be supplied

> by a specific distributor?

> Currently, most of my items do NOT have supplier which makes a Purchase

> Order impossible.

> Thanks