• 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!

Importing Purchase orders from an outside system

Jing_lex

Member
Hello All:

I have a third party system that will generate purchase orders. I would like to interface that file to OneWorld Xe. Anybody got suggestions on how I can accomplish this task. I hope there is an intermediate file I can populate and then call a UBE that will populate all the OneWorld Xe files properly. Thanks in advacnce.

James Ingram
 

Adrian_Chimirel

Legendary Poster
Hello James,
1-Your hope was not only heard but also materialized by JDE; there is a cozy guide I grabbed from the KG, "Interoperability B7332" (a compressed .html document I could send to you if you can't find it & provide an email address - I guess you have already noticed that the list/forum doesn't allow attachments). It describes the Header & Detail files to be populated with POs.
2-More than that, you may find something on the Xe Docs-CD, in any (Distribution included) Manual (something like Batch Process ...)
Good luck,
Adrian Chimirel

LIVE: B732.1 SP12.2, Oracle 805
SANDBOX: XE SP13, 8i
RS/6000, Citrix, 200+ clients
 

Jing_lex

Member
Adrian

Thank you, I will see if I can download that document from the KG. I am still relatively new to OneWorld Xe. It looks like fun so far. I will edit my usercode to include my email address, but for now, it is JIngram@dkmail.com. Once again, Thanks

James Ingram
 

jbrown

Member
This is a multi-part message in MIME format.

------_=_NextPart_001_01C08C0F.E772C370
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
charset="iso-8859-1"

We have built a web-based requisition system (we determined that, for =
people
who would only be in OW to place requisitions, it was too onerous to =
have
them use OW from a licensing and training perspective), outside of OW, =
that
populates the F4301Z1 and F4311Z1 interoperability tables. Purchasing =
staff
then reviews the information in these tables and runs R4311Z1I to =
convert
the entries to real purchase orders. We added a table in OW that links =
the
purchase order number with the requisition number, so the requisition =
system
can see what the PO # is once it is assigned (since we'd want to purge =
the
Z-tables from time to time). The system works well. Let me know if =
you'd
like further details.

James
 
Hello James!

We are trying to enter Reqs outside OW using a web based application and
then bring them in as you explained in your post. I am interested in a few
more details. I was hoping that you could answer a few questions for me:

1. When the reqs are coming into the 4301Z and 4311Z files, what order
type are they coming in as --OP or ORs?

2. If the answer to #1 is OP, how are you getting committments against
projects?

3. After the R4311Z1I has been run, is the Req # then entered into the Z1
files?

I have tried to get this process working and have run into some problems.
Any insite you could provide woulod be greatly appreciated.


Thanks!
AM Kremer
Xe SP 13 coexistenet
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
 
Top