I am trying to add the current qty on hand to the stoke take printout.
This is so that while counting the stock we are aware of the qty there should be.
I know this is counter to proper procedure but we are a very small company and have always done it this way and don't want to change.
*This post is locked for comments
You will need to edit the "Stocktake - Stock Take Report (Detailed).qrp" file in notepad
Add this to the report
Begin Column
FieldName = "Item.Quantity"
DrillDownFieldName = ""
DrillDownReportName = ""
Title = "Qty Expected"
VBDataType = vbDouble
Formula = ""
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 650
GroupMethod = groupmethodSum
ColFormat = ""
End Column
Save the file and rerun the report from the physical inventory screen.
P.S. you can not change the count screen, only the report.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (