Visual Batches

Finding batches is a bitch. Here's a cheat sheet.

Manufacturing Batches
Options:

- Print the posted transactions for the month with-in the module it was posted to. For example if you are deleting an Accounts Receivable invoice you will want to print the posted transactions from accounts receivable.

 - Some batches are not as easily found. If you find that you are trying to delete an issue, receipt or shipment it may be easier to run a script in order to find the batch. All batch numbers are stored in the DIST tables. To find the batch number you can run a select statement on the particular tables here are a few.



Select * from wip_issue_dist where workorder_base_id = '????' (Material issue batches)



Select * from wip_receipt_dist where workorder_base_id = '????' (work order receipt batches)



Select * from adjustment_dist where transaction_id = '????' (adjustment batches)



Select * from purchase_dist where purc_order_id = '?????' (purchase receipt batches)



Select * from shipment_dist where cust_order_id = '?????' (shipment batches)





