3,027
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
Please try to explain your query in detail, I believe you have posted 5 or 6 different posts for the same issue.
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
Date |Amount
02/05/2018| 350.00
03/05/2018| 150.00
Is this what you want to do?
Hi,
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.
Hi
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.
Thanks
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (