Question

How can we find any Return for Rework transactions that have not had the part returned from ventory?

  • 11 March 2022
  • 4 replies
  • 187 views
M
Rank
Userlevel 1
Badge +2

We are trying to find any receipts that have return for rework transactions that are still outstanding.  Is there an out of the box screen or report that would provide that information?  The Received - not yet Invoiced Report shows any return for credit requests that are outstanding but we need to verify reworked parts have been returned.

This topic has been closed for comments

4 replies

Lumini Sahabandu
Rank
Userlevel 5
Badge +10

Hi @MaurineS ,

In Return Tab of the PO order Receipt itself , you will be able to find the Return Rework Qty.

And also if you query on the Register Arrival Screen using PO number , you will see the remaining qty which was return to rework is waiting to be received. 

 

And also in Inventory Transaction History , there is a separate record created for the same.

Thank you,

Lumini.

M
Rank
Userlevel 1
Badge +2

Thanks Lumini - that works great if you remember what PO has the rework.  We are trying to run a weekly or monthly check to review all return to vendor for rework transactions that are outstanding, in one list (report, advanced search, lobby element, something) so we can contact Suppliers and have one conversation about all parts.  Would also be a good way to make sure all receipts happened and that a box isn’t sitting under someone’s desk (we had that happen).

Lumini Sahabandu
Rank
Userlevel 5
Badge +10

Hi @MaurineS ,

This can be done using an Inventory Transaction Report. You can create a report and connect inventory code : RETWORK to the report. Once done all receipts where the Transaction Code = RETWORK will be listed.  This is how you do it. 

  1. Create Basic data in ‘Inventory Transaction Basic Data’ window as illustrated below
    1. Report Types : Ass Return Work type and direction would be minus.

    2. Report Type for Transaction Codes : Add RETWORK transaction code

    3. Define a Number series for the report type for site

       

  2.  Next Go to : Inventory Transaction Report Group and create a report using the report type defined above.  Once done you will be able to see available inventory transaction with the RETWORK transaction Code.

    This report can be generated as per the time frame you have provided in the Transactions Created Date / Time section.                                                                    Thank you,                                                                                                                          Lumini. 

M
Rank
Userlevel 1
Badge +2

This gets me closer but is there a way to run for all users?  The purchasing agent will run this but the return could have been done by shipping/receiving users.

Thanks,

Maurine

Terms & ConditionsCookie settings