Chaging Items' Primary Location

Chaging Items\' Primary Location

Hi All,

I'm looking at using SQL to change the Primary Location of numerous items, simply by changing the Item Location's record, "PBIN" data element from "P" to "S" for one Location and then from "S" to "P" for another Location, in the Item Location File, F41021. After some analysis, the only implication I can see by doing this through SQL, versus base JDE functionality, is that any PO related quantities would not be reflected in the new Primary Location in the F41021. I do not feel this is a large issue.

Has anyone performed a mass change of their Items' Primary Location through:

1. SQL, or
2. Custom JDE Program

Are there are other issues that I may be overlooking?

Re: Chaging Items\' Primary Location

Keep in mind your Open Sales Order and Purchase Orders. Ideally you would be best to update the locations on these as well and then run the Re-post programs to rebuild the Open PO and Commitments on the F41021.

Re: Chaging Items\' Primary Location

Along with keeping in mind updating sales orders and purchase orders, let's not forget work orders... you don't want to cause problems there either.