field size change

[Leafs]

I have been asked the question below by our lead financial application analyst. Was hoping someone could tell if paragrapgh number 2 is "doable" and is a developer required or are the steps well documented in any of the manuals and could be implemented by a technical resource?

Thank-You.

Is it possible to set the length of a field (ie. order number) to a
larger size? Field is currently 10 bytes, need it to be 15 as we would likely want to bring the order down using the long order number to present on the invoice.

I have identified a User reserved code in the SOH & SOD tables F4201 & F4211 respectively that is a 15character string field. I believe this to be the best solution as it doesn't involve combining fields. Do you know how to activate this field for use in the SO processing function. We will obviously need to get data to the field (Manually at first) The field is
SHURRF and SDURRF.

 

[got_to_love_jde]

Leafs,
You will need to have a OW specialist come in to evaluate your needs. If it only requires adding a field to a screen that already exists (ie. you need to untilize a field to be able to cross reference to other systems) in the order files this MAY BE a 'smaller' change but this will still require training.
If you want to modify how OW works in general (what field it uses to enter, look up, track, pass information to G/L & A/R, etc....) you need a HUGE, HUGE change.
I don't believe this is something you want to attempt by yourself in either case.
Good Luck,
Dave

 

[shazbot]

I agree Dave - changing an order number field from 10 to 15? How many tables would be involved in that? It'd be a huge change to the database and all applications using those tables plus reports, etc. Just the thought of what would be involved in upgrades would turn me off it!

If it's a field that's already being utilized (or one that's available to use, but you haven't started using yet), and you just want to show a "reference" number on the invoice and have no other links anywhere else in the system, you may only need to worry about changing the invoice print to show that field instead of the current order number (or in addition to) - still a change required, but a much smaller effect on the system overall.

Sharon

 

[Carl_Fisher]

As you can see changing the JDE assigned order number is not an easy solution.

Where does your long order number come from? Do you mean Customer Purchase Order? This is alrady on the Sales Order Screen and can carry forward to the Invoice.

There are a number of Text / Reference fields which already appear on the Order Entry screen you could use.

Look for the simple solution - if it is just a number which needs to appear on the Invoice then find a solution where you just have to change the Invoice Print Program, at worst do a look up on the Order table.

 

[misaelg]

Guys I just couldn't agree more with you, that change would imply so many things that you better back off the whole idea and forget anyone mention something similar. The overall impact and collateral changes required make this task not impossible but TOO DEMANDING! better work around an already supplied comment on modifying the invoice print program and have an additional field added to the Orders table, just for reference.

Misael
XE / SQL 2000 / W2K / Citrix