• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

AP to banking software interface

scole

Member
Hello,

My company is interested in exporting payables data from OneWorld (B7332) to two banking systems we use (Chase Manhattan's Insight and Den norske Bank's Telebank). In a nutshell, we want to eliminate manual rekeying of information from JDE' AP module to the banking systems when we do wire payments.

My client manager believes this would be a fairly straightforward interface to write, however I would very much like to avoid reinventing the wheel for what I consider to be a fairly generic interface.

Does anyone know of (or use) an existing interface between OneWorld and Chase Manhattan (Insight) or Den norske Bank (Telebank)?

Thanks very much,
Stuart Cole

JDEdwards OneWorld B733.2
 

JonFoster

Member
Sorry I do not have an answer to your question, but I was hoping you could answer one for me. We are relatively new to OneWorld, so I am not sure how complicated this question is. Perhaps you can point me in the right direction.

We are hoping we can define a new voucher code for wire transfers and/or ACH payments that will automatically code things to the GL as an expense and offset the cash account we designate instead of running them through our Accounts Payable Clearing account. Basically, we would like to differntiate between regular AP Vouchers and Wire type vouchers. The reasoning are two-fold. 1) It creates an audit trail that takes us back to the source for research. 2) As we are wiring the funds instead of cutting checks, we need to treat these different in JDE so we don't accidently cut checks.

Thoughts?
 

Mike Dupaix

VIP Member
re[2]: AP to banking software interface

<BODY text=3D"#000000" link=3D"#0000FF">
<font style=3D"font-family:'Arial';font-size:10pt;">Jon,


Use a different payment method during voucher entry or if a vendor is always =
paid by wire, in the supplier master. This will allow you to run your checks =
and wires in separate payment groups by specifying a specific payment method in =
the data selection. You can then control the printing of checks.


>> Sorry I do not have an answer to your question, but I was hoping you =
>> answer one for me. We are relatively new to OneWorld, so I am not =
>> how complicated this question is. Perhaps you can point me in the =
>> direction.

>> We are hoping we can define a new voucher code for wire transfers =
>> ACH payments that will automatically code things to the GL as an =
>> and offset the cash account we designate instead of running them =
>> our Accounts Payable Clearing account. Basically, we would like =
>> differntiate between regular AP Vouchers and Wire type vouchers. =
>> reasoning are two-fold. 1) It creates an audit trail that takes us =
>> to the source for research. 2) As we are wiring the funds instead =
>> cutting checks, we need to treat these different in JDE so we =
>> accidently cut checks.

>> Thoughts?

>> --------------------------

>> Visit the forum to view this thread at:

>> </font><a =
href=3D"http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=3D&Board=3DOW=
>> =3D11893

>>
 

vap

Active Member
Jon,

You may use a different doc type (and can link it to different accounts
in distribution, not in financials). All of your reasoning is correct.

However, JDEdwards way of differentiating different methods of payment
is Payment Instrument code, which you can also link to different print
payment UBE's (if you use automatic payment processing). You may
consider using it in addition to different doc types. Payment instrument
is set on supplier master and can be overridden in voucher entry (or
changed in Speed Release)

Regards,
Vladimir Ponomarev
B733, B7331, B7332, XE (mostly XE at the moment); SQL 7.0, Oracle 8.1.5,
DB/400 (mostly SQL); Wintel, HP, AS/400 (mostly Wintel)
 

cwambolt

Member
I realize this post is over a year old, but was wondering if you figured out how to extract the JDE payment information and feed it into your 3rd-party system?

I am faced with a similiar problem. I want to be able to extract information from the F47 EDI payment outbound tables and feed it to our Sterling Gentran EDI software to have it send the appropriate ANSI 820 formatted file to the banks via FTP server.
 

ame

Reputable Poster
Please see my response on other email.



I am faced with a similiar problem. I want to be able to extract
information from the F47 EDI payment outbound tables and feed it to our
Sterling Gentran EDI software to have it send the appropriate ANSI 820
formatted file to the banks via FTP server.
 

jdedave

Active Member
Can you please let me know how do you feed the EDI payment outbound tables to another system. Did you wrote a program to create a file or what method you used?
We are in a process of looking for EDI payments and collecting information about this process. Can you please explain how it works and your setup, will really appreciate you help.

Thanks
David
XE, SQL 2000
 
Top