Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) What does the Item Dai...

What does the Item Daily Quantity (ItemDailyQuantity) table in the DynamicsGPWarehouse contain?

(0) Share

Report

Posted on by Community Member Microsoft Employee

Can anyone explain the contents of the Item Daily Quantity table? I was hoping it would contain item balances by site, by day...but in looking at the data it doesn't seem to be the case.

*This post is locked for comments

All responses (2)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: What does the Item Daily Quantity (ItemDailyQuantity) table in the DynamicsGPWarehouse contain?

That won't help...hers will only show the current balances. I was hoping to be able to retrieve historical balances without going through all the gyrations done by the Historical Stock Status report. The ItemDailyQuantity table in the Analysis Cubes data warehouse looked like it might be saving the item balances on a daily basis, but closer inspection shows that's not the case.
Suggested answer

sandipdjadhav 18,265 on at

Like (0)

Report

RE: What does the Item Daily Quantity (ItemDailyQuantity) table in the DynamicsGPWarehouse contain?

Hi,

Check Victoria's blog. Here is link for Inventory Qty on hand: victoriayudin.com/.../sql-view-for-inventory-quantities-on-hand

This may give you some lead to create your report.

Thanks

Sandip