Recent content by jbelk11

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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