E10 : Customization to show Invoice selection on UD Form

Sorry Bernie, I forget to note that I have testing with demo database and my sentence not clear.
I want to Duplicate Invoice Selection from Cash Receipts Entry to my UD03 Form by trying to use CashRecGetInvoices method on CashRecAdapter, but sadly when I try with my code It return null to dataset. Please help me?
Pic1 Pic2
 
Sorry my english is not good.
Thanks
nuttt


On Tuesday, October 7, 2014 6:13 PM, "Bernie Walker bwalker@... [vantage]" <vantage@yahoogroups.com> wrote:


 
<div id="ygrps-yiv-1605988385yiv2965715702ygrp-text">
  
  
  <div>
You still have ‘open’ invoices from over 4 years ago?
 
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, October 07, 2014 1:11 AM
To: vantage@yahoogroups.com
Subject: [Vantage] E10 : Customization to show Invoice selection on UD Form
 



Hi users and experts;
I am trying to use CashRecGetInvoices method on CashRecAdapter to show invoice selection from Cash Receipts Entry to show on my gird on the UD03 Form, But my dataset that return from use that method always null. I cannot figure out which I have missing? Please could you help.
My step is :
1. Tracing and get :
<businessObject>Erp.Proxy.BO.CashRecImpl</businessObject>
  <methodName>CashRecGetInvoices</methodName>
  <returnType>ARInvcAllocTableset</returnType>
  <parameters>
    <parameter name="payDay" type="DateTime"><![CDATA[8/23/2010 12:00:00 AM]]></parameter>
    <parameter name="whereClause" type="System.String"><![CDATA[CurrencyCode = 'USD' AND OpenInvoice = true AND Posted = true AND ( CustNum = 9 )]]></parameter>
    <parameter name="CallContext" type="Ice.Bpm.Context.ContextDataSet">
    </parameter>
  </parameters>
2. Customization on UD03 Form add epiultragrid, epibutton and call CashRecAdapter :
private void epiButtonC1_Click(object sender, System.EventArgs args)
{
   CashRecAdapter CashAdapter = new CashRecAdapter(this.oTrans);
   CashAdapter.BOConnect();
   DateTime DT = Convert.ToDateTime("08/23/2010 12:00:00 AM");
   Erp.BO.ARInvcAllocDataSet dsCash = CashAdapter.CashRecGetInvoices(DT, "CurrencyCode = 'USD' AND OpenInvoice = true AND Posted = true AND ( CustNum = 9 )");
   CashAdapter.Dispose();
   this.epiUltraGridC1.DataSource = dsCash;
   this.epiUltraGridC1.DataBind();
}
Thanks
nuttt.
 



</div>
 


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

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702ygrp-mkp #ygrps-yiv-1605988385yiv2965715702hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702ygrp-mkp #ygrps-yiv-1605988385yiv2965715702ads {
margin-bottom:10px;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702ygrp-mkp .ygrps-yiv-1605988385yiv2965715702ad {
padding:0 0;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702ygrp-mkp .ygrps-yiv-1605988385yiv2965715702ad p {
margin:0;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702ygrp-mkp .ygrps-yiv-1605988385yiv2965715702ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702ygrp-sponsor #ygrps-yiv-1605988385yiv2965715702ygrp-lc {
font-family:Arial;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702ygrp-sponsor #ygrps-yiv-1605988385yiv2965715702ygrp-lc #ygrps-yiv-1605988385yiv2965715702hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702ygrp-sponsor #ygrps-yiv-1605988385yiv2965715702ygrp-lc .ygrps-yiv-1605988385yiv2965715702ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702activity span {
font-weight:700;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702activity span span {
color:#ff7900;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702activity span .ygrps-yiv-1605988385yiv2965715702underline {
text-decoration:underline;}

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

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 .ygrps-yiv-1605988385yiv2965715702attach div a {
text-decoration:none;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 .ygrps-yiv-1605988385yiv2965715702attach img {
border:none;padding-right:5px;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 .ygrps-yiv-1605988385yiv2965715702attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 .ygrps-yiv-1605988385yiv2965715702attach label a {
text-decoration:none;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 .ygrps-yiv-1605988385yiv2965715702bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 .ygrps-yiv-1605988385yiv2965715702bold a {
text-decoration:none;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 dd.ygrps-yiv-1605988385yiv2965715702last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 dd.ygrps-yiv-1605988385yiv2965715702last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 dd.ygrps-yiv-1605988385yiv2965715702last p span.ygrps-yiv-1605988385yiv2965715702yshortcuts {
margin-right:0;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 div.ygrps-yiv-1605988385yiv2965715702attach-table div div a {
text-decoration:none;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 div.ygrps-yiv-1605988385yiv2965715702attach-table {
width:400px;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 div.ygrps-yiv-1605988385yiv2965715702file-title a, #ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 div.ygrps-yiv-1605988385yiv2965715702file-title a:active, #ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 div.ygrps-yiv-1605988385yiv2965715702file-title a:hover, #ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 div.ygrps-yiv-1605988385yiv2965715702file-title a:visited {
text-decoration:none;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 div.ygrps-yiv-1605988385yiv2965715702photo-title a, #ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 div.ygrps-yiv-1605988385yiv2965715702photo-title a:active, #ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 div.ygrps-yiv-1605988385yiv2965715702photo-title a:hover, #ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 div.ygrps-yiv-1605988385yiv2965715702photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 div#ygrps-yiv-1605988385yiv2965715702ygrp-mlmsg #ygrps-yiv-1605988385yiv2965715702ygrp-msg p a span.ygrps-yiv-1605988385yiv2965715702yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 .ygrps-yiv-1605988385yiv2965715702green {
color:#628c2a;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 .ygrps-yiv-1605988385yiv2965715702MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 o {
font-size:0;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702photos div {
float:left;width:72px;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

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

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702reco-category {
font-size:77%;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702reco-desc {
font-size:77%;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 .ygrps-yiv-1605988385yiv2965715702replbq {
margin:4px;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702ygrp-mlmsg select, #ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 input, #ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702ygrp-mlmsg pre, #ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 code {
font:115% monospace;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702ygrp-mlmsg #ygrps-yiv-1605988385yiv2965715702logo {
padding-bottom:10px;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702ygrp-msg p#ygrps-yiv-1605988385yiv2965715702attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702ygrp-reco #ygrps-yiv-1605988385yiv2965715702reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702ygrp-sponsor #ygrps-yiv-1605988385yiv2965715702ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702ygrp-sponsor #ygrps-yiv-1605988385yiv2965715702ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702ygrp-sponsor #ygrps-yiv-1605988385yiv2965715702ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702ygrp-text {
font-family:Georgia;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702ygrp-text tt {
font-size:120%;}

#ygrps-yiv-1605988385 #ygrps-yiv-1605988385yiv2965715702 #ygrps-yiv-1605988385yiv2965715702ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-1605988385



Hi users and experts;

I am trying to use CashRecGetInvoices method on CashRecAdapter to show invoice selection from Cash Receipts Entry to show on my gird on the UD03 Form, But my dataset that return from use that method always null. I cannot figure out which I have missing? Please could you help.

My step is :

1. Tracing and get :

<businessObject>Erp.Proxy.BO.CashRecImpl</businessObject>

  <methodName>CashRecGetInvoices</methodName>

  <returnType>ARInvcAllocTableset</returnType>

  <parameters>

    <parameter name="payDay" type="DateTime"><![CDATA[8/23/2010 12:00:00 AM]]></parameter>

    <parameter name="whereClause" type="System.String"><![CDATA[CurrencyCode = 'USD' AND OpenInvoice = true AND Posted = true AND ( CustNum = 9 )]]></parameter>

    <parameter name="CallContext" type="Ice.Bpm.Context.ContextDataSet">

    </parameter>

  </parameters>

2. Customization on UD03 Form add epiultragrid, epibutton and call CashRecAdapter :

private void epiButtonC1_Click(object sender, System.EventArgs args)

{

   CashRecAdapter CashAdapter = new CashRecAdapter(this.oTrans);

   CashAdapter.BOConnect();

   DateTime DT = Convert.ToDateTime("08/23/2010 12:00:00 AM");

   Erp.BO.ARInvcAllocDataSet dsCash = CashAdapter.CashRecGetInvoices(DT, "CurrencyCode = 'USD' AND OpenInvoice = true AND Posted = true AND ( CustNum = 9 )");

   CashAdapter.Dispose();

   this.epiUltraGridC1.DataSource = dsCash;

   this.epiUltraGridC1.DataBind();

}

Thanks

nuttt.


You still have ‘open’ invoices from over 4 years ago?

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, October 07, 2014 1:11 AM
To: vantage@yahoogroups.com
Subject: [Vantage] E10 : Customization to show Invoice selection on UD Form

 




Hi users and experts;

I am trying to use CashRecGetInvoices method on CashRecAdapter to show invoice selection from Cash Receipts Entry to show on my gird on the UD03 Form, But my dataset that return from use that method always null. I cannot figure out which I have missing? Please could you help.

My step is :

1. Tracing and get :

<businessObject>Erp.Proxy.BO.CashRecImpl</businessObject>

  <methodName>CashRecGetInvoices</methodName>

  <returnType>ARInvcAllocTableset</returnType>

  <parameters>

    <parameter name="payDay" type="DateTime"><![CDATA[8/23/2010 12:00:00 AM]]></parameter>

    <parameter name="whereClause" type="System.String"><![CDATA[CurrencyCode = 'USD' AND OpenInvoice = true AND Posted = true AND ( CustNum = 9 )]]></parameter>

    <parameter name="CallContext" type="Ice.Bpm.Context.ContextDataSet">

    </parameter>

  </parameters>

2. Customization on UD03 Form add epiultragrid, epibutton and call CashRecAdapter :

private void epiButtonC1_Click(object sender, System.EventArgs args)

{

   CashRecAdapter CashAdapter = new CashRecAdapter(this.oTrans);

   CashAdapter.BOConnect();

   DateTime DT = Convert.ToDateTime("08/23/2010 12:00:00 AM");

   Erp.BO.ARInvcAllocDataSet dsCash = CashAdapter.CashRecGetInvoices(DT, "CurrencyCode = 'USD' AND OpenInvoice = true AND Posted = true AND ( CustNum = 9 )");

   CashAdapter.Dispose();

   this.epiUltraGridC1.DataSource = dsCash;

   this.epiUltraGridC1.DataBind();

}

Thanks

nuttt.