Skip to main content
Microsoft Dynamics NAV forum
Suggested answer

Bill To customer No , with wrong rep code

editSubscribe (0) ShareShare
ReportReport
Posted on by 467

I have done an order using the ‘sell to’  which is the the End Customer and Bill to which is the re seller that we invoice him 

  1. When I went to change the Bill to  

bill-to.png

  1. Then this message when I changed it.

bill-to-2.png

Is there a way we can avoid some of these messages and automatic changes?  

Even though it sounds like it’s going to overwrite everything it doesn’t but it did automatically change the salesperson code and the rep codes, probably

the rep Code is for the Sell to customer not the Bill to 

how can we let the Rep code be the one related to the BILL to customer ? 

Categories:
  • Suggested answer
    azelaya59 Profile Picture
    azelaya59 2,805 on at
    RE: Bill To customer No , with wrong rep code

    Samer

    Sorry for the delay in responding, today has been very busy. The image that you sent, is this for a "Reseller" or "End User Customer"? If it is a "Reseller", the configuration is correct. If it is an "End User Customer" then populate the "Bill To Customer" with the appropriate "Reseller" account number. Now the AP will be on the correct customer. Of course, please use your test instance first. Run some reports and make sure you are happy with the outcome. I suggest exporting a RapidStart Configuration package, make you changes, then import the same. NAV likes data changes done with native tools. I hope this gives you direction.

  • Samer Baskhayroun Profile Picture
    Samer Baskhayroun 467 on at
    RE: Bill To customer No , with wrong rep code

    Thanks a lot for your feedback , and keep remember the issue

    use the "Sell To" as the End Customer/User and the "Bill To" as the Reseller/3rd Party, will this always be the case?

    yes this is will be always the case

    You can enter the "Bill To" on the customer card and all Sales Invoices will go to the "Bill To"'s AR. There will be no message

    this was the setup from the beginning as below screen shot , but the issue is the same

    billtsellto.png 

  • Suggested answer
    azelaya59 Profile Picture
    azelaya59 2,805 on at
    RE: Bill To customer No , with wrong rep code

    Samer

    Remember what the functionality is supposed to do. The Parent / Child relationship here is to have everything involved with the sale to stay under the "Sell To" customer but the AR to be under the "Bill To" customer. In your scenario, you want use the "Sell To" as the End Customer/User and the "Bill To" as the Reseller/3rd Party, will this always be the case? You can enter the "Bill To" on the customer card and all Sales Invoices will go to the "Bill To"'s AR. There will be no message.  If you say that sometimes Sales Invoices go to the End Customer and sometimes it goes to the Reseller, then I would look at using the "Ship To" addresses instead. It will keep the AR cleaner for both the End Customer and Reseller. As far as the "Rep Code" is concerned, that information is on the header level and is not changed. Feel free to message me if you need more clarification.

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Sundar…

Industry experts answer burning questions directly from our amazing Community…

Enabling Copilot Case and Conversation…

Agents can easily recap an ongoing chat, transcribe a voice conversation…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 282,978 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,562 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans