Dan St. John
  • Male
  • Hollywood, FL
  • United States
Share

Dan St. John's Friends

  • Teofanes Zorrilla
  • Jose Soeiro

Dan St. John's Groups

Dan St. John's Discussions

Sage 100 Inventory Item Image
1 Reply

Can the Inventory Image stored in the CI Item table be displayed in the output file or pivot table?Sage 100 stores the *.jpg field in "CI_Item"."ImageFile"Additional Information is stored in…Continue

Tags: Image, Item, Inventory

Started this discussion. Last reply by Keeveshin Naidoo Aug 10.

Non-Financial Current month/year vs. prior year comparison
7 Replies

Trying to design a Customer Sales Report that contains Month/Current Year and same Month/Prior Year.Platform: Sage 100Table: AR_InvoiceHistoryHeaderParameter field: InvoiceDateTrying to present a…Continue

Started this discussion. Last reply by Dan St. John Jul 16.

Sage 500 Reference Codes

Has anyone had any success designing/generating Financial Reports using the Sage 500 Reference Code feature?Continue

Started Jun 4, 2013

 

Dan St. John's Page

Latest Activity

Keeveshin Naidoo replied to Dan St. John's discussion Sage 100 Inventory Item Image
"Hi Dan, Connecting Excel to a DB to capture an image may not work unless the file type is recognized by Excel. Excel natively understands raw data and as a result, this connection would most likely result in some scrambled characters being displayed…"
Aug 10
Dan St. John posted a discussion

Sage 100 Inventory Item Image

Can the Inventory Image stored in the CI Item table be displayed in the output file or pivot table?Sage 100 stores the *.jpg field in "CI_Item"."ImageFile"Additional Information is stored in "CI_Item".ItemImageWidthInPixels and "CI_Item"."ItemImageheightInPixels"How do I display the actual image next to the Item Description in my output report?See More
Aug 8
Dan St. John replied to Dan St. John's discussion Non-Financial Current month/year vs. prior year comparison
"Thanks, Doug! I really appreciate the response. Long time no talk. Hope all is well with you and yours."
Jul 16
Doug Walker replied to Dan St. John's discussion Non-Financial Current month/year vs. prior year comparison
"Dan - Attached is an example on how to get the Current Pd/Year and the Prior Pd/Year. It's a Union report that has 2 sub reports. One for Current Pd/Year and one for the Prior Pd/Year. There are 2 Pass-Thru Variables setup in each for Invoice…"
Jul 16
Dan St. John replied to Dan St. John's discussion Non-Financial Current month/year vs. prior year comparison
"Forgot to point out the report is filtered by Customer."
Jul 13
Dan St. John replied to Dan St. John's discussion Non-Financial Current month/year vs. prior year comparison
"Detail -- Invoice Totals I have attached a snapshot"
Jul 13
Doug Walker replied to Dan St. John's discussion Non-Financial Current month/year vs. prior year comparison
"Are you looking to get Summarized Sales Totals or Detail (i.e. Invoice) Totals"
Jul 12
Dan St. John replied to Dan St. John's discussion Non-Financial Current month/year vs. prior year comparison
"Thank you for the response... Greatly appreciated! I will check out the YouTube links."
Jul 12
Keeveshin Naidoo replied to Dan St. John's discussion Non-Financial Current month/year vs. prior year comparison
"Hi Dan, This can be achieved by use of a "pass through variable" in your container. You'll can use this variable to filter data in the report to a specified date range. You can find more information on how to set this up at the below…"
Jul 12
Dan St. John posted a discussion

Non-Financial Current month/year vs. prior year comparison

Trying to design a Customer Sales Report that contains Month/Current Year and same Month/Prior Year.Platform: Sage 100Table: AR_InvoiceHistoryHeaderParameter field: InvoiceDateTrying to present a report that shows invoices for June 2018 and June 2017.Any suggestions on how to set the parameters to pull month - year and month - prior year?See More
Jul 11
Dan St. John joined Bron Dorrofield's group
Jul 11

Profile Information

Sage Intelligence powers the following Accounting/ERP/Payroll solutions, pick yours
Sage MAS Intelligence
Website
http://www.southeastcomputers.com
How long have you been using the above solution?
1 month
Where did you hear about us?
Other

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