Where is Cash Discount Taken Stored? E10.0.700.4

Good, thanks. I missed it the first time, mainly because I didn't look very hard. :-)

Joe

On Wed, Jan 20, 2016 at 10:32 AM, Dora Chavarria dorachavarria87@... [vantage] <vantage@yahoogroups.com> wrote:

Â
<div>
  
  
  <p></p><div style="color:#000;background-color:#fff;font-family:HelveticaNeue-Light, Helvetica Neue Light, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px;"><div dir="ltr"><span>cashdtl.docdiscount?</span></div><div></div><div> </div><div>Dora Chavarria  

Sr. Consultant Analysis Services, ERP Â
Mayan Technologies USA, Inc. dchavarria@… www.mayantechs.comÂ



On Wednesday, January 20, 2016 5:50 AM, "Manasa Reddy manasa.reddy@… [vantage]" <vantage@yahoogroups.com> wrote:



Â

<div>
  
  
  <div>
Off the top of my head I don’t know, but since the discount only happens once payment is made I would play around with the payment screen to see the fields used.
Â
Manasa
Â
Â
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, January 19, 2016 6:22 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Where is Cash Discount Taken Stored? E10.0.700.4
Â
Â
Hi,
I'm trying to calculate commissions based on invoice transaction history. I can find everything but the terms/cash discount amount taken on a particular invoice.
CasthDtl and TranGLC seem to have all the other data.
I'm guessing the cash discount gets lumped together in TranGLC. Maybe it's stored somewhere else for the invoice?
Thanks,
Joe
--
Joe D. Trent
Bigham Ag Equipment
Â
IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.
IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.
</div>
 


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


</div>
 


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

Hi,

I'm trying to calculate commissions based on invoice transaction history. I can find everything but the terms/cash discount amount taken on a particular invoice.

CasthDtl and TranGLC seem to have all the other data.

I'm guessing the cash discount gets lumped together in TranGLC. Maybe it's stored somewhere else for the invoice?

Thanks,

Joe

--

Joe D. Trent

Bigham Ag Equipment


Off the top of my head I don’t know, but since the discount only happens once payment is made I would play around with the payment screen to see the fields used.

 

Manasa

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, January 19, 2016 6:22 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Where is Cash Discount Taken Stored? E10.0.700.4

 

 

Hi,

I'm trying to calculate commissions based on invoice transaction history. I can find everything but the terms/cash discount amount taken on a particular invoice.

CasthDtl and TranGLC seem to have all the other data.

I'm guessing the cash discount gets lumped together in TranGLC. Maybe it's stored somewhere else for the invoice?

Thanks,

Joe

--

Joe D. Trent

Bigham Ag Equipment

 

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.
cashdtl.docdiscount?
 
Dora Chavarria   Sr. Consultant Analysis Services, ERP   Mayan Technologies USA, Inc. dchavarria@... www.mayantechs.com 


On Wednesday, January 20, 2016 5:50 AM, "Manasa Reddy manasa.reddy@... [vantage]" <vantage@yahoogroups.com> wrote:


 
<div id="ygrps-yiv-624744932yiv4173065302ygrp-text">
  
  
  <div>
Off the top of my head I don’t know, but since the discount only happens once payment is made I would play around with the payment screen to see the fields used.
 
Manasa
 
 
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, January 19, 2016 6:22 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Where is Cash Discount Taken Stored? E10.0.700.4
 
 
Hi,
I'm trying to calculate commissions based on invoice transaction history. I can find everything but the terms/cash discount amount taken on a particular invoice.
CasthDtl and TranGLC seem to have all the other data.
I'm guessing the cash discount gets lumped together in TranGLC. Maybe it's stored somewhere else for the invoice?
Thanks,
Joe
--
Joe D. Trent
Bigham Ag Equipment
 
IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.
IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.
</div>
 


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

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302ygrp-mkp #ygrps-yiv-624744932yiv4173065302hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302ygrp-mkp #ygrps-yiv-624744932yiv4173065302ads {
margin-bottom:10px;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302ygrp-mkp .ygrps-yiv-624744932yiv4173065302ad {
padding:0 0;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302ygrp-mkp .ygrps-yiv-624744932yiv4173065302ad p {
margin:0;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302ygrp-mkp .ygrps-yiv-624744932yiv4173065302ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302ygrp-sponsor #ygrps-yiv-624744932yiv4173065302ygrp-lc {
font-family:Arial;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302ygrp-sponsor #ygrps-yiv-624744932yiv4173065302ygrp-lc #ygrps-yiv-624744932yiv4173065302hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302ygrp-sponsor #ygrps-yiv-624744932yiv4173065302ygrp-lc .ygrps-yiv-624744932yiv4173065302ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302activity span {
font-weight:700;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302activity span span {
color:#ff7900;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302activity span .ygrps-yiv-624744932yiv4173065302underline {
text-decoration:underline;}

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

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 .ygrps-yiv-624744932yiv4173065302attach div a {
text-decoration:none;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 .ygrps-yiv-624744932yiv4173065302attach img {
border:none;padding-right:5px;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 .ygrps-yiv-624744932yiv4173065302attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 .ygrps-yiv-624744932yiv4173065302attach label a {
text-decoration:none;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 .ygrps-yiv-624744932yiv4173065302bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 .ygrps-yiv-624744932yiv4173065302bold a {
text-decoration:none;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 dd.ygrps-yiv-624744932yiv4173065302last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 dd.ygrps-yiv-624744932yiv4173065302last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 dd.ygrps-yiv-624744932yiv4173065302last p span.ygrps-yiv-624744932yiv4173065302yshortcuts {
margin-right:0;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 div.ygrps-yiv-624744932yiv4173065302attach-table div div a {
text-decoration:none;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 div.ygrps-yiv-624744932yiv4173065302attach-table {
width:400px;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 div.ygrps-yiv-624744932yiv4173065302file-title a, #ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 div.ygrps-yiv-624744932yiv4173065302file-title a:active, #ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 div.ygrps-yiv-624744932yiv4173065302file-title a:hover, #ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 div.ygrps-yiv-624744932yiv4173065302file-title a:visited {
text-decoration:none;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 div.ygrps-yiv-624744932yiv4173065302photo-title a, #ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 div.ygrps-yiv-624744932yiv4173065302photo-title a:active, #ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 div.ygrps-yiv-624744932yiv4173065302photo-title a:hover, #ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 div.ygrps-yiv-624744932yiv4173065302photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 div#ygrps-yiv-624744932yiv4173065302ygrp-mlmsg #ygrps-yiv-624744932yiv4173065302ygrp-msg p a span.ygrps-yiv-624744932yiv4173065302yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 .ygrps-yiv-624744932yiv4173065302green {
color:#628c2a;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 .ygrps-yiv-624744932yiv4173065302MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 o {
font-size:0;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302photos div {
float:left;width:72px;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

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

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302reco-category {
font-size:77%;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302reco-desc {
font-size:77%;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 .ygrps-yiv-624744932yiv4173065302replbq {
margin:4px;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302ygrp-mlmsg select, #ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 input, #ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302ygrp-mlmsg pre, #ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 code {
font:115% monospace;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302ygrp-mlmsg #ygrps-yiv-624744932yiv4173065302logo {
padding-bottom:10px;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302ygrp-msg p#ygrps-yiv-624744932yiv4173065302attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302ygrp-reco #ygrps-yiv-624744932yiv4173065302reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302ygrp-sponsor #ygrps-yiv-624744932yiv4173065302ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302ygrp-sponsor #ygrps-yiv-624744932yiv4173065302ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302ygrp-sponsor #ygrps-yiv-624744932yiv4173065302ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302ygrp-text {
font-family:Georgia;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302ygrp-text tt {
font-size:120%;}

#ygrps-yiv-624744932 #ygrps-yiv-624744932yiv4173065302 #ygrps-yiv-624744932yiv4173065302ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-624744932