web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Inter-company invoices settlement

(0) ShareShare
ReportReport
Posted on by

Hi,
We are creating a new legal entity. So when the entity CAD sells to entity US trough a Sales Order, an Inter-co Purchase Order is automatically created (due to the trading relationship set up). All is working fine, I am wondering if the inter-co setup could allow an inter-co invoices settlement.

Here is the process:
SO created from the primary entity CAD to push the inventory to the new entity US.
SO Pick/Pack/Ship/Invoice.
This creates an open Invoice 123 for customer US (in CAD company)
PO: Confirm/Receive/Invoice.
This creates an open Invoice 123 for Vendor CAD (in US company) (note the same invoice number is populated from both side.

To pay the vendor invoice, US company creates a payment journal, before to post the payment, I settled this payment to the open Invoice, when posted, the open invoice is no longer in the vendor aging.

Question.

We have to do the same process, in the AR side, Create a payment journal and settle payment against the open invoice. Is there a way that the AR invoice could be automatically settled after the AP are settled since they are the same.

Thank you !

Kamel Sadek.

*This post is locked for comments

I have the same question (0)
  • Finance and operations Profile Picture
    on at
    RE: Inter-company invoices settlement

    Hi Ludwig,

    Everything is OK with me.

    Thank you for your help.

    Kamel.

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Inter-company invoices settlement

    Hi Kamel,

    Is there anything else open / not answered for this thread or can we get it verified and closed?

    Best regards,

    Ludwig

  • Finance and operations Profile Picture
    on at
    RE: Inter-company invoices settlement

    Hi Ludwig,

    It worked (thanks for your advice), and here what I added to my previous setup.

    I created a new Journal (Interco)

    Interco_5F00_2.jpg

    In the Offset account. I setup the Interco Customer (primary entity)

    Interco_5F00_2.jpg

    This was the only way allowed me to obtain the result.

    when the AP payment journal is created and settled against open invoices, a AR journal is automatically created and the AR open invoices are automatically settled.

    Thank you !

    Best regards.

    Kamel.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Inter-company invoices settlement

    Hello Kamel,

    After the IC-invoices are created, an AP payment journal needs to be created to settle the open IC amount.

    Against the background of your parameter setup, an AR payment journal should automatically be created and posted once the AP payment journal is posted.

    Please refer to the following TechNet site:

    technet.microsoft.com/.../Aa571143.aspx

    Can you test creating and posting the AP payment journal and verify that the AR payment is automatically created and posted?

    Best regards,

    Ludwig

  • Finance and operations Profile Picture
    on at
    RE: Inter-company invoices settlement

    Hi Ludwig,

    Here is the setup, sorry, my print screens didn't follow my previous email.

    Customer: PO policies

    Vendor_5F00_SO-Policies.jpg.png

    Customer: SO Policies

    Customer_5F00_SO-Policies.jpg

    Vendor: PO Policies

    Vendor_5F00_PO-Policies.jpg

    Vendor: SO Policies.

    Vendor_5F00_SO-Policies.jpg.png

    I have also setup a comment payment terms and method of payment. when a payment is created in AP side and settled with the open invoice. I am expecting that the AR invoice is settled automatically after this action

    Thank you again.

    Kamel.

  • Finance and operations Profile Picture
    on at
    RE: Inter-company invoices settlement

    Hi Ludwig, 

    The setup in the Trading relationship (Customer / Select the Customer / General / Intercompany...

     Here is the setup. 

     

    Customer.
    Sales Order Policies

    Purchase Order Policies.

    Vendor.

    Purchase Order policies

    Sales Order Policies

     

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Inter-company invoices settlement

    Hi Kamel Sadek,

    Please check your IC parameters again.

    There are settings available that automatically allow you making IC payments and settlements.

    Maybe you can share some screenshots that illustrate your IC setup

    Many thanks,

    Ludwig

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Guy Terry Profile Picture

Guy Terry 2 Moderator

#1
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

#1
Community Member Profile Picture

Community Member 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans