You’re offline. This is a read only version of the page.
Hello,
I want to write a codeunit where for a particular customer no. the records has to be displayed from 2 different tables i.e Sales header & Sales Invoice Header.
Can anybody help me in displaying the data from these 2 tables ?
When the particular customer no. is filtered then the data from both the tables has to combined and displayed.
Please help me its an urgent requirement.
Thanks in advance.....
*This post is locked for comments
You do not have the option of linking two tables to one page. In Microsoft Dynamics NAV, it is a one to one relationship with tables and pages. As for a solution for your requirement, best option is to create an table and then populate the data to it.
If you only need these for a display purpose, then the best option is to populate the data to the newly created table at the run time (As temp table). By doing this you do not have to worry about data integrity of the sales header and new table, because it only create the table data at the time of running the function.
If you need any help regarding the C/AL coding please do get back to us.
You can't use one page for two tables, you would need to create a temporary table, fill it with needed data and then display via needed page: msdn.microsoft.com/.../dd355211.aspx
hi,
look at these pages of NAV online help on MSDN, may be useful.
Essential C/AL Functions
msdn.microsoft.com/.../dd355257(v=nav.90).aspx
GET, FIND, and NEXT Functions
msdn.microsoft.com/.../dd338616(v=nav.90).aspx
Using Codeunits
Use filter as customer no to filter the record from both the table. You will desired result
Using temp table will be right choice, create a structure as desired. As most of the fields in above example tables are common so you can use existing any of both table as temp and use transfer fields and insert statement to add your records to temp record variable post applying filters. Write a function to manipulate the records and call it onvalidate trigger of customer no filter field.
You will write code itself on Page, think of approach and design as per your requirement before you start designing.
Make sure you specify temporary property of variable also delete all records from table before you add new set of records post changing filters and retrieving new set of records. This is common mistakes done by developers in such situation.
If using higher version Query will be good approach.
If you just want to show records you can use report too.
You have to create 2 forms for each, otherwise if you need only selected fields then store in temporary table, and that temporary table show in form
SalesHeader.RESET;
SalesHeader.SETRANGE("Sell-to Customer No.",'10000');
IF SalesHeader.FINDSET THEN
REPEAT
TempSH.INIT;
TempSH."No." := SalesHeader."No.";
TempSH."Sell-to Address" := SalesHeader."Sell-to Address";
TempSH.INSERT;
UNTIL SalesHeader.NEXT = 0 ;
SalesInvoiceHeader.RESET;
SalesInvoiceHeader.SETRANGE("Sell-to Customer No.",'10000');
IF SalesInvoiceHeader.FINDSET THEN
REPEAT
TempSH.FINDLAST;
TempSH."No." := SalesInvoiceHeader."No.";
TempSH."Sell-to Address" := SalesInvoiceHeader."Sell-to Address";
TempSH.INSERT;
TempSH.NEXT; // for move next record
UNTIL SalesInvoiceHeader.NEXT = 0 ;
Note:
Here TempSH is a Temporary table of [Sales Header or Sales Invoice Header], or you can also create new Table and it has fields from both table based on your requirement.
Now you can see your data after inserting data in TempSH table, you can call a form, that form has Source table is TempSH.
This is only for sales header and similar if i write for invoice header then in two different forms i will get data.
I have to display the data in a single tablular form from both the tables one after another.
Hello Pushpa,
Declare Record Variable of sales Header and Sales Invoice Header.
and write code something like:
SalesHeader.RESET;
SalesHeader.SETRANGE("Sell-to Customer No.",Cust."No.");
IF SalesHeader.FINDSET THEN
REPEAT
MESSAGE(SalesHeader."No.");
//Here you get all filtered record
// for displaying Records you have to use some container
// So your data will be displayed.
UNTIL SalesHeader.NEXT = 0 ;
#1
Sohail Ahmed
2
#1
mmv
2
#1
Amol Salvi
2
Share
Report
All responses (
Answers (
