Reconciling JD Edwards Inventory Using ‘IT’ Transactions for Branch to Branch Transfers

    Insider main resizedEdward Gutkowski, Chief Architect - RapidReconciler, Products

    When moving goods from one branch to another in JD Edwards, the process most often used in the transfer order (aka 'ST/OT'). This works well especially when there is distance between the locations as shipping paperwork may be required to transport the materials. Time delays occur occasionally between the shipment and receipt and the 'ST/OT' process removes the quantities from the stock status report while the goods are in transit. This process would be required to allow accurate recording of revenue and cost of goods sold should the shipping branch transfer the products with a markup.

    Can the transfer be simplified? Is the overhead associated with the 'ST/OT' required?

    The answer is simpler than you think. You can use the standard 'IT' transfer transaction to produce similar results, just be wary of some caveats:

    The distance of the transfer should be feet or yards, not miles. This would happen if you are using "virtual warehouses" (e.g. consignment or returns) where the branch plants in JDE are in the same building.
    Related to the above item, the 'IT' transaction moves the material instantly. There is no time delay between the 'from' and 'to' locations so keep the distance to a minimum.
    Accounting instruction table 4141 for the 'IT' document type. Time and time again I see this populated with the balance sheet account for inventory instead of cost of goods or other expense account. This table is used to offset any cost differences, intentional or not, between lots or locations.

    Keeping these things in mind, you may be able to reduce some overhead and simplify processing using an 'IT' transaction instead of the 'ST/OT'. Try this in you test environment and see the results!

    Happy reconciling!

    If you have any questions about JD Edwards inventory, please email us at inquiries@GetGSI.com.