Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Intercompany item sales
Microsoft Dynamics NAV (Archived)

Intercompany item sales

(0) ShareShare
ReportReport
Posted on by Daryl Newman 100

I have a canadian and US company.  All US sales need to be billed through our US customer but the product will be coming from Canada.  So we do a sales order to the customer in the US company using the drop ship feature, the US company does a purchase order to Canada using the intercompany posting features, Canada receives the PO in the intercompany inbox which turns it into a sales order which they can then ship out.  My problem that I am running into is

  1. When I go to post the sales order in Canada, it indicates that general posting set up does not exist.  Do I need to have the same Business and product posting groups in both my Canadian and US company?
  2. I have to "receive" the items on the PO in the US company in order for the transaction to go to the IC outbox.  Is there a way to send it to to the Outbox without receiving the purchase order first.  We want to get to the point where the US company is ordering stock to store and issues a PO which would automatically create the SO in Canada but the goods are received on the PO until they are received in the US warehouse

Thanks

*This post is locked for comments

  • TWBlaisdell Profile Picture
    TWBlaisdell on at
    Re: Intercompany item sales

    Hi Daryl,

    I'm glad to hear it! :) Great news.  Have a super day.

    Best Regards,

    Tom

  • Daryl Newman Profile Picture
    Daryl Newman 100 on at
    Re: Intercompany item sales

    Hi Tom

    After some further testing I figured out the problem.  I needed to identify the common item no. on both the US and Canadian side.  I initially had it just on the US and it was pulling in the correct part so I thought it was working fine.  Thanks for all the assistance.

    Daryl

  • TWBlaisdell Profile Picture
    TWBlaisdell on at
    Re: Intercompany item sales

    Hi Daryl,

    I completed some further review and testing and cannot reproduce a scenario where the Gen Product and Gen Business Posting Group are stripped. I am using the IC Partner setting of Common Item No. on the IC Partner Card for each company within each of the Company's respective data sets.  Make sure that the Intercompany Customer for the USA company in Canada Company's data has the correct Gen. Business Posting Group and that the Item has the Gen. Product Posting Group identifed. Otherwise, I'm not sure what to tell you. At this point, I cannot reproduce the issue, so you may have to get with your partner to review the data flow.

    Thanks

    Tom

  • Daryl Newman Profile Picture
    Daryl Newman 100 on at
    Re: Intercompany item sales

    Hi Tom

    Thanks for the information.  The second item definitely works great.  On the first question, for some reason the sales order in the Canada Company is being "stripped" of the General Business and Product group when I bring it in from an intercompany transaction but when I post a normal sales order for that item it is fine.  I am using the common item feature in Nav to tell it to pull the correct item.  Not sure what is going on.

  • Suggested answer
    TWBlaisdell Profile Picture
    TWBlaisdell on at
    Re: Intercompany item sales

    Hello Daryl,

    Thank you for posting on the Microsoft Forum.

    You will need to have the General Posting Setup completed in the Canada Company. It doesn't necessarily have to be identically setup. However, when you are processing an Item Transaction, it must have a General Product Posting Group and Inventory Posting Group established to post.  Therefore, the General Posting Setup must be established to post a Receipt and Invoice with an Item in the company in CA as well as the required Inventory Posting Group.

    With item 2, you should be able to create the SO in canada by settting up the PO and then sending over the Order through Function > Send IC Purhcase Order.

    I hope this helps.

    Best Regards,

    Tom

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans