Author |
Message |
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 08 Mar 2011 at 8:48am |
are the "account number" fields in order across the entire report so that you never jump back to one
like
410000.00
410000.00
410000.00
412500.00
412500.00
412325.00
and NOT like
410000.00
412500.00
410000.00
410000.00
412500.00
|
IP Logged |
|
Repent34
Newbie
Joined: 03 Mar 2011
Location: United States
Online Status: Offline
Posts: 19
|
Posted: 08 Mar 2011 at 8:53am |
Originally posted by DBlankare the "account number" fields in order across the entire report so that you never jump back to one
like
410000.00
410000.00
410000.00
412500.00
412500.00
412325.00
and NOT like
410000.00
412500.00
410000.00
410000.00
412500.00
Yes, currently there is no grouping applied to the records. There currently is record sorting by GLAccount number. so I see the accounts listed in numerical order as you have in the first example. In it's finished form, the report and records would be sorted by CustomerCatNo(Sales Region) and then by Invoice number. chris
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 08 Mar 2011 at 8:58am |
IN your RT change is the evaluate section set to
'On change of field' and the GLAccount number field selected?
|
IP Logged |
|
Repent34
Newbie
Joined: 03 Mar 2011
Location: United States
Online Status: Offline
Posts: 19
|
Posted: 08 Mar 2011 at 9:19am |
Originally posted by DBlankIN your RT change is the evaluate section set to
'On change of field' and the GLAccount number field selected? Yes here is a screen clip: http://i686.photobucket.com/albums/vv225/Repent34/RTclipforDan.jpg
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 08 Mar 2011 at 9:25am |
can you post your final @GLAcctBalRunningTotalFormula
|
IP Logged |
|
Repent34
Newbie
Joined: 03 Mar 2011
Location: United States
Online Status: Offline
Posts: 19
|
Posted: 08 Mar 2011 at 9:29am |
Originally posted by DBlankcan you post your final @GLAcctBalRunningTotalFormula You bet http://i686.photobucket.com/albums/vv225/Repent34/RTclipforDan-1.jpg
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 08 Mar 2011 at 9:35am |
Everything seems in order. To trouble shoot, on the detail section set the GLacct# field, next to the MOnthBeginValue next to the @GLAcctBalRunningTotalFormula next to the Running Total
it should look like this
Acct# AMount 'Amount_W_0s' RT
410000.00 $500 $500 500
410000.00 $500 $500 500
410000.00 $500 $500 500
412500.00 $800 $800 1300
412325.00 $900 $0 1300
412325.00 $900 $0 1300
415000.00 $200 $200 1500
What does yours look like?
|
IP Logged |
|
Repent34
Newbie
Joined: 03 Mar 2011
Location: United States
Online Status: Offline
Posts: 19
|
Posted: 08 Mar 2011 at 11:24am |
Dan;
I had a slight mistake on my end that I fixed.
Here is what it looks like now. Notice the:
Report Total Sales is $801,761,156.70 should be $1,556,817.78 Report total Adjustments is $30,284,266.00 should be $58,804.40 Report Net Sales $ 771,476,890.70 Should be $1,498,013.38 Balance per GL is $-1,498,013,38 so this is correct Difference is $0.00 and is correct
The report is also 3332 pages long instead of the usual 9 or so pages.
Here are some screen shots showing the progression of some of the account numbers so you can get the idea. I also included the last page of the report.
http://s686.photobucket.com/albums/vv225/Repent34/
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 08 Mar 2011 at 11:43am |
just guessing here...
You likely need to make similar running totals to get your other values.
YOu may have a cartesian join (I think that is what it is called) going on which is duplicating your rows and making the report length huge as well as your other values huge
Edited by DBlank - 08 Mar 2011 at 11:49am
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 08 Mar 2011 at 11:49am |
In File > Report Options there is a check box for 'Select Distinct Records'. it does not work with all data types but you might try that too.
|
IP Logged |
|
|