Has anyone automated Calc Whse Adjustment?

eedobson

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

Jan_Veenendaal

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_Veenendaal

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.

bbrown

Funny part is this was all automated back in version 2.60. The feature was "lost" when Microsoft acquired the WMS functionality from Lanham.

eedobson

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!

bbrown

eedobson wrote: »

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.

eedobson

Ahah - took me a bit, but I found the lot number fact box on the bin content page. Thank you!