Search results for query: *

I have start and end times that are stored as varchar such as "0700", "1600", etc. How do I convert these to time? Macola and Sage 50/Sage 100 Consultant Check out our Macola tools: www.gainfocus.biz/exceladdin.html

I have little experience with Cross Tab reports. I inherited one with month names as columns. But the sort is April, August, December, etc. - Alphabetic sort. How do I get this to sort as January, February, March, etc.? Macola and Sage 50/Sage 100 Consultant Check out our Macola tools...

In the BacoAppLog table, it logs every time you open an application in Macola ES/Macola 10. For example MACMDEBITR.slc is the entry made for customer maintenance. Is there a list or table that holds the English description of this? Macola and Sage 50/Sage 100 Consultant Check out our...

I just saw a case of a cycle count batch that is returning incorrect data on the pre-post register of "Post Count Tags". No external input from Wisys or any other application is being used. This will happen 3 or 4 times and they have been re-creating the cycle count batch to solve it. A very...

Its been 15 years since I worked with Pervasive SQL. I want to create a view. Here is my code to do so: CREATE VIEW "ItemBeginningBalance" AS select i.ItemID,i.ItemDescription, sum(c.quantity) as BegBal from LineItem i left outer join InventoryCosts c on c.ItemRecNumber=i.ItemRecordNumber...

Basically the title. Where do I find a suitable DDF builder for actian files? Macola and SAP Business One Consultant Check out our Macola tools: www.gainfocus.biz/exceladdin.html

Sage 50 Quantum. Despite going through the normal installation step to make these functions available, they aren't. The u2lpeach.dll is in C:\windows. I even tried to manually register it with regsvr32 to no avail. Where should this .dll be? What am I missing here? Macola and SAP Business...

Outlook 365. I used to able to right click an email, select follow up, and I had a choice of dates like today, tomorrow, this week, next week, This month, etc., or Custom, which was very helpful. Now I have 2 choices, flag message and clear flag. I cannot even select a date. Someone please...

I need to determine if the current row (iRow), column A, is duplicated anywhere in the range of A11:A & Range("E7").Value. E7 will contain a value that will indicate the end of the range. This could realistically be from 11 to maybe 10,000. It will change every time. The SetGLRRowColor() sub...

I'd like to write a report against all the emails in a certain folder. CE 2013. I created a Data source by going to Create new connection->More data sources->Outlook. It showed my email address so I chose it and soon had a list of fields to choose from. I chose a few and ran the report but it...

Does anyone out there charge Finance Charges in AR in Macola? I personally have never run across anyone using this, but I was asked this question yesterday. In doing research, each state has a maximum finance charge, but several have no laws on the books addressing this. Do you apply this...

This is Macola ES only, no Synergy. Has anyone ever used this to any effect? In my limited testing, it does not stop the user from entering , releasing or printing a PO regardless of the $ amount. Is there actually some functionality behind this field? If so does any know how to make it...

Macola Progression 7.9.200 So I had a request to write the MRP by Date Report as an Excel Power Query. Looks great and runs in 4 seconds. UNTIL I decided to add the MRP exception codes. Then the query takes 25 minutes! In either excel or SSMS, it is a dog. I have checked the indexes...

Are there any Macola users that would like an integration between AutoCAD or SolidWorks and your Macola Bill of Material and Inventory Modules? I am thinking of an integration to create the parts in Macola if they do not already exist, then of course to create/edit the BOM itself. What if...

WTH? Release notes for Macola ES 9.8.400: Screens with Flexibility modifications are not supported when run on a Windows Server 2019 machine Does anyone have a clue as to why this would not be supported? What does Server 2019 do that is so different? Server 2016 has End of Life set at Jan...

So I have an order table and comments is a separate table. There could be several lines of comments per order, or there could be none. So my desired output should look like this: Order_no, Order_date, Comments So my SQL is straight forward: select O.ord_no, O.ord_dt, C.cmt from oeordhdr_sql...

Excel 2016, SQL Server 2008 (not R2). I created a view in SQL, then wanted to to use Power Query to analyze the data. I created a view because my SQL was too complicated to be displayed graphically, and it must be able to be displayed graphically in order to use parameters. So I did all this...

Excel 2016, SQL Server 2008 (not R2). I created a view in SQL, then wanted to to use Power Query to analyze the data. I created a view because my SQL was too complicated to be displayed graphically, and it must be able to be displayed graphically in order to use parameters. So I did all this...

I have a table which was created via Power Query. Works exactly like I want it except I want to total a few columns. If I do this manually by going to the first blank row and clicking on the Sigma icon, the cell contents are this: =SUBTOTAL(109,[sls_amt]) My column name is of course sls_smt...

OK I have a pivot table with Item Number as the rows and the Year-Month as the columns. I have 4 fields I want summarized in the Pivot Table: Units Sold, Sales $, Cost $ and Gross Margin $. When I add these, the output looks like this: ITEM 2020-Nov ABC123 UNITS SALES $ COST...