I am new to Jet and looking for assistance, to determine what table to use in pulling data. (Salesperson, Customer Code, Posting Date, Customer Name, Customer No., List Price, Unit Price, Margin, Margin % and showing sub-total and ground total).
Date
Votes
2 comments
-
Harry Lewis Hello Victor -
I am assuming you are using Dynamics NAV; so I'll proceed from there.
To my knowledge, there is no single table that incorporates all of those fields.
You may want to start with the Value Entry table (typically, the single largest table in an NAV system).
In addition "margin" is generally not a field. Rather, that is something you have to compute (based on list price vs. unit price).
Other tables in which you may be interested: Customer, Cust. Ledger Entry, Item, Item Ledger Entry, Salesperson/Purchaser)
-
Victor Adebo Thanks Harry,
There are cases with several assembly bonds with different items, on one sales order, how can I get the sum of each line?
=NL("Rows","Sales Header Archive","No.","No.",">0","Posting Date","2019-12-01..2019-12-31","Document Type","Order","Link=","Sales Invoice Header","No.","=Last Posting No.")
looking at Brokerage you have two from the assembly bonds. What should i do Thanks
Please sign in to leave a comment.