Author: admin

JDE R42800 R42950 reprice recost both sales order and purchase order (transfer orders)

Okay, so I had to share this… I know, the inner nerd.

We’re running transfer orders, your standard JDE ST/OT (sales order/purchase order).

However, there is no invoice and it jumps straight to R42800 end of day process.

The problem:
R42800 calls reprice R42950 and it does a reprice/recost of the sales order, but it does NOT change the cost on the purchase order – which puts our intransit accounts (General Ledger F0911) out of whack if the transfer order was raised days prior and the standard cost has changed since. Seeing as this job is in the petroleum industry and the price/cost of things are changing daily you can imagine what this does to our intransit accounts.

The solution:
When R42800 end of day runs, it calls the R42950 (reprice) there is a processing option on R42800 to include a version of P4210 (sales order entry) to determine the basic defaults when updating the sales order during the reprice/recost. The version of P4210 in our instance did not have transfers enabled, which means during the 4211 edit line call it doesn’t know that it has to update the associated purchase order.

By simply creating a new version of P4210 (a copy of the existing one) turning on transfer orders and then updating the version of R42800 with this new version of P4210 ensures that the purchase order cost is updated and our in-transit accounts are now back in balance.

Yay!

JDE EnterpriseOne – Common tables

JDE table names explained:

F4211 – Sales Order Detail records
F – F is for file, it’s the old school way of saying a table.
42 – is the JDE system code, in this case it means sales.
11 – Generall 11 means detail records, 01 usually means header records – so it’s safe to say the JDE Sales Order Header table is F4201

Here’s a short list of tables I use regularly:
F4211 – Sales order detail records,
F4201 – Sales order header records.
F42119 – Sales order detail archive records (usually after the end of day ube has run and archived the detail records from the F4211).

F4301 – Purchase Order Header records.
F4311 – Purchase Order Detail records.
F43121 – This table is the log of all the receipts against a purchase order.

F0101 – Address book

F4111 – Inventory ledger
F4101 – Item Master

F0911 – General Ledger

Those are the key ones, I’m sure there are more, and if you’ve got any you think should be added, give me a comment and I’ll consider it.

JDE EnterpriseOne flat files – unicode, UTF8, UTF16,

The scenario:

You have a JDE UBE or a JDE application that you want to output a flat file (text file) to somewhere?

The short answer is use: P93081 – Work With Flat File Encoding.

The more verbose answer is:

This is pretty standard stuff, and JDE provides you a some basic business functions to call to do this, namely:

B34A1010 – OpenFlatFile – Open Flat File
B34A1010 – WriteOneLine – Write One Line To Flat File
B34A1010 – CloseFlatFile – Close Flat File

The usage is pretty simple, you open the file, you call the Write One Line as many times as desired and in the end you close it.

Now, if you’re like me you’ve used this a million times without any issue, however recently the files were being used to integrate to a 3rd party system, and apparently the file was in a UTF8 format and they wanted it in a UTF16 format.

After a super quick look at the business function inputs it appeared there is no way to change the file output type.

However, some searching later I stumbled across P93081 – Work With Flat File Encoding.

Simply type that app name into the fast path, and you can specify your UBE, Version name, environment etc and it will output the file to your desired format. What’s amazing is you don’t have any code changes, it works automatically through the business functions/middle ware.

Any more information, please feel free to post below.

Happy ERP’ing!

Matt