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
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
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
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 ?
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
Hello,
See the bellow screenshot for linking on tables that you want.
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
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.
André Arnaud de Cal...
291,996
Super User 2025 Season 1
Martin Dráb
230,853
Most Valuable Professional
nmaenpaa
101,156