Search results for query: *

Thanks Crys' I haven't tried it...but looks promising...i don't see how it would not work! i'll run it tonight. Thank you.

Happy Holidays Tekkies, Macola 7.6.4 MSSQL I've developed a simple Ms Access data importing solution into Macola tables. I've tested it successfully in the TEST COMPANY. My boss insist that I show a successful test with values equal to the LIVE COMPANY. Which brings me to my question: What is...

Don, sorry for the delay on my response. that tip was very helpful. thanks!

Hi Guys, Macola 7.6.400a - MS SQL In "Inventory Transaction View" (Screen Name:IMTRXHST), from which table/field does the following field come from? - Total Cost - Old Unit Cost I found where all the other "cost" fields are coming from (i.e., IMNVTRXHST or POORDLINE), but not the two fields...

Tom, Thank you very much!

Hello! Macola 7.6.400a - SQL Does anyone know what reference numbers or from which field/table is being used to populate the following fields in IMDISFIL? 1. id_no 2. jnl_src Thanks a bunch!

Thanks Crys!

Hi guys, Macola 7.6.400 - SQL At what point, or how does the G/L Transaction Table (GLTRXFIL_SQL) get populated/updated by entries from the PO module? Is this automatically done by Macola sometime between PO creation and PO Receiving (if so, what triggers it)? Or Is it a separate process not...

dgillz, I am new to this company and the reason behind having two mrp/erp system (Macola, and later a "customised solution"), is beyond me. The two systems are now utilized as one being a production platform, and Macola as a financial platform. Back to my goal: I am pulling data from the new...

Hello. Environment: Macola Progression 7.6400a, MSSQL Goal: Simple automated entry of POs that require only few keyboard "TABs" or "ENTERs" and uniform accross several POs. I'm getting error "unrecognized database format" in Macola VBA. I'm trying to open records from Access 2007, and have...

I applied both your tips: A default in Designer, then a LoseFocus event fires a dialogue prompting a user, from that point forward, I either used vbsendKeys or Focus Events. It' very basic but got me where I wanted. Most likely i'll be asking for more tips later on. Thank you guys!

dgillz, What would I do without you? Thanks. I'm using Progression. Basically just trying to get familiar with Flex. I'm currently on the OE screen and I can't even put a value on the macform.Type1 (listbox). Code: Private Sub Type1_GotFocus() macForm.Type1.Text = "I=Invoice" End sub Thanks again.

Hi Guys, I am new to Flex and currently working on OE screen. As I understand, the fields can't be updated until it has the focus...correct me if i'm wrong. So, I've done just that on my codes using GotFocus. I also found in my search in this forum that sometimes the LostFocus should be used to...

Thanks guys, I am actually looking into third party solutions since I could just imagine the amount of time i would spend figuring this out might end up costing us more. but i can't seem to find that "add-on". most of the ones on the net are either importing OE Orders or GL Jrnls. Another...

Can anyone give me some tips on importing PO data into the PO Module. Data is coming from a customized manufacturing solution for the industry we are in. I'm planning on importing the PO data thru MS Access into the SQL tables in Macola. Current environment and modules avail: - Windows Network -...

What is the best way to import batches of orders for one customer in Macola OE tables. Details of the orders and Macola Environment below. Thanks in advance for your tips! Macola Environment: Windows 2003 Server; MSSQl Engine (Not Pervasive); Macola Progression 7.5 Source file (Orders)...

Nemacguy, I'm using LIFO/FIFO. You said, I should be concerned about the item location level info, shouldn't all this information be automatically transferred/tracked in the new location? If not, Does this mean I have to manually update the new location? Again, Thanks you guys!

My environment by the way is: Pervasive SQL 2000; Macola 7.6.2; NO Advance Distribution; NO RMA Thanks Again!

Hello, We currently have TWO Stock/Whse Locations in Macola. We'd like to add more locations for functions that we want (ie. Sort/Rework floor; WIP for orders; and 2 New Whse/Stock Locations to eventually replace the old TWO Locations. During this process, we will be counting inventories for...

The 832 EDI document is separate from the UCCnet initiative, I thought of going that road about six months ago, and I realized it's a whole different ballgame. We are a supplier for the top 25 US/global retailers and are also looking for the best solution. UCCnet requires a lot of prerequisites...