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

ktroestler@blytheco.com's Discussions

GETDATE() IN WHERE CLAUSE
2 Replies

Hello,This should be easy, but I'm having difficulty.First off, I'm using Sage 100.  I am trying to get yesterdays orders in an automated report by adding a where clause such as below, however, its…Continue

Started this discussion. Last reply by Peter Scully Nov 27.

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.

 

ktroestler@blytheco.com's Page

Latest Activity

Peter Scully replied to ktroestler@blytheco.com's discussion GETDATE() IN WHERE CLAUSE
"Good to hear Karl!"
Nov 27
ktroestler@blytheco.com replied to ktroestler@blytheco.com's discussion GETDATE() IN WHERE CLAUSE
"Ok, I figured it out.  SI needed Parentheses surrounding the GETDATE()-1 expression."
Nov 19
ktroestler@blytheco.com posted a discussion

GETDATE() IN WHERE CLAUSE

Hello,This should be easy, but I'm having difficulty.First off, I'm using Sage 100.  I am trying to get yesterdays orders in an automated report by adding a where clause such as below, however, its not working.  Any help would be appreciated!INNER JOIN "AR_Customer" ON "SO_SalesOrderHistoryHeader"."ARDivisionNo" = "AR_Customer"."ARDivisionNo" AND "SO_SalesOrderHistoryHeader"."CustomerNo" = "AR_Customer"."CustomerNo")WHERE "SO_SalesOrderHistoryHeader"."OrderDate" = GETDATE()-1Thanks in advance!!!See More
Nov 19
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

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