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
Sort Item No on Order
yuppicide
Member Posts: 410
Navision 3.10
When entering an order I enter my items. I can go to VIEW, then SORT and I can sort by "No." field.
When you exit out of the order and back in, though, it's back to the way I entered it.
Is there a way I can make this sort stay? Or maybe I can keep the original sort button, but somehow make a new one for my purpose? .. maybe this is too complicated a thing to try or maybe I don't have access to do so.. not sure at this point.
I'll tell you my issue. For international customers we physically write on the invoice "100% Cotton, Made In India", etc. We write this for every item.
Our Item Numbers in Navision dictate what the item is and what it is made out of.. so it would be nice to be able to sort items so they appear together on screen, and also when I print out my Sales Order and Invoices.
For example, Item 1160-2241 let's me know it's a dress made out of fabric cotton. Same thing for 1165-2220. It would be dress cotton as well. The first two digits of our item number designate this. If it had began with 12 it would be considered dress made in fabric rayon.
So, when a customer gives us an order from a show it's hand written and random order. WOuld be nice to group those together so when we do write stuff like "100% cotton, made in india" on the invoice/packing list we can lessen our work.
When entering an order I enter my items. I can go to VIEW, then SORT and I can sort by "No." field.
When you exit out of the order and back in, though, it's back to the way I entered it.
Is there a way I can make this sort stay? Or maybe I can keep the original sort button, but somehow make a new one for my purpose? .. maybe this is too complicated a thing to try or maybe I don't have access to do so.. not sure at this point.
I'll tell you my issue. For international customers we physically write on the invoice "100% Cotton, Made In India", etc. We write this for every item.
Our Item Numbers in Navision dictate what the item is and what it is made out of.. so it would be nice to be able to sort items so they appear together on screen, and also when I print out my Sales Order and Invoices.
For example, Item 1160-2241 let's me know it's a dress made out of fabric cotton. Same thing for 1165-2220. It would be dress cotton as well. The first two digits of our item number designate this. If it had began with 12 it would be considered dress made in fabric rayon.
So, when a customer gives us an order from a show it's hand written and random order. WOuld be nice to group those together so when we do write stuff like "100% cotton, made in india" on the invoice/packing list we can lessen our work.
0
Comments
Because your sales line is sorting by "Document No., Line No." by default.
If you had it set to Document No., Item No. I would probably jump around the screen.
We've added some new key on our Sales Line Table (at the end)
[Document Type, Document No, Description, Description 2 ]
So we can sort by description
[Document Type, Shelf/Bin No., No.]
So we can sort by location & item #
We can also use that key on our picking ticket so the items appear in picking sequence order.
On the Sales Invoice Live table we've also added
[Document Type, Document No, Description, Description 2 ]
So our Invoices sort in Alphabetical Order.
That's done on the 1st SalesInvLineDesc view properites
& on the DataItemTableView Property Your would set your default sort
SORTING(Document No,Description, Description 2) ORDER(Ascending) in my case.
What have you tried?
We tried having Item Numbers mean something long ago with our old ERP Macola
when we switched to Nav we went regular numbers that have no meaning :thumbsup:
http://www.BiloBeauty.com
http://www.autismspeaks.org
RIS Plus, LLC
MVP - Business Apps
It was seen to be semi -useful after orders were completed and the corrected picking ticket came back from the warehouse. Some felt it was easier to find the items they needed to correct by sorting it by description.
I mentioned it was more work than clicking the magnifing glass(Find) which is pretty easy.
http://www.BiloBeauty.com
http://www.autismspeaks.org
I'll have to fool with it on Monday (when people go to lunch) as there's a few people in the office working and adding a key to a table takes time and freezes the system.
Thanks!
Remember earlier I was saying a key takes awhile to make? I had went into and started making a key, but I hit cancel before it finished and I did not compile.
Now when I try to print a Packing List it prints out weird. Sales Invoice prints fine.
For example item 1450-1107.. customer ordered Pink 6 pieces.. it's showing EVERY color in that item on my packing list! The customer did not order Black, White, Turq, or Lime! But it shows it just with 0 quantity.
sales line key shouldn't take too long - depends on your server.
I can see the sales invoice line taking a while, if you're able to add one to that table since it's usually a protected table.
http://www.BiloBeauty.com
http://www.autismspeaks.org
I went into the the report and verified that the key I was going to enter and canceled is not there.