Quantity Adjustments

(Randy) #1

I am attempting to query PartTran filtering QtyAdjustments. I cannot find the fields, Reason Code and Reference from the Quantity Adjustment form, nor can I find a related table with those fields.

Thanks in advance if you can help.

Randy Weber

(Dan Edwards) #2

PartTran Table - TranReference and InvAdjReason should be what you are looking for.

(Joshua Giese) #3

Filter on TranType the help outlines each transaction type and what they mean.

(Randy) #4

Thanks. What is the document in your screen shot?

(Joshua Giese) #5

It’s the standard Epicor help.