Rank: Member
Joined: 2/21/2007(UTC)
Posts: 1,113
|
The Inventory email is something I need to use on a weekly basis -- however it shows inactive products, even products that don't track inventory, it seems. Is there some code we can insert somewhere that would at least filter out inactive products? |
|
|
|
|
|
|
Rank: Member
Joined: 9/20/2006(UTC)
Posts: 92
|
Joe, I have not tested this, but you should be able to exclude inactive items by making a small change (shown in red) below to the SQL stored proceedure "bvc_ProductInventory_AllLowStock_s" Code:
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
BEGIN TRY
SELECT
a.bvin,
a.ProductBvin,
a.QuantityAvailable,
a.QuantityOutOfStockPoint,
a.ReorderPoint,
a.QuantityReserved,
a.Status,
a.LastUpdated
FROM bvc_ProductInventory AS a JOIN bvc_Product AS b ON a.ProductBvin = b.bvin
WHERE a.ReorderLevel <= 0 AND b.TrackInventory = 1 [b][color=red>AND][/b]
END TRY
BEGIN CATCH
EXEC bvc_EventLog_SQL_i
END CATCH
END
[/code] [color=gray> <HR align=left][1] [/color] Wallace Miller -- Narrowpath Design
Providing installation, custom development, and design services for BVC5 sites <FONT color=red>24/7 tech support and consultation service available for BVSoftware E-Commerce[/1][/color] 760.728.8679 (phone) sales at narrowpathdesign.com
|
|
|
|
|
|
Rank: Member
Joined: 2/21/2007(UTC)
Posts: 1,113
|
|
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.