"Thanks"
-
Doug Walker
- Male
- Los Angeles, CA
- United States
- Blog Posts
- Discussions (32)
- Groups (5)
- Photos
- Photo Albums
- Videos
Doug Walker's Groups
-
Free Report Templates Gr…
116 members
-
Excel on Steroids
150 members
-
Report Designer
99 members
-
Alchemex Recorded Webina…
115 members
-
Sage ERP MAS Intelligence
137 members
Doug Walker's Discussions
Pivot Table - Inventory Qty Beginning Balance Running Total
2 Replies
I am trying to create a report and need some help creating a Running Total that starts with a Beginning Balance and adding a Period Change field to this Qty.I have attached an example of the Pivot…Continue
Tags: Table, Sage100, Pivot, Excel
Started this discussion. Last reply by Doug Walker Mar 30.
2 new reports added for Sage 100 (formally known as MAS90/MAS200) in the "Free Reports Templates" Group.
If you were not aware there is a "Free Reports Templates" Group on the BI Community where you can download free copies of reports for you to use in your SMI.The two new reports added are Inventory…Continue
Tags: Manufacturing, Distribution, Report, Inventory, Free
Started Mar 9
Help creating a SQL Join
22 Replies
I need to create a SQL join for IM_TransactionHistory to the AR_InvoiceHistoryHeader table.Because the AR Invoice number in the IM_TransactionHistory is retained as "#######-IN" and in…Continue
Started this discussion. Last reply by Nigel Naicker Mar 22.
[ERROR] Authorisation Failed please check if your password is correct.
1 Reply
First I want to say hello to everyone. I am a SMI newbie and look forward to getting to know and support your product. The above error happened when I tried to register an installation on my desktop.…Continue
Started this discussion. Last reply by Stephen Coull Apr 6, 2011.
Doug Walker's Page
Latest Activity
Doug Walker replied to Doug Walker's discussion Pivot Table - Inventory Qty Beginning Balance Running TotalEdwin replied to Doug Walker's discussion Pivot Table - Inventory Qty Beginning Balance Running Total" Hi Doug;
I am working at resolving your query. However I need some clarity in understanding your question. Drop me an email : edwin@alchemex.com and will take it up from there."
Doug Walker posted a discussionPivot Table - Inventory Qty Beginning Balance Running Total
I am trying to create a report and need some help creating a Running Total that starts with a Beginning Balance and adding a Period Change field to this Qty.I have attached an example of the Pivot Table setup.The Rows in Sheet1 has the output.Each Row has:Item NoWarehouseYearPeriodBeginning Balance QtySum of Period Change QtyThe 'Beginning Balance Qty' field will only contain a Qty of Period 1 records.Each record will have a 'Sum of Period Change Qty'.I need to have a Column in the Pivot Table…See More
Doug Walker added a discussion to the group Excel on Steroids
Pivot Table - Inventory Qty Beginning Balance Running Total
I am trying to create a report and need some help creating a Running Total that starts with a Beginning Balance and adding a Period Change field to this Qty.I have attached an example of the Pivot Table setup.The Rows in Sheet1 has the output.Each Row has:Item NoWarehouseYearPeriodBeginning Balance QtySum of Period Change QtyThe 'Beginning Balance Qty' field will only contain a Qty of Period 1 records.Each record will have a 'Sum of Period Change Qty'.I need to have a Column in the Pivot Table…See More
Doug Walker replied to Marc C's discussion Missing button labels in designer in the group Sage ERP MAS Intelligence"Reinstalling is never a bad thing. Maybe try installing it on another workstation or a VM environment. I have it installed in 3 different VMWare setups and it works great.
The fact that it runs makes me wonder if it is an issue with the environment…"
"The usually process would be for you to contact a Alchemex consultant.
Apologies though, I wish I could have asssited you further Doug."
Doug Walker replied to Marc C's discussion Missing button labels in designer in the group Sage ERP MAS Intelligence"Hi Mark - I was wondering even though you cannot see any of the Text does it still function? From your screenshots this looks like the case.
What version of MAS100 and SMI are you using?
Do you have different companies you can try it on? Like…"
Doug Walker replied to Doug Walker's discussion Help creating a SQL Join"I did it without the Sub-strings and did not receive the error. I also didn't get any useable data.
I take it what I am doing is not considered a "Standard" report. Do you have any suggestions as to where I maybe able to go and…"
Doug Walker replied to marnie rhen's discussion Quick Edit Problems"Hi Marnie - I use Sage100 and have had something similar happen. The Report Designer screen shows up but none of the rows appear. It will allow me to exit out so it physically is not hanging.
I had a several hundred Rows setup for the report. I…"
Doug Walker replied to marnie rhen's discussion Quick Edit Problems"Marnie - Can you give us a little more detail regarding this issue you are having?
What accounting package are you using?
Where does it hang? Do you get into the designer or does it hang trying to get in?
Thanks
Doug"
"In a case where there was a problem with a standard report, this would go through our support desk and then I would be able to investigate and provide a solution. :-)
A way to test whether your subtring is…"
Doug Walker replied to Doug Walker's discussion Help creating a SQL Join"I turned off the UQE and still get the error.
What do you mean by "professional capacity"?"
Doug Walker replied to Mark Ledford's discussion Using the connector module to consolidate 3 companies in the group Sage ERP MAS Intelligence"Mark - You are aware that there is a more current version of the SMI.
You can download Ver. 4.50.7107.015 from Sage Support.
I would highly recommend upgrading."
"u can try, but in my experience UQE enhances the functional capability of the engine.
I don't think substrings are a problem in the UQE. I won't be able to verify this for you as I have no access to a provide x enviroment unless it were in…"
Profile Information
- Alchemex Powers the Following BI Solution, Pick Yours
- Sage MAS Intelligence
- About Me:
- MAS90/200 Consultant since 1990.
MAS90/200 Contributor to the TheIntelligenceStore.com
.
- How long have you been using the above solution?
- 01/2011
- Where did you hear about us?
- Other
- If other, please specify
- Sage
Comment Wall (1 comment)
- At 8:08am on April 7, 2011,
Ruth Gray said…
Hi Doug
Welcome to the BI Community. I look forward to assisting you in becoming the best SMI support consultant.
have a great day
Follow Alchemex on twitter
Like Alchemex on facebook
© 2012 Created by Admin.
