Has anyone automated Calc Whse Adjustment?
eedobson
Member Posts: 16
Just wondering if anyone has ever automated Calc Whse Adjustment, such as building it into the Register action on the Whse Item/Phys Invy journal. It's a step that people always forget to do, and folks never understand why it doesn't just happen automatically.
I know we can schedule it to run in the job queue, but in emergencies people forget about the second step, and then can't find their inventory.
Thank you in advance for any ideas,
Liz
I know we can schedule it to run in the job queue, but in emergencies people forget about the second step, and then can't find their inventory.
Thank you in advance for any ideas,
Liz
0
Best Answer
-
Yes, I 'have done that loooooong time ago in NAV 5 & 2009. Sadly enough I do not have the code since I do not work for the same company anymore.
As I recall it needed a COMMIT and the setting of some parameters, but it could be done.
We did encounter some issues [we were using LOT tracking]: when an error occured then not all created 'warehouse adjustment' journal lines were cleaned up and other users would get errors on the 'faulty' lot even when they did not use that LOT at all - in such cases manual action was required to fix it.Jan Veenendaal5
Answers
-
Yes, I 'have done that loooooong time ago in NAV 5 & 2009. Sadly enough I do not have the code since I do not work for the same company anymore.
As I recall it needed a COMMIT and the setting of some parameters, but it could be done.
We did encounter some issues [we were using LOT tracking]: when an error occured then not all created 'warehouse adjustment' journal lines were cleaned up and other users would get errors on the 'faulty' lot even when they did not use that LOT at all - in such cases manual action was required to fix it.Jan Veenendaal5 -
Funny part is this was all automated back in version 2.60. The feature was "lost" when Microsoft acquired the WMS functionality from Lanham.
There are no bugs - only undocumented features.0 -
Yes, there's just some odd disconnected features in WMS that you'd think would be handled better (like not being able to see a lot/serial number from bin contents). I haven't had a chance to look at 2016 yet, hoping some have been fixed.
Thank you for your comments!0 -
Yes, there's just some odd disconnected features in WMS that you'd think would be handled better (like not being able to see a lot/serial number from bin contents). I haven't had a chance to look at 2016 yet, hoping some have been fixed.
Thank you for your comments!
You need to set "Whse Lot Tracking" on your "Item Tracking Codes" to see lot numbers in the warehouse. There is then a "Lot No. Filter" on the Bin Contents. Same functionality exists for Serial numbers.
There are no bugs - only undocumented features.0 -
Ahah - took me a bit, but I found the lot number fact box on the bin content page. Thank you!0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
