Where Stores the Reason Code in PartTrans

Yahoo Archive
1
The reason code is stored in PartTran.InvAdjReason. Use that field as a lookup into the reason code table. Be aware that not all inventory adjustments will have a reason code, e.g. Cycle count adjustments (always blank).

----- Original Message -----
From: mintokmint
To: vantage@yahoogroups.com
Sent: Saturday, November 22, 2008 3:55 AM
Subject: [Vantage] Where Stores the Reason Code in PartTrans


As we know when we make a Qty-adjustment we have to input the reason
code.so there are lots of ADJ-QTY Types in my Transcations.I want to
make a report searching by Reason code.But I can't find the reason code
in the PartTrans Table.Where is it?Or there is another way to do that
report
Anyone can help?
Many thanks.




Charles Carden
IT Manager
Manitex, Inc.


[Non-text portions of this message have been removed]
1 Like
2
As we know when we make a Qty-adjustment we have to input the reason
code.so there are lots of ADJ-QTY Types in my Transcations.I want to
make a report searching by Reason code.But I can't find the reason code
in the PartTrans Table.Where is it?Or there is another way to do that
report
Anyone can help?
Many thanks.
3
Do you mean parttran.trantype?





________________________________
From: mintokmint <mintokmint@...>
To: vantage@yahoogroups.com
Sent: Saturday, November 22, 2008 3:55:00 AM
Subject: [Vantage] Where Stores the Reason Code in PartTrans


As we know when we make a Qty-adjustment we have to input the reason
code.so there are lots of ADJ-QTY Types in my Transcations. I want to
make a report searching by Reason code.But I can't find the reason code
in the PartTrans Table.Where is it?Or there is another way to do that
report
Anyone can help?
Many thanks.






[Non-text portions of this message have been removed]