Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Sell-to customer No field
Microsoft Dynamics NAV (Archived)

Sell-to customer No field

(0) ShareShare
ReportReport
Posted on by Community Member

Good day all 

I am trying to find the best join to retrieve the sell-to customer no information in NAV 2013. I have the following tables:
Value Entry , Item Ledger Entry, Sales Invoice Line and Customer

When i left join the Sales invoice line table with the Value entry table on Sell-to customer = Source No it displays the Bill-to Customer no and not the Sell-to customer no information. That means i cannot join Sales Invoice Line table with the Value Entry.

What table join with Sales invoice line will give me the sell-to customer no information 

*This post is locked for comments

  • Binesh Profile Picture
    Binesh 7,885 on at
    RE: Sell-to customer No field

    First what you want just say...

    See, These are the your tables,

    Customer

    Sales Invoice Line

    Item Ledger Entry

    Value Entry

    ----------

    Assume Customer is a Master Table, and if you want to get the records from, Sales Invoice Line, Item Ledger Entry. And Value Entry, whose Customer No. is 10000.

    If is this your requirement then you have to filter.

    For

    Sales Invoice Line

    Sell-to-Customer

    Value Entry

    Sales Type -> Customer

    Source No 10000

    Item Ledger Entry

    Sales Type -> Customer

    Source No 10000

  • Community Member Profile Picture
    Community Member on at
    RE: Sell-to customer No field

    When I join the sales invoice line to Value entry , the result is the bill to customer info which is wrong because value entry does not know if it should take bill to customer or sell to customer , there for the values for that customer and the information gets placed in another country with the same customer name

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Sell-to customer No field

    Item ledger entry and value entry can be join with Item ledger entry no field  and value entry and Sales Invoice line can be join with document no ,Item No etc.

    Can you tell us what result you are trying to achieve by joining all these three tables ?

  • Community Member Profile Picture
    Community Member on at
    RE: Sell-to customer No field

    Binesh I see the Item ledger entry , Value Entry and Sales invoice line tables , in which order should the joins be , I don't understand the arrows displayed on the image

  • Suggested answer
    Binesh Profile Picture
    Binesh 7,885 on at
    RE: Sell-to customer No field

    Hello,

    See the bellow screenshot for linking on tables that you want.

    0601.q.png

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Sell-to customer No field

    Hi Jason

    Check on your customer card also whether sell to customer and bill to customer no are same

    As well as there is field in Sales invoice line i.e Sell to customer No You can check that

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 44,656 on at
    RE: Sell-to customer No field

    Jason,

    The Sales Invoice Line already has Sell-to Customer No. field which should give you the sell-to customer no. if you need more information of that customer you need to join that with Customer Table.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans