Lincoln Mahlangu
  • Male
  • Johannesburg
  • South Africa
Share

Lincoln Mahlangu's Groups

 

Lincoln Mahlangu's Page

Latest Activity

Lincoln Mahlangu replied to Lincoln Mahlangu's discussion Report Designer Row sets not pulling all accounts in the group Sage Intelligence Reporting
"Hi Paul, I finally figured it out, the way to get it correct is to always have a range. So in my case entering just the one account the formula doesn't work but if I do a range even if the account is the same then the calculation comes out…"
Jul 31, 2018
Paul replied to Lincoln Mahlangu's discussion Report Designer Row sets not pulling all accounts in the group Sage Intelligence Reporting
"Hi Lincoln, Without the ability to see everything it's going to be difficult to assist any further. I would edit the formula in the formula editor and check each component until you see it return a number. I believe there's…"
Jul 27, 2018
Lincoln Mahlangu replied to Lincoln Mahlangu's discussion Report Designer Row sets not pulling all accounts in the group Sage Intelligence Reporting
"Hi Paul, Yes I thought that could be the case or maybe because it ends with a 99, but the accounts are all the same for this row set. Even worse now, if I do a range of accounts I get a figures but if I just have one account nothing is…"
Jul 27, 2018
Paul replied to Lincoln Mahlangu's discussion Report Designer Row sets not pulling all accounts in the group Sage Intelligence Reporting
"Hi Lincoln, The best I can do from here is suggest you compare the account(s) that do produce a value to the account that does not. I think there is something different about the account the is not retrieved."
Jul 27, 2018
Lincoln Mahlangu replied to Lincoln Mahlangu's discussion Report Designer Row sets not pulling all accounts in the group Sage Intelligence Reporting
"Hi Paul, Its meant to pull the account balance for the period. In my case there is one transaction in each period so I'm expecting to have values each period."
Jul 27, 2018
Paul replied to Lincoln Mahlangu's discussion Report Designer Row sets not pulling all accounts in the group Sage Intelligence Reporting
"Hi Lincoln, This is good. We have narrowed the source of the issue. Is your formula retrieving the account balance or the period net change? I am not clear on your meaning about actuals versus value for the period so the preceding is a best…"
Jul 27, 2018
Lincoln Mahlangu replied to Lincoln Mahlangu's discussion Report Designer Row sets not pulling all accounts in the group Sage Intelligence Reporting
"Hi Paul, Yes I did, it returns no data when I do so. I have also just tried on a blank worksheet and the result is the same. Weird though, Actuals for period 3 is showing -4132.46 but the value in that period is actually 13 678.56. When I drill down…"
Jul 27, 2018
Paul replied to Lincoln Mahlangu's discussion Report Designer Row sets not pulling all accounts in the group Sage Intelligence Reporting
"Hi Lincoln, One question for you: Did you try 75.2.2.2.99 on it's own to confirm the data comes through? The formula looks good to me but I have found cases where there are really small things that are not readily visible that cause…"
Jul 26, 2018
Lincoln Mahlangu added a discussion to the group Sage Intelligence Reporting
Thumbnail

Report Designer Row sets not pulling all accounts

Hi there,I'm creating a P&L using Report Designer and need to have it categorised as needed by my client.I'm noticing that some row sets are not pulling the data. For example I have added a row set "Insurance" with type "Account" and the rule is "75.2.2.2.1 to 75.2.2.2.4 + 75.2.2.2.99".On generating the report I see that account "75.2.2.2.99" is being omitted and I have checked to ensure that there is data for the specified period. I also have another one where the rule for Account is…See More
Jul 26, 2018
Lincoln Mahlangu joined Bron Dorrofield's group
Jul 26, 2018
Lincoln Mahlangu is now a member of The Sage Intelligence Community
Feb 12, 2018

Profile Information

Sage Intelligence powers the following Accounting/ERP/Payroll solutions, pick yours
Sage Pastel Intelligence Reporting (Formerly BIC), Excel On Steroids
How long have you been using the above solution?
8 years
Where did you hear about us?
Sage Intelligence website

Comment Wall (1 comment)

You need to be a member of The Sage Intelligence Community to add comments!

Join The Sage Intelligence Community

At 12:11pm on April 12, 2018, Mrs.Dankwa Perious said…


Good day,
I picked interest on you after going through your short profile and demand it necessary to write you immediately. I have something very vital to disclose to you, but I found it difficult to express myself here, since it's a public site.Could you please get back to me on(miss.bb.abiolabawuah00@gmail.com) for the full details.

Have a nice day.
Mrs.Dankwa Perious.

 
 
 

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service