ORACLE APPLICATIONS ARCHIVES

Topicwise collection of
Postings on Mail Lists
ON
INVENTORY



Loading Item/Subinventory associations

Date: Thu, 1 Jul 1999 13:13:53 -0400
From: Malcolm_Jowett@ingerrand.com
Subject: INV: Loading Item/Subinventory associations

Hi,

I am implementing R11.0.2 and having a problem with loading Item/Subinventory/Locator data for my 54,000 items.

When creating an item manually, it is necessary to use the Special-Item Subinventories screen to list the subinvs and locators where that item can be stored. This must be done before you can enter the WIP Supply Locator and WIP Supply Subinventory in the WIP region of the item form. These values are used to default the location of the item when issuing.

When using the Items Open Interface, the import programme populates the WIP Supply ... columns, but not the tables behind the 'Item Subinventories' form. This is clearly breaking Oracle's own data integrity rules.

We need to populate the tables behind this form as they are used to validate other data inputs. Manual loading is NOT an option!!

There is an interface table (mtl_item_sub_invs_interface) which does not work at R11.0.2. There have been discussions on this list about having to write scripts to load data direct to the core tables.

Has anyone solved this?
Thanks in advance, Malcolm Jowett.


Megapatch - C

Date: Thu, 1 Jul 1999 09:07:10 -0400
From: "Finney, Jack" jack.finney@glenayre.com
Subject: INV-C Mega Patch

We have recently applied INV-C mega patch to our test instance and I noticed that it added two segments to the 'Stock Locators' key flexfield. The two segments are: (1) Project; column SEGMENT19 value set PJM_PROJECT (2) Task; column SEGMENT20 value set PJM_TASK. I called Oracle for an explanation for these new segments and I was unable to get a clear answer. The Inventory rep said that Projects would populate the segments and the Projects rep said that Inventory would populate them. Neither could give me the functional purposes or benefits of having these new segments.

Does anyone know what these segments are and how they are to be used? Is there any documentation concerning this 'new' functionality?

Thank you, in advance, for any information you have.
Jack Finney Jr.
Glenayre
Business System Analyst


Date: Thu, 1 Jul 1999 09:31:48 -0400
From: "Robey, Bartley H" brobey@kpmg.com
Subject: RE: INV-C Mega Patch

I believe the fields get populated from Order Entry or Inventory to be able to interface inventory/WIP to Projects through the Cost Collector and Transaction Import (average costs only). It sounds like Oracle added or fixed functionality to the new Release 11 'Project Manufacturing'. I would check the R11 Project Manufacturing User's Guide and R11 Project Manufacturing mplementation Guide for more details.

Hope this helps.
Bart Robey
KPMG Consulting
Voice Mail: (703) 747-5122
Email: brobey@kpmg.com



Cannot remove Reservable Flag

Date: Thu, 1 Jul 1999 15:53:19 +0200
From: "Andre Kuerten" akuerten@imation.com
Subject: INV:cannot remove reservable flag

Hi folks,

i want to disable the reservable flag for an specific item. There is no qty, no Sales order, no Purchase order. But i get the error message, that there are reservations defined and therefore i cannot remove the flag.

Any help is appreciated Andree


Upload high volume of items

On 1 Jul 99 at 7:14, aragab wrote:

HI ALL
HOW I CAN UPLOAD INV 54,000 ITEM BY USING INV_INTERFACE BEST_REGARDS / AHMED RAGAB


Date: Thu, 1 Jul 1999 22:27:12 MYT-8
From: philip@aleytys.pc.my
To: aragab a_ragab@tccbce.com, oraapps-l@cpa.qc.ca
Subject: Re: INV_UP_LOADING _PROBLEM

Hi!

We are converting from 9.4 to 10.7SC and I am testing the Inventory Open Item Interface to bring over all of our 20K+ items. I brought over a test batch and populated both the Master and Inventory Organizations. However while I could view and update these items from the character mode screens, from the GUI I couldn't query them up; although I could use these items from all the other GUI screens (PO, OE, receiving etc).

Oracle support sent me a patch for the Item import programme and now my import is working touch wood. I strongly suggest you get this patch first and save youself some grief.

I tried to post my script for populating the Item Interface earlier but it was over 20K and was bounced. Anybody who wants to laugh at my miniscule PL/SQL skills can e-mail me for it.

Philip



Time consuming batch programs

Date: Tue, 6 Jul 1999 16:30:18 +0530
From: rpsingh/Polaris@polaris.co.in
Subject: Inventory : time consuming batch programs

Hi all
We need the list of batch programs which are taking too much time to process. The objective is to utilize one tool to reduce the processing time. Please send the names of the programs in Inventory, AP,AR,GL which you find are taking too much time.

regards
RP singh
Technical Consultant
Oracle Applications.


Viewing Inter-Org Transfers on Screen

Date: Tue, 06 Jul 1999 09:07:43 -0400
From: Paul Mallon pmallon@oasys-grp.com
Subject: Viewing Inter-Org Transfers on Screen

Is there a way in Oracle (v11.02) to view (on screen) items in-transit between organizations? I know various reports exist and I can see items due in via the Supply/Demand screen, but that's only item by item.

Paul M.


Date: Tue, 6 Jul 1999 06:40:45 -0700
From: "MCAVOY, Brian J." bmcavoy@shl.com
Subject: RE: Viewing Inter-Org Transfers on Screen

Paul, in R10.7 you could go to the manage shipments form to see this information. Not sure if they have taken this away in R11. Hopes this helps.

Brian McAvoy
Consultant
EDS
pager 888-319-3433
bmcavoy@shl.com



Inventory Availability Extract

Date: Tue, 6 Jul 1999 10:05:46 -0400
From: "Lott, Jeff" jlott@universalfurniture.com
Subject: Inventory Availability Extract

My organization has customers who require that we provide them with inventory availability information. This information should include on-hand inventory availabity as well as work-in-process quantities less current demand. These quantities would be "bucketed" by the date upon which the inevntory would be available to ship.

I'm interested if any other organizations have had similar requirements and if so, the manner in which they satisfied these requirements. Did you use the Open Demand Interface or was a customized solution required?

Any assistance is greatly appreciated.


Item and Org Assignment

From: mohammed alshaarawi m_sharawy@tccbce.com
Subject: item with organization assignment
Date: Tue, 6 Jul 1999 10:07:54 -0400 (EDT)

Hi
I defiend item and i assigned to it 2 organization i would like to remove on of these assignment is there a way?
thanx


From: DASARI SUBRAHMANYAM srdasari@hotmail.com
Date: Tuesday, July 06, 1999 9:56 PM
Subject: Re: item with organization assignment

Hi,
I think deleting an item is only the way.
dasari


Date: Wed, 7 Jul 1999 09:53:55 +0530
From: "Chitti Babu" cbabu@satyam.net.in
Subject: Re: item with organization assignment

Yes. You can create delete groups in the organization where you want to delete and submit delete from that organization.

Thanks Chitti


Date: Tue, 6 Jul 1999 22:00:37 -0700 (PDT)
From: Krishnakumar Narasihman chnkrishna@yahoo.com
Subject: Re: item with organization assignment

dasari is correct but you must ensure that there are no delete constraints that prevent you from deleting. also ensure trail for such deletes.

nkkumar


Date: Thu, 8 Jul 1999 08:44:42 +0300
From: Mohammad Fouwaaz Mfouwaaz@savola.com
Subject: RE: item with organization assignment

How do you do this? Do you mean to login using responsibility with access to the relevant organization and then query for the item on the item definition screen and do a / row delete? This does not seem to work for me.

Regards


Date: Fri, 9 Jul 1999 10:00:14 +0530
From: "Chitti Babu" cbabu@satyam.net.in
Subject: Re: item with organization assignment

Hi

I did not mean to loose the access of organizations at all. You need not access Organizations access form. Onlt thing you need to do create delete group through inventory GUI responsibility under the organization where you need to delete item, then submit delete item information. I don't remember exactly screens in character based screens.

Hope this helps Thanks Chitti


Date: Thu, 8 Jul 1999 12:15:06 +300500
From: BPL-UPTRON_Team@india.notes.pwa.co.in
Subject: Re: item with organization assignment

Hi,

Instead of deleting the item the attributes can be reset to non inventory, non stockable, non transactable and non purchasable etc or the status of the item can be set to Inactive or the uniquely defining segment's valueof the item code can be disabled from the LOV.

Hope the above information helps.
Regards, Harpreet



Inventory availability extract

From: Lott, Jeff jlott@universalfurniture.com
Date: Tuesday, July 06, 1999 7:51 PM
Subject: Inventory Availability Extract

My organization has customers who require that we provide them with inventory availability information. This information should include on-hand inventory availabity as well as work-in-process quantities less current demand. These quantities would be "bucketed" by the date upon which the inevntory would be available to ship.

I'm interested if any other organizations have had similar requirements and if so, the manner in which they satisfied these requirements. Did you use the Open Demand Interface or was a customized solution required?

Any assistance is greatly appreciated.


Date: Wed, 7 Jul 1999 10:01:50 +0530
From: "Chitti Babu" cbabu@satyam.net.in
Subject: Re: Inventory Availability Extract

You may need to develop a custom report which meets customer reuirements. Similar requirement was there Pillowtex/Fieldcrest Cannon for some of its customers.You can contact rambabu_nukala@pillowtex.com

Thanks Chitti


Cycle Counting - Automatic Scheduling

Date: Wed, 7 Jul 1999 19:07:30 +0700
From: "Nagamohan U." umohan@irs.co.id
Subject: INV:Cycle Counting, Automatic Scheduling

Hi
We are on 10.7 GUI SC16.1.

We are trying to implement Cycle Counting here at our site. I am trying to use the auto-scheduling feature for the defined cycle count.

The cycle counting attribute is enabled for all the items. Auto scheduling option is also enabled for the cycle count. I am using weekly interval for the schedule.

I have three classes in the ABC classification i.e., A, B and C. My frequency of counting of the items per year are as follow.

A 52 times per year
B 26 times per year
C 13 times per year

Now I run the Cycle Count Scheduler from the Cycle Count Form. But this turns out be an error always. The error message reads like this.

SQL Error; EXEC # 14B; Error Code = 0
ERROR= ORA-01403: No Data Found.

Has anybody encountered this error. Am I missing something? Any patch required?

Regards/Nagamohan


Date: Wed, 7 Jul 1999 15:18:46 -0700
From: skirby@bco.com
Subject: RE: Cycle Counting, Automatic Scheduling

I can't give you the detail from 10.7, I have only done this in 11..

Here is a cut from the 11 documentation:

Steps Involved
Define and run an ABC compilation. See: Defining and Running an ABC
Compilation.
Define ABC classes. See: Defining ABC Classes.
Define ABC groups. See: Defining ABC Assignment Groups.
Assign items to ABC classes within a group. See: Defining ABC Item
Assignments.
Update item assignments. See: Updating ABC Item Assignments.
Purge ABC information. See: Purging ABC Information.

You need to do steps 1-4 before you can schedule the counts... If you have done that already then you are on your own...

Steve Kirby skirby@bco.com


Date: Thu, 8 Jul 1999 09:35:10 +0200
From: "Andre Kuerten" akuerten@imation.com
Subject: Re: INV:Cycle Counting, Automatic Scheduling

Hello,

i would recommend to create a calendar to tell the system at which days you want to count and on which days not. For example, you want to count from Monday to Friday, but for sure not on sunday, i guess. That offers also the chance to switch days off were you may have public vacation or manpower problems. After creating such a calendar and following the steps that another guy has already described, you shouldŽnt have a problem to get your cycle count listings. But the system will only collect the items that have to be counted on the specific day. You must instrucht the system to print you the cycle count listings. For that you have to go in the cycle count screen, choose "special", click on Performe full cycle count. Than you will get a mask where you can decide how many copies you want and so on. This screen is also useful for scheduling the cycle count, because automatic scheduling is not working!! See the help screen for detailed information, or come back to me. I am the lucky guy in our company that has to do it every day...

Regards Andree



Inventory and Cost

From: mohammed alshaarawi [mailto:m_sharawy@tccbce.com]
Sent: Tuesday, July 06, 1999 7:22 AM
Subject: INV & cost

I have a problem in Oracle inventory which is i want to limit the store keeper from entering the cost , only enter the qty. anohter user can enter the cost or modify it can we do this ??
regard


Date: Wed, 7 Jul 1999 17:10:30 +300500
From: BPL-UPTRON_Team@india.notes.pwa.co.in
Subject: RE: INV & cost

Mohammed,

My client had a similar requirement. It can be done without customising any form (if I have understood ur requirement properly). The only forms where costs can be input are average cost update form and Misc. Transaction form. So make a responsibilty for store keeper and don't give him access to avaerage cost update form. Store keeper shall require access to Misc. Transaction form so hide the unit cost field by creating a folder. Also change the profile option of Allow Folder customization to No for that user. Thus the user can do the transaction and shall not have access to unit cost field. The initial cost of the item is defined at the time of inputting the opening balances. In average cost organization the cost of the item changes automatically with every receipt transaction.

Hope the above solution helps and in case there are any queries feel free to get back to me.

Harpreet


Date: Wed, 07 Jul 1999 20:24:33 GMT
From: Ananth Swaminath ananth999@hotmail.com
Subject: RE: INV & cost

Hi Nagmohan

The folder functionality helps...but isn't available on all the forms. Further there are a few shortcomings with this solution. It therefore does depend on the transactions that are being conducted.

Ananth Senior Applications Consultant


Date: Thu, 8 Jul 1999 16:16:35 +0530
From: rohit.sharma/Polaris@polaris.co.in
Subject: RE: INV & cost

In my opinon as I have not implemented Inventory till date but my functional exp says that at the time of creating a item a master cost is created for any inventory item or if at the time of receiving PO is matched then the copst mentioned in PO is the default cost .Therfore the storekeeper while entering the inventory is not supposed to enter the cost but in case there is any diffrence person responsible for creatng masters can change the price. there fore i suggest you to pls look into these matters and i hope their will be certainly a work around for you.

Please let me know if there is any benefit arises from my opinon. Rohit sharma



Autocreate and item supply/demand

Date: Wed, 7 Jul 1999 15:44:38 +0200
From: Andrew Robertson AndrewR@langeberg.co.za
Subject: RE: Urgent - Auto create process and item supply/demand

Hi All

We are running Oracle 10.7 NCA with INV, WIP OE amongst other modules.

Our problem is as follows:

A sales order is placed against export items and a requisition is created to get the stock from the manufacturing organisation into the shipping organisation. From the original sales order/internal requisition discrete jobs are autocreated in the manufacturing organisation. This autocreated job is meant to look at the current items supply and demand (ie: stock on hand that is not reserved against any other sales orders) and then only autocreate a job for the balance of stock required. However this is not taking place.

At the moment the autocreate process is ignoring stock availability and creating jobs for the entire quantity ordered on the sales order/requisition.The entire quantity on the job is reserved against that particular sales order and cannot be used against other shipments

When there is enough demand to fulfill the sales order then the autocreate process does not create a discrete job.

Has anyone come across this problem before of partially fulfilled demand against a sales order? If so how did you go about fixing it. As I understand it this should be Oracle functionality - possibly we have missed out a profile option or something. Any help would be appreciated!

Thanks Andrew andrewr@langeberg.co.za


Receipt Date Import

Date: Mon, 8 Feb 1999 11:35:37 -0500 (EST)
From: cshay@csc.com
Subject: Receipt Date Conversion - URGENT

When converting on hand balances from the leagcy system, we also want to convert a receipt date. The receipt date is used to issue material using First In First Out (FIFO). We don;t need to know the PO number.

Does anyone know how to bring over the receipt date when laoding inital balances. We will be bring the balances over as Misc issues.


Date: Mon, 8 Feb 1999 11:47:09 -0500 (EST)
From: Harry Swallow harry.swallow@interpath.net
Subject: Re: Receipt Date Conversion - URGENT

You would convert your on-hand balances as Misc. Receipts, not Issues, and could populate the transaction_date column with your receipt date. Just make sure that the Accounting Periods in your Inventory Organizations are open, as far back as your earliest receipt date.

Harry Swallow
Consulting Manager
Noblestar Systems Corp.
(703) 641-8511 x 2644
hswallow@noblestar.com


Attribute control setup

Date: Thu, 8 Jul 1999 09:57:49 +300500
From: BPL-UPTRON_Team@india.notes.pwa.co.in
Subject: INV: Rel 11.0 Attribute control setup problem

Hi All,

I am doing Inventory set up on Rel 11.0 and on accessing Attribute Controls set up form I receive an error "query unable to retrieve any records...." and no records are retrieved on this form.

Any clues as to the cause of the problem. We are setting up multi-org.Without multi-org on another instance, we are not facing this problem.

TIA Harpreet


Receiving Unordered items

Date: Wed, 07 Jul 1999 22:53:10 PDT
From: ravi chandran johnny_ravi@hotmail.com
Subject: Receiving Unordered items

Hi!

we are setting up 11.03. We followed the procedures for receiving unordered items and later regularising it. It doesn't work.

Has anyone who has done this let us know the steps??

Thanks Ravi


Items Open Interface - Release 10.7 Character

Date: Tue, 13 Jul 1999 15:24:15 +0100
From: Peter Wolyniec pwolyniec@edenconsulting.co.uk
Subject: Items Open Interface

All,

I've populated a number of fields in MTL_SYSTEM_ITEMS_INTERFACE from a flatfile using SQL*Loader.

I understand the next step is to run a concurrent process to import the items into MTL_SYSTEM_ITEMS.

I know in 10.7 GUI there is a Import Items menu under Inventory and in the reports set also. I'm currently working on 10.7 CHAR and cannot find the equivalent.

Can anyone help?
Pete W.


Date: Tue, 13 Jul 1999 10:26:18 -0400
From: "Cotten, Jim" Jim.Cotten@respironics.com
Subject: RE: Items Open Interface

In inventory - \Navigate\Item|Interface, Type = Report, Report = Import Items


Date: Tue, 13 Jul 1999 10:45:43 -0400
From: Yerraguntla Ravindra -G1447C G1447C@ga25epd.mot.com
Subject: RE: Items Open Interface

Hi

You 've to add the Item interface (SRS) form for the Inventory Module menu in AOL in case of 10.7 CHAR, refer open interface manual how to do that.

HTH
Ravindra Yerraguntla
Consultant
Motorola ESG
770 338 3659(W)



Items costing less than a penny

Date: Tue, 13 Jul 1999 13:27:08 -0500
From: GEN OUSER genouser@mcquay.com
Subject: Cost - Items with value less than a penny

When transacting on items with an individual value (cost) of less than one penny the calculation first rounds the item cost to zero then extends times the quantity ...always resulting in a zero cost transaction.

Does anybody have any successful experience in geting around this?? (The only thing we have thought of is making the cost equal to one cent (.01) - which is not a real attractive one since we have lots of components with small values.

Any advice would be welcome -thanks
Alan Grundei
alan.grundei@mcquay.com


Date: Wed, 14 Jul 1999 09:48:41 +0530
From: "Chitti Babu" cbabu@satyam.net.in
Subject: Re: Cost --- Items with cost value of less than a PENNY

Hi
This may be due to currency precision you are using is two decimals and therefore all costing transactions that need to be interfaced to General Ledger should have only two decimal places. If you are particular about more precision you may need to increase the precision of currency.

Hope this helps
Thanks Chitti


Misc Transaction error

Date: Mon, 13 Apr 1998 14:07:49 +0200
From: aragab a_ragab@tccbce.com
Subject: INV_URGENT??????????????????????MISC_TRANSACTION_ERROR?????

Hi all

when attempting to make a misc. transaction in inventory module I got this error
-----------------------------------------------------------------
APP-01564: ORACLE error 6502 in fdfksr
Cause: fdfksr failed due to ORA-06502: PL/SQL: numeric or value error
ORA-06512: at line 1.
The SQL statement being executed at the time of the error was:
BEGIN FND_FLEX_SERVER.VALIDATE_COMBINATION
( :user_appid, :user_respid,
:userid, :app_sname, :code,
:num, :vdatestr, :vrules,
:data_set, :invoking_mode,
:validate_mode, :dinsert, :qsecurity,
:required, :allow_nulls,
:display_segs, :concat_segs,
:vals_or_ids, :concat_vals_out,
:concat_ids_out, :concat_desc,
:where_clause, :get_extra_cols,
:extra_cols, :get_valatts,
:valatts, :get_derived,
:derived_vals, :start_date,
:end_date, :enabled_flag,
:summary_flag, :seg_delimiter,
:ccid_in, :ccid_out,
:vstatus, :segcodes,
:error_seg,
:message); END; and was executed from the file &ERRFILE.


Date: Wed, 14 Jul 1999 20:07:12 -0400
From: "Paul van den Brink" pbrink1@ibm.net
Subject: Re: INV_URGENT??????????????????????MISC_TRANSACTION_ERROR?????

Try to recompile the System Item flexfield.


Date: Fri, 16 Jul 1999 11:59:46 +0530
From: "Chitti Babu" cbabu@satyam.net.in
Subject: Re: INV_URGENT??????????????????????MISC_TRANSACTION_ERROR?????

Hi
This type of problem may come due to improper configuration of SGA from server side as per my previous experience. If this is working previously then definitely this should be problem. If network is also heavy with traffic this might happen. Please set temporarily profile option Flexfields:Validate On Server to No. This might work. If this works you may need to concentrate on DB setups such as Proper SGA, network configuration etc.

Hope this helps
Thanks
Chitti


Date: Fri, 16 Jul 1999 16:32:53 +0700
From: "Nagamohan U." umohan@irs.co.id
Subject: RE: INV_URGENT??????????????????????MISC_TRANSACTION_ERROR?????

Hi

Do you have a descriptive flexfield in the Misc transactions form? I guess the value set you have attached to one of the segments is giving this error.

If DFF exists please check the value sets.
Regards/Nagamohan


Inventory transfer to GL

Date: Wed, 14 Jul 1999 11:10:18 -0400
From: Kathryn VanScoy kvanscoy@prg.com
Subject: INV: TRANSFER TO GL

Hello,

I am currently testing Rel 11.03 and when I do a misc transaction out of inventory it saves fine. When I transfer to the GL the result is :"download completed" . However, when I run the import from GL it says "NO DATA FOUND."

Any help would be great.
Kathryn VanScoy


Date: Wed, 14 Jul 1999 12:03:42 -0400
From: Harry Swallow harry.swallow@interpath.net
Subject: Re: INV: TRANSFER TO GL

Are you sure the Item has a Cost? If so, has the Cost Manager Concurrent Program run since you committed your transaction? If so, has the transaction been costed (can you see Account Distributions if you look at the transaction, or run a Material Account Distribution Detail Report?) Was the transaction done in an 'Asset' Subinventory?

The problem could be in your setup or the Cost Manager, not in the GL import.

Hope this helps,
Harry Swallow
Noblestar Systems Corp.
(703) 646-4000 x 2644


Creating new items

Date: Fri, 16 Jul 1999 09:18:55 -0400
From: jbuelow@suburban.com
Subject: INV - Creating new items

We are looking for alternatives for creating purchasing/inventory items in Oracle (i.e., mtl_system_items.) Any ideas on the following would be much appreciated:

1) Besides entering the items manually, what solutions are you using for creating items?

2) We currently define the items in a spreadsheet, export them, and run them through the Open Items Interface. However, it appears the interface can't be used to set up any of the following:
- Create cross references (mtl_cross_references)
- Assign items to categories (mtl_item_categories)
- Create manufacturer part numbers (mtl_mfg_part_numbers)
Has anyone developed a "batch" method for creating this information?

3) At the last OAUG conference, one of our users saw a demo of integration between Lotus Notes and Oracle for the creation of items. The items were defined in a Lotus Notes form and then somehow interfaced into Oracle. Anyone familiar with this, and do you know where we could get more information?


Date: Fri, 16 Jul 1999 20:10:42 +0530
From: "Vaibhav Agarwal" vaibhavagarwal@hpcl.co.in
Subject: Re: INV - Creating new items

hi
have you tried entering items by using item template that saves lot of time. classifying items which have more or less item attributes , make a template and copy from there.i think that would reduce your lot of effort and time.


How to handle refurbished parts

Date: Mon, 19 Jul 1999 11:41:39 +0200
From: "Andre Kuerten" akuerten@imation.com
Subject: INV:Refurbished Parts

Hello,

we have parts within our company that we can send back to the Vendor for Refurbishing. Unfortunately is it not possible for the colleagues in the receiving area, which items are included in this program. If they could distinguish, they would be able to sign the parts with labels so that everyone knows what to do with the parts when its broken. Has someone else also parts for refurbishing and how do you handle them? Is there an attribute which we can set to show in the receipt mask whether its an part for refurbishing or not?

Any comment or help would really appreciated.
Thanks in advance Andree
we are using 10.7 SC


Date: Mon, 19 Jul 1999 06:42:24 -0700 (PDT)
From: Ravi Krishnamurthy ravi_krishna@rocketmail.com
Subject: Re: INV:Refurbished Parts

Andre,

I guess the simplest solution would be to add the word 'Refurbished' to the description.

HTH. Ravi K.


Date: Wed, 21 Jul 1999 08:45:25 -0500
From: "Shockey, David" DShockey@jwrinc.com
Subject: RE: Refurbished Parts

We do the same sort of thing. We carry both new and refurbished parts in our inventory that are otherwise identical. The part number for each is the same except that the refurbished part has an R on the end (a suffix). We have set up a flexfield titled "Rebuildable". Any part in our inventory that can be refurbished has a Y in that flexfield. We report off of that flexfield to prompt people for the rebuildable core when the item is replaced.