Search results for query: *

Macola Progression SQL v 7.6.400b We are upgrading our server hardware and want to move from Small Business Srvr/SQL Srvr 2000 to 2008. Can someone tell me if our version of Macola is compatible with 2008? Thank-you in advance

Progression SQL 7.6.400b I am trying to prepare for the future and it is my understanding that when installing updates we lose our custom screens. I was reading the SM User Guide and saw that I could export screen sets. My question is: Would I export the screensets somewhere for safe keeping...

Macola SQL Progression 7.6.400b Setup for tax schedules I have a sales invoice with a sales amnt of 314.72 The tax code report only shows 100.00 in the sales amnt field (in this case it is a non taxable client so taxable amount is correct at $0 and there is non-taxable freight which also shows...

Macola Progression 7.6.400b MSSQL When printing aging report by customer number the report appears to hang on one customer. Eventually, it will print the report but with this one customer repeated over many pages. I tried running the Integrated Crystal Report and while it opens quickly enough...

Macola Progression 7.6.400b - pkgs ar/ap/oe/gl/im/po/sm We created a new location without proper task completion. The one of the most concern to me is that the prod cat used for all items at this location was never defined for this location thru oe maintain prod cat/loc acct. Is there a...

At this moment I have limited information however, we are using Progression 7.6.3 MSSQL. My data entry person was entering the counts from our physical inventory when everthing froze up.(I am awaiting further clarification). I DID run a rebuild on the tag file but it did not have an impact...

I am going to be working remotely and need some input with regard to what I need to have setup. We're using Macola Progression 7.6.3 MSSQL. I want to be able to work just as I do within the office. One of the issues that I have is that I may be restricted to a limited amount of online time...

MSSQL Progression 7.6.3 - After using the Progression setup utility to create the new database and log files I then proceed to Company Maintenance (I am only creating company in order to have a place to restore a backup). I complete everything by duplicating the items in our main company, save...

When printing this report sorted by user defined field what table/field is it pulling this from. I tried user_def_1 in IMITMIDX but didn't appear to be that field. Need, ASAP!!

In OE when a user creates a Credit Memo I need to force them to enter an invoice#(would settle for any non-zero number) in the apply to field. I went into the screen designer and selected to make it required but this field automatically defaults to 0 if nothing is entered so that negates the...

Macola 7.6.3 MSSQL - this is the first of many error messages I get when trying to run Physical Count Select (also with Cycle Count Select) it always appears to stop at the same item_no) and then I get a barage of error messages. This first message seems the most important, it is very long so...

I found thread962-1080316 to provide most of what I need however I was left with a question With regard to shrinking Log Files the above thread illudes to the following statement: --------------------------------------- use {Database} dbcc shrinkfile ({LogFileName}, {SizeToShrinkTo})...

(Windows 2000)I have found info on the various switches for changing the default view for explorer but I am slightly confused -- the instructions that I have found say: ------------------ 1. Click Start, point to Programs, point to Accessories, right-click Windows Explorer, and then click...

Progression 7.6.3 MSSQL I am editing the ItemLocMaint form (IM0201) so as to unhide a couple of the user defined fields on the 2nd page of this screen. Everything looks fine on the 2nd page but after I save anything I put on the 2nd page is now on the 1st page. What don't I know??

VB 6.0, MSSQL 2000 I have just learned how to create stored procedures and how to call them from VB code. I have written a program in VB 6.0 which has many SQL queries. It seems to me that it would clean things up real nice if I created stored procedures and called them from my program instead...

I am using VB6 and MSSQL - Adv.Beginner Level. From the msdn website I have copied the code for a function called ExecuteSQL (see below). I was using this function just fine for returning recordsets but now I want it to execute an INSERT query. I am confused as to how to call the function...

Macola Progression 7.6.3 MSSQL I run the PO Received/Not Invoiced Report and find the following information for an item: Ordered 7 Receiver 7 Invoiced 1122 Quantity Not Invoiced -1115 This is a 'closed' PO The qty of 7 is correct. I am trying to find where/how the 1122 could have gotten...

Please note that I began my adventure with thread639-819736 and am just narrowing the field with my current question. We use line item cost in order entry and if i understand correctly that means that the inventory is relieved using this cost. But, what I don't get is if the stock status...

I do not know the right syntax to achieve my desired result: This would be my beginning point: INSERT INTO table_job (job_no) VALUES (variablenumber) But I need to add the verbage to loop through this 1,000 times (adding 1,000 records) incrementing the variablenumber each time. What is...

Macola Progression 7.6.3 MSSQL Presumed: every item# is assigned a product category and a material cost type whose combination then determines to which GL acct related info will post. Question: what table(s) would I query to view the account#'s associated with the various matlcosttyp/prodcat...