Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jbelk11

    Need Addtional Fields for Order Entry Header

    It's been awhile since I used Flexibility with Progression.....but within Macola ES, when you are in Designer, you right-click an open area of the screen, left-click Special, left-click Add Entry Field. You should get prompted with a message about adding the field as the next number in the...
  2. jbelk11

    Are there lookup tables for Macola ES?

    Macola ES does have a lookup table....it is called DDTests. select * from DDTests where TableName = 'BankTransactions' For Type C=template S=cashflow W=term For Status C=entered J=journalized V=void Enjoy! Jen
  3. jbelk11

    Landed Costs

    Hi All.... Macola ES v9.5.700 (or v9.5.800) We are looking at possibly adding landed costs to some of our InTransit documents. I understand how to add the landed cost to each line item on the transfer, etc. When the shipment is received, I see that the added cost is being included in the...
  4. jbelk11

    What is your support solution

    We just switched from Exact direct to a business partner. Jen
  5. jbelk11

    Macola ES - Crystal Reports and SQL Lag

    You are not the only person to experience performance issues with some reports in Macola. It is pretty safe to say that many Macola ES customers have speed/locking issues from time to time. The culprit tends to be the methodology/database design around the accounting modules of ES...I know I...
  6. jbelk11

    Macola ES release?

    Has anyone heard when Exact plans to release the next rev of Macola ES? They announced interface changes at Engage and said it would go to general release this month...just curious if anyone has more info? Jen
  7. jbelk11

    Need help to extract data from A/P

    Hi mlbechard.... Have a look at the BankTransactions table. Everything associated with invoices and payments (vendors and customers) is located in that table. Jen
  8. jbelk11

    How to transfer the content of the Item Maintenance screen from one database to another

    Hi mlbechard.... We can certainly advise you on tables and what kind of data is stored there....but at this point, I'm wondering why you don't just do a backup and a restore to a new database? You would then have everything you need to be able to test just about anything? Jen
  9. jbelk11

    How to transfer the content of the Item Maintenance screen from one database to another

    In addition to Don's suggestion above...you may also want to grab IMLOCFIL as that contains the locations found in IMINVLOC, which would be needed to use the Macola toolsets to see the values. Also note that this will give you the master item data from the source database...but does nothing as...
  10. jbelk11

    Engage 2012 - thoughts?

    For those of you have attended Engage (or will this week), I'm curious to hear about anyone's impressions regarding the direction of the product? Jen
  11. jbelk11

    Can a new Customer Address Type be created in ES?

    NEmacGuy is correct....Macola ES only recognizes the 4 types out of the box...and only allows you to create additional DEL addresses. However, if you can tell us what you are trying to do and where you are trying to use these new address types, we might be able to point you to a different...
  12. jbelk11

    Can a new Customer Address Type be created in ES?

    Sorry MAKNIGHT71...should read the subject. However...some of my questions still stand. What version of ES are you running? And where exactly are you trying to utilize the new address types (besides the Addresses tab on the customer record)? And what table(s) did you edit in your attempt to...
  13. jbelk11

    Can a new Customer Address Type be created in ES?

    First and foremost are you talking about Progression or ES? Version number would be helpful as well. I'm having a hard time understanding what it is you are trying to do and why....where exactly are you trying to differentiate the address types? You indicated you went in through SQL and added...
  14. jbelk11

    ES - Flex capture OE line item save?

    In case anyone else is in the market for something similar....the way I ended up accomplishing this task is to utilize a public boolean form variable to hold whether the form can be saved or not. Then during the Save event of OE0101, I check the variable and respond accordingly. At the header...
  15. jbelk11

    OE sales history table layout

    NEmacGuy is correct....the DRM is the best resource for field definitions. In addition to oelinhst_sql, you may also wish to consider grabbing oehdrhst_sql and possibly your customer table (arcusfil_sql for Progression, cicmpy for ES) to get the most complete picture. When you join the history...
  16. jbelk11

    ES - Flex capture OE line item save?

    Good evening all.... Macola ES 9.5.700 I am currently working on a project where I would like to streamline the entry of a value to an order entry line item user defined field. This value would only be required on a subset of customers. I know the "long" way is to have the end user click the...
  17. jbelk11

    Macola ES - AR/AP Open Item Load?

    Macola ES v9.5.700 We are looking to bring in items (ie AR and AP invoices) from another database. I recall that Progression had Open Item Load...does ES offer something similar? Thanks Jen
  18. jbelk11

    ES 9.5.700 -- changing line dates

    Hey Don... I did receive confirmation from the Exact support team that these have been identified as bugs. So hopefully, they will get in the development cycle soon. 41.828.750 is the product issue for the POP orders. 41.828.989 is the product issue for a second problem we found...only the...
  19. jbelk11

    How to display the extra_14 field in the Enter Sales Order (OE0101)

    I dunno if you can do that with the stock Macola ES screens. I can think of a way to do this with Flexibility....you could write code to retrieve the value directly from the database and display it in a VBA-only control on the page...could do this in say the LoseFocus event of the order number...
  20. jbelk11

    ES 9.5.700 -- changing line dates

    Reported it to Exact a couple days ago. Since I don't have a support contract, not sure if I will get a confirmation on it or not. We do own flexibility...just curious as to how you would design the fix? I suppose in the Save event, you read in the order number and then look for the...

Part and Inventory Search

Back
Top