Last Sold in HQ not Updating

Aug 25, 2007 5 Replies
A

I am having an issue where some items are not updating the last sold information in HQ. If I check my reports at the store level, all the data is there, but that data is not transferring back to HQ. A little more digging around and I noticed where I have a whole department that is not reporting back either. If I go look at individual items, it is showing that those items have sold under the store quantity tab.



I tried a backdated 401 to the day before the last date that it updated to see if I captured that data and that didn't work. I even did a test and exported a copy of the store out of HQ and tried to send that data back to HQ and that didn't work either. Any ideas of how to get this back in sync?



Thanks


Vote
Twitter Facebook LinkedIn
C

I wrote for a customer a SQL trigger to update the field "Last Sold" from transactionentry when they are received from store.

cod

Vote
Twitter Facebook LinkedIn
C

The trigger use the ItemDynamic data ..

CREATE TRIGGER tr_updateItemDynamicSold ON ItemDynamic AFTER INSERT, UPDATE AS IF UPDATE(LastSold) BEGIN UPDATE Item SET LastSold = inserted.LastSold FROM inserted WHERE ISNULL(inserted.LastSold,0) 0 AND inserted.LastSold >= ISNULL(Item.LastSold,0) AND Item.ID = inserted.ItemID END

Vote
Twitter Facebook LinkedIn
T

That is a pretty half-hearted 'solution' from MS to what even a child would realize is an obvious programming oversight.

Any reasonable person would expect this to be resolved in the next HotFix, but I think the CustomerSource 'solution' is already older than the latest HotFix...

Pathetic.

Tom

Vote
Twitter Facebook LinkedIn
J

Agreed. This is a serious oversight that has an easy solution. Get on the ball, MS.

Vote
Twitter Facebook LinkedIn

Join the Discussion

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

Didn't find your answer?

Ask the community — no account required