template in an accounting program
template in an accounting program
I need help with a print template in an accounting program. The manufacturer provides basic forms, and if we want to change something, we have to change it ourselves. I have never dealt with Stimulsoft before. The attachments show what the program is like and what variables and constants I can choose from.
I would like to have a line after each line summarizing the above white lines as in the picture.
Instead of 1/2024, I would like the name of the month to be e.g. January.
The last thing I would like to change here is that when the value is "0.00" the field will be empty.
I have a .npt template file but I can't add it.
If I am in the wrong section, please move to the appropriate one.
I would like to have a line after each line summarizing the above white lines as in the picture.
Instead of 1/2024, I would like the name of the month to be e.g. January.
The last thing I would like to change here is that when the value is "0.00" the field will be empty.
I have a .npt template file but I can't add it.
If I am in the wrong section, please move to the appropriate one.
-
- Posts: 6358
- Joined: Tue Mar 20, 2018 5:34 am
Re: template in an accounting program
Hello,
> I would like to have a line after each line summarizing the above white lines as in the picture.
You can use the SumRunnning() function.
> Instead of 1/2024, I would like the name of the month to be e.g. January.
Try to use the MonthIdent function.
> The last thing I would like to change here is that when the value is "0.00" the field will be empty.
Try to set the HideZeros property.
Thank you.
> I would like to have a line after each line summarizing the above white lines as in the picture.
You can use the SumRunnning() function.
> Instead of 1/2024, I would like the name of the month to be e.g. January.
Try to use the MonthIdent function.
> The last thing I would like to change here is that when the value is "0.00" the field will be empty.
Try to set the HideZeros property.
Thank you.
Re: template in an accounting program
Lech are u from Poland and can we contact in polish lang ?
-
- Posts: 6358
- Joined: Tue Mar 20, 2018 5:34 am
Re: template in an accounting program
Dzień dobry,
No własnie możemy rozmawiać po polsku, ale proszę zwrócić uwagę, że to jest forum angielski)
Pozdrawiam,
Lech Kulikowski.
No własnie możemy rozmawiać po polsku, ale proszę zwrócić uwagę, że to jest forum angielski)
Pozdrawiam,
Lech Kulikowski.
Re: template in an accounting program
Dzień Dobry,
Tak wiem, a czy jest możliwy kontakt mailowy lub telefoniczny, bo widzę, że jest Pan ekspertem w tych sprawach, a producent oprogramowania odsyła do instrukcji Stimsulsoft, albo serwisu ale serwis też za bardzo nie chce pomóc. Wydruki są tutaj tragiczne jak sprzed dekady. Jeżeli kontakt na forum to będziemy kontynuować tutaj, może być wtedy po ang. Jak do tej pory nie potrzebowałem programowania, muszę zobaczyć jak to ugryźć i resztę powinien rozpracować. Ale nie wiem czy sam program księgowy nie ma jakiś ograniczeń.
W razie kontaktu jk@bufu.pl
When i what sumabove what it should be for example cell value
{SumRunnning(Dokument.PrzychodSprzedazTowarowIUslug)}
but when i want use it "Error!The name 'SumRunning' does not exist in the current context"
The same situation with
{MonthIdent(Dokument.MiesiacKwartal)}
Probably i do something wrong.
Now i see that is HideZeros property, when its ON blank cell is perfect But for now how make sum above?
Tak wiem, a czy jest możliwy kontakt mailowy lub telefoniczny, bo widzę, że jest Pan ekspertem w tych sprawach, a producent oprogramowania odsyła do instrukcji Stimsulsoft, albo serwisu ale serwis też za bardzo nie chce pomóc. Wydruki są tutaj tragiczne jak sprzed dekady. Jeżeli kontakt na forum to będziemy kontynuować tutaj, może być wtedy po ang. Jak do tej pory nie potrzebowałem programowania, muszę zobaczyć jak to ugryźć i resztę powinien rozpracować. Ale nie wiem czy sam program księgowy nie ma jakiś ograniczeń.
W razie kontaktu jk@bufu.pl
When i what sumabove what it should be for example cell value
{SumRunnning(Dokument.PrzychodSprzedazTowarowIUslug)}
but when i want use it "Error!The name 'SumRunning' does not exist in the current context"
The same situation with
{MonthIdent(Dokument.MiesiacKwartal)}
Probably i do something wrong.
Now i see that is HideZeros property, when its ON blank cell is perfect But for now how make sum above?
-
- Posts: 6358
- Joined: Tue Mar 20, 2018 5:34 am
Re: template in an accounting program
Hello,
> but when i want use it "Error!The name 'SumRunning' does not exist in the current context"
Should be:
{SumRunning(DataBandName, DataSourceName.ColumnsName)}
> The same situation with {MonthIdent(Dokument.MiesiacKwartal)}
What is the type of the MiesiacKwartal column?
Also, please clarify which version are you use? File - About.
Thank you.
> but when i want use it "Error!The name 'SumRunning' does not exist in the current context"
Should be:
{SumRunning(DataBandName, DataSourceName.ColumnsName)}
> The same situation with {MonthIdent(Dokument.MiesiacKwartal)}
What is the type of the MiesiacKwartal column?
Also, please clarify which version are you use? File - About.
Thank you.
- Attachments
-
- Screenshot 2024-03-22 135703.png (39.67 KiB) Viewed 1116 times
Re: template in an accounting program
The version of Stimulsoft that comes with the accounting software is Stimulsoft Reports Ver 2018.2.3 from 06.07.2018, WPF (Rev 1)
https://file.io/iyWvcn5Jxycd
Additionally, the settings in the program are included in the attachment. I didn't change anything, it's standard and, a link to the KPiR.mrt file
Thanks to your example, I noticed where I was making a mistake. Once the correct premium is applied, the summation works
But I can't figure out the name of the month.
The formula displays the current month correctly as text.
I tried but it gives an error that Monthldent does not exist in the context. I also tried something similar, but it didn't work.
So far, I managed to get practically what I wanted there.
What should the code look like if I wanted to use a math function and wanted to get the sum result of each row from columns 9-10-11-14.
I tried that but I'm not doing something wrong
and how to make this result cumulatively like the others.
I don't know why the line appears in the display incrementally, it is not there in the preview, but it eventually appears. Does the line have to be there if there is also a line above it?
https://file.io/iyWvcn5Jxycd
Additionally, the settings in the program are included in the attachment. I didn't change anything, it's standard and, a link to the KPiR.mrt file
Thanks to your example, I noticed where I was making a mistake. Once the correct premium is applied, the summation works
Code: Select all
{SumRunning(_Podsumowanie_Zapisów_W_KPiR__Dane, Dokument.PrzychodSprzedazTowarowIUslug)}
The
Code: Select all
{Today.ToString("MMMM")}
I tried
Code: Select all
{MonthIdent(_Summowanie_Zapisów_W_KPiR__Dane, Document.MiesiacKwartal)}
Code: Select all
{Document.MonthQuarter.ToString("MMMM")}
What should the code look like if I wanted to use a math function and wanted to get the sum result of each row from columns 9-10-11-14.
I tried that but I'm not doing something wrong
Code: Select all
{Dokument.Przychod - Dokument.ZakupyTowarow - Dokument.KosztyUboczneZakupow - Dokument.Wydatki}
I don't know why the line appears in the display incrementally, it is not there in the preview, but it eventually appears. Does the line have to be there if there is also a line above it?
-
- Posts: 6358
- Joined: Tue Mar 20, 2018 5:34 am
Re: template in an accounting program
Hello,
Most probably, in your version (old version), the MonthIdent function is not available.
> I don't know why the line appears in the display incrementally, it is not there in the preview, but it eventually appears. Does the line have to be there if there is also a line above it?
Please send us your report with test data for analysis.
Thank you.
Most probably, in your version (old version), the MonthIdent function is not available.
> I don't know why the line appears in the display incrementally, it is not there in the preview, but it eventually appears. Does the line have to be there if there is also a line above it?
Please send us your report with test data for analysis.
Thank you.
Re: template in an accounting program
Are the files I sent enough? *.MRT and *.MDC ?Lech Kulikowski wrote: ↑Mon Mar 25, 2024 2:47 pm Please send us your report with test data for analysis.
What should the code look like if I wanted to use a math function and wanted to get the sum result of each row from columns 9-10-11-14.
9 = _Podsumowanie_Zapisów_W_KPiR__Dane, Dokument.Przychod
10 = _Podsumowanie_Zapisów_W_KPiR__Dane, Dokument.ZakupyTowarow
11 = _Podsumowanie_Zapisów_W_KPiR__Dane, Dokument.KosztyUboczneZakupow
14 = _Podsumowanie_Zapisów_W_KPiR__Dane, Dokument.Wydatki
I tried that but I'm not doing something wrong
Code: Select all
{Dokument.Przychod - Dokument.ZakupyTowarow - Dokument.KosztyUboczneZakupow - Dokument.Wydatki}
- Attachments
-
- KPiR Podsumowanie(nowy)1.mrt
- (134.58 KiB) Downloaded 76 times
-
- KpirPodsumowanie.mdc
- (126.58 KiB) Downloaded 78 times
-
- Posts: 6358
- Joined: Tue Mar 20, 2018 5:34 am
Re: template in an accounting program
Hello,
> I tried that but I'm not doing something wrong
It should work.
But in your expression are used variables, not columns from the data source.
Also, from 2018.x. version were made a lot of fixes, improvements and optimizations with working with business objects.
Thank you.
> I tried that but I'm not doing something wrong
It should work.
But in your expression are used variables, not columns from the data source.
Also, from 2018.x. version were made a lot of fixes, improvements and optimizations with working with business objects.
Thank you.