Subinventory Account change Query 1
Date: Thu, 26 Aug 1999 13:16:00 -0700
From: Todd Manley tmanley@zilog.com
Subject: INV: Subinventory Accounting Change
Hello-
I'm trying to change the material account for several subinventories. The
setup form will not allow me to update this account. Is there any way that
I can update the material account for a subinventory that's been used for
several months? Can it be done through the application? Can this setup
even be changed?
Any help is appreciated.
-Thanks, Todd
Todd Manley
ZiLOG
408.558.8962
tmanley@zilog.com
Date: Thu, 26 Aug 1999 13:32:12 PDT
From: "Prasanna Kumar Jena" pk_jena@hotmail.com
Subject: Re: INV: Subinventory Accounting Change
Hi
Is your Organization using Average Costing? If yes, then SubInventory
accounts will be the same as Organization accounts, except the expense
account.
In Standard Costing organization, SubInventory accounts can be different
from the Organization accounts.
Prasanna Jena
KAY Software Inc.,
Silicon Valley
Date: Thu, 26 Aug 1999 16:39:35 -0400
From: "McShane, Chris" Chris.McShane@glenayre.com
Subject: RE: Subinventory Accounting Change
I'm not sure but if you zero out the quantity on hand you should be able to
the account information associated with . Then transfer the quantity back
in.
Date: Thu, 26 Aug 1999 14:40:05 -0700 (PDT)
From: Jay Patel-ERP Consultant jpmrp@yahoo.com
Subject: Re: INV: Subinventory Accounting Change
Todd,
Even under the conditions where you can change the subinventory
accounts, you need to make sure there is no on hand inventory,
typically you would have to transfer out the inventory (to another
subinventory), change the account and transfer the inventory back.
Jay
Date: Fri, 27 Aug 1999 09:43:41 +0200
From: Clive Calder CliveC@langeberg.co.za
Subject: RE: Subinventory Accounting Change
In 10.7 NCA Standard Costing you cannot change the account while inventory
balances are on hand. Your best plan is to zero the stock (a stock take
adj. is a quick way to do it) you can change the GL account allocation and
then bring the stock back into the subinventory using a misc. receipt.
Doing it this way removes the balance from the old GL account and brings the
balance into the new GL account.
I have done this previously and it does work. Do not change the account
numbers in the tables as you GL will no longer balance your inventory
module.
Clive Calder
Date: Fri, 27 Aug 1999 09:37:09 GMT
From: "Ananth Swaminath" ananth999@hotmail.com
Subject: Reply: INV: Subinventory Accounting Change
Hi Todd
In an organisation following Average Costing, the inventory valuation
accounts are controlled at the apex - the organisation. Hence changes at the
subinventory level would be redundant.
In case you follow the standard costing method, what you could do is this:
- Perform a physical count to zero out quantities. Adjust the valuation
account for the subinventory.
- Bring back the items into subinventory through a Misc. Receipt.
You will notice that the books will balance and inventory continues to be
reconciled with GL.
Any changes you make at the database level will leave you with unreconciled
balances between Inventory and GL. So do exercise caution prior to adopting
this approach.
The advantage of zero(ing) balances in the old sub-inventory and bringing
them back in with updated valuation accounts ensures that you retain the
fabric of intergration throughout the system.
Hope this helps
Ananth
Senior Applications Consultant
Date: Fri, 27 Aug 1999 05:47:42 PDT
From: "DASARI SUBRAHMANYAM" srdasari@hotmail.com
Subject: Re: Reply: INV: Subinventory Accounting Change
Hi Todd,
I am sure solution suggested for zeroing out the onhand qty. from the
subinventory and receiving them back after changing the account through
miscellaneous receipt, is foolproof and a standard practice.
In my case, there were no. of subinventories with no. of items in hand.
While zeroing out may not by a problem through physical count, i faced
constraint of no. of miscellaneous receipts. THis has driven me to change
the code_combination_id for the subinventories table and it worked fine to
me. I made sure there are no transactions in trnasaction temp tables. For
the inventory balances to agree with the account balances in GL, we passed a
manual journal entry transfering the existing balance in the old account to
the new account.
As i stated earlier, the first solution is a perfect solution since
application takes care of all the validations. U may adopt the second one
only when it is not manageable to enter miscallaneous receipts, but with
utmost care testing in a test instance.
bye
dasari
Date: Fri, 27 Aug 1999 10:03:31 EDT
From: "Raj P" raj_orapps@hotmail.com
Cc: tmanley@zilog.com
Subject: RE: Subinventory Accounting Change
Hi
I AM ABLE TO CHANGE ACCOUNT NUMBERS IN SUBINVENTORY ---MY APPLICATION
VERSION IS 107 AND ORG SETUP UNDER STANDARD COSTING.
IF U WANT TO CHANGE UR SUBINVENTORY ACCOUNT NUMBER UNDER THE ABOVE
CIRCUMSTANCES, U CAN DO AND THAT SHOULD NOT POSE ANY PROBLEM EVEN IF U HAVE
ON-HAND QUANTITY.
IN CASE U WANT TO MAINTAIN SAME SUBINEVNTORY NAME BUT WITH DIFFERENT
SUBINVENTORY ACCOUNTS,
RENAME UR EXISTING SUBINVENTORY NAME.
1. GOTO SUBINVENTORY NAME
2. GOTO TOOLSTRACE
3. CHANGE INTO NEW SUBINVENTORY NAME
4. OPTIONALLY INACTIVATE THIS SUBINVENTORY.
CREATE NEW SUBINVENTORY BY OLD NAME AND ASSIGN UR NEW ACCOUNTING
INFORMATION...
THIS WILL HELP U IF U WANT TO MAINTAIN THE SAME INVENTORY NAME BUT WITH NEW
SUBINVENTORY ACCOUNTS..
TO HAVE UR ON-HAND QUANTITY IN NEWLY CREATED SUBINVENTORY YOU CAN
DO SUBINVENTORY TRANSFER EITHER PROGRAMMATICALLY OR MANUALLY,
Rajagopalan,Panchat
Kay Software
The Robbins Company
Date: Fri, 27 Aug 1999 20:07:28 GMT
From: "Ananth Swaminath" ananth999@hotmail.com
Subject: Reply: Subinventory Accounting Change
Raj:
Have you tried to reconcile balances with GL? Please do so and let us know
your results.
Just a point - Tools | Trace does NOT allow the change you are referring to.
I think it is Tools | Examine.
Changes at the levels you are suggesting, may not actually conduct a bullet
proof validation through the system. And the entire purpose of the effort is
to ensure this. Further, GL reconciliation at period end will land up being
a major nag in case one were to follow your method.
However, this is just an opinion. And as such all of us have one!!
Cheers
Ananth
Senior Applications Consultant
Date: Fri, 27 Aug 1999 16:38:16 EDT
From: "Raj P" raj_orapps@hotmail.com
Subject: Re: Reply: Subinventory Accounting Change
HI ANANTH
YOU ARE RIGHT,
IN FACT I AM CHECKING THE IMPACT ON GL.... B'CAUSE WE HAVE THE SAME ISSUE IN
OUR CLIENT, BUT IT IS SOMETHING DIFFERENT FROM THE TODD REQUIREMEENT..
WE WANT TO KEEP THE SAME INVENTORY NAME AND NOT ON HAND QUANTITIES.
WHILE DOING THIS TEST, I HAPPENED TO SEE THAT ON-HAND QUANTITIES AND OTHER
RELEVENT DETAILS ARE AVAILABLE IN NEW SUBINVENTORY SINCE THE NAMES ARE SAME
EVEN THOUGH ACCOUNTING VALUES ARE DIFFERENT.
SO I AM CHECKING ON MY PART WHAT WOULD BE THE IMPACT ON GL. IF THIS WORKS,
TODD NEED NOT DO ON-HAND CONVERSION.
Rajagopalan,Panchat
Kay Software
The Robbins Company
Subinventory info not defaulting to Ship Confirm
Date: Fri, 27 Aug 1999 09:28:21 -0400
From: "Annette Anost" aanost@goodegg.com
To: "Oracle OE Listserver" ORACLE_OE_SIG@GI.COM,
Subject: OE/IN: Subinventory Info not defaulting
I am trying to "ship confirm" at the delivery level in release 11.03 and
the problem I am encountering is that the "details required" box is checked
due to the fact that the subinventory is a required field.
I've looked at the following requirements and there seems to be a step
missing. Please help!!!
- Inventory item has no lot control or serial control.
- Item has a subinventory assigned to it under "Item subinventories"
- Subinventory information does not default on the sales order but even
when entered, this information does not default on the ship
confirm screen
I've logged a TAR with Oracle but no response at this time. Thanks in
advance for your responses.
Annette Anost
aanost@goodegg.com
Date: Fri, 27 Aug 1999 10:40:07 -0700 (PDT)
From: Jay Patel-ERP Consultant jpmrp@yahoo.com
Subject: Re: OE/IN: Subinventory Info not defaulting
Annette,
We are on 10.7 so not sure if this is your problem. Is the item
reservable, and what is your picking rule setup as ?
Jay
Cost update program - effect on mtl_material_transactions
Date: Fri, 27 Aug 1999 10:27:14 PDT
From: "DASARI SUBRAHMANYAM" srdasari@hotmail.com
Subject: **URGENT**-cost update program changes
Hi,
Can any one tell me for which lines in mtl_material_transactions, Cost
update program creates adjusting costing lines.
In my case a shipping transaction has taken place on 4th August 99 and a
line is inserted in mtl_material_transactions with the cost existing on 4th
Augutst 99. Subsequently, a cost updating took place on 19th august. the
original value was replaced with the new cost and another line was created
in mtl_material_transactions with 'cost_update' as the transaction action.
Can any one explain which transactions get updated when cost updating takes
place and if there is a way to go the the source transaction of the cost
update transaction in mtl_material_transactions.
dasari
Date: Fri, 27 Aug 1999 13:43:22 -0400
From: cshay@csc.com
Subject: Re: **URGENT**-cost update program changes
No transactions get updated. The cost update creates additonal transactions
to
the mtl_material_transactions and mtl_transaction_accounts tables.
Transactions
get created for all inventory on hand, including what has been issued to
WIP. I
don;t remember the number for the transaction_type_id for cost updates, but
if
you look at all the transactions with this id, then you can isolate them.
fdfcmp error with Patchset C
Date: Fri, 27 Aug 1999 14:20:39 -0700 (PDT)
From: Mark Myszkowski myszko@yahoo.com
Subject: fdfcmp error
I was applying inventory patch set c. The patch got to the last line
in the driver and was running fdfcmp when it got the following error:
Descriptive Flexfield-$SRS$.INCMMX_CUSTOM
Compilation aborted ...
APP-01630 SETUP_DESCR_VSETS: Error detected when attempting to load
value sets
Previous Messages (for Support Purposes)
APP-01361 Please register your concurrent program executable fdfcmp.exe
with App
APP-01381 Program name differs from executable name or program not
registered
APP-01168 Concurrent program associated with invalid application
information
APP-01875 The value set assigned to Restock segment does not exist.
APP-01551 FDFAVS: Detected a data error.
Continuing....
Descriptive Flexfield-$SRS$.INCOIN
Any suggestions about where to start troubleshooting?
TIA
===
Mark Myszkowski
Entre Computer Center
Brookfield, WI USA
(414) 938-2139 x3129
(414) 938-2155 (fax)
Inventory Periods - error in closing
Date: Mon, 30 Aug 1999 06:18:27 -0700 (PDT)
From: suroma suroma@rocketmail.com
To: oraapps-l@cpa.qc.ca
Subject: are there any Inventory Gurus ?
Hi,
I have problem in closing inventory periods,
because some items are pending.
there is no error displaying and i want to know the
reason. any one can help ?
please email your answers to suroma@rocketmail.com
thanks
suroma
Date: Mon, 30 Aug 1999 15:46:40 +0200
From: "Andre Kuerten" akuerten@imation.com
To: oraapps-l@cpa.qc.ca
Subject: Re: are there any Inventory Gurus ?
What does it mean, pending?
Have you checked the Transaction Open Interface?
There you should find the reason for the pending item.
Otherwise give me more specified informations.
Andree
Date: Mon, 30 Aug 1999 10:47:26 -0400
From: "Finney, Jack" jack.finney@glenayre.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: are there any Inventory Gurus ?
There may not be anything wrong with the item. In the 'Pending Transaction'
form, try checking the resubmit check box to the left of the line (10.7 SC)
and save the form, you can also choose 'resubmit all' from the Special menu
option. If this doesn't work have your DBA kill and restart the Inventory
managers.
Jack Finney
Date: Mon, 30 Aug 99 10:15:14 -0800
From: cwright@guthy-renker.com
To: oraapps-l@cpa.qc.ca
Subject: Re[2]: are there any Inventory Gurus ?
One error in a batch will cause the entire batch to error out. The
instructions below (above) are good except for one more point. If your have
multiple inventory organizations you should Change Organization for
each different organization your data represents before resubmitting
it. The record with an Error Description is the one with the problem.
Date: Mon, 30 Aug 1999 15:52:04 +0100
From: alexandre.gravelin@degremont.com
To: oraapps-l@cpa.qc.ca
Subject: =?ISO-8859-1?Q?R=E9f._:_are_there_any_Inventory_Gurus_=3F?=
Have you check the Transaction Interface Transactions (Transaction/ Open
Interface)
If some transactions are in error you should be eable to sea, modify and
resubmit these transactions
Hope this helps
Alexandre GRAVELIN
France
Date: Wed, 1 Sep 1999 06:42:25 -0700
From: CFowler@littonapd.com
To: oraapps-l@cpa.qc.ca
Subject: RE: are there any Inventory Gurus ?
Hi,
There are 3 types of "pending" transactions that MUST be cleared before you
can close your inventory period:
1. Unprocessed Material
2. Uncosted Material
3. Pending WIP Costing
Item #1 - go to Inventory:Transactions:Pending Transactions for each
inventory organization to see the transactions.
Item # 2 - go to sqlplus:
select inventory_item_id
from mtl_material_transactions
where the costed_flag in ('E','N')
You will need to refine the above for things like transaction_date,
organization_id, etc. to narrow down the scope.
Item # 3: go Work In Process:Resource Transactions:Pending Resource
Transactions for each inventory organization to see the transactions.
In addition to the above 3 types of "pending" transactions you should also
check for the following:
1. Pending Receiving
2. Pending Material
3. Pending Shop Floor Move
You will be able to close your inventory periods even if you don't clear
these 3 types of "pending" transactions, but if you close the inventory
period first you will not be able to process these transactions as they will
then have transaction dates in closed period.
I hope this helps.
BTW - we are 10.7 16.1SC environment.
Conversion of items - error during
Date: Mon, 30 Aug 1999 20:16:39 -0000
From: "Janik Thorez" jthorez@paramconsult.com
To: oraapps-l@cpa.qc.ca
Subject: Error message during conversion of items
Hello there,
Does anybody know this error message or problem. We are doing a conversion.
OPEN INTERF MSG: -1 INVPOPIF: Error in ASSIGN phase; Please check
mtl_interface_errors table
Best regards,
Janik Thorez.
Param Consult BV.
Date: Mon, 30 Aug 1999 18:06:42 EDT
From: "Raj P" raj_orapps@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Error message during conversion of items
attach the latest patch set..
Subinventory Accounts Change Query 2
Date: Tue, 31 Aug 1999 07:45:28 -0400
From: "McEntee, Thomas M." McEnTM@jea.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: INV: Subinventory Accounting Change
Has anyone changed all of the Inventory accounts at the organizational level
not just at the Subinventory level?
We have 80,000 items with inventory on hand. I thought about issuing all
material out via the Open Transaction Interface MTL_TRANSACTIONS_INTERFACE
table, make my account changes and then re-populate the
MTL_TRANSACTIONS_INTERFACE with the receipts to adjust the on hand
inventories back to normal.
What problems did open PO's, AP, Projects etc. cause?
I have been challenged by our accounting people to solve this problem.
Any experiences encountered would be appreciated,
Thomas McEntee
Senior Systems Analyst
JEA(Jacksonville Electric Authority)
mcentm@jea.com
Date: Tue, 31 Aug 1999 21:16:38 MYT-8
From: philip@aleytys.pc.my
To: "McEntee, Thomas M." McEnTM@jea.com, oraapps-l@cpa.qc.ca
Subject: RE: INV: Subinventory Accounting Change
Hi!
I'm very new to 10.7SC and I was facing some problems with the material
accounts at the subinventory level. We are using average costing but our
accountants want/need some of our subinventories to have different
material accounts. This was working in 9.4 but apparently 10.7 SC
doesn't allow this.
My work around was to write a SQL script that went through all the
MTL_TRANSACTION_ACCOUNTS, I linked back to MTL_SECONDARY_INVENTORIES via
MTL_MATERIAL_TRANSACTIONS to get the material account and then I updated
the reference_account column in all the rows in transactions_accounts
where the transaction_line_type was = 1 (Inventory/Material).
The end of month reports and inventory value reports all seem to be OK.
Of course this is not supported by Oracle. Can anyone with more
experience tell me if this is workable or am I heading up the creek
without a paddle?
Ta!
Philip
Item interface - Inventory_Item_Id not found
Date: Tue, 31 Aug 1999 09:08:00 -0500
From: Akkineni_Prakash Akkineni_Prakash@videojet.com
To: oraapps-l@cpa.qc.ca
Subject: Inventory : Item Interface
Hi All!
I've been trying to import items by running the "Import Items"
program. I inserted the recommended minimum information into the item
interface table with a process flag of 1 and ran the program for
loading the items into the Master Org. I also made sure that all the
setups exist for the default values to be derived into the interface
table for validation.(Organization Parameters, Puchasing
Parameters,Receiving parameters....as per Oracle Support)
I keep getting this error :
"You have specified an Inventory_Item_Id that is not found in
MTL_SYSTEM_ITEMS.New items automatically have an Inventory_Item_Id
assigned and this field need not be specified."
I did not give it an inventory_item_id. To make sure i deleted the
inventory_item_id and ran the program again and it gave me the same
error. In both the cases, when i requeried the information the
interface table, it had an inventory_item_id.
Any suggestions!!!???
We are on 10.7.0 SC161 (character). Rdbms 7.3.4
Thanks.
Best Regards.
Prakash Akkineni
Date: Tue, 31 Aug 1999 23:17:11 MYT-8
From: philip@aleytys.pc.my
To: Akkineni_Prakash Akkineni_Prakash@videojet.com, oraapps-l@cpa.qc.ca
Subject: Re: Inventory : Item Interface
I had to get some patches from Support before Item import would work
reliably for me.
Philip
Inv Org diff from Cost Org
Date: Tue, 31 Aug 1999 13:51:49 PDT
From: "Liqun Wang" liqun_wang@hotmail.com
To: oraapps-L@cpa.qc.ca
Subject: How to define different Item Master Organization and Costing
Organization
Hi all,
When I define a new organization,I hope Costing Org is the organization
itself, not Item Master Org, but I can't do that,Costing Org is alwayse the
same as Item Master Org.How to do with that?
Thanks,
Lynn
Date: Tue, 31 Aug 1999 17:10:00 -0400
From: "Arul, Muragan x1326" MARUL@genicom.com
To: Liqun Wang liqun_wang@hotmail.com,
Subject: RE: How to define different Item Master Organization and Costing
Lynn,
You can either choose to share the cost in all the organization from item
master or you can maintain the cost at the individual organization level.
Once you have defined any inventory org with its own org as the costing
organization , oracle will not aloow you to choose the item master as the
costing organization.
I think you are facing this problem.
Thanks,
Arul Murugan CPIM,
Manufacturing Consultant
Date: Wed, 1 Sep 1999 10:27:00 +0100
From: alexandre.gravelin@degremont.com
To: liqun_wang@hotmail.com
Cc: oraapps-l@cpa.qc.ca
Subject:
=?ISO-8859-1?Q?R=E9f._:_How_to_define_different_Item_Master_Organization_and_Costing_Organization?=
If you want Oracle to alow you to define each organization as it's own costing
org, you have prevously to setup the item attribute control at "org level"
for the "Costing enabled" attribute
After that you should be able to choose something else taht the master
org as costing organization
Hope this helps
Alexandre GRAVELIN
FRANCE
Date: Wed, 01 Sep 1999 09:34:16 -0400
From: Harry Swallow harry.swallow@interpath.net
To: oraapps-l@cpa.qc.ca
Subject: Re: Réf. : How to define different Item Master Organization and
Costing Organization
Yes, and also make sure your Default Cost Category is controlled at the Org
Level.
Harry Swallow
Noblestar Systems Corp.
(703) 464-4000 x 2644
hswallow@noblestar.com
http://www.noblestar.com
STEPS for Successfully Loading Items Using IOI
Date: Wed, 1 Sep 1999 08:00:15 -0500
From: "Veach, L. Vincent" VeachLV@bvsg.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Inventory : Item Interface
Is been a while since I worked with the Inventory Item Interface but I have
a document that might help you.
Please click here for IOI steps.txt
Date: Wed, 1 Sep 1999 08:27:38 -0500
From: Kim Bauman kbauman@midcom-inc.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Inventory : Item Interface
This patch is supposed to fix many things. I have attached the readme file
that details what the patch does.
Please click here for details on Patch 892049
Thanks
Kim Bauman
Oracle HD Coordinator
ANZA, Inc.
Kbauman@anza.com
Categories and Org - assign when loading
Date: Thu, 02 Sep 1999 07:52:50 GMT
From: "GopalaKrishna Surapaneni" srisri47@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Inv: Categories and Organisation Assignments
Hi All,
I would like to know if it is possible to assign categories and
organisations to items at the time of loading. Around 50,000 items are being
imported and they have to be assigned to 9 organisations. Can this be
automated.
Thanks
Gopal
Date: Thu, 2 Sep 1999 07:38:56 -0500
From: "MCAVOY, Brian J." bmcavoy@shl.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Categories and Organisation Assignments
You can assign items to organizations when loading, first load the master
and then during a second pass through the item interface assign those items
to any other organizations you want. Items automatically get assigned to
the default category, you'll need to write an additional program to update
the item with the correct category either during or after loading.
I'm assuming you're on 10.7 or below, haven't used this in R11.
Brian McAvoy
Consultant
EDS
Client phone # 973-491-8614
Email bmcavoy@shl.com
Date: Thu, 2 Sep 1999 21:07:01 MYT-8
From: philip@aleytys.pc.my
To: "GopalaKrishna Surapaneni" srisri47@hotmail.com, oraapps-l@cpa.qc.ca
Subject: Re: Inv: Categories and Organisation Assignments
I have loaded 23K items into two inventory orgs. As far as I can tell,
instead of having to click on the special-assign 23 thousand times the
only other way is to load all the items into each organization via the
open item interface, so if you have 9 organizations you have to bring in
your 50K items nine times each time specifying a different ORG_ID.
I think I posted a script to this forum some time back on how to fiddle
with the categories after importing the items.
Philip
Philip Chee: Tasek Corporation Bhd, P.O.Box 254, 30908 Ipoh, MALAYSIA
Date: Fri, 03 Sep 1999 02:15:47 PDT
From: "ravi chandran" johnny_ravi@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Inv: Categories and Organisation Assignments
gopal,
We have done this in our implementation and it is prudent to do
that since it is will be a herculean task to manually assign category and
org to 50000 items
Ravi
Date: Fri, 3 Sep 1999 11:27:00 +0200
From: Gorre Richard GorreR@fnherstal.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Inv: Categories and Organisation Assignments
Gopal
I know my collegues in US did perform a automatic update. I suppose using
the item interface.
I remember to do that you must provide the Oracle cat combination number and
not the cat values.
Richard Gorr
Tel 32 4 240 88 37
Date: Sun, 05 Sep 1999 23:50:26 PDT
From: "shawish sababa" shawish_sababa@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Inv: Categories and Organisation Assignments
Hi Gopal
the only way to assign categories to items at the time of loading is by
insert/update to MTL_ITEM_CATEGORIES. i have done this for 3 customers how
are live and running. if you need any help feel free to contact me.
shawish