Chart Tracker Add Column

system · July 18, 2014, 10:28am

I was able to complete this by using the dynamic query method and adding columns, the hard part was figuring out how to get to the results I wanted in the BAQ. I had to use the TranGL and the parttran tables using some of the numbered key fields as links. Once I was getting the right PO number and line for a journal entry I was good to go and just inserted the columns and had a dynamic query run on the Initializerow event.

system · June 30, 2014, 2:36pm

Hello Group,

I have a question regarding the Chart Tracker (Financial Management > General Ledger > General Operations > Chart Tracker)

In this screen there is a tab I want to add some columns to. I want to add PO Num and Part Num to the grid located on Transaction Detail > Specific > Detail tab. This grid shows Journal Entry Detail information. If you highlight a rows there then click on the Transaction Detail > Specific > Cost Transaction tab and click retrieve it grabs information for that journal entry. I want to add the PO Num and Part Num field from this grid to the first grid from the Detail Tab.

However I'm unable to find the way the Cost Transaction tab is getting the information. When I trace what happens when the retrieve button is clicked it shows the gird is using BO GLCostTrans and Method GetRowsCustom. The only parameter that is being entered is the glJrnDtlRowid.

I've used the BO reader and dynamic queries to add columns to grids however I'm not sure on how to apply the glJrnDtlRowid to achieve the goal of adding the column's values. Any insight into this would appreciated.

Thanks

system · June 30, 2014, 2:46pm

Have you tried the personalization to add these columns?

All grid views have certain fields that are â€œhiddenâ€. Once you know what fields are there, you can unhide them.

All you do is right-click on a grid view and click on personalization (or click on Tools â€“ personalization â€“ then click on the grid view). Click on the actual gridâ€¦.you should see the Columns row (with Collection). Click on collection so that the drop down arrow comes up and see if those fields are there. You can sort the field name column to find the fields easier.

I did not check on the grid view you mentioned to see if those fields are available. Just throwing that out there.

M. Manasa Reddy

manasa.reddy@...

281-994-3483 [d] | 773-401-4126 [m]

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, June 30, 2014 1:37 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Chart Tracker Add Column

Hello Group,

I have a question regarding the Chart Tracker (Financial Management > General Ledger > General Operations > Chart Tracker)

In this screen there is a tab I want to add some columns to. I want to add PO Num and Part Num to the grid located on Transaction Detail > Specific > Detail tab. This grid shows Journal Entry Detail information. If you highlight a rows there then click on the Transaction Detail > Specific > Cost Transaction tab and click retrieve it grabs information for that journal entry. I want to add the PO Num and Part Num field from this grid to the first grid from the Detail Tab.

However I'm unable to find the way the Cost Transaction tab is getting the information. When I trace what happens when the retrieve button is clicked it shows the gird is using BO GLCostTrans and Method GetRowsCustom. The only parameter that is being entered is the glJrnDtlRowid.

I've used the BO reader and dynamic queries to add columns to grids however I'm not sure on how to apply the glJrnDtlRowid to achieve the goal of adding the column's values. Any insight into this would appreciated.

Thanks

system · June 30, 2014, 4:20pm

Thanks for the response,

yes, these columns are not available in the grid currently. I will need to add them via the BO Reader or Dynamic Query. However I'm not sure how the second grid is using the information in first grid to retrieve the PO and Part Number. It looks like it is using the glJrnDtlRowID, but i'm not sure how that is being used.

system · June 30, 2014, 4:30pm

You may have to add a foreign key view to get the transglc table added. In the transglc key1 is used for PONum, key2 is used for POLine, and key3 is used for PORelease, IF the transaction record is PUR-INS, PUR-UNK, PUR-STK, et al

Start by looking at the key1, key2, key3 values found under trandetail/transglc detail. I am looking at the same thing so if I get it to work i will do a followup here as well

On Monday, June 30, 2014 4:20 PM, "jarradlayne@... [vantage]" <vantage@yahoogroups.com> wrote:

<div id="ygrps-yiv-951168233yiv5729120459ygrp-text">
  
  
  <div>Thanks for the response,</div><div><br clear="none"></div><div>yes, these columns are not available in the grid currently. I will need to add them via the BO Reader or Dynamic Query. However I&#39;m not sure how the second grid is using the information in first grid to retrieve the PO and Part Number. It looks like it is using the glJrnDtlRowID, but i&#39;m not sure how that is being used.</div>

</div>
 


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

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459 -- #ygrps-yiv-951168233yiv5729120459ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459ygrp-mkp #ygrps-yiv-951168233yiv5729120459hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459ygrp-mkp #ygrps-yiv-951168233yiv5729120459ads {
margin-bottom:10px;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459ygrp-mkp .ygrps-yiv-951168233yiv5729120459ad {
padding:0 0;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459ygrp-mkp .ygrps-yiv-951168233yiv5729120459ad p {
margin:0;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459ygrp-mkp .ygrps-yiv-951168233yiv5729120459ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459ygrp-sponsor #ygrps-yiv-951168233yiv5729120459ygrp-lc {
font-family:Arial;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459ygrp-sponsor #ygrps-yiv-951168233yiv5729120459ygrp-lc #ygrps-yiv-951168233yiv5729120459hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459ygrp-sponsor #ygrps-yiv-951168233yiv5729120459ygrp-lc .ygrps-yiv-951168233yiv5729120459ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459activity span {
font-weight:700;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459activity span span {
color:#ff7900;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459activity span .ygrps-yiv-951168233yiv5729120459underline {
text-decoration:underline;}

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

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 .ygrps-yiv-951168233yiv5729120459attach div a {
text-decoration:none;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 .ygrps-yiv-951168233yiv5729120459attach img {
border:none;padding-right:5px;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 .ygrps-yiv-951168233yiv5729120459attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 .ygrps-yiv-951168233yiv5729120459attach label a {
text-decoration:none;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 .ygrps-yiv-951168233yiv5729120459bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 .ygrps-yiv-951168233yiv5729120459bold a {
text-decoration:none;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 dd.ygrps-yiv-951168233yiv5729120459last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 dd.ygrps-yiv-951168233yiv5729120459last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 dd.ygrps-yiv-951168233yiv5729120459last p span.ygrps-yiv-951168233yiv5729120459yshortcuts {
margin-right:0;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 div.ygrps-yiv-951168233yiv5729120459attach-table div div a {
text-decoration:none;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 div.ygrps-yiv-951168233yiv5729120459attach-table {
width:400px;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 div.ygrps-yiv-951168233yiv5729120459file-title a, #ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 div.ygrps-yiv-951168233yiv5729120459file-title a:active, #ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 div.ygrps-yiv-951168233yiv5729120459file-title a:hover, #ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 div.ygrps-yiv-951168233yiv5729120459file-title a:visited {
text-decoration:none;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 div.ygrps-yiv-951168233yiv5729120459photo-title a, #ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 div.ygrps-yiv-951168233yiv5729120459photo-title a:active, #ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 div.ygrps-yiv-951168233yiv5729120459photo-title a:hover, #ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 div.ygrps-yiv-951168233yiv5729120459photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 div#ygrps-yiv-951168233yiv5729120459ygrp-mlmsg #ygrps-yiv-951168233yiv5729120459ygrp-msg p a span.ygrps-yiv-951168233yiv5729120459yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 .ygrps-yiv-951168233yiv5729120459green {
color:#628c2a;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 .ygrps-yiv-951168233yiv5729120459MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 o {
font-size:0;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459photos div {
float:left;width:72px;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

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

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459reco-category {
font-size:77%;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459reco-desc {
font-size:77%;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 .ygrps-yiv-951168233yiv5729120459replbq {
margin:4px;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459ygrp-mlmsg select, #ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 input, #ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459ygrp-mlmsg pre, #ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 code {
font:115% monospace;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459ygrp-mlmsg #ygrps-yiv-951168233yiv5729120459logo {
padding-bottom:10px;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459ygrp-msg p#ygrps-yiv-951168233yiv5729120459attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459ygrp-reco #ygrps-yiv-951168233yiv5729120459reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459ygrp-sponsor #ygrps-yiv-951168233yiv5729120459ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459ygrp-sponsor #ygrps-yiv-951168233yiv5729120459ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459ygrp-sponsor #ygrps-yiv-951168233yiv5729120459ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459ygrp-text {
font-family:Georgia;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459ygrp-text tt {
font-size:120%;}

#ygrps-yiv-951168233 #ygrps-yiv-951168233yiv5729120459 #ygrps-yiv-951168233yiv5729120459ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-951168233

system · June 30, 2014, 4:30pm

You can also add them with a BPM using the User define fields.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, June 30, 2014 1:20 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Chart Tracker Add Column

Thanks for the response,

yes, these columns are not available in the grid currently. I will need to add them via the BO Reader or Dynamic Query. However I'm not sure how the second grid is using the information in first grid to retrieve the PO and Part Number. It looks like it is using the glJrnDtlRowID, but i'm not sure how that is being used.