Inventory Management - EBS (MOSC)

MOSC Banner

Inter-Org Transfer

Comments

  • Hi, 

    When the item would be transferer from source organization to destinition organization, destinition inventory would be debitted and source inventory would be creditted. Similar accounting would happen for receivable account for the shipping organization and payables account for the receiving organization.

    If you provide same account for both the receivable account & payables account then the balance would be 0 except not. Please let me know your concern.

    Thanks

    Shekhar Ghosh

  • User_2025-09-17-18-48-45-827
    User_2025-09-17-18-48-45-827 Posts: 198 Green Ribbon
    edited Mar 31, 2009 9:13PM
    Hi, 

    When the item would be transferer from source organization to destinition organization, destinition inventory would be debitted and source inventory would be creditted. Similar accounting would happen for receivable account for the shipping organization and payables account for the receiving organization.

    If you provide same account for both the receivable account & payables account then the balance would be 0 except not. Please let me know your concern.

    Thanks

    Shekhar Ghosh

    Thank you Shekhar .

    Our setup was wrong .We modified it according to Oracle Inventory User Guide (Inter Organization Shipping Network):

    2. Enter the general ledger receivables account used as an

    interorganization clearing account for the shipping organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    3. Enter the general ledger payables account used as an

    interorganization clearing account for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    for the receiving organization.

    3. Enter the general ledger payables account used as an

    interorganization clearing account for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    3. Enter the general ledger payables account used as an

    interorganization clearing account for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    for the receiving organization.

    3. Enter the general ledger payables account used as an

    interorganization clearing account for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    3. Enter the general ledger payables account used as an

    interorganization clearing account for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    for the receiving organization.

    3. Enter the general ledger payables account used as an

    interorganization clearing account for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    3. Enter the general ledger payables account used as an

    interorganization clearing account for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    for the receiving organization.

    3. Enter the general ledger payables account used as an

    interorganization clearing account for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    2. Enter the general ledger receivables account used as an

    interorganization clearing account for the shipping organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    3. Enter the general ledger payables account used as an

    interorganization clearing account for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    for the receiving organization.

    3. Enter the general ledger payables account used as an

    interorganization clearing account for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    3. Enter the general ledger payables account used as an

    interorganization clearing account for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    for the receiving organization.

    3. Enter the general ledger payables account used as an

    interorganization clearing account for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    3. Enter the general ledger payables account used as an

    interorganization clearing account for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    for the receiving organization.

    3. Enter the general ledger payables account used as an

    interorganization clearing account for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    3. Enter the general ledger payables account used as an

    interorganization clearing account for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    for the receiving organization.

    3. Enter the general ledger payables account used as an

    interorganization clearing account for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

  • Mike George
    Mike George Posts: 726 Gold Badge
    Thank you Shekhar .

    Our setup was wrong .We modified it according to Oracle Inventory User Guide (Inter Organization Shipping Network):

    2. Enter the general ledger receivables account used as an

    interorganization clearing account for the shipping organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    3. Enter the general ledger payables account used as an

    interorganization clearing account for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    for the receiving organization.

    3. Enter the general ledger payables account used as an

    interorganization clearing account for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    3. Enter the general ledger payables account used as an

    interorganization clearing account for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    for the receiving organization.

    3. Enter the general ledger payables account used as an

    interorganization clearing account for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    3. Enter the general ledger payables account used as an

    interorganization clearing account for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    for the receiving organization.

    3. Enter the general ledger payables account used as an

    interorganization clearing account for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    3. Enter the general ledger payables account used as an

    interorganization clearing account for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    for the receiving organization.

    3. Enter the general ledger payables account used as an

    interorganization clearing account for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    2. Enter the general ledger receivables account used as an

    interorganization clearing account for the shipping organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    3. Enter the general ledger payables account used as an

    interorganization clearing account for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    for the receiving organization.

    3. Enter the general ledger payables account used as an

    interorganization clearing account for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    3. Enter the general ledger payables account used as an

    interorganization clearing account for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    for the receiving organization.

    3. Enter the general ledger payables account used as an

    interorganization clearing account for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    3. Enter the general ledger payables account used as an

    interorganization clearing account for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    for the receiving organization.

    3. Enter the general ledger payables account used as an

    interorganization clearing account for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    3. Enter the general ledger payables account used as an

    interorganization clearing account for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    for the receiving organization.

    3. Enter the general ledger payables account used as an

    interorganization clearing account for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    The interorganization receivable account for the shipping

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    organization should equal the interorganization payables account

    for the receiving organization.

    for the receiving organization.

    Should post as a question... 
  • LisaO -Oracle
    LisaO -Oracle Posts: 665 Bronze Trophy - Community Leader
    Hi,
    The documents section of the Community is for articles/scripts/solutions in order to share knowledge or content in the community.
    Please post your issue/question in the Discussions area of the Inventory Management Community where you will get a better response.
    I will leave this up until the end of the week, 01-May-09 and delete it after that.
    Thanks,
    Lisa
     
  • user1209264
    user1209264 Posts: 307 Red Ribbon
    Hi,
    The documents section of the Community is for articles/scripts/solutions in order to share knowledge or content in the community.
    Please post your issue/question in the Discussions area of the Inventory Management Community where you will get a better response.
    I will leave this up until the end of the week, 01-May-09 and delete it after that.
    Thanks,
    Lisa
     
     Accounting Distributions from the Shipment SET OF BOOKS - A
    Dr COGS@ unit cost x quantity
    Cr Inventory Valuation @ unit cost x quantity

    The COGS account is built using WorkFlow.

    Accounting Distributions from the Customer Invoice
    SET OF BOOKS - B
    Dr AR@ (selling price x qty + Tax + Freight)
    Cr Revenue Tax Freight

    All of the above accounts are built using AutoAccounting,

    Currency
    The transaction will be recorded in the currency of the price list on the sales order;

    Accounting Distributions from the Intercompany
    AR Invoice
    SET OF BOOKS - A
    Dr Intercompany AR@(transfer price x qty + Freight + Tax if applicable)
    Cr Intercompany Revenue Freight Tax

    Currency
    The transaction will be recorded at transfer price, using the price list attached

    Accounting Distributions from the Intercompany AP Invoice
    SET OF BOOKS - B
    Dr Trade COGS @(transfer price x qty) + Freight
    Cr Intercompany Payable @ (transfer price x qty + Freight)

    Currency
    The transaction will be recorded in the currency of the AR invoice;

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center