Search results for query: *

What would help here is any error messages that you get plus the version of Macola and db that you are on. Having an issue with just one company could mean it's an issue with one of the check form files. They could be exported out of a working company and then imported into the non working...

Is there a setting in OE Setup or AR Setup that allows you to choose what exchange rate to apply? Kevin Scheeler

What about just logging out and back into Macola in the morning after MRP has finished. Or restarting the PC once a day. Kevin Scheeler

Instead of using qty to ship in your crystal reports, why not use qty ordered instead? Kevin Scheeler

Are you set up for confirm ship? Kevin Scheeler

I'm running 7.6.100a on SQL 2000 sp4 with Flex and mine are varbinary. Kevin Kevin Scheeler

it's possible that the tot_sales_amt isn't right in the header and you should bring in the oeordlin_sql table and sum the lines yourself. Since you are doing this in access, you should first create a query to get just the order number and the data entry user as unique records from the...

What costing method are you using. Kevin Scheeler

Have you checked the OEHDRAUD_SQL table to see if each change in invoice number is updating the system? The other thing you can to do track it better is to put a trigger on the OEORDHDR_SQL table and write a record to a custom table anytime there's a change in the inv_no field. I currently...

I'm actually running 7.6.100a (don't go there!) and also running sp4 without any issues. Kevin Scheeler

Don, Good catch. I missed the ES part of the question. Yes, my answer was for Progression. Kevin Scheeler

There is nothing currently built in but you could populate 2 tables through a SQL or an Access program and then post it normally in Macola. The two tables are ARCSHAPL_SQL and ARCSHTRX_SQL Kevin Scheeler

Is it printing ALL paid items or just the ones that were paid within the date range. If it's just the ones within the date range, enter the starting and ending date as the same date and try it again. Use the month ending date as the date. For your down payments, you will need to reapply them...

Go to a DOS prompt and type PATH and verify that all of the folders listed actually exist. Also, try running a program called filemon.exe which you can google. It will show you all of the different files and the paths that the computer is opening at that point in time. It also has a filter...

I agree with crystalreporting with just one note. Read below about receiving at $0 cost. Question: In an Average Cost environment for inventory valuation, if there is zero (0) on hand and an Average Cost in the Item Location file for an Item, is the Average Cost recalculated if a receipt...

Did you verify the drive mapping on the one workstation. Are there other things that are different from the other two workstations, like the user logging in, etc.. Kevin Scheeler

I have the same issue and one of my friends called me about it as well. I checked the sqlsrch_sql table and all looks fine. I also checked the .epj file for the report I was running and it seems to be calling the correct search function, which should be the case since the top search works...

You also should use a clearer heading for the post. Kevin Scheeler

You should first read Macola's help file when opening the screens. Especially the section on how the program calculates the reorder level. After reviewing it and doing some testing in one of your test companies, you should post more specific questions about what you are finding that doesn't...

I misunderstood. I wasn't thinking Designer. If a field isn't visable or shows as something you can "unhide" in Designer then Macola didn't make it available for that screenset. If you don't have flex and the screen shows the customer number, you can add a search box next to the customer...