Item / ItemDynamic Help

May 05, 2007 8 Replies

We are running HQ and SO 1.3r. We have an "outside" application that has loaded some items into the HQ database. However, the programmer failed to load the corresponding ItemDynamic entries. Can someone provide me with a SQL program that will search through the ITEM table and add the appropriate ITEMDYNAMIC entries for each of our stores? So, far - no inventory has been received for these items but they soon will be and then this problem will only be compounded. Your SQL expert assistance is requested.



Thank you ... in advance.



You could also get in touch with Retail Realm...they have a small application called 'Item Dynamic Fix that will do this for you...it very handy for handling items imported into HQ...

Regards, Todd NitroSell

Hi Ahmed,

I am having the same issue as the above person. I would be very grateful if you could provide me with the same SQL query.

Regards,

Brian

"Ahmed Nashat" wrote:

Hi Brian,

I believe the attached document entitled "How to insert missing item records that are not included in the Item Dynamic table in Microsoft Dynamics Retail Management System Headquarters" will help.

Frederic

begin 666 insert missing item records.pdf M)5!$1BTQ+C0-)>+CS],-"C$Y(# @;V)J(#P\+TQI;F5A._?L4_8**H,XE2)7D,12QND3Q$I8/=?V6&+AVQZ#7$19/K7^"'[N\)$] M&OHDZFM#(X-D9H.0?V.66UFQ],D3I&_/$3XNQ MXNBY M[C7.]U9_DJ5I*2&][?,8]X""*+J@5DM!I!XW''+W4)EL&4KYBE!VC98P0%I6 M=/T+B:$28FOS^!5S;+2*9^UICV'T7"PAFYGTGV[@-$1P0P3TU?>VW':[5BQC2@/(5* F48]4X^047L)%(2HR5?CVP(1\ ML&"5%6A:> 9QAB8MA4+&JR-G`W:#6OM@.%K3T0&J[LXNSDX"K*0+IT)&>;PT MIG%^>WUINCP(W]Z399N_\B!>.Y/OV56FQ!&@E2S1>(

Could you please send me the file as well as I am having the same issue.

Thank you.

"Ahmed Nashat" wrote:

I have the same issue. can someone please send me this file and help me.

Mannan

"Brian_McCarthy" wrote:

I am having the same issue. May I please have the same file that was attached to the original post? Thanks in advance

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required