How to find Bank Account Address

Yahoo Archive
1

If you can find out where the address is stored, you can create your own subreport and save it in the Epicor reports folder. You can make your own query at that point. When you add the subreport to your main report, pass the account number parameter which should be your key in the subreport query.

 

Thanks,

 

Steve

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, November 11, 2015 1:20 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] How to find Bank Account Address

 

 

Mr. Steve: The address fields on the bank form are not listed in the Data Dictionary OR listed in the DataDef - unless you know of some other way.

 

I see the bank address fields and see (using field help) where they are pointing.  I just cant get to those fields.

 

DaveO

2

We are running V10 and would like to include our bank address on our AP checks.

I see on the bank account form there is an address tab.  The address fields look like they are pointing to BankAcct.Address1, BankAcct.Address2, BankAcct.City, etc.


However if I go in to the Data Dictionary I do not see those fields for the BankAcct table.


Also, if I go into the Datadef for the APChecks there is a BankAcctID lookup and I don't see any addresses there either.


Am I missing something?  How do I use a Bank Address on my AP checks.


Thanks,


Dave Olender

Ph: 651-246-3281

3

I edited the SSRS check manually and added the address and logo on the check.

 

Thanks,

 

Steve

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, November 11, 2015 10:52 AM
To: vantage@yahoogroups.com
Subject: [Vantage] How to find Bank Account Address

 

 

We are running V10 and would like to include our bank address on our AP checks.

I see on the bank account form there is an address tab.  The address fields look like they are pointing to BankAcct.Address1, BankAcct.Address2, BankAcct.City, etc.

 

However if I go in to the Data Dictionary I do not see those fields for the BankAcct table.

 

Also, if I go into the Datadef for the APChecks there is a BankAcctID lookup and I don't see any addresses there either.

 

Am I missing something?  How do I use a Bank Address on my AP checks.

 

Thanks,

 

Dave Olender

Ph: 651-246-3281

4

Thanks Steve.


Actually I started doing that - but now we have multiple companies with multiple bank accounts.  I'd like to have just One AP Check style.


DaveO

5

Maybe make the address area a sub report and query for the address by passing the account number? There is the address field in the bank account area, as long as it is filled out.

 

Thanks,

 

Steve

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, November 11, 2015 1:03 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] How to find Bank Account Address

 

 

Thanks Steve.

 

Actually I started doing that - but now we have multiple companies with multiple bank accounts.  I'd like to have just One AP Check style.

 

DaveO

6

I read on this site that if you view the Field Help -> Technical details and "external" is checked it means the field data is stored is somewhere else, usually in the PatchFld table (temp table Epicor uses until a patch moves those fields).  I am on 9.05 so not sure if this is still true on 10... you could query the patchfld table to find out (tablename = "BankAcct" ...  Field = "Address1")




On Wed, Nov 11, 2015 at 10:52 AM, daveolender@... [vantage] <vantage@yahoogroups.com> wrote:
 
<div>
  
  
  <p><p><span></span></p><p>We are running V10 and would like to include our bank address on our AP checks.</p><p>I see on the bank account form there is an address tab.  The address fields look like they are pointing to BankAcct.Address1, BankAcct.Address2, BankAcct.City, etc.</p><p><br></p><p>However if I go in to the Data Dictionary I do not see those fields for the BankAcct table.</p><p><br></p><p>Also, if I go into the Datadef for the APChecks there is a BankAcctID lookup and I don&#39;t see any addresses there either.</p><p><br></p><p>Am I missing something?  How do I use a Bank Address on my AP checks.</p><p><br></p><p>Thanks,</p><p><br></p><p>Dave Olender</p><p>Ph: <a rel="nofollow">651-246-3281</a></p><p></p>

<p></p><p></p></div>
 


<div style="color:rgb(255,255,255);min-height:0px;"></div>



--

Sarah Vareschi ▪ Systems ManagerÂ

Â

NyproMold, Inc.

144 Pleasant St, Clinton, MA 01510 ▪ www.nypromold.com Â

D 978.368.4718Â â–ª F 978.365.4548

Â

Â

Â

This e-mail may contain information which is
confidential or privileged. The information is intended to be for the use of
the individual or entity named above. If you are not the intended
recipient, be aware that any disclosure, copying, distribution or use of the
contents of this e-mail is prohibited. In the event of any error in
transmission, unauthorized recipients are requested to contact the sender
immediately and not to disclose or make use of this information. No
employee or agent is authorized to conclude any binding agreement on behalf of
NyproMold with another party by email without express written confirmation by
NyproMold Offices.

P Please consider the environmental impact of
printing this e-mail.

7

Mr. Steve: The address fields on the bank form are not listed in the Data Dictionary OR listed in the DataDef - unless you know of some other way.


I see the bank address fields and see (using field help) where they are pointing.  I just cant get to those fields.


DaveO