Jasmine Rury
  • Female
  • Eugene, OR
  • United States
Share

Jasmine Rury's Groups

Jasmine Rury's Discussions

Multiple Company AR Aging – Consolidated Connecter
1 Reply

I am trying to create a multi company aging report. I can get the report to show onw of the other detailed things but not both. I'm not sure what I'm doing wrong.This displays the company…Continue

Tags: COMPANY, MULTI, AGING, AR

Started this discussion. Last reply by Doug Walker Mar 16, 2017.

Consolidation Report on Vendor with Company Code
14 Replies

I am trying to build a report that will show me what companies a particular vendor is set up in. We have 53 companies. I am not sure how to join the company code with the vendor table to show on one…Continue

Tags: Company, Code, with, Vendor, Report

Started this discussion. Last reply by Carmen Griessel Sep 23, 2016.

 

Jasmine Rury's Page

Latest Activity

Ruth Gray replied to Jasmine Rury's discussion Error: Expected lexical element not found: FROM in the group Free Reports Group
"Which Sage Software are you using? I see you tried to download Sage 100 & Sage 50 reports. And I am guessing that is why you are getting the errors, the reports are specific to Sage products so will only work on the Sage Product that it has been…"
Mar 17, 2017
Sandra Smith replied to Jasmine Rury's discussion Error: Expected lexical element not found: FROM in the group Free Reports Group
"what version of SQL?  Did you use the reports from the Report Utility or from the free templates?"
Mar 17, 2017
Jasmine Rury replied to Jasmine Rury's discussion Error: Expected lexical element not found: FROM in the group Free Reports Group
"Attached. I'm not having any luck getting it to accept the report even when I alter the error sections. Error also attached.  "
Mar 17, 2017
Jasmine Rury replied to Jasmine Rury's discussion Error: Expected lexical element not found: FROM in the group Free Reports Group
"Yes this is Sage Intelligence Connector 2015. bummer. :("
Mar 17, 2017
Doug Walker replied to Jasmine Rury's discussion Multiple Company AR Aging – Consolidated Connecter
"Jasmine - I have created an AR Aged Invoice report for Sage 100 and it took a long time to finally figure out how to get it to work. Ended up having to build multiple Sub Reports to get the data the data in the right format to be able to build the…"
Mar 16, 2017
Jasmine Rury replied to Ruth Gray's discussion Aged Receivables (C11-0-1) in the group Free Reports Group
"Do you know why I would be getting this error for the report you offered? BTW thank you for sharing. I really would love to get this working! Description : [ProvideX][ODBC Driver]Expected lexical element not found: FROMNumber : -2147217900Source :…"
Mar 16, 2017
Jasmine Rury replied to Ruth Gray's discussion Accounts Receivable Invoice Aging (S100C) 1-2 in the group Free Reports Group
"I'm getting this error: Description : [ProvideX][ODBC Driver]Expected lexical element not found: FROMNumber : -2147217900Source : Driver Error : 1015SQL State : 37000 Any ideas?"
Mar 16, 2017
Sandra Smith replied to Jasmine Rury's discussion Error: Expected lexical element not found: FROM in the group Free Reports Group
"Is this version 2015? Tends to not work on lower versions. "
Mar 16, 2017
Doug Walker replied to Jasmine Rury's discussion Error: Expected lexical element not found: FROM in the group Free Reports Group
"What accounting system is this for? What report is this?"
Mar 16, 2017
Jasmine Rury added a discussion to the group Free Reports Group
Thumbnail

Error: Expected lexical element not found: FROM

I keep trying to use the importable reports, I keep getting this error message; any ideas?Description : [ProvideX][ODBC Driver]Expected lexical element not found: FROMNumber : -2147217900Source : Driver Error : 1015SQL State : 37000Attached is the code:SELECT CAST(ROUND(IIF(acrinv.duedte>=perlist.periodend,IIF((acrinv.amtpad = 0 AND acrinv.dsctkn = 0),acrinv.invttl-acrinv.retain,IIF(ISNULL(PAID.recnum),acrinv.invttl-acrinv.amtpad-acrinv.dsctkn-acrinv.retain,acrinv.invttl -…See More
Mar 16, 2017
Jasmine Rury posted a discussion

Multiple Company AR Aging – Consolidated Connecter

I am trying to create a multi company aging report. I can get the report to show onw of the other detailed things but not both. I'm not sure what I'm doing wrong.This displays the company info:(("AR_Options"RIGHT JOIN "SY_Company"  ON "AR_Options"."CompanyCode" = "SY_Company"."CompanyCode"  AND "AR_Options"."CompanyCode" = "SY_Company"."CompanyCode")LEFT JOIN "AR_Customer"  ON "AR_Options"."Divisions" = "AR_Customer"."ARDivisionNo")This displays the customer aging info:(("AR_Options"RIGHT JOIN…See More
Mar 16, 2017
Jasmine Rury joined Sage Alchemex's group
Dec 24, 2016
Carmen Griessel replied to Jasmine Rury's discussion Consolidation Report on Vendor with Company Code
"Thanks for sharing Doug.  "
Sep 23, 2016
Doug Walker replied to Jasmine Rury's discussion Consolidation Report on Vendor with Company Code
"Created a new container using the AP Vendor table under Consolidated. Changed it to a Join. Then added the inner joins. Then added the Data Expressions. That was it."
Sep 22, 2016
Jasmine Rury replied to Jasmine Rury's discussion Consolidation Report on Vendor with Company Code
"How did you build that?"
Sep 22, 2016
Jasmine Rury replied to Jasmine Rury's discussion Consolidation Report on Vendor with Company Code
"That worked like a charm!!!! I'm very grateful!"
Sep 22, 2016

Profile Information

Sage Intelligence powers the following Accounting/ERP/Payroll solutions, pick yours
Sage 100 ERP Intelligence Reporting (Formerly MAS), Sage 100 Contractor Intelligence Reporting

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

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service