How To Create A Custom Pick List Report sorted by Bin Location / Warehouse Using Item Custom Fields
Options
Inigo
Member Posts: 166 Novice Member 
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
This discussion has been closed.