Sell-to customer No field

(0) Share

Report

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

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Suggested answer

Suresh Kulla 50,269 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Binesh 7,887 on at

Like (0)

Report
Copy link

Link copied!

Hello,

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report
Copy link

Link copied!

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 ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Binesh 7,887 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No