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 :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Inter company Purchase...
Microsoft Dynamics AX (Archived)

Inter company Purchase Order Sales Order Issue in AX2012

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

In my AX there is Inter company setup between two legal entities. It is working fine as well. But particularly one invoice I found there was a problem. Let me explain to you the issue. There was an Inter company PO with 4 lines and it has been converted as Inter company SO in the other company. The sales order has been invoiced as well. But somehow one line has been deleted from it. and now the PO got only 3 lines. Because of mismatching I am not able to post the PO now. But SO has been posted. I am stuck in posting the PO.

Anybody can help me to solve the same?

Thanks in advance,

Dhanoop R.Warrier

*This post is locked for comments

I have the same question (0)
  • Sohaib Cheema Profile Picture
    Sohaib Cheema 49,434 User Group Leader on at
    RE: Inter company Purchase Order Sales Order Issue in AX2012

    From where the Line has been deleted? PO or SO?

  • Community Member Profile Picture
    Community Member on at
    RE: Inter company Purchase Order Sales Order Issue in AX2012

    Hi Sohaib,

    Seems like it has been deleted after posting SO. I have made PO with 4 lines and then SO also had 4 lines. SO has been posted as well. PO is not posted. When I am trying to post PO, I can see there is only 3 lines in it but the same corresponding SO got 4 lines and it has been posted. One line is missing in PO. I am not able to add the line again in PO because SO has been posted. It wont allow me.

    Thanks,

    Dhanoop R.Warrier

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 49,434 User Group Leader on at
    RE: Inter company Purchase Order Sales Order Issue in AX2012

    what is status of PO? Received or open/confirmed ??

  • Community Member Profile Picture
    Community Member on at
    RE: Inter company Purchase Order Sales Order Issue in AX2012

    PO is in open status. It has confirmed but not received.

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 49,434 User Group Leader on at
    RE: Inter company Purchase Order Sales Order Issue in AX2012

    so, if you try to add a line manually? will it allow you?

  • Community Member Profile Picture
    Community Member on at
    RE: Inter company Purchase Order Sales Order Issue in AX2012

    No. It wont allow me to add the lines because Intercompany SO has been posted already in other company. I think it can sorted out only by editing AOS. Can you please tell me how to edit the same in AOS?

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 49,434 User Group Leader on at
    RE: Inter company Purchase Order Sales Order Issue in AX2012

    well, what you are talking about is adding line of PO forcefully by X++,

    that can be done, but I cannot say any words about that as I did not experimented it, unfortunately I don't have access to Demo AX now, as its an Off day here in my country. and my own machine don't have intercompany setup

  • Community Member Profile Picture
    Community Member on at
    RE: Inter company Purchase Order Sales Order Issue in AX2012

    Otherwise change the status of the posted invoice to open order. Then I can add line in PO. Is it possible? If you can suggest me which table I can change the status then I think I can do it from Database as well.

  • Community Member Profile Picture
    Community Member on at
    RE: Inter company Purchase Order Sales Order Issue in AX2012

    Is it a good idea to change the status of the posted Sales order to Open? Can anybody tell me which table it is getting affected while posting the sales order?

    Or even adding the missing item to PO also acceptable.

    Thanks in advance,

    Dhanoop R.Warrier

  • Verified answer
    Sohaib Cheema Profile Picture
    Sohaib Cheema 49,434 User Group Leader on at
    RE: Inter company Purchase Order Sales Order Issue in AX2012

    its not a good idea to change status of order.

    if you want to do it forcefully do following

    1) take a backup of Transactional DB. also note down amounts of trail balance

    2) update status of order from SQL Server (it will skip related methods or any pre-post events)

    3) add your missing line in ax

    4) go back to SQL server and verify the newly added line, by comparing it with existing lines. this is needed as you are creating line manually, so must be sure that any references are not missing.

    5) revert back status of order, which you changed #2. do again on sql server

    6) Post your intercompany order,

    7) verify your Trail balance and posted Vouchers

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 3

#3
Scott_itD Profile Picture

Scott_itD 2 Community Manager

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans