Share
Report*This post is locked for comments
You’re offline. This is a read only version of the page.
*This post is locked for comments
Good morning,
Thank you Danny for the follow up; and thank you Gerald for posting some things for him to check.
1. How do I know when it was closed?
If the order is closed I would assume that the [order].LastUpdated date would be the date it was closed.
2. Which Date field should I use?
As Gerald stated there is an [order].LastUpdated date that appears to show the last time the order was touched.
If this is not on the report already you could modify the report to add this information.
3. How to know if it was a full or partial pickup?
If the status is Closed it was a full pickup.
If you want to check what is on order there are a couple custom reports in the Reports Library you may want to reference:
mbs.microsoft.com/.../modifiedreports_rmsstoreoperationsreports.htm
Report - Order Summary and Order Detail with Remaining Balance Calculation
These reports calculate the remaining balance on special transactions within an active report (for work orders, back orders, and layaways)
Please let me know if this answers your questions,
Hi.
The reference number & detail comment are in the Order table, the item comment and change in description is in the Order Entry table. In the (sales) transactionentry table, only the item id is recorded.
You could get the status date from the lastupdated field, I guess.
-Jerry
When a WorkOrder is closed - I still need to get info about the WorkOrder.
Doing a report with status=Closed gets me some data - how do I know when it was closed?
Which Date field should I use, plus how to know if it was a full or partial pickup.
The data is somewhere - just no sure what table and field.
Danny
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
All responses (
Answers (