How To Create A Custom Pick List Report sorted by Bin Location / Warehouse Using Item Custom Fields
Options
Inigo
Member Posts: 193 ✭
This is from a previous community post
https://community.reckon.com/reckon/topics/sorting-pick-ticket
Create a Custom Transaction Detail Report
Modify the report:
- change the title to something relevant, such as Pick List
- to display the Bin Location custom field
- to display the Item field
- to add any other columns you do need
- to remove any other columns you do not need
- to Total By = Customer
- to Sort By = Bin Location
- filter it to display Transaction Type = Sales Order
- filter it to display Posting Status = Non Posting
- filter it any other way you need, such as dates, customer names, etc
Memorise this report
-IM
https://community.reckon.com/reckon/topics/sorting-pick-ticket
Create a Custom Transaction Detail Report
Modify the report:
- change the title to something relevant, such as Pick List
- to display the Bin Location custom field
- to display the Item field
- to add any other columns you do need
- to remove any other columns you do not need
- to Total By = Customer
- to Sort By = Bin Location
- filter it to display Transaction Type = Sales Order
- filter it to display Posting Status = Non Posting
- filter it any other way you need, such as dates, customer names, etc
Memorise this report
-IM
0
Comments
-
Can you have multiple Bin Locations against 1 stock item?0
Categories
- All Categories
- 6.4K Accounts Hosted
- 10 📢 Reckon Accounts Hosted - Announcements
- 5.9K Reckon Accounts (Desktop)
- 3 📢 Reckon Accounts Desktop - Announcements
- 1.3K Reckon Payroll 🚀
- 21 📢 Reckon Payroll - Announcements
- 21 Reckon Payroll Help Videos 🎥
- 21 Reckon Mate App
- 3K Reckon One
- 7 📢 Reckon One - Announcements
- 10 Reckon Invoices App
- 14 Reckon Insights
- 107 Reckon API
- 822 Payroll Premier
- 307 Point of Sale
- 1.9K Personal Plus and Home & Business
- 62 About Reckon Community