Search results for query: *

My client has an error with the ECM number when creating new shop order. The flag "Use ECM" under Engineering tab in Item Master is checked for several items. When creating a new shop order, the ECM number is automatically filled when entering the item number. But for some items, there is no...

I am using Macola ES 9.5.200. I am trying to delete an item from the Item Maintenance screen and I get the message "Item has a bin record and cannot be delete.". Does anyone know what that message means? The item is not part of any BOM, Shop Order or Sales Order. Thank you!

I am using Macola ES. We have created a second company and we would like to know the best way to transfer FOB, Ship via, Ship-to and PO Form No codes (all codes in Purchase order) from our first company to the new one. Do we also have to change any settings in Package Settings to make PO works...

I am using Macola ES. I have to create a report and in this report, I have to show the "Actual Hours" values from the "Shop Order Status View - Operation Info" screen (SFOPERNQ). Does anyone know where to find this information in the database? Thank you

Hi all, I am using Macola ES 9.5.200. I am always using the Modify Released Shop Orders screen when I have to modify a released shop order. This time, the shop order does not displayed in the list. I am able to modify other shop orders but not the one I would like to. I looked into the...

I am using Macola ES 9.5.200. Sometimes we receive items in the system by error. I would like to know how can we reverse the receiving transaction ( once it has already been received)? As an example, supposed we have an item with a quantity of 6 in a PO. In the Purchase Receiving screen from...

Hi, Is there a way to associate a shop order with a sales order? Currently we can't associate it and I would like to know if it is possible to do. Thank you

Can someone explain me what both options "Tax Freight" and "Tax Miscellanous Charges" are used for? Here is the situation. Our company is international but located in Canada. Creating an order for USA, some items are not taxable like Freight, packaging, etc. However, these same items are...

Below is the Flex code we are using to send email in the customised screen OE0101. It was working fine for the last 5-6 years but the server has changed last friday and since then, no message is sent. The only thing I have changed is the name of the server. The Flex code below does not return...

I have added a new field in the Basics tab of IM0101 screen. I have called a function to display the data in this new field when the Description field got focus. The function to save the data is called when this new field loses focus. Here is the issue. I get the error message "Save Changes?"...

It is the second time I start the Regenerate Material Plan process today and it seems to "freeze" in the Merging Remaining Order section. I waited for more than 1 hour each attempts and I had to manually close the MRP Process Status window. Of course closing this window does not generate...

I have customized the Order Entry screen (OE0101) since a many years. It is working fine except for 2 users. These 2 users have access to this screen recently. The error message is "The requested properties cannot be supported". Starting Macola with a "Run As" using my user, there is no issue...

I have to extract data for tax review. Here are the information requested: Accounts Payable Detail File (1) Supplier or Vendor Name (2) Supplier or Vendor Number (3) Batch, Voucher, Document, Posting or Transaction Number (all where applicable) (4) Invoice Number (5) Invoice Date (6) Invoice...

It's possible to open 2 instances of Macola and choose a different company. Lets say I have 2 companies, 100 and 200. I open the first instance of Macola with the company 100 and the other instance with the company 200. Sometimes, Macola gets confused because it shows information on the company...

eSynergy is installed on our live server and it's connected to the Macola's live database. We are about to create a new database on the same server. Can eSynergy be set to manage both databases as Macola does with the company? Please let me know if you need more details. Thanks in advance ML

We have created another database on the same server. We would like to transfer the content of the Item Maintenance screen and its related screen (Item Vendor, Item Location) from the current database to the new one. I guess to better way is to use SQL statement, right? In this case, which tables...

I got this error message when I tried to pre-post the invoice. Does anyone have seen this error before? The following lines are coming from the MSLErrRpt.bin file: An error occured in MacMSL.dll (ver. 9, 5, 200, 51) DB Provider Error: COM Error: Error Code = 0x80040E14 Code meaning =...

Is it possible to display into the Basics tab the field extra_14 contain in the oeordhdr_sql field? If yes, I know how to add a new field in a screen but I don't know how to match it with a field in a table. Can someone help me please? Thanks in advance

When I try to delete some items, I get the following error message: "Item is active captured component. Item cannot be deleted." The items have no BOM and are not used. The items don't appeared in the following tables: imordbld_sql, oeordlin_sql, oelinhst_sql, bmprdstr_sql Can someone help...

Since a couple of days, we see duplicate item_no in the Item Maintenance screen. I looked into the imitmidx_sql table and the item_no are duplicates. I did some test to find out what is causing the duplication and here is what I found. Each time we click on the Item Location button in the Item...