Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: J G PM
  • Content: Threads
  • Order by date
  1. J G PM

    KnowledgeSync

    Hello and thanks for taking time to review my post. I have been working with KnowledgeSync a few months now and find it much nicer than its predecessor Event Manager. That being said, I was thinking maybe we could create a forum or thread where we can share ideas? I have quite a few Events...
  2. J G PM

    Inventory Report

    I am still in the learning part of my Macola experience. My company relies heavily on SQL based reports in part because some of the Macola solutions are clumsy at best. My boss wants a simple history transaction report for Inventory. So far the best I can come up with is a basic inventory...
  3. J G PM

    Macola Allocations

    Is there either a report in Macola or a Crystal Report or perhaps some SQL that would allow me to report out what inventory is allocated and to what order. Be it a Sales order or a Work Order? I can pull up inventory and see if it is allocated but I have yet to be able to tell what is causing...
  4. J G PM

    PO Report out of Macola

    I have been asked to come up with a report around Purchase Orders that shows varied information from Macola. I have created reports in the past using MS Visual Studio. Typically, I get the SQL I want from one or two existing reports, I put the SQL together, run it in our SQL Server environment...
  5. J G PM

    Sales Person Data

    I am not sure if my team has used Macola to track our complete sales team. That being said I am trying to locate the table that contains the actual list of Sales Team Members. Currently I have the table arslmfil_SQL and it seems to hold the data but it refers to Territory and when I try to...
  6. J G PM

    Macola Line Item Comments

    I see line comments in an order. I can review the line comments in OELINCMT_SQL if I do so by order number. I know the comments apply to my example item because I checked to make sure the example item in on my example order. What I cannot figure is how to make comments to an item in Macola...
  7. J G PM

    Order Entry Question

    I am new to Macola and have worked with SQL before. I have a task to provide my boss the number of orders input into Macola yesterday. I have it running in our Report Portal and providing the data daily. The issue is I need to add to this report the user that input the order into Macola and I...
  8. J G PM

    Need to Share

    I am new to a company that is using Macola, and I have not been around Macola nor have I dealt with "bin" storage. I have had Locations but not bins the way it seems Macola deals with them. My VP has asked if there is a company in Central Valley or somewhere in California that would be willing...

Part and Inventory Search

Back
Top