When using the standard offline inventory list report, it seems to show all products that have ever gone offline. Is there a report that shows offline stock that is only offline at the time of the report? I have looked in the InventoryOffline table but there is no indication of when the product went offline.
Thanks
Hi Richyrich, I am not sure why your report is not showing the date. but the standard report contain the date and time when the inventory of particular item goes offline. May I send you the report.
Likely if you are not look> When using the standard offline inventory list report, it seems to show all
HI Richy, I have check the table structure and found that there are 2 fields which you can work and added to the inventoryoffline report under the HQ. The field are: Date and DBTimeStamp. This really help you for your issue:
In Report add the column;
Begin Column FieldName = "Inventoryoffline.[Date]" DrillDownFieldName = "" DrillDownReportName = "" Title = "Date" VBDataType = vbDate Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1020 GroupMethod = groupmethodNone ColFormat = "" End Column
"RichyRich" wrote:
Have something to add? Share your thoughts — no account required.
Ask the community — no account required