EDI Processing

[harkinj20]

Can anyone please tell me the Processes involved for automating the entry of Supplier Invoices.We Currently run a Two Way Match Process and would like the Purchase Order Status automatically updated once the Invoice has been matched to the Purchase Order

B733.1
NT & SQL 2000

Currently upgrading to Xe

 

[ame]

What programs are you running on the inbound side to process the supplier's
invoices? Are they truly a 2 way match type order?



B733.1
NT & SQL 2000

Currently upgrading to Xe

 

[harkinj20]

we are using the p0411 with Processing Options set to run Voucher Match Program P4314 )

 

[ame]

are you actually doing this from an inbound EDI document or are you talking
generally? Normally... on a 2 way match... it will update your PO to a
400-999 status when it's "received" which is running the P0411 with the
P4314 (which is what you are doing)... Is your PO status before being
matched 280-400 or something close?

 

[harkinj20]

We are currently doing this through normal JDE programs but would like to achieve the same through EDI. Status of Purchase order lines before match are 280-400

 

[ame]

Okay... if you populate the data inbound into the EDI Files (System
47)...which would be F47041 (header), F47042 (Detail), F47044 (Additional
Header), F4706 (Address), F4714 (header text), F4715 (Detail Text)... then
you can run the R47071 (which in turn runs the R04110Z) to process the
records... the gotcha I found in the past is that you need Order Number,
Document type, Line number... and COMPANY number ... to help match against
the PO file... I am not sure when you bring it in if you are bringing it in
through an EDI translator (Like Sterling, Extol, or Invois - aka
Peregrine/Harbinger).... or if you are using a flat file, but either way
will work.... let me know... thanks, Bobby

 

[harkinj20]

Bobby , Thanks for the advice . I will try as you suggested and let you know.

Regards

james

 

[THOMASSIN]

Can anyone please tell me the Processes involved for automating the entry of Sales Orders.
Thanks for your help.

 

[ame]

Are you on XE or World? are you using an EDI translator and if so... which
one?






Thanks for your help.

 

[THOMASSIN]

We are on Oneworld B7331 SP 7.1.
We are not using EDI translator but only MS ACCESS to add data on F47011 and F47012.
We use R47011 batch. Is it correct ?

Thanks.

 

[ame]

Hi Denis - You are correct that P47011 is correct. I am not sure how
getting the MS Access to a scheduler... but you may try to add it and see if
it will work (best idea is to run this on a fat client)... Any way... you
should be able to put the P47011 on a job scheduler and it will update your
records ... one thing you may look at... JDE has a flat file process so you
can pull it out of Access and into a flat file and send to JDE... the down
side of this is that the flat file has to be EXACTLY like the JDE file...
what it does by you though... is allows the scheduler to look for a file
that it hasn't processed.. if it does then it will process ... otherwise it
will wait... or you can just set it up on a scheduler to run at certain
times of the day (which sometimes works out well for customer service so
they know when to expect "new" orders)... any way... let me know what you
think.. thanks bobby






We are not using EDI translator but only MS ACCESS to add data on F47011 and
F47012.
We use R47011 batch. Is it correct ?

Thanks.

 

[THOMASSIN]

I use R47011 program. I put datas in F47011 and F47012 tables. R47011 programs add sale orders in F4201 et F4211 tables. Some item informations (SRP1, SRP2, ... PRP1, ..) are not initialize by R47011. Item availibility does not run.
Do you know these problems ?
Thank you for your help.