E1 Tools Release 9.1.5 Purchase Order Item Number Locks on J Type Line

SteveLee

Member
Hello, We are currently upgrading from E1 8.1 tools release 6.2 , to E1 Tools Release 9.1.5

Entering a Purchase Order OP (entry by G/L account number) J type Line - Interface A G/L offset NS40 Non Inventory

The new release 9.1.5 after entering a Purchase Order Line the Item Number "Locks" ? and unable to edit or correct even though the Purchase Order is Open ( This is a Non Inventory item ) and just a general Purchase Order that does not validate against the item master

The original E1 8.1 tools release 6.2 was OK and able to edit or correct the Item Number whilst the PO was open, and would only lock after vouchering and not before.

This is the last issue to be resolved before going live, is this a setting ?, or can the Item Number be simply unlocked ? while the PO is open.

Thanks
 
"J" lines are non-inventory lines, and the Item Number field can only be entered when you first create the line. You cannot go back in and change this value. I just verified this in our 9.0/Tools 9.1.4.4 system. For the record, I couldn't change the item number on either "B" or "S" lines, either. Usually we'd just have our buyers cancel the line with the incorrect item number and re-enter with the correct item number value.
 
Thanks, Yes this is the same response as Oracle, we purchase many one (1) off items and require the Item Number to be edited or corrected prior to vouchering, do you know of any work around or modifications, ? or using another line type ? our current E1 8.1 tools release 6.2 works OK and the Item number does not lock and can be edited prior to vouchering , cancelling lines allows wrong Item Number to remain in E1 which is not desirable , I understand why a B and S line locks because theses are validated against the item master, and see no reason why you would want a J type line should lock prior to vouchering all other filed are editable ?

Thanks
 
Thanks , Our previous version allow this field to be edit or corrected while the PO was open, and locked after vouchering, this has worked seamlessly for 10 years, do you know of any work around ?, or set up that allows the edit of this field, B and S type validate against the Item Master which is understandable , can we use the N type line and configure to interface : A G/L account costing ? Thanks
 
You're going against how Oracle has written JDE to behave, so you'll most likely have to put a custom modification into place to accomplish what you want. Also, as far as cancelling lines go, any reporting or queries we use against historical almost always exclude PO lines with last status of 980, which indicates the line was cancelled. So while the record is still there, it is ignored for all intents and purposes.

If you do a custom mod, be sure to test it thoroughly, and be aware that Oracle support may balk if you call for support on any custom modified object.
 
Back
Top