Notifications
Announcements
No record found.
Hi
Suppose user enters date 01012017..10012017. I want to add records in a table datewise (Grouping on Date) from Sale Line table using C/al in a form.
Date , Amount
Thanks
*This post is locked for comments
Hi,
From where do you want to insert records, Excel ?
I am reading Data from Sales Line and insert records in Custom Table. I have to create Form. User will select Location and for that Location want to insert record on Date Grouping.
You can created global variables for start Date and end date where start date is 01012017 and end date is 10012017 and then in your code you can add these dates as setrange with the Sales Line Date you desire to, along with Location code and then insert data into your customized table.
Do you want a Report and want to group entries by date and sum of the amount for that particular date.
For eg:
Date |Amount
02/05/2018| 250.00
02/05/2018| 100.00
03/05/2018| 150.00
and you want the data to look like
02/05/2018| 350.00
Is this what you want to do?
Please try to explain your query in detail, I believe you have posted 5 or 6 different posts for the same issue.
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 Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
HoangNam 7
