parora
Well Known Member
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?
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?