Matthew Anthony
  • Male
  • Madera, CA
  • United States
Share

Matthew Anthony's Friends

  • Doug Walker

Matthew Anthony's Discussions

MRP Reporting in Sage Intelligence
5 Replies

We are starting to utilize MRP in Sage 100 more and we are quickly becoming frustrated with the limited ability to export the standard MRP reports to Excel to do further analysis. Does anyone have…Continue

Tags: MRP

Started this discussion. Last reply by Doug Walker Apr 1, 2016.

Company Code or Name on Consolidation Report
23 Replies

I have a consolidated report that combines the invoiced sales data from two company files, and I would like to add a field to my table that simply indicates the company code where the data is coming…Continue

Tags: Consolidation

Started this discussion. Last reply by Doug Walker May 28.

Inventory Valuation Trend
4 Replies

I would like a report that shows ending monthly inventory levels for a given period of time.  Essentially this would be the same information that is presented in the Valuation Report by Period in the…Continue

Started this discussion. Last reply by Doug Walker Feb 18.

 

Matthew Anthony's Page

Latest Activity

Doug Walker replied to Matthew Anthony's discussion Company Code or Name on Consolidation Report
"Erin - If you want to upload the report here I will take a look at it."
May 28
Erin Oldaker replied to Matthew Anthony's discussion Company Code or Name on Consolidation Report
"I am running into this issue with it bringing in the wrong company codes as well. was there ever a solution to this?"
May 25
Doug Walker replied to Matthew Anthony's discussion Inventory Valuation Trend
"I believe Craig's report was built for Sage 100."
Feb 18
Theo Verster replied to Matthew Anthony's discussion Inventory Valuation Trend
"Dear Craig, Getting the following error, I am using Sage Evolution Description : Invalid sql query near SE WHEN "IM_PeriodPostingHistory"."FiscalCalYear" = CAST( AS CHAR) THEN…"
Feb 18
Doug Walker replied to Matthew Anthony's discussion MRP Reporting in Sage Intelligence
"Sorry that's the old version. IM1 is now called IM.Item. The MPM module was never upgraded to the business frameworks files so it still uses the old file formats."
Apr 1, 2016
Matthew Anthony replied to Matthew Anthony's discussion MRP Reporting in Sage Intelligence
"I see the second two tables, but I'm not able to find an IM1 table."
Mar 31, 2016
Doug Walker replied to Matthew Anthony's discussion MRP Reporting in Sage Intelligence
"I looked up under the Resources section and found a listing for what files are used for the MRP Report.  It lists the following files that are used to generate the report: IM1 MP_04 MP_05"
Mar 31, 2016
Matthew Anthony replied to Matthew Anthony's discussion MRP Reporting in Sage Intelligence
"It's pretty much the main MRP Report. I think the projected demand I know how to pull out because I am importing into that table now. It looks to me that the MRP report is just made up of data from several different tables so I just need to…"
Mar 31, 2016
Doug Walker replied to Matthew Anthony's discussion MRP Reporting in Sage Intelligence
"Matt - What report(s) are you looking to try and duplicate with the Intelligence?"
Mar 31, 2016
Matthew Anthony posted a discussion

MRP Reporting in Sage Intelligence

We are starting to utilize MRP in Sage 100 more and we are quickly becoming frustrated with the limited ability to export the standard MRP reports to Excel to do further analysis. Does anyone have any suggestions on the best way to generate the MRP data in Sage BI? I'm guessing that I just need to pull the relevant tables like sales, POs, projected demand, inventory on hand, and work orders and pull all that together, but I wasn't sure if there was a central "MRP" table that I can pull that has…See More
Mar 31, 2016
Mike Fitzgerald replied to Matthew Anthony's discussion Company Code or Name on Consolidation Report
"Did you create the TST company normally through S100 Utilities?  We ran into something similar when we restored from a TST company back to a live company by simply copying back.   Problem is a couple of files including GL.Account table has…"
Mar 3, 2016
Doug Walker replied to Matthew Anthony's discussion Company Code or Name on Consolidation Report
"If it still shows export the report and upload it here and I'll run it on my setup."
Feb 11, 2016
Doug Walker replied to Matthew Anthony's discussion Company Code or Name on Consolidation Report
"Well maybe just delete the TST company from Sage-100. It's a test company and you can always make another one. If you need it create a new company and copy the TST data then delete it."
Feb 11, 2016
Matthew Anthony replied to Matthew Anthony's discussion Company Code or Name on Consolidation Report
"No. I'm logged in to EUR."
Feb 11, 2016
Doug Walker replied to Matthew Anthony's discussion Company Code or Name on Consolidation Report
"When you launch the Intelligence from Sage-100 you're not in the TST Company per chance?"
Feb 11, 2016
Matthew Anthony replied to Matthew Anthony's discussion Company Code or Name on Consolidation Report
"We just upgraded to 2015 (Version 5.20.3). I also checked the Cache viewer and the only company files listed were EUR and MEX."
Feb 11, 2016

Profile Information

Sage Intelligence powers the following Accounting/ERP/Payroll solutions, pick yours
Sage MAS Intelligence
Website
http://www.eurodripusa.com
How long have you been using the above solution?
Less than 6 months
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

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service