|
Posted by Nashat on October 13, 2006, 8:48 am
Please log in for more thread options Naveed,
find attached a script to insert the missing items into ItemDynamic table,
please BACKUP FIRST
Nashat
> Dear Glenn Adams
> You are right I have seen in item property there is nothing in store
> quantity tab(showing Blank).but i can make this transfer from store
> operations.
> What should i do for this problem to resolve.
>
> Regards,
> Naveed
>
> "Glenn Adams [MVP - Retail Mgmt]" wrote:
>
>> I think you might have a problem where the items do not exist in
>> ItemDynamic for one of the stores. In HQ Manager, open the item
>> properties and look at the Store Quantity tab - does the display look
>> normal?
>>
>> If this ends up being your issue, Retail Realm has a fix for this -
>> http://www.retailrealm.us
>>
>>
>>
>> Glenn Adams
>> Tiber Creek Consulting
>> http://www.tibercreek.com
>> glenn@tibercreek.com
>> ----------------------------------------------
>> Please DO NOT respond to me directly but post all responses here in the
>> newsgroup so that all can share the information.
>>
>>
>> Nashat wrote:
>> > Did u ever import items in HQ instead of adding them from HQ Manager?
>> > i faced this problem in a testing database in which i imported some
>> > items
>> > from excel, the problem was corrected when i re-import the items being
>> > more
>> > careful, but unfortunately, i don't remember the trick!
>> >
>> > u might "SELECT * FORM Item WHERE ItemLookupCode='x' or
>> > ItemLookupCode='Z'"
>> > where x is an item that added normally, and 'y' isn't added
>> > then compare the 2 records trying to catch what is different
>> >
>> > Nashat
>> >
>> >> I am facing a very strange problem while creating transfer from HQ.
>> >> When we
>> >> try to add items manually in transfer, it does not allow adding with a
>> >> message Unable to add items. This is happening with some items not
>> >> with
>> >> all
>> >> but these items could easily be added in POs and we have received a
>> >> lot of
>> >> stock of these items and now needs to me transfer to other store.
>> >>
>> >> Any idea about this problem?
>> >> regards,
>> >> Naveed
>> >
>> >
>>
begin 666 Correct ItemDynamic.sql
M9&5C;&%R92! 4W1O<F5)1"!I;G0-"F1E8VQA<F4@0$ET96U)1"!I;G0-"@T*
M1$5#3$%212!)=&5M7T-U<G-O<B!#55)33U(@1D]2#0IS96QE8W0@9&ES=&EN
M(&ET96TN:60]:71E;6ED('=H97)E(&ET96UI9"!I<R!N=6QL#0H-"F]P96X@
M:71E;5]C=7)S;W(-"D9%5$-(($Y%6%0@1E)/32!I=&5M7V-U<G-O<@T*:6YT
M;R! 271E;4E$#0I72$E,12! 0$9%5$-(7U-405154R ](# -"D)%1TE.#0H)
M1$5#3$%212!3=&]R95]#=7)S;W(@0U524T]2($9/4@T*"5-%3$5#5"!I9 T*
M"4923TT@<W1O<F4-"@D-"@E/4$5.(%-T;W)E7T-U<G-O<@T*"49%5$-(($Y%
M6%0@1E)/32!3=&]R95]#=7)S;W(-"@EI;G1O($!3=&]R94E$#0H)5TA)3$4@
M0$!&151#2%]35$%455,@/2 P#0H)0D5'24X-"@D):6YS97)T(&EN=&@:71E
M;61Y;F%M:6,H:71E;6ED+%-T;W)E240L<75A;G1I='EC;VUM:71T960L<75A
M;G1I='DL4F5O<F1E<E!O:6YT+%)E<W1O8VM,979E;"Q3;F%P4VAO=%%U86YT
M:71Y+%-N87!3:&]T475A;G1I='E#;VUM:71T960I#0H)"79A;'5E<R H0$ET
M96U)1"Q 4W1O<F5)1"PP+# L,"PP+# L,"D-"@T*"0E&151#2"!.15A4($92
M3TT@4W1O<F5?0W5R<V]R#0H)"6EN=&@0%-T;W)E240-"@E%3D0-"@E#3$]3
M12!3=&]R95]#=7)S;W(-"@E$14%,3$]#051%(%-T;W)E7T-U<G-O<@T*"49%
M5$-(($Y%6%0@1E)/32!I=&5M7V-U<G-O<@T*"6EN=&@0$ET96U)1 T*#0I%
M3D0-"D-,3U-%(&ET96U?0W5R<V]R#0I$14%,3$]#051%(&ET96U?0W5R<V]R
�I'3PT*
`
end
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap