Mark Du Sautoy
  • Male
  • Adelaide, South Australia
  • Australia
Share

Mark Du Sautoy's Friends

  • Glynnis

Mark Du Sautoy's Discussions

Report Designer-Tools-Dynamic Range- How to subtract an account in the middle of the range

HI,Using the Dynamic Account Range method under the Tools menu, I would like to subtract an account out of a range. Is this possible? If so what is the formula to do this?eg in the range 3135-02 TO…Continue

Started Feb 12

SAGE 300 Report Designer
5 Replies

Hi,I am new to report designer. When I run the report designer it picks up our Database twice in the Data. ( this is visible when you pick the company, it appears twice). Should you in the formula…Continue

Started this discussion. Last reply by Mark Du Sautoy Jan 31.

NEED HELP WITH CREATING A NEW AGED DEBTORS REPORT
1 Reply

Hi,I have created a new report but as I am new to creating new reports i have the following two problem with my report.1) the report shows duplicate values 2) Then I need the report  to place the…Continue

Started this discussion. Last reply by Glynnis Aug 29, 2017.

 

Mark Du Sautoy's Page

Latest Activity

Mark Du Sautoy posted a discussion

Report Designer-Tools-Dynamic Range- How to subtract an account in the middle of the range

HI,Using the Dynamic Account Range method under the Tools menu, I would like to subtract an account out of a range. Is this possible? If so what is the formula to do this?eg in the range 3135-02 TO 3135-90 , I would like to subtract the account 3135-79.ThanksMarkSee More
Feb 12
Mark Du Sautoy replied to Mark Du Sautoy's discussion SAGE 300 Report Designer
"If we dont select the company, it will duplicate the information for each gl account."
Jan 31
Sandra Smith replied to Mark Du Sautoy's discussion SAGE 300 Report Designer
"Oh, this is using the Layout Generator. That is ok.  Just select one. If you choose the columns and rows you want to use then generate the Layout do you still see double values?"
Jan 31
Mark Du Sautoy replied to Mark Du Sautoy's discussion SAGE 300 Report Designer
"Thanks Sandra see below database shows twice DB%20shows%20twice.xlsx"
Jan 31
Jim Smith replied to Mark Du Sautoy's discussion SAGE 300 Report Designer
"You probably have both Functional and Source amounts on your report. Make sure your formulas are only using one or the other. "
Jan 30
Sandra Smith replied to Mark Du Sautoy's discussion SAGE 300 Report Designer
"Hi Mark,  It is ok to use the company code within the formula but you don't have to use it in the single company (non-consolidated) report.  I don't understand where you are seeing twice the data in the report Can you…"
Jan 30
Mark Du Sautoy posted a discussion

SAGE 300 Report Designer

Hi,I am new to report designer. When I run the report designer it picks up our Database twice in the Data. ( this is visible when you pick the company, it appears twice). Should you in the formula not pick our company, all the accounts will  return a duplicated value. Why is this happening?Thanks in advance.See More
Jan 30
Glynnis replied to Mark Du Sautoy's discussion NEED HELP WITH CREATING A NEW AGED DEBTORS REPORT
"Hi Mark Welcome to report writing :-)   Sage Intelligence have quite a few free reports available on the Sage 300 Report Store which I am sure would be an excellent starting point for the report you are wanting to create. If you…"
Aug 29, 2017
Mark Du Sautoy posted a discussion

NEED HELP WITH CREATING A NEW AGED DEBTORS REPORT

Hi,I have created a new report but as I am new to creating new reports i have the following two problem with my report.1) the report shows duplicate values 2) Then I need the report  to place the values in the respective ageing eg  Current, 30 days 60 Days Etc but all the values are landing in 0 days.See More
Aug 23, 2017
Mark Du Sautoy is now a member of The Sage Intelligence Community
Aug 23, 2017

Profile Information

Sage Intelligence powers the following Accounting/ERP/Payroll solutions, pick yours
Sage 300 ERP Intelligence Reporting (Formerly Accpac)
How long have you been using the above solution?
4 years
Where did you hear about us?
Other

Comment Wall (1 comment)

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

Join The Sage Intelligence Community

At 11:47pm on September 19, 2017, Sandra Essien said…

Good Day,

How is everything with you, I picked interest on you after going through your short profile and deemed 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:( mrs.sandraessien@yahoo.com) for the full details.

Have a nice day

Thanks God bless.

Sandra Essien

 
 
 

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service