AP Voucher EDI - Format 810

Tino Di Natali

Member
Hi there
I need to import AP vouchers through EDI.
From what the documentation says I must import into F47041 and F47042 using R47002C.
My problem is that I cannot seem to get the right format.
The job always ends in error.

Question 1 - Does the import format have to match the file format? I assume yes!
Question 2 - Do I have to use also F47044?
Question 3 - Do I have to delimit also numeric fields using the field delimiter or only char/string? what about date fields?

Does anyone have a working import file that I could use as an example?
I very much appreciate any help here.

tino
 
Hi Tino,

Just like you will see here all the time, we really need to know the JDE release/version etc. that you are using.

In general you may not have to map to the F47044. Much depends on your setups with inbound invoice processing. Are you doing 2 or three way matching? There can be some issues with how the invoice matching works; depends on versions etc.

Because the setup parameters are so dynamic with JDE, one configuration will not work while another will. The documentation is pretty bad in the EDI area for processing setup/options. The only way is trial and error.

When mapping, take a minimalist approach. Start with only the very basic data, get it working then incrementally add other data points to more fully define the process.

Configuration options in the item master, address book, customer master and AP all have an impact on how the functions will execute. Walk through a specific example, checking every option; document it and walk it through. If you take a hit/miss approach it could take a long time; or you could get lucky.

Define your business requirements, validate the setup parameters, select a single customer, decide on invoice matching technique and go from there.

Cheers,

Skip Stein
 
Hi Skip.

Thanks for the reply.
The version in use is 8.10
The process is simple: EDI invoices should create AP Vouchers. No inventory, no matching, only F0411/F0911

I have, as you suggest, taken a minimalist approach. One record for the header, one for the detail. Just company, supplier, value.
The job ends in error and all the workcentre says "job did not finish correctly".

I am assuming the format is simply wrong. Regarding the delimiters, I tried in delimiting only strings, strings and dates, strings and dates and numerics. All to no avail.
This is why I am (almost) convinced the problem is in the format, hence, me asking if anyone knows the correct format to use.

Once I get JDE to accept the records, then I can start looking into the errors, issues, etc.

Rgds, tino.
 
I have attached a word document listing the fields that should be filled to process the inbound invoice. Try to verify that these are correctly filled and give it another shot!

Skip
 
Hi Skip

thanks a lot. I will have a look straight away.
However, considering that these are going to be AP Vouchers only, without any relation to Inventory and without an existing purchase order, do I still need to provide KCOO/DCTO/DOCO/LNID? I guess I'll find out, and if that is the case, then I will have to mock something up ...

The question more important, though, is regarding the physical appearance of the CSV file. The format, that is.
If I want to upload into F4071 and F4074, is it correct that I have to provide a CSV file which includes all fields from these tables, filling only required values and leaving the remainder of the fields empty? (= present but without value)

This is my biggest issue: The physical format of the CSV file to upload.

Sorry if I have confused you.

Rgds. tino
 
I'm sorry but can't help you with the CSV format. I never use that obsolete interface (although many still do). I recommend a proper EDI translation/communication tool/program. It allows direct mapping and data translation into the F47 files so JDE can process the data in a more controlled format.

Cheers,

Skip Stein
 
Hi Tino,

We do EDI using the obsolete CSV interface, although we do not do AP Vouchers specifically.

You certainly should have all fields present, even if empty, for spacing purposes to load the F47 tables.

Are you using a translator service or VAN to collect documents from customers? We use TrueCommerce, so we worked with them to create file layouts for the JDE tables. I included all columns so that future needs would be easier to handle.

Also, do you have the correct path set up in P47002 Flat File Cross Reference?

Jer
 
Hi JMast

Thanks for the info. Yes, that's what I thought, all fields present. Do you delimiter also the numeric values and dates or only string/char fields?

Regarding the path, it is set correctly, that I'm sure of.

Regarding the translator service .. well, the company gets an XML from a purchasing service that provides services for a number of vendors (cc-Hubwoo). The translator maps it to an initial CSV file (the team around EDI do not want anything to do with JDE, so they use a basic non-descript flat file).
I then have to spec a prog that converts the initial CSV into a CSV that carries JDE information (e.g. vendor nr, accounts, various codes, etc.). This CSV will then be uploaded through the 47 mechanism.

@Skip: Originally I suggested to bypass the 47-files and feed directly F0411Z1 and F0911Z1. However the company (I'm a contractor) wants partout to use the 47 files, so .. here I am.

Anyway ... thanks for your help so far.

Regards
tino
 
Tino,

This is a sample from our PO incoming file showing numerics, dates and text. "58405","SO"," ","850"," ","06/30/08",

The delimiting that you use needs to match the processing options on the R47002C.

Like you, we get a file that has the basic EDI information from the customer. I handled loading the JDE specific info with these steps. I copied the R47002C to R5647002C. I added a custom section that gets called after the flat file is loaded. It reads the F47011 (F47041 in your case) records that have not been successfully processed. I do all the fetches, changes, additions....that JDE needs to successfully create a sales order then update the F47011 record. There is a child section that handles the changes needed in the detail table.

This works for us because TrueCommerce is creating the file with the fields in the correct position to load the F47 tables. I agree with you that it would be great for you to use the table conversions. You might think about doing this in 2 steps. First, create a UBE that reads the generic file and outputs a new file that has the info in the right field positions. Then use this new file as input to the R47002C. Once that works, you can update with the additional JDE info. I know this seems like more work, but with EDI, small steps can be very useful later for troubleshooting and handling new requirements. I have had to make quite a few specific code changes for specific situations.

Regarding Question 2 in your initial post, I don't know the AP Voucher process specifically, but I would guess you need to have records inserting into F47044. We do records into F4706 for PO addresses although we completely ignore them in creating the Sales Order.

Jer
 
Hello Mr Stein,

I was searching through the jdelist for a similar solution, I am trying to create a voucher flat file but cant find much guidance on the format. I see that you have, in this message, attached a word document that can help but I do not find the attachment in JDELIST and was wondering if you would be so kind to let me look at it. Thanks very much.
 
Back
Top