Inventory Transactions

[miaconis55]

Hi all. I am working with a project that interfaces a PC based system with JD Edwards World. The system is used to custom design and build products, and generates G/L transactions for the cost of raw materials into WIP when the bill of materials is complete. I am using the F0911Z1 input to load the journal entries and everything up to this point is working fine because everything was considered non-stock to the JDE system.

The controller would now like to inventory raw materials in JDE and as they are consumed by the PC based system, reduce inventory on the stock items. I will need to load inventory issue transactions that will subtract from balances and create the proper journal entries. At first I thought of just developing a custom program, perhaps by cloning P4112 and making it a batch process. I was hoping to use the JDE system in some way but I do not believe there is any Z file input process that would handle inventory transactions. My first question is, does anyone know if such a process exists in World?

I then thought I might be able to generate a specialized sales order that would input through F47011 and F47012. By using a unique document type and creating AAIs, I would post the proper accounts in G/L and subtract from inventory by just running the sales orders through sales update. My second question is, would this work or am I missing something that would cause problems if I use sales order transactions?

I would be most grateful for any ideas.

Thanks,

Mike

 

[Pam_MacKinnon]

On menu G47241, there is an EDI option 4 for inbound transactions that
allows you to do an "Issue" from an outside system. The program is
J47121. If you read the documentation on this on the web site, it will
tell you what files need to be populated with what values. The AAI's will
drive the GL that will happen as a result. We have use this process
successfully to upload inventory transactions from outside systems. Good
Luck!

Pam MacKinnon
Manager of Application Development
High Liner Foods Inc.
mailto[email protected]



miaconis55 <[email protected]>
Sent by: [email protected]
11/10/2006 10:03 AM
Please respond to
JD Edwards=AE World <[email protected]>


To
[email protected]
cc

Subject
Inventory Transactions






Hi all. I am working with a project that interfaces a PC based system with
JD Edwards World. The system is used to custom design and build products,
and generates G/L transactions for the cost of raw materials into WIP when
the bill of materials is complete. I am using the F0911Z1 input to load
the journal entries and everything up to this point is working fine
because everything was considered non-stock to the JDE system.

The controller would now like to inventory raw materials in JDE and as
they are consumed by the PC based system, reduce inventory on the stock
items. I will need to load inventory issue transactions that will subtract
from balances and create the proper journal entries. At first I thought of
just developing a custom program, perhaps by cloning P4112 and making it a
batch process. I was hoping to use the JDE system in some way but I do not
believe there is any Z file input process that would handle inventory
transactions. My first qu! estion is, does anyone know if such a process
exists in World?

I then thought I might be able to generate a specialized sales order that
would input through F47011 and F47012. By using a unique document type and
creating AAIs, I would post the proper accounts in G/L and subtract from
inventory by just running the sales orders through sales update. My second
question is, would this work or am I missing something that would cause
problems if I use sales order transactions?

I would be most grateful for any ideas.

Thanks,

Mike

 

[curryj]

We don't use it, but there is functionality in the EDI system that might help you. Check menu G47241 Product Activity Data, option 3 Revisions. Once in there, you can push F10 to see the detail entry screen.

A couple of the underlying files are the F47122 and F47123. Based on our experience with other EDI transcations, I think you could dump data from your PC system into these files, then run option 4 - P47121 - to update the JDE inventory system based on your imported data.

It ought to be just like the Z file process you're looking for.

Hope this helps.