Epicor 905.702A - PORel GL Account

Yahoo Archive
1
You are going to have to look to the TranGLC table, for the relatedtofile field = PORel. The APInvoice field should be blank, and bookdebit and bookcredit should be zero, but it will tell you the GL account assigned to the release.
  Hope this helps!
  - leAnn


From: "Stelios Zoumis s.zoumis@... [vantage]" <vantage@yahoogroups.com>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Friday, May 1, 2015 2:18 PM
Subject: [Vantage] RE: Epicor 905.702A - PORel GL Account

  
<div id="ygrps-yiv-1026700104yiv6257541948ygrp-text">
  
  
  <div id="ygrps-yiv-1026700104yui_3_16_0_1_1430764199247_12954">You have to join table tranglc.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, April 30, 2015 5:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 905.702A - PORel GL Account


I have been asked to create a BAQ showing the open POReleases along with the GL Account for each release.
I don’t see it on the PORel table, does anyone know where this is stored so I can grab it?


Bill Turgeon
Director, Information Technology
Coto Technology, Inc.
66 Whitecap Drive
North Kingstown, RI 02852
Phone: (401) 583-7223
Cell: (401) 368-9938
Fax: (401) 942-0920
Email: Bill.Turgeon@...
Web: www.cotorelay.com
[Image removed by sender.]
Please consider the environment before printing this email.
This e-mail and any attachments are for the sole use of the intended recipients and may be privileged or confidential. Any distribution, printing or other use by anyone else is prohibited. If you are not an intended recipient, please contact the sender immediately, and permanently delete this e-mail and attachments.

“Come visit Coto Technology at Sensors Expo Booth #138 in Long Beach, June 10-11, to see the RedRock RR100 and all of our other Switch, Sensor, and Relay Solutions!”


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

</div>
 


<div style="color:#fff;height:0;"></div></div>
#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948 -- #ygrps-yiv-1026700104yiv6257541948ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948ygrp-mkp #ygrps-yiv-1026700104yiv6257541948hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948ygrp-mkp #ygrps-yiv-1026700104yiv6257541948ads {
margin-bottom:10px;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948ygrp-mkp .ygrps-yiv-1026700104yiv6257541948ad {
padding:0 0;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948ygrp-mkp .ygrps-yiv-1026700104yiv6257541948ad p {
margin:0;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948ygrp-mkp .ygrps-yiv-1026700104yiv6257541948ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948ygrp-sponsor #ygrps-yiv-1026700104yiv6257541948ygrp-lc {
font-family:Arial;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948ygrp-sponsor #ygrps-yiv-1026700104yiv6257541948ygrp-lc #ygrps-yiv-1026700104yiv6257541948hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948ygrp-sponsor #ygrps-yiv-1026700104yiv6257541948ygrp-lc .ygrps-yiv-1026700104yiv6257541948ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948activity span {
font-weight:700;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948activity span span {
color:#ff7900;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948activity span .ygrps-yiv-1026700104yiv6257541948underline {
text-decoration:underline;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 .ygrps-yiv-1026700104yiv6257541948attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 .ygrps-yiv-1026700104yiv6257541948attach div a {
text-decoration:none;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 .ygrps-yiv-1026700104yiv6257541948attach img {
border:none;padding-right:5px;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 .ygrps-yiv-1026700104yiv6257541948attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 .ygrps-yiv-1026700104yiv6257541948attach label a {
text-decoration:none;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 .ygrps-yiv-1026700104yiv6257541948bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 .ygrps-yiv-1026700104yiv6257541948bold a {
text-decoration:none;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 dd.ygrps-yiv-1026700104yiv6257541948last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 dd.ygrps-yiv-1026700104yiv6257541948last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 dd.ygrps-yiv-1026700104yiv6257541948last p span.ygrps-yiv-1026700104yiv6257541948yshortcuts {
margin-right:0;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 div.ygrps-yiv-1026700104yiv6257541948attach-table div div a {
text-decoration:none;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 div.ygrps-yiv-1026700104yiv6257541948attach-table {
width:400px;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 div.ygrps-yiv-1026700104yiv6257541948file-title a, #ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 div.ygrps-yiv-1026700104yiv6257541948file-title a:active, #ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 div.ygrps-yiv-1026700104yiv6257541948file-title a:hover, #ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 div.ygrps-yiv-1026700104yiv6257541948file-title a:visited {
text-decoration:none;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 div.ygrps-yiv-1026700104yiv6257541948photo-title a, #ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 div.ygrps-yiv-1026700104yiv6257541948photo-title a:active, #ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 div.ygrps-yiv-1026700104yiv6257541948photo-title a:hover, #ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 div.ygrps-yiv-1026700104yiv6257541948photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 div#ygrps-yiv-1026700104yiv6257541948ygrp-mlmsg #ygrps-yiv-1026700104yiv6257541948ygrp-msg p a span.ygrps-yiv-1026700104yiv6257541948yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 .ygrps-yiv-1026700104yiv6257541948green {
color:#628c2a;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 .ygrps-yiv-1026700104yiv6257541948MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 o {
font-size:0;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948photos div {
float:left;width:72px;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948reco-category {
font-size:77%;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948reco-desc {
font-size:77%;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 .ygrps-yiv-1026700104yiv6257541948replbq {
margin:4px;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948ygrp-mlmsg select, #ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 input, #ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948ygrp-mlmsg pre, #ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 code {
font:115% monospace;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948ygrp-mlmsg #ygrps-yiv-1026700104yiv6257541948logo {
padding-bottom:10px;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948ygrp-msg p#ygrps-yiv-1026700104yiv6257541948attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948ygrp-reco #ygrps-yiv-1026700104yiv6257541948reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948ygrp-sponsor #ygrps-yiv-1026700104yiv6257541948ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948ygrp-sponsor #ygrps-yiv-1026700104yiv6257541948ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948ygrp-sponsor #ygrps-yiv-1026700104yiv6257541948ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948ygrp-text {
font-family:Georgia;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948ygrp-text tt {
font-size:120%;}

#ygrps-yiv-1026700104 #ygrps-yiv-1026700104yiv6257541948 #ygrps-yiv-1026700104yiv6257541948ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-1026700104



2

I have been asked to create a BAQ showing the open POReleases along with the GL Account for each release.

I don’t see it on the PORel table, does anyone know where this is stored so I can grab it?

 


Bill Turgeon
Director, Information Technology
Coto Technology, Inc.
66 Whitecap Drive
North Kingstown, RI 02852
Phone: (401) 583-7223
Cell: (401) 368-9938
Fax: (401) 942-0920
Email: Bill.Turgeon@...
Web: www.cotorelay.com

Please consider the environment before printing this email.
This e-mail and any attachments are for the sole use of the intended recipients and may be privileged or confidential. Any distribution, printing or other use by anyone else is prohibited. If you are not an intended recipient, please contact the sender immediately, and permanently delete this e-mail and attachments.

“Come visit Coto Technology at Sensors Expo Booth #138 in Long Beach, June 10-11, to see the RedRock RR100 and all of our other Switch, Sensor, and Relay Solutions!”
3
It should be tied to the GL Control setup for the Part Class of the part being purchased on that Line of the PO.
4
Take a look at linking the PORel table and the TranGLC table.  You should find the GLAccount in the TranGLC table.
5
You have to join table tranglc.


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, April 30, 2015 5:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 905.702A - PORel GL Account


I have been asked to create a BAQ showing the open POReleases along with the GL Account for each release.
I don’t see it on the PORel table, does anyone know where this is stored so I can grab it?


Bill Turgeon
Director, Information Technology
Coto Technology, Inc.
66 Whitecap Drive
North Kingstown, RI 02852
Phone: (401) 583-7223
Cell: (401) 368-9938
Fax: (401) 942-0920
Email: Bill.Turgeon@...
Web: www.cotorelay.com
[Image removed by sender.]
Please consider the environment before printing this email.
This e-mail and any attachments are for the sole use of the intended recipients and may be privileged or confidential. Any distribution, printing or other use by anyone else is prohibited. If you are not an intended recipient, please contact the sender immediately, and permanently delete this e-mail and attachments.

“Come visit Coto Technology at Sensors Expo Booth #138 in Long Beach, June 10-11, to see the RedRock RR100 and all of our other Switch, Sensor, and Relay Solutions!”



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