UBS Inventory Software » Maintenance

ID #1247

Discontinue Item cannot send to excel

Description

In Item  Listing menu,  all items can be sent  to Excel except  Discontinue Item.  The solution below shows  the  steps  to sent  all information including Discontinue item, to excel.

 

Solution

Go to Maintenance  >  Item Maintenance  >  List Item,  click “Ok“, Excel, right click on “Exit“, click “Copy“, “Yes“, change SQL Statement from inner join icitem a on (a.itemno=i.itemno) to inner join icitem a on (a.itemno=i.itemno and a.item_stat<>”DISCONTINUE”), then  click “Send“.

Tags: Discontinue Item cannot send to excel

Related entries:

Last update: 2010-11-11 10:42
Author: Noor Diyana
Revision: 1.0

Digg it! Share on Facebook Print this record Send FAQ to a friend Show this as PDF file
Propose a translation for Propose a translation for
Please rate this FAQ:

Average rating: 0 (0 Votes)

completely useless 1 2 3 4 5 most valuable

You cannot comment on this entry