3,027
Hi
I have main form Location & sub Form . Both Forms are linked on Location Code. In Sub Form i want to display Day Wise Sales Amount Data
from Sales Line table.
01/04/2018 200000
02/04/2018 400000 & so on
Thanks
*This post is locked for comments
Hi
Main Form is Location . In Sub Form i want t display Data.
Thanks
can you send us the screenshot, is it a document form if so where are you planning to populate the values ? What is your actual requirement
Hi
Code is written on Push Trigger of Button .
Thanks
Where are you writing this code and what is the purpose of it ?
Hi
I am trying like this but not working . It is giving error
DLine already exists
Identification fields and values:
Location = 'LDH',Date='01/01/17'
TEntry has key Location,Date . In Sum Amount Index field it is written Amount . In DLine table i want display Date Wise Amount Sum of Location.
TEntry.RESET;
TEntry.SETCURRENTKEY("Location",Date);
TEntry.SETFILTER("Location","No.");
TEntry.SETRANGE(TEntry.Date,StartDate,EndDate);
IF TEntry.FINDFIRST THEN BEGIN
REPEAT
DLine.INIT;
DLine."Location" := "No.";
DLine."Date" := TEntry.Date;
DLine."Amount" := TEntry."Amount";
DLine.Status := 0;
DLine.INSERT;
UNTIL TEntry.NEXT=0;
END;
Thanks
what is your source for the subform , is it sales line table ?
Hi
In Sales Lines table there may be lot of entries of same date. Like
01/04/2018 Doc1 20000.00
01/04/2018 Doc2 35000.00
02/04/2018 Doc3 25000.00
05/04/2018 Doc4 40000.00
05/04/2018 Doc5 50000.00
But in SubForm i want data should displayed like this.
01/04/2018 55000.00
02/04/2018 25000.00
05/04/2018 90000.00
Thanks
Provide more details..
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
