How To Create A Custom Pick List Report sorted by Bin Location / Warehouse Using Item Custom Fields
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.8K Accounts Hosted
- 10 📢 Reckon Accounts Hosted - Announcements
- 6K Reckon Accounts (Desktop)
- 3 📢 Reckon Accounts Desktop - Announcements
- 1.2K Reckon Payroll 🚀
- 21 Reckon Payroll Help Videos 🎥
- 21 Reckon Mate App
- 18 📢 Reckon Payroll - Announcements
- 3.1K Reckon One
- 7 📢 Reckon One - Announcements
- 11 Reckon Invoices App
- 14 Reckon Insights
- 114 Reckon API
- 830 Payroll Premier
- 325 Point of Sale
- 1.9K Personal Plus and Home & Business
- 73 About Reckon Community