Open Forum

Expand all | Collapse all

How to export intercompany transactions in a file

  • 1.  How to export intercompany transactions in a file

    Posted 10-17-2018 03:48 PM
    Hi there,

    I see that there is a function to import a file in the IC Inbox but I cannot find a function to export an IC transaction to a file, so I can import it in NAV on a different database. Can anyone assist on this?

    Thanks in advance,

    Leyssy

    ------------------------------
    Leyssy Ponce
    Sabre Limited
    Cambridge ON
    ------------------------------


  • 2.  RE: How to export intercompany transactions in a file

    TOP CONTRIBUTOR
    Posted 10-18-2018 11:07 AM
    Edited by Geovanny Fuentes 10-18-2018 11:08 AM
    ​You need to setup both sides, then determine what period to export, then you can import it to the other location. Below is a good setup and process to perform this.
    Navision Planet: Intercompany Setup in Dynamics NAV
    Navision Planet remove preview
    Navision Planet: Intercompany Setup in Dynamics NAV
    Intercopany setups used for those companies having different Branches or entities exist. Also when there is internal Sales or Purchase etc like transactions happening in between. By the help of Intercompany we can reduce the effort of Monthly reconcile of 2 companies. Dynamics NAV intercompany transferring transaction between companies and partners electronically.
    View this on Navision Planet >


    IC Inbox/Outbox Transaction
    Good luck.



    ------------------------------
    Geovanny Fuentes
    San Diego CA
    ------------------------------



  • 3.  RE: How to export intercompany transactions in a file

    Posted 26 days ago
    Hi Geovanny,

    Thank you very much for your reply. We do have all the setup done and it works when  you are exporting the transactions to the same database. What I am wondering is how to export it to a file, when it is not all in the same database. There is a function in the IC inbox to import file, but there is no option on the IC outbox to export to a file.

    Thanks,

    Leyssy

    ------------------------------
    Leyssy Ponce
    Sabre Limited
    Cambridge ON
    ------------------------------



  • 4.  RE: How to export intercompany transactions in a file

    TOP CONTRIBUTOR
    Posted 21 days ago
    Leyssy , sorry for the delay.

    First determine the IC partner card and select these two fields correctly.
    IC partner card
    Create the proper jrls. Then in your IC Outbox. Select ACTIONS -> SET LINE ACTION -> SEND TO IC PARTNER.
    IC jrl
    You should now find the IC XML file.

    Good luck.


    ------------------------------
    Geovanny Fuentes
    San Diego CA
    ------------------------------