Hi Experts,
I want to add some fields in cust aging DP class(Standard Report), if i am trying to insert it giving an error(even i made fields in temp table already) as shown in the image. The second thing is if I tried to go to the definition of this temp report it behaves like a map giving an error please check.
Best Regards,
Shabir Ahmad
Hi Shabir,
The error in infolog shows that you added a field to insert_recordset section (SortOrder?), but have not added the source field in select section.
Hi Sergei Minozhenko,
I added fields in tmp table before then i came here to add these fields.
Shabir
The number of fields in insert_recordset section should be the same as in select section
You have the same case as below: field3 is missing from select section. You need to review all fields in insert_recordset * select statement and find what field is missing in select.
insert_recordset myTable ( field1, field2, field3) ) select field1, field2 // field3 is missing from myTable1
First thanks for your suggestion that worked, one point is there why temp table behave like MAP if I want to go to its definition it doesn't work check-in the image in the post.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 1,771
André Arnaud de Cal... 806 Super User 2025 Season 2
Sohaib Cheema 542 User Group Leader
