Search results for query: *

Macola ES 9.5.600 I am trying to find a way to prevent certain users from deleting notes. For instance, we would like to allow customer service order entry to add order notes only, with a manager required to delete notes. However with the current security options, note maintenance is all or...

I've been asked to automate the inventory resets and MRP regens to run overnight. I used the Macola deferred reports about 10 years ago and gave up because I couldn't get it to run more than a week without having to check on it - kind of defeated the purpose of a scheduled report. I see that...

Sharepoint services 3.0 - we have a document library which will contain all versions of documents for our technical staff to use as reference material. We would like our non-tech people to be able to see only the latest version of the document from the same library. How do I restrict the...

I"m trying to use the SP Version number as part of a calculation for another field in the list, however, I cannot get this to work. I've tried changing the Version field type to numeric with no effect. Is the Version field usable as part of a calculation and if so, how is it done?

We are running Macola ES build 372. My customer service department needs the ability to update contact info while the customer is on the phone placing an order with us. My thought was to use VBA to call the contacts maintenance tab of maintain customers - similar to how the credit limit window...

We were notified last night by our reseller that the ES product updater is not available because it is corrupting tables? Does anyone have any details or updates? We were planning to upgrade to 372 this weekend until this bit of news...

Crystal Reports v10 - I'm testing a very simple report reading a shop order table in a SQL2K db. I would like to use a parameter allowing both discrete and range values to select ord_numbers to print. Problem is when I enter the select statement {ord_table.ord_no} in ?{parameter} , then press...

We are starting to use engineering change management and have found an issue when creating new shop orders. We had expected the ECM Revision on the shop order entry screen to default to the currently active revision as soon as the item number is entered, however, the ECM Revision field remains...

This problem started after an upgrade from SQL7 to 2000 and Crystal 7 to 8.5 done concurrently. I was able to convert all existing v7 rpts to v8.5 without a problem and they continue to run OK. The problem is trying to create new reports - when trying to login to the database with the SQL...

I spoke too soon. Two listboxes on the Item Master Maintenance screen, Order Policy Code and Serial/Lot, do not allow changes, almost as if a default value that is not modifiable has been programmed in. Doesn't matter if it's a new or existing item, I can't change the value of either field...

7.5.103f SQL - I am trying to move the Serial/Lot listbox from page 3 of Item Master Maintenance to page 1 by hiding the control on page 3, then unhiding on page 1. However, when I unhide on page 1, I lose the down arrow and the listbox capability. On my system, this happens with all of the...

What I thought was a simple update.... I would like to update multiple rows of table2 upon insert or update of table1. My approach was to create a trigger on table1 ..... CREATE TRIGGER [trgOECusItemMaster] ON [table1] FOR INSERT,UPDATE AS declare @item_no varchar(50) declare @cus_item_no...

Version 7.5.103f MS SQL - comparing the OEORDHDR tot_sls_amt and tot_dollars fields against the corresponding OEORDLIN qty_ordered * unit_price revealed discrepancies where either/both the tot_sls_amt or tot_dollars field = 0 on about 5% of our open sales orders. There is nothing unique about...

We are planning to upgrade to SQL2000 and Macola 7.6.300 (currently SQL7/7.5.103f). We also have many older 233MHZ Win98SE workstations currently running Macola. Will these still be able to connect to Macola after the upgrades or will they need to connect through terminal services?

After trying all the combinations in other threads, I'm still not able to get this to work. I am using CR7 and setting up a purchase order print on a duplex printer. I need the front to show the PO info and the back to always print some boilerplate text. So the page printing sequence needs to...

My accounting person has encountered a problem with a cancelled voucher. The original for $95K was entered 1/25 and cancelled 1/31. When printing the AP transaction register for the cancellation, the first part of the entry ending with Voucher Total, shows the correct amount. The second part...

Is there a way to pass the order number from SFSOADD(shop floor order entry) to SFORDREL(the printing subwindow for shop floor order entry). I would like to allow the user the choice to print a Crystal shop order instead of the Macola version. In VBA, the 2 screens are considered 2 different...

Close to buying new Win2003 servers and wondering if anyone has any comments on Macola performance - specifically we are looking to run MS Terminal Services for about 30 users on our campus. I remember earlier threads about problems with W2K or win2003 servers and TS. Also, is anyone using TS...

SQL Macola v7.5.103f. Trying to add a new search name to the note_1 field on the Item Master maintenance screen. We use the note_1 field to assign a value from a table in another database. The search name on the screen set is IM-FOCUS-GROUP. I created a new search with the name...

I am looking to replace ~50 PCs with thin clients over the next 6 months or so. I know there is no right answer, but I'm having a hard time understanding the differences between the thin client machines and why one would be 'better' than the other for my circumstance. Up until now, we've used...