The ItemDynamic table and inventory reports

(0) Share

Report

Posted on by tom123

Hi All:

Does anyone know if the HQ ItemDynamic table is updated with every transaction, as an HQ client connects, or only when a 501 worksheet is requested?

I want an up-to-date item quantity for store-inventory report without having to run a 501 every time. It does look like it's kept in sync with the store data, but I'm not 100% sure.

*This post is locked for comments

All responses (4)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

Re: The ItemDynamic table and inventory reports

Forget about the quantity field, it's the SnapShotQuantity that u should be looking at
tom123 80 on at

Like (0)

Report

Re: The ItemDynamic table and inventory reports

Thanks to both of you.

It appears the SnapShotQuantity column gets updated. There's a separate Quantity column, but I'm not sure of it's purpose.
Verified answer

Gerald Rothaus 2,930 on at

Like (0)

Report

Re: The ItemDynamic table and inventory reports

My, take, for what it's worth, is the itemdynamic entries are created when you roll out a 250, and update via 401's. I'm not so sure about the 501, but you can run a test and find out.

-Jerry
Community Member Microsoft Employee on at

Like (0)

Report

Re: The ItemDynamic table and inventory reports

Whenever the item qty is changed at the store level due to sales, purchase, or any type of movement, the corresponding record is updated at the HQ