Recent content by leishad

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

No, I was not aware of the MACOLAED user --- Thank-you - Thank-you and Thank-you --- I will have to inquire regarding not losing screens because every time we have upDATED I am asked about the screens and have at times had to redo them. Is there something in the updating process that asks a...

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

Well, as would not be surprising I found multiple sources of the problem -- and then learned a few additional things along the way. 1) One of the tax codes was not listed in the master tax schedule. 2) Several items did not have a tax schedule associated with them (which led to the discovery...

While I continue to work on this I realize that I failed to mention that the tax schedule is made up of 4 tax codes, 3 of which show the proper sale amount for the invoice and only 1 that does not.

That will be my next approach --- when I determine the cause(positive thinking) I will post results here.

I have looked into the sytaxhst table and just did a search on $0 sale amounts and see that there are many times over history that this occurs (when the sale amount is not $0). When setting up tax codes/schedules are there conditions that would account for this? I CAN think of reasons to do it...

All items are taxable and in item master. I can look at 2 different invoices that are alike in item_no, cus_no, tax_sched and they do not both behave in this manner as far as the tax code report is concerned.

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

I have created a Crystal Report that is run after orders are selected for billing but before they are posted. This report shows me whether the qty on hand will be negative as a result of any sales invoicing. Then we unselect and investigate. (I also include fields to check for any $0 costs on...

Where is the 'reset fully paid status'?

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

I have answered the WHERE things went question through the gltrxfil -- while it is unclear where the default postings came from. My problem is solved.

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

more info - the user reported "When I go to enter tag counts and type in the batch number or select it from the search screen, the batch appears to open but the cursor will not tab to the count field and will not move by clicking with the mouse either.