ktroestler@blytheco.com
  • Male
  • Golden, CO
  • United States
Share

ktroestler@blytheco.com's Discussions

Decimal Precision/Rounding
7 Replies

Hi All,I have a decimal precision issue that is causing me grief.  I'm using Sage 100 with a third party add-on for multi-currency.  In the AR_TransactionPaymentHistory table there is a numeric field…Continue

Started this discussion. Last reply by Peter Scully May 14.

AP Aging Bucket
8 Replies

Hello All,I am trying to create SQL Expressions in my container to categorize AP Open Invoices into aging buckets.  I am successful in getting the Days Outstanding by using the following SQL…Continue

Started this discussion. Last reply by ktroestler@blytheco.com Mar 13.

Is SI any faster with Sage 100 Premium (SQL)
1 Reply

Hi,Does anyone know if SI Report Designer Financial Reports are any faster when using Sage 100 Premium as opposed to Advanced or Standard?I have a client with 140 Companies and SI just takes too long…Continue

Started this discussion. Last reply by NATE Oct 9, 2017.

Loosing My Slicer Connections
2 Replies

Hello,Was curious if anyone else has experienced lost pivot slicer connections when distributing reports.My pivot tables and slicers are on separate worksheets since the slicer controls 30 or so…Continue

Started this discussion. Last reply by ktroestler@blytheco.com Oct 5, 2017.

 

ktroestler@blytheco.com's Page

Latest Activity

ktroestler@blytheco.com replied to Kim Walton's discussion Excel process still running after report runs and Excel is closed
"I am having same issue.  "Close Book on Completion" is checked, however, each time the report is run either manually or through Task Scheduler, an instance of Excel is left open.  Any help is appreciated."
Jun 13
Peter Scully replied to ktroestler@blytheco.com's discussion Decimal Precision/Rounding
"Hi Karl.  I've replied to you directly via email."
May 14
ktroestler@blytheco.com replied to Valerie hagen's discussion reference a period # and Write out month and last day of the month in full
"I'm sure you can do this with a SQL expression, but an easy way is with an Excel Expression like the following: TEXT(EOMONTH(DATE(2000,C2,1),0),"mmmm dd")  Where c2 is 10.  I just picked 2000 as the year, but it could have…"
May 12
ktroestler@blytheco.com replied to ktroestler@blytheco.com's discussion Decimal Precision/Rounding
"Sandra, I don't know what you mean by a sample of the source code but I can provide you with a screen shot of the data in SQL and then the data that the container is returning.  It should be very clear that SI is returning a rounded…"
May 12
Sandra Smith replied to ktroestler@blytheco.com's discussion Decimal Precision/Rounding
"Hi Ken,  Can you please tell us what the third party add-in is and give us a sample of the source code?  Thank you, Sandra."
May 8
Peter Scully replied to ktroestler@blytheco.com's discussion Decimal Precision/Rounding
"Hi Karl. What add-in are you using for this? Can you please provide an image of the base amount in 100 and show how it's pulling through in the Connector. I'm not familiar with any decimal type fields in 100 so it's difficult for me…"
May 8
ktroestler@blytheco.com replied to ktroestler@blytheco.com's discussion Decimal Precision/Rounding
"Any suggestions?"
May 8
ktroestler@blytheco.com replied to ktroestler@blytheco.com's discussion Decimal Precision/Rounding
"Hi Peter, Its happening in the source container, prior to going to Excel.  Karl"
May 7
Peter Scully replied to ktroestler@blytheco.com's discussion Decimal Precision/Rounding
"Hi Karl. Where do you see the rounding happening, in the source data pulled via the connector or in Excel?  I just want to make sure that it's not Excel that's doing the rounding..."
May 7
ktroestler@blytheco.com posted a discussion

Decimal Precision/Rounding

Hi All,I have a decimal precision issue that is causing me grief.  I'm using Sage 100 with a third party add-on for multi-currency.  In the AR_TransactionPaymentHistory table there is a numeric field for the currency exchange entry rate.  This field typically has a lot of decimal places.  When included in any container, SI is rounding the number of decimal places. An example is .0379550 is returned by SI as .038.  This is happening with all values for this field.  I've tried changing the data…See More
May 6
ktroestler@blytheco.com replied to ktroestler@blytheco.com's discussion AP Aging Bucket
"Hi, Thanks for the response.  Your suggestion worked.  This is probably not the most elegant case statement, but here is what I did for the 30-60 day bucket: CASE when CAST(GETDATE()-"AP_OpenInvoice"."InvoiceDate" AS…"
Mar 13
ktroestler@blytheco.com replied to ktroestler@blytheco.com's discussion AP Aging Bucket
"Thank you.  I am familiar with the datediff function, however this really doesn't help me with my case SQL expression.  I am using Sage 100."
Mar 13
ktroestler@blytheco.com replied to ktroestler@blytheco.com's discussion AP Aging Bucket
"Thanks, I'll try that."
Mar 12
ktroestler@blytheco.com replied to ktroestler@blytheco.com's discussion AP Aging Bucket
"Hi Peter! This is for Sage 100. Karl"
Mar 12
Munya Musi replied to ktroestler@blytheco.com's discussion AP Aging Bucket
"Hi You are missing the function END at the end of your script, it shoud read CASE WHEN CAST(GETDATE()-"AP_OpenInvoice"."InvoiceDate" AS int) < 30 THEN "AP_OpenInvoice"."Balance" ELSE 0 END"
Mar 12
Peter Scully replied to ktroestler@blytheco.com's discussion AP Aging Bucket
"Hi Karl. When subtracting dates it's best to use the DATEDIFF function. https://www.w3schools.com/sql/func_sqlserver_datediff.asp If this doesn't help, let me know what Sage product this is for and I'll take a further look."
Mar 12

Profile Information

Sage Intelligence powers the following Accounting/ERP/Payroll solutions, pick yours
Sage 100 ERP Intelligence Reporting (Formerly MAS)
About Me:
ERP Consultant - Blytheco
How long have you been using the above solution?
2 months - Sage Intelligence, 20 years MAS 90/200 - Sage 100
Where did you hear about us?
Sage Intelligence Academy

Comment Wall

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

Join The Sage Intelligence Community

  • No comments yet!
 
 
 

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2018   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service