Quantity Adjustments

[randallweber]

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

[danbedwards (Dan Edwards)]

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

[jgiese.wci (Joshua Giese)]

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

[randallweber]

Thanks. What is the document in your screen shot?

[jgiese.wci (Joshua Giese)]

It’s the standard Epicor help.