Search results for query: *

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

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..

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...

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!

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...

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...

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...

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...

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...

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...

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

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...

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...

Don, thanks for the insight and help. As always you are spot on. Thanks, J Green DeltaTRAK www.deltatrak.com

...>= '10/20/2020' and ord_dt <= '10/22/2020' ---and ph.ord_no = '25449' The selected fields are flexible obviously, to start I had done Select * from the tables and did not see the GL Account Code, and when I check in Macola to see where that field exists I only see the prglfil_sql table but...

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...

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...

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

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...

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,