Thanks Joe
On Monday, July 25, 2016, Joe Douglas Trent jdtrent@... [vantage] <vantage@yahoogroups.com> wrote:Â<div> <p></p><div dir="ltr">Here's something somebody sent me, and then what I actually used underneath. I can't vouch for efficacy.<div><br></div><div>"1" is positive, "0" is no effect, "-1" is negative.<br><div><br></div><div>Joe</div><div><br></div><div><div>('ADJ-CST',1) </div><div>('ADJ-DRP',0),</div><div>('ADJ-MTL',0),</div><div>('ADJ-PUR',0),</div><div>('ADJ-QTY',1),</div><div>('ADJ-SUB',0),</div><div>('AST-STK',1),</div><div>('ASM-INS',0),</div><div>('DMR-MTL',0),</div><div>('DMR-REJ',0),</div><div>('DMR-STK',1),</div><div>('DMR-SUB',0),</div><div>('DRP-CUS',0),</div><div>('INS-ASM',0),</div><div>('INS-DMR',0),</div><div>('INS-MTL',0),</div><div>('INS-REJ',0),</div><div>('INS-STK',1),</div><div>('INS-SUB',0),</div><div>('KIT-CUS',0),</div><div>('MFG-CUS',0),</div><div>('MFG-PLT',0),</div><div>('MFG-STK',1),</div><div>('MFG-VAR',0),</div><div>('Mfg-Ven',0),</div><div>('MFG-WIP',0),</div><div>('MTL-INS',0),</div><div>('MTL-DMR',0),</div><div>('PLT-MTL',0),</div><div>('PLT-STK',1),</div><div>('PUR-CUS',0),</div><div>('PUR-DRP',0),</div><div>('PUR-INS',0),</div><div>('PUR-MTL',0),</div><div>('PUR-STK',1),</div><div>('PUR-SUB',0),</div><div>('PUR-UKN',0),</div><div>('RMA-INS',0),</div><div>('STK-ASM',-1),</div><div>('STK-CUS',-1),</div><div>('STK-INS',-1),</div><div>('STK-KIT',-1),</div><div>('STK-FAM',-1),</div><div>('STK-MTL',-1),</div><div>('STK-PLT',-1),</div><div>('STK-STK',1),</div><div>('STK-UKN',-1),</div><div>('STK-DMR',-1),</div><div>('SUB-INS',0),</div><div>('SUB-DMR',0),</div><div>('SVG-STK',1),</div><div>('UKN-CUS',0),</div><div>('WIP-MFG',0)</div><div><br></div><div>Used in calcs  query JT-Transactions</div><div>('ADJ-CST',1) </div><div>('ADJ-QTY',1),</div><div>('AST-STK',1),</div><div>('DMR-STK',1),</div><div>('INS-STK',1),</div><div>('MFG-STK',1),</div><div>('PLT-STK',1),</div><div>('PUR-STK',1),</div><div>('STK-ASM',-1),</div><div>('STK-CUS',-1),</div><div>('STK-INS',-1),</div><div>('STK-KIT',-1),</div><div>('STK-FAM',-1),</div><div>('STK-MTL',-1),</div><div>('STK-PLT',-1),</div><div>('STK-STK',1),</div><div>('STK-UKN',-1),</div><div>('STK-DMR',-1),</div><div>('SVG-STK',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"><<a rel="nofollow">vantage@yahoogroups.com</a>></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 tableIE 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
</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
Quis custodiet ipsos custodes?