PartTran TranQty True Sign

Thanks Joe

On Monday, July 25, 2016, Joe Douglas Trent jdtrent@... [vantage] <vantage@yahoogroups.com> wrote:
Â
<div>
  
  
  <p></p><div dir="ltr">Here&#39;s something somebody sent me, and then what I actually used underneath. I can&#39;t vouch for efficacy.<div><br></div><div>&quot;1&quot; is positive, &quot;0&quot; is no effect, &quot;-1&quot; is negative.<br><div><br></div><div>Joe</div><div><br></div><div><div>(&#39;ADJ-CST&#39;,1) </div><div>(&#39;ADJ-DRP&#39;,0),</div><div>(&#39;ADJ-MTL&#39;,0),</div><div>(&#39;ADJ-PUR&#39;,0),</div><div>(&#39;ADJ-QTY&#39;,1),</div><div>(&#39;ADJ-SUB&#39;,0),</div><div>(&#39;AST-STK&#39;,1),</div><div>(&#39;ASM-INS&#39;,0),</div><div>(&#39;DMR-MTL&#39;,0),</div><div>(&#39;DMR-REJ&#39;,0),</div><div>(&#39;DMR-STK&#39;,1),</div><div>(&#39;DMR-SUB&#39;,0),</div><div>(&#39;DRP-CUS&#39;,0),</div><div>(&#39;INS-ASM&#39;,0),</div><div>(&#39;INS-DMR&#39;,0),</div><div>(&#39;INS-MTL&#39;,0),</div><div>(&#39;INS-REJ&#39;,0),</div><div>(&#39;INS-STK&#39;,1),</div><div>(&#39;INS-SUB&#39;,0),</div><div>(&#39;KIT-CUS&#39;,0),</div><div>(&#39;MFG-CUS&#39;,0),</div><div>(&#39;MFG-PLT&#39;,0),</div><div>(&#39;MFG-STK&#39;,1),</div><div>(&#39;MFG-VAR&#39;,0),</div><div>(&#39;Mfg-Ven&#39;,0),</div><div>(&#39;MFG-WIP&#39;,0),</div><div>(&#39;MTL-INS&#39;,0),</div><div>(&#39;MTL-DMR&#39;,0),</div><div>(&#39;PLT-MTL&#39;,0),</div><div>(&#39;PLT-STK&#39;,1),</div><div>(&#39;PUR-CUS&#39;,0),</div><div>(&#39;PUR-DRP&#39;,0),</div><div>(&#39;PUR-INS&#39;,0),</div><div>(&#39;PUR-MTL&#39;,0),</div><div>(&#39;PUR-STK&#39;,1),</div><div>(&#39;PUR-SUB&#39;,0),</div><div>(&#39;PUR-UKN&#39;,0),</div><div>(&#39;RMA-INS&#39;,0),</div><div>(&#39;STK-ASM&#39;,-1),</div><div>(&#39;STK-CUS&#39;,-1),</div><div>(&#39;STK-INS&#39;,-1),</div><div>(&#39;STK-KIT&#39;,-1),</div><div>(&#39;STK-FAM&#39;,-1),</div><div>(&#39;STK-MTL&#39;,-1),</div><div>(&#39;STK-PLT&#39;,-1),</div><div>(&#39;STK-STK&#39;,1),</div><div>(&#39;STK-UKN&#39;,-1),</div><div>(&#39;STK-DMR&#39;,-1),</div><div>(&#39;SUB-INS&#39;,0),</div><div>(&#39;SUB-DMR&#39;,0),</div><div>(&#39;SVG-STK&#39;,1),</div><div>(&#39;UKN-CUS&#39;,0),</div><div>(&#39;WIP-MFG&#39;,0)</div><div><br></div><div>Used in calcs  query JT-Transactions</div><div>(&#39;ADJ-CST&#39;,1) </div><div>(&#39;ADJ-QTY&#39;,1),</div><div>(&#39;AST-STK&#39;,1),</div><div>(&#39;DMR-STK&#39;,1),</div><div>(&#39;INS-STK&#39;,1),</div><div>(&#39;MFG-STK&#39;,1),</div><div>(&#39;PLT-STK&#39;,1),</div><div>(&#39;PUR-STK&#39;,1),</div><div>(&#39;STK-ASM&#39;,-1),</div><div>(&#39;STK-CUS&#39;,-1),</div><div>(&#39;STK-INS&#39;,-1),</div><div>(&#39;STK-KIT&#39;,-1),</div><div>(&#39;STK-FAM&#39;,-1),</div><div>(&#39;STK-MTL&#39;,-1),</div><div>(&#39;STK-PLT&#39;,-1),</div><div>(&#39;STK-STK&#39;,1),</div><div>(&#39;STK-UKN&#39;,-1),</div><div>(&#39;STK-DMR&#39;,-1),</div><div>(&#39;SVG-STK&#39;,1),</div></div><div><br></div><div><br></div></div></div><div class="ygrps-yiv-1638167951gmail_extra"><br><div class="ygrps-yiv-1638167951gmail_quote">On Mon, Jul 25, 2016 at 3:40 PM, Jose Gomez <a rel="nofollow">jose@...</a> [vantage] <span dir="ltr">&lt;<a rel="nofollow">vantage@yahoogroups.com</a>&gt;</span> wrote:<br><blockquote class="ygrps-yiv-1638167951gmail_quote" style="border-left:1px #ccc solid;">
Â
<div>
  
  
  <p></p><div dir="ltr"><div class="ygrps-yiv-1638167951gmail_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>

</div>
 


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


--

Jose C Gomez
Software Engineer


T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
     Â

Quis custodiet ipsos custodes?

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?
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>