bx?]Ð1nÃ0 Ð]§ø0 ?C§ YÚ???AÒ1|ûR :d||=Jú]?q??;MØ7¬' /¹Æþ"v??ÆT&°8\!)|!?b?¼ÊÎ??C° ûbÈskëY/× ?ñuÿn?M¹? øl@áYtÍ^?C?tSyTZQ,J9&Ôzµ-W?H3[ [Ý0 ½Ñi|³»¸N Ii®4??¡ ?ë =sõbºÿqJ?¨l??TcÖnÛ^Ýútk?S! ùl?3?j£})ö?RB¬?{b
Items entered initially to inventory with $0.00 cost PROBLEM
Mar 08, 2006
1 Replies
Not really.
If you were *really* desperate, you could conceivably do the following:
Run a query in SO Admin to get the ItemLookupCode, ID and Cost from Item. Export the results to Excel. Use Excel to build a set of queries for every item that go like this: UPDATE TransactionEntry Cost = WHERE ItemID You would use a formula like CONCATENATE or a text formula using the ampersand '&' to extract the text from the cells with numeric data. Copy the entire list of queries into SO Admin.
BEWARE: This is a potentially risky recommendation. I'd urge you to backup your database before every query or set of queries.
CAUTION: There may be other tables involved in the reports you want. The end result may or may not be any better than the zeroes you have now.
DISCLAIMER: Proceed at your own risk.
Hope that helped, Tom
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required