You’re offline. This is a read only version of the page.
267
We have imported SQL the BOM Header BM010415 and BOM detail BM010115 and the Routing Master RT010001 and Routing Detail RT010130 tables
My concern is Noteindex fields (the BOM tables do not appear to have the typical Noteindex field, however BM010115 has a Mfgnoteindex2_I that appears to get updated when a record is added through the GP interface. What table holds the next index number for the mfgnoteindex?
the routing tables both have noteindex fields but they do look to be updated when records are added through GP. Do we need to update these with our import?
Thanks in advance for any assistance
-Len
Hello Len,
My name is Becky, and I will assist you.
You do not need to update the MFG notes column when you are importing in routings or BOM information.
The Manufacturing module has its own note system that is separate from GP.
With Routing Notes there are three tables involved.
RT010130 - Routing Line, this is the note attached to the routing (MFGNOTEINDEX_I)
MN010000 - Manufacturing notes, contains the actual note (NOTEINDX)
MNH10000 - Manufacturing Notes next index, tracks the next note index for manufacturing notes (MFGNOTEINDEX_I)
The mfgnote index columns in these tables must match the NOTEINDX column in the MN010000 (Manufacturing Notes Master) for the system to locate the correct note for each location.
Share
Report
All responses (
Answers (
