3,099
Hi
I am using Invoice Header & Lines as dataitem to display Invoices . IN the end of the report i want to display data from Sales Order which are not posted. Fields to be No_, Posting Date.
Thanks
*This post is locked for comments
Hello,
If you would like to show in single Report then you have to do some steps:
You can do this by
1> creating a Temporary table and insert all records then in data item call this Temporary table.
for reference see the below code:
2. In this you have to create 4 data sets, first 2 for Invoice Header and Line and next 2 for Order Header and Line.
Then create two tables in Report Layout one for Invoice and another for Order,
Design Order table after invoice, or as per your requirement.
See below for reference:
For non posted order you need to look at Sales Header and sales line table. You need to check the field called as outstanding quantity on sales line table and then display those order where outstanding quantity is not zero.
Hi
I have able to display Invoice Data using Invoice Header & Lines Data.
How to display Order Data at the end of the report which are not posted that i dont know how to do.
IF i have to do in another report then no problem
Thanks
Hi,
Kindly let us know what you tried so far.
Share
Report
All responses (
Answers (
