E9: INV-ADJ by reason code

dang, I just missed that. Thankss.

 

Miguel A. Santillan

Compass Manufacturing Systems

510-661-6666  Office

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, March 03, 2015 4:42 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E9: INV-ADJ by reason code

 

 

PartTran.InvAdjReason <<-->> Reason.ReasonCode

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, March 03, 2015 5: 32 PM
To: vantage@yahoogroups.com
Subject: [Vantage] E9: INV-ADJ by reason code

 

 

I looked in the PartTran, but I don’t see how I can link PartTran to Reason Codes.

 

I want to determine from my INV-ADJ which ones were from Cycle Counts and which ones were from Other.

 

Miguel A. Santillan

ERP Analyst

Compass Manufacturing Systems

< span style="color:black;">510-661-6666  Office

 

I looked in the PartTran, but I don’t see how I can link PartTran to Reason Codes.

 

I want to determine from my INV-ADJ which ones were from Cycle Counts and which ones were from Other.

 

Miguel A. Santillan

ERP Analyst

Compass Manufacturing Systems

510-661-6666  Office

 

PartTran.InvAdjReason <<-->> Reason.ReasonCode

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, March 03, 2015 5:32 PM
To: vantage@yahoogroups.com
Subject: [Vantage] E9: INV-ADJ by reason code

 

 

I looked in the PartTran, but I don’t see how I can link PartTran to Reason Codes.

 

I want to determine from my INV-ADJ which ones were from Cycle Counts and which ones were from Other.

 

Miguel A. Santillan

ERP Analyst

Compass Manufacturing Systems

510-661-6666  Office

 

I just check a part we cycle counted – in the tranreference field it has 2014*9*1 .

 

Which is a combination of  CCYear and  CCMonth and   CycleSeq  from the CCDtl  - which are also  fields on the parttran table.

 

Do a query on the parttran table where CCYeare is > 0.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, March 03, 2015 3:32 PM
To: vantage@yahoogroups.com
Subject: [Vantage] E9: INV-ADJ by reason code

 

 

I looked in the PartTran, but I don’t see how I can link PartTran to Reason Codes.

 

I want to determine from my INV-ADJ which ones were from Cycle Counts and which ones were from Other.

 

Miguel A. Santillan

ERP Analyst

Compass Manufacturing Systems

510-661-6666  Office