PartTran TranQty True Sign

Yahoo Archive
3
Here's something somebody sent me, and then what I actually used underneath. I can't vouch for efficacy.

"1" is positive, "0" is no effect, "-1" is reversed

Joe

('ADJ-CST',1)Â
('ADJ-DRP',0),
('ADJ-MTL',0),
('ADJ-PUR',0),
('ADJ-QTY',1),
('ADJ-SUB',0),
('AST-STK',1),
('ASM-INS',0),
('DMR-MTL',0),
('DMR-REJ',0),
('DMR-STK',1),
('DMR-SUB',0),
('DRP-CUS',0),
('INS-ASM',0),
('INS-DMR',0),
('INS-MTL',0),
('INS-REJ',0),
('INS-STK',1),
('INS-SUB',0),
('KIT-CUS',0),
('MFG-CUS',0),
('MFG-PLT',0),
('MFG-STK',1),
('MFG-VAR',0),
('Mfg-Ven',0),
('MFG-WIP',0),
('MTL-INS',0),
('MTL-DMR',0),
('PLT-MTL',0),
('PLT-STK',1),
('PUR-CUS',0),
('PUR-DRP',0),
('PUR-INS',0),
('PUR-MTL',0),
('PUR-STK',1),
('PUR-SUB',0),
('PUR-UKN',0),
('RMA-INS',0),
('STK-ASM',-1),
('STK-CUS',-1),
('STK-INS',-1),
('STK-KIT',-1),
('STK-FAM',-1),
('STK-MTL',-1),
('STK-PLT',-1),
('STK-STK',1),
('STK-UKN',-1),
('STK-DMR',-1),
('SUB-INS',0),
('SUB-DMR',0),
('SVG-STK',1),
('UKN-CUS',0),
('WIP-MFG',0)

Used in calcs  query JT-Transactions
('ADJ-CST',1)Â
('ADJ-QTY',1),
('AST-STK',1),
('DMR-STK',1),
('INS-STK',1),
('MFG-STK',1),
('PLT-STK',1),
('PUR-STK',1),
('STK-ASM',-1),
('STK-CUS',-1),
('STK-INS',-1),
('STK-KIT',-1),
('STK-FAM',-1),
('STK-MTL',-1),
('STK-PLT',-1),
('STK-STK',1),
('STK-UKN',-1),
('STK-DMR',-1),
('SVG-STK',1),



On Mon, Jul 25, 2016 at 3:40 PM, Jose Gomez jose@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p></p><div dir="ltr"><div class="ygrps-yiv-1732189804gmail_default"><p style="font-family:verdana, sans-serif;font-size:small;">Does anyone have a list of the “True Sign” of these Part

Transactions?

For example I just realized that STK-CUS show positive when you Ship out and negative when you reverse it… (which is damn stupid)… I need to know how each of these transactions affects inventory regardless of the sign they show in the Part Tran table

IE STK-CUST PartTran Positive means NEGATIVE (REMOVE) Inventory

Etc..

'PUR-INS'

'PUR-MTL',

'PUR-STK',

'PUR-SUB'
'PUR-UKN'
'STK-ASM'

'STK-CUS'

'STK-DMR'

'STK-MTL'

'STK-PLT'

'STK-UKN'

'SVG-STK'

Any info would be awesome

Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

</div>
 


<div style="color:#fff;min-height:0;"></div>