Hello all I need help about reports in navision. I need create multiple fields in my report that act like the flowfield(Sum) in tables. To be clear. I will make a report with some fileds which will sum the G/L Entries with an certain account and which are caused by sales processes (Can be idetified-filtered by source codes I think). There are multiple fileds like that. And those fields are static so there is no need for a counter like function only fileds with certain sums.
… and what would be your problem??? So far, everything you comment sounds ok, though i don’t get the “counter like function” part… [;)] Saludos Nils
ok I am “literally” clueless how to do it well I know what to do (Set filters … etc.) but I never tried or met an example report like this kind of usage. So I need general information about creation of sums of ledger entries. Mind you I will not be using a flowfield but entries to calculate and show predetermined totals (not the entries itself) in a list. What do I mean by counter like function is reports generally get and show a list of records which I will not do.
On the section where you want to show the total of G/L Entries, you must define a global record e.g. recGLEntries. Put a filter (SETFILTER or SETRANGE) you want on recGLEntries. Define a globel decimal e.g. decTotal. decTotal := recGLEntries.CALCSUMS(Field); Put decTotal in your section. Hopefully is this what you meant.
Well… it is a bit harder than that since there will be only one section and different fields all beeing calculated by G/L Entry table by different filters set. Still it gives a starting point thanks
You probably have to repeat the following part of code in that section. Put a filter (SETFILTER or SETRANGE) you want on recGLEntries. Define a globel decimal e.g. decTotal. decTotal := recGLEntries.CALCSUMS(Field); And define decTotal2, decTotal3, etc. and use other Fields for recGLEntries.CALCSUMS(Field). Good luck!
decTotal := recGLEntries.CALCSUMS(Field); Rises an error message for me “Decimal := boolean is not possible!” Are u sure the syntax is correct. I use Nav 3.7. I also checked the help it says comment shows the sum of the amount field wherever I use the amount. I guess it will be easier to describe the report layout. There are two columns and about 30 rows. All of them has a specific information like… Field(R,C) (R stands for Row, C is for Column) Field(1,1) is the cash income of sales Field(1,2) is the cash payment of sales returns. Field(2,1) is the income of Bank Account A by any means of sales … It goes on like that. Since there is only one page with all preset values I am having difficulties. If any one knows a report working this way in navision that I can use as an example it would be great. Also any other help will be greatly appreciated.
Oops, I made a mistake… [:I] decTotal := recGLEntries.CALCSUMS(Field); isn’t correct. It must be: recGLEntries.CALCSUMS(Field); decTotal := recGLEntries.Field; There are some conditions for using CALCSUMS. These conditions are well explaned in the CSIDE Reference Guide. I don’t know an example of a standard report. We rarely use standard reports.