x Want to participate? Join the group to interact
Options
  • State Suggested Answer
  • Replies 7 replies
  • Answers 1 answer
  • Subscribers 19 subscribers
  • Views 347 views
  • Users 0 members are here
Browse Forums
Announcements
151
topics
113
replies
General Discussion
5k
topics
13k
replies
Payroll & Tax
633
topics
894
replies
Reporting and Analytics
574
topics
1k
replies
Service Alerts
1
topics
0
replies
Software Development Kit (SDK)
436
topics
673
replies
Year End
83
topics
128
replies
BamaDon

Inventory Turns Report

SUGGESTED
Posted By

I have been tasked to create an Inventory Turns Calculation in Crystal,  I have a report with all the items, a date range parameter and COGS calculation,  Piece of cake.  How would get average inventory?  Is there a table that gives you historical inventory on hand?  

Any insights appreciated.  I've been writing crystal for 20+ years but somewhat new a Sage 50.

Parents
  • 0

    You can schedule a Crystal Report to export the date and Inventory on Hand figures to a table every month (or whatever the desired frequency is. 

    Some of the 3rd-party Crystal Reports Schedulers listed here include that functionality. 

  • 0 in reply to ixm7

    Visual CUT can do that, but I have my doubts it can write to the Sage 50 database.  If we had a full, working version of Actian, fka Pervasive SQL, this would be a snap.  But I am not sure what we can do with the limited version of Actian that Sage installs.

  • 0 in reply to BamaDon

    Visual CUT can export the data to any ODBC target.
    So the scheduled process can read from SAGE and write to any desired database target (MS Access, MySQL, SQL Server, etc.).
    The report that uses the recorded monthly snapshot data would run against the desired target database.

  • 0 in reply to ixm7

    Yes it can, but I am not sure we can create an ODBC data source with the limited version of Actian that Sage installs.  For example the crystal reports for Sage 50 do not use ODBC at all, they use OLE and a Microsoft Data Link File (.udl).  Another example: we cannot even go to Actian Control Center and create a table to hold this data.  Why?  Because Sage does not install Actian Control Center.

    When I used Actian/Pervasive SQL with other ERP systems, most notably Macola, we could create tables, views, stored procedures, etc., but not with Sage 50.

    I admittedly am new at Sage 50 but if I am incorrect someone please show me how to do this.  It is a serious limitation on reporting.

Reply
  • 0 in reply to ixm7

    Yes it can, but I am not sure we can create an ODBC data source with the limited version of Actian that Sage installs.  For example the crystal reports for Sage 50 do not use ODBC at all, they use OLE and a Microsoft Data Link File (.udl).  Another example: we cannot even go to Actian Control Center and create a table to hold this data.  Why?  Because Sage does not install Actian Control Center.

    When I used Actian/Pervasive SQL with other ERP systems, most notably Macola, we could create tables, views, stored procedures, etc., but not with Sage 50.

    I admittedly am new at Sage 50 but if I am incorrect someone please show me how to do this.  It is a serious limitation on reporting.

Children

*Community Hub is the new name for Sage City