Item / ItemDynamic Help

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.

Reply to
Luminox
Loading thread data ...

Reply to
Ahmed Nashat

Reply to
Luminox

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

Reply to
Todd

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:

Reply to
Brian McCarthy

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>(

Reply to
Frederic Hurlet

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

Thank you.

"Ahmed Nashat" wrote:

Reply to
KS Computer

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

Mannan

"Brian_McCarthy" wrote:

Reply to
mana

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

Reply to
Joeylegendssports

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.