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
 
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
 
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 [email protected]. Once again, Thanks

James Ingram
 
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
 
Back
Top