1. Home
  2. Point-Of-Sale Software
  3. Last Sold in HQ not Updating

Last Sold in HQ not Updating

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

Reply to
Anthony Laidler
Loading thread data ...

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

cod

Reply to
cod

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

Reply to
cod

Reply to
Anthony Laidler

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

Reply to
Terrible Tom

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

Reply to
Jason

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.