On the AR side, how can I see Items that have been picked but not packing slip updated?
*This post is locked for comments
It's possible you might miss some if you run the query based on document status, it's better to use the transaction status as your inquiry. The document status is updated on the sales order header. So you might have one line which is picked or partial picked, but if you've packed or invoiced another line on the order, the document status on the sales order is updated to packed/invoiced and then it won't appear in your query.
Hi,
Use this report for picking list generation
AR-Reports->status->Open sales order lines by item
Select the document status as "picking list" under sales order and line status as "open order" under order lines .
Hope this will help you.
Thanks,
Vijay
Thanks both. Bob - I never got time to try out your method, but Diana's seems easier and does what I what.
You just need to setup a query on inventory transactions where reference = sales order and Issue = picked.
You can do that from the inventory transactions inquiry in Inventory- inquiries-transactions-transactions.
Or you can add the inventory transaction table to your query in the Open sales line inquiry in AR or from the sales order form itself.
Di Thompson, www.ThePPAXStore.com
Use the WMSOrderTrans table and link it to the salesTable and look at order status less than delivered.
Something like:
SELECT WMSORDERTRANS.ITEMID, SALESTABLE.SALESID ... ...
FROM WMSORDERTRANS INNER JOIN SALESTABLE ON WMSORDERTRANS.INVENTTRANSFERID = SALESTABLE.SALESID AND SALESTABLE.SALESSTATUS < 2
The result from this query will give you all the pick slipped registered items on orders that still have not been delivered. I'm not sure how you would accomplish this on the front end.
I THINK this is what you are after! Yes, no?
But its possible (likely at our site) that Items on Orders which are Picking List Posted are not yet picked.
I should re-phrase my question. How can I see items on Sales Orders which have been picking list registered, but not packing slip updated! On the Sales Order Line 'Quantity' Tab, these show in the column 'Picked'.
The problem we have here is that we invoice anything that has been packig slip updated, but it may happen that our warehouse guys pick and physically ship something but forget to post the packing slip.
There are a few ways to do this. Easiest way is to filter by "Picking list" on the document status field in the general tab of the salesTable form.
This will give you all the SO's that are pick list posted.
Kind regards.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 2 Most Valuable Professional
Guy Terry 2 Moderator
Community Member 2
