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!

The sycdefil_sql table contain the data for the FOB and Ship via codes but not for the "PO Form No". Which table contain "PO Form No" data?

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 tried but Macola does not allow us to re-enter the PO because the quantity receipt was completed for the line number. What else can I try?

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

We will discuss with our Macola reseller before doing any changes. Thank you so much.

I am using ES version 9.5. I guess forced demand is not equal to pull because all I see in source package is MR. There is no OE. Where can I change the forced demand to set it to pull? I looked into the package settings and did not find it. Thanks

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

I did checked the "enter billing info at order entry" in the OE Package Settings in our test database. I am not sure to understand when you say "allow you to manually enter freight and misc charges on a quote/order". How can I enter a service code in Order entry? I am able to only enter line...

Yes. Most of the services are entered as item numbers because it has to be seen in the quote/order and be part of the total amount. How can we add services in a quote/order?

In System / Financial / Accounts receivable / Services code, we have created a several services. Most of them are also created as part numbers in Item Master Maintenance. Then, we are entering these as part numbers on the order. Isn't it the way to do it? How to tell what services to charge in...

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

The solution I found is to display as read only the value of the extra_6 field on the screen. Create a push button to call a new form that allow to change de value of the extra_6 in the database. Just displaying the extra_6 value as read only get rid of the prompt. Thanks for your help!

No I don't want it to save when I hit Cancel but I get the prompt. I think I get the prompt because I populate the field with the extra_6 field value on the description_gotfocus event. If I am not populating the value from a SQL query, it is always blank even if there is data in the table for...

That is a good idea but the thing is it does not go in the macform_save event when I press Cancel. This is where I got the prompt. I looked but did not find any event for the Cancel. Does it exist?

How can I get that message when there is no change in the form? I just populate a custom field from the extra_6 table field imitmidx_sql.

What trigger the "Save Changes?" message box? Thanks in advance