Lloyd Smith
  • Pflugerville, TX
  • United States
Share Twitter

Lloyd Smith's Friends

  • Krithika Raju
  • Jacqueline C Powers
  • Venkatesh Arasanapalai Varadhan
  • Sales @ CI.com
  • Susan Antonsen
  • Eric Anderson
  • Suzy Rabb
  • Stephen Coull
  • Ruth Gray

Lloyd Smith's Groups

Lloyd Smith's Discussions

SAI Accpac 300 Report Manager Error PLLIB.DLL
1 Reply

After upgrading to Accpac 6.0, when attempting to open Report Manager we are getting the following error. The application works on the server.  We have installed PU 1 for Accpac and SAI.…Continue

Started this discussion. Last reply by Kandi M Messerschmidt Jul 25, 2012.

Emailing Reports
3 Replies

I have created an late PO report which we want to email each night to the vendors the reports are for. How can I enable the emailing of these reports which are created at 2:30 am each…Continue

Tags: emailing

Started this discussion. Last reply by Ruth Gray Jul 26, 2011.

Sage Accpac PO
6 Replies

Has any tried to create a report showing: Accpac Purchase Orders          Receipts Against Purchase Order     Invoice Against Receipts We have been seeing this come up time and time again. We have…Continue

Started this discussion. Last reply by Lloyd Smith Feb 23, 2011.

Sage Accpac CRM
3 Replies

I remember seeing a document/video on Accpac Intelligence and creating a report which is then available in Sage CRM as a dashboard but I can't find it anymore.  I hope someone else has a better…Continue

Started this discussion. Last reply by sarah harvey Feb 7, 2011.

 

Lloyd Smith's Page

Latest Activity

Lloyd Smith replied to Denise Austin's discussion Report Designer Add-In Error - Cannot Run Macro 'mnu_ShowTaskPane' the macro may not be available in this workbook or all macros may be disabled
"Ruth,"
Sep 13, 2013
Lloyd Smith replied to Riekie Roux's discussion Object Reference not set
"Start Accpac the same way, by right clicking and running as administrator."
May 27, 2013
Lloyd Smith replied to Riekie Roux's discussion Object Reference not set
"You did the right click and run as Administrator right?"
May 13, 2013
Lloyd Smith added a discussion to the group Sage 300 ERP Intelligence Reporting
Thumbnail

Sage 300 Inventory Linking Issue

I'm trying to develop a report linking OEINVH --> OEINVD --> ICITEM --> ICSEGV. The join works in SQL and in the Connector module. Here is the join:((([OEINVH]Inner join [OEINVD]on [OEINVH].[INVUNIQ] = [OEINVD].[INVUNIQ])Inner join [ICITEM]on [OEINVD].[ITEM] = [ICITEM].[FMTITEMNO])Left JOIN ICSEGV as ICSEGV1 ON ICSEGV1.SEGVAL = ICITEM.SEGMENT1 AND icsegv1.SEGMENT  = 1Left JOIN ICSEGV as icsegv2 on ICSEGV2.SEGVAL = ICITEM.SEGMENT2 AND icsegv2.segment = 2Left JOIN ICSEGV as icsegv3 on…See More
May 13, 2013
Lloyd Smith replied to Riekie Roux's discussion Object Reference not set
"Riekie, What type of workstation is this?"
May 9, 2013
Lloyd Smith is now friends with Venkatesh Arasanapalai Varadhan and Sales @ CI.com
Mar 8, 2013
Kandi M Messerschmidt replied to Lloyd Smith's discussion SAI Accpac 300 Report Manager Error PLLIB.DLL
"We had  this same error - but our dll's were installed on the workstation. We ended up rerunning the regAcc.exe again on the workstation.  Now it allows us to get into the user's Report Manager - but whenever the client clicks on…"
Jul 25, 2012
Lloyd Smith posted a discussion

SAI Accpac 300 Report Manager Error PLLIB.DLL

After upgrading to Accpac 6.0, when attempting to open Report Manager we are getting the following error. The application works on the server.  We have installed PU 1 for Accpac and SAI.I've seen another post in this forum solving the issue by registering the dll's on the workstation but currently the dll's are not on the…See More
Jun 1, 2012
Denice Leuschner replied to Lloyd Smith's discussion Formatting a report in the group Sage ERP Accpac Intelligence
"Sorry, once the Pivot Table is created, click on the Pivot Table Options feature.   denice.leuschner@sysera.net  "
Jul 28, 2011
Denice Leuschner replied to Lloyd Smith's discussion Formatting a report in the group Sage ERP Accpac Intelligence
"You have the ability to change the Pivot Table layout to display across the worksheet.  Remove the totals for each Row Label and you should be very close to getting your display accurate.  However, you will need to add the Expected Arrival…"
Jul 28, 2011
Ruth Gray and Lloyd Smith are now friends
Jul 27, 2011
Lloyd Smith replied to Janet Lynch's discussion Database administration tool
"Janet,   It's easy to use as long as you understand the table structure and links between tables.   Regards,   Lloyd"
Jul 27, 2011
Lloyd Smith added a discussion to the group Sage ERP Accpac Intelligence
Thumbnail

Formatting a report

I'm trying to format a report so that it looks like the following: Vendor #  XXXXXX     ABCD Vendor PO     PO Date      Item Number  Item Description Due Date  Qty Late PO1   12/10/2010    A1-100    DESCRIPTION     12/31/2010     100PO1   12/10/2010    D4-200    DESCRIPTION     12/31/2010     5PO2   1/4/2011       J8-300    DESCRIPTION      1/18/2011       555PO2   1/4/2011       A1-100    DESCRIPTION     1/22/2011        60PO4   1/16/2011     J8-300    DESCRIPTION      2/15/2011       …See More
Jul 27, 2011
Ruth Gray replied to Lloyd Smith's discussion Emailing Reports
"You are welcome. Enjoy scheduling and auto-emailing. Hopefully it will give you some free time :-) Glad you came right."
Jul 26, 2011
Lloyd Smith replied to Lloyd Smith's discussion Emailing Reports
"Ruth,   It help tremendously!   Thanks   Lloyd"
Jul 26, 2011
Ruth Gray replied to Lloyd Smith's discussion Emailing Reports
"You can use the auto email option for Intelligence reports. If you go to the Accpac Intelligence Group on the community, and open the Sage ERP Accpac Product Tips and Tricks you will find the auto email process in there. Group…"
Jul 26, 2011

Profile Information

Alchemex Powers the Following BI Solution, Pick Yours
Sage Accpac Intelligence
Website
http://www.mindovercorp.com
How long have you been using the above solution?
1 yr
Where did you hear about us?
Other
If other, please specify
Sage

Comment Wall

You need to be a member of The Sage Intelligence Community to add comments!

Join The Sage Intelligence Community

  • No comments yet!
 
 
 

© 2014   Created by Sage Alchemex.

Badges  |  Report an Issue  |  Terms of Service