miaconis55
Member
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
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