1. In Business Central, open a filtered Sales Lines view with the below filters:
a. Document Type = Order
b. Outstanding Quantity = 0
c. Productline Code = 14-HOL|17-ESL|18-SI
d. Expedited Order = Yes
2. Export the filtered view to Excel
3. Open Excel document, and delete all line items that are not part items (i.e begin with Kit, LP, SI, SP, etc)
4. Select all data in the columns for Part Number and Qty on Sales Order.
Note: you may need to delete other columns in order to have the required columns next to each other for selection.
5. Copy the selected data in the Part Number and Qty on Sales Order columns
6. Create new Transfer Order in Business Central from YULRAW to MAIN.
7. Paste selected data including Part Number and Qty into line items on Transfer Order.
8. Create Warehouse Shipment
9. Create Warehouse Pick, assign to User, and print document if no handheld available.
10. Manually pick items from Warehouse pick. Once complete, register pick.
11. Post pick and receive Transfer Order.
12. Re-run 'Combined Shipping Report' Jet Report
13. Once report is available, navigate to the 'Parts' tab.
14. Navigate to Data tab in Excel and select Subtotal.
15. Set up subtotal as below and select OK
0 Comments
Add your comment