Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 267 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Qty to Ship in Sales Order Screen, Auto Fill on second post
Ben_Dyson
Member Posts: 18
Hi All (In RTC, V6)
As an example I have been into the sales order screen and ordered 3 items, ItemA , ItemB and ItemC.
Item ID,Required Qty,Stock,Qty to Ship
ItemA , 5 , 5 , 5
ItemB , 6 , 4 , 4
ItemC , 7 , 0 , 0
From this example you can see that some items can be picked immediatly and others will require a purchase order. We send the stock of available goods right away.
I have 2 issues here. Although the answer two one may make the answer to the other unrequired.
Once the Backorder has been recieved we go back into the sales order to create a new pick note, the Qty to Ship field is blank on all lines despite the fact that stock is now available, meaning we have to manually adjust each line. This is ok on when 2 lines need adjusting but in real life we have a hell of a lot more to update. Does anyone know of a way to make this field Autofill in with the new stock on reloading the S/O?
However we were also wondering if at the point of recieving the stock into the system that we could have the stock Auto Allocate to a new picknote, or perhaps assign it to an Sales Order from Good receiving. Thus negating the requirement to go back into the sales order to allocate the stock to a picknote.
Regards
Ben Dyson
As an example I have been into the sales order screen and ordered 3 items, ItemA , ItemB and ItemC.
Item ID,Required Qty,Stock,Qty to Ship
ItemA , 5 , 5 , 5
ItemB , 6 , 4 , 4
ItemC , 7 , 0 , 0
From this example you can see that some items can be picked immediatly and others will require a purchase order. We send the stock of available goods right away.
I have 2 issues here. Although the answer two one may make the answer to the other unrequired.
Once the Backorder has been recieved we go back into the sales order to create a new pick note, the Qty to Ship field is blank on all lines despite the fact that stock is now available, meaning we have to manually adjust each line. This is ok on when 2 lines need adjusting but in real life we have a hell of a lot more to update. Does anyone know of a way to make this field Autofill in with the new stock on reloading the S/O?
However we were also wondering if at the point of recieving the stock into the system that we could have the stock Auto Allocate to a new picknote, or perhaps assign it to an Sales Order from Good receiving. Thus negating the requirement to go back into the sales order to allocate the stock to a picknote.
Regards
Ben Dyson
0
Comments
You can create a function in sales Order (Ex: Update Stock) to update the stock each time...user can click that and check the quantity
-Mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav
Thanks for the swift response. I can see how that would work by adding the new function into App management in classic. But we were hoping there might be a "Out of the box" solution and avoid developing a a new function. It seems odd that we can't get these fields to update automatically. Someone created a routine to check the stock and fill them in, in the first instance. So why not apply the same routine when the refresh button is pressed for example.
Anyone else have an idea about auto allocate the stock when the good are received.
Regards
Ben
First come basis? By order date? customer priority?
Are you using Requisition worksheet to create the po?
We created a function "as stated above" from the po called "Update Sales Lines" where from after the receipt of the po it goes thru any open sales lines to update.
But that's for a specific purpose for our biz. I like the function idea on the sales order so you have more control.
unfortunately not everything can be automated 8)
http://www.BiloBeauty.com
http://www.autismspeaks.org
Cheers