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!

Register Log in
  • Congratulations Chriss Miller 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: *

  1. J G PM

    Spam from Tek-Tips ?

    lol I am glad that mikrom posted a suggestion and I can stop the madness. Ciao
  2. J G PM

    SSMS question

    Th New dataset.. Throw as USE at the start.. i.e. USE[NewTable] Then the SQL, the new table name must be in the brackets. Good luck..
  3. 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...
  4. J G PM

    Lot tracking to sales

    MFaizan, It looks like you are in a similar boat as myself, just getting a feel for the specifics of Macola. I would be happy to share ideas and information. Let me know if you have any other concerns or questions and perhaps I can assist. One Team One Fight!
  5. J G PM

    Inventory Report

    I honestly appreciate all the knowledge and insight on this forum. I am sure there are other software options and other applications that can make any WMS "better" or more user friendly or whatever the case may be. My task is to find a way to make Macola work for me without enlisting a new...
  6. J G PM

    Inventory Report

    Hello, I am still getting my hands around Macola. I dont find it as user friendly as I have other WMS's I have worked with. That being said, we do what we can with what we have. I think it would be easier if you contact me at work so we can reply a bit easier and perhaps share ideas. I should...
  7. J G PM

    Inventory Report

    MFaizan (MIS0 My team has an Access Database they use to make large transfers in Macola. That being said, we dont use Locations in Macola, so it may be different for you. If you want to hear more about this Access DB let me know I can either work through it with you or if you are Access...
  8. 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...
  9. J G PM

    PO Report out of Macola

    To those of you who have chimed in and offered help I do appreciate it.. I am getting close. Recently I was asked where are the $$'ars on my report. the data I am pulling does not have money in the report. I was reluctant to bring that into a report available for everyone. Now I am being...
  10. J G PM

    Macola Allocations

    NEmacGuy, that is awesome... that helps immensely. I have ran my query and compared it to a few items and the numbers match perfectly. Initially I was thinking it would only be for open orders and I would have to separate old orders from current to get what I was thinking would be only active...
  11. J G PM

    Macola Allocations

    Don thanks, you gave me the information I needed. I can stop looking for this. I was convinced I should be able to get a list of allocations based on an item. We are, as I suspect you know, using the Soft Allocations. Thanks for your time, Jim J Green DeltaTRAK www.deltatrak.com
  12. 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...
  13. J G PM

    PO Report out of Macola

    In my original post I show a GL Distribution account number, for recieving, where are the receiving transactions stored or where can I get the GL Distribution Account number related to any of the respective PO's? Its not in my original query so it must be another table. Is there a transaction...
  14. J G PM

    PO Report out of Macola

    Don, thanks for the insight and help. As always you are spot on. Thanks, J Green DeltaTRAK www.deltatrak.com
  15. 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...
  16. J G PM

    Sales Person Data

    Don, thanks for the insight, as for “team”, that’s just a vernacular to refer to my Team.. or my People… not in the literal sense as you might think. Apologies for as I see how that might confuse my question. You did give me the answer I wanted and as always I appreciate your help. J Green...
  17. 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...
  18. J G PM

    Macola Line Item Comments

    Peter.. right you are and thanks. That was exactly what I was looking for and that answered my question. Thank you so much for being spot on. v/r Jim
  19. 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...
  20. J G PM

    Order Entry Question

    dgillz thanks as you know you were spot on. I appreciate your help. I thought this tread would notify me when I got a post. I guess I have some adjustments to make. Thanks,

Part and Inventory Search

Back
Top