Search results for query: *

I'm using Progression 7.6.400b on MS SQL 2000. Many of the customers have terms (due and discount) that can't be calculated simply by adding a number of days to the invoice date. We use the capability in Progression to specify a specific due and discount date for a particular terms code and we...

I've built a cross reference table in SQL (MacolaDates) with two fields, a date field with a SQL field type of smalldatetime and a MacolaDate field int type. I've populated the table with about 10 years of dates aprox 4000 records. I use it and link to it and in SQL views and any time I need...

We're on Macola Progression 76.300b and have recently begun encountering some POs that have a status of P but when attempting to report reciept in OE it indicates that the order has not been printed so it cannot be recieved. But it cannot be printed since the status is P. Any idea what might...

What version of Macola was this? I'm using Macola Progression and was under the impression that triggers were not supported in Progression. This may be one of the reasons.

Is anybody using Currency manager and having difficulty reapplying payments or credits when the original apply to is 0 (on account)? We are getting "No transaction on file" message on entering the apply to document number. We are using Progression 7.6.300b with MSSQL.

I use Monarch Data extraction software for this. It's kind of expensive but it will allow you to build templates/models for each kind of std Macola report or any text or pdf report from other applications, so that you can reuse/automate the conversion process. It will allow the data to be used...

In case anyone else has the same problem that I posted here I've been able to resolve the issue. The network uses Winproxy as it's proxy server/firewall, the Winproxy also scans e-mails inbound and outbound (SMTP) for viruses. THe problem is caused by the outbound SMTP scanning, once that was...

I'm having a problem with Outlook and Outlook Express and attachments. The problem is occuring on several machines on the same network. When sending attachments from either mail app and attaching large files > 700Kb the e-mail with attachments are arriving without MIME headers and cannot be...

Is it possible to default a field to the current system date? Example: On the Order Entry screen can the ship date be defaulted to the current date vs A.S.A.P which stores as 0. I've been able to make the field required but to avoid the likely hood of typo's I'd like the default to be the...

Thanks for your response. That confirms what I would have expected. So wouldn't that imply for a non-stock item with 0 qty on hand the average cost should always be equal to the last cost. And if they are different something else must be effecting average cost.

If I have a non-stocked item with 0 qty on hand and an average cost of $2.00 and place an order for 1 item at a cost of $2.50 shouldn't my average cost on reciept change to $2.50 . I seem to have non-stock items in the item location file with a different average cost than the last cost and am...

Reinitializing the table in Macola and then doing a SQL insert to populate the table while letting the A4GLIdentity field populate itself did the trick. My 1,860,320 records inserted in less than 15 minutes and no problems with the A4GLIdentity field. I was able to copy that OEPRCFIL_SQL table...

My think my concern stems from having incorrectly populated that field in the past and then having a problem when trying to add records from Macola to the table. Your comment about the field type and length got me to look at the table design and that may have answered my own question. The data...

None of the records are expired. And all are actively in use to cover pricing agreements with specific customers. There is nothing I can do to reduce the number of records in the table. The posture of the sales department is such that any customer (2000+) customers can negotiate any price on any...

I'm in the middle of a price increase project that requires a lot of work on a very large OE price file and I'm concerned that at some point it may be necessary to rebuild or export/initialize/import the OEPRCFIL. This is a MS-SQL installation. The OEPRCFIL has just under 2 million records...

Thank you all for your thoughts on this. I think what ChrisP520 and ultrav suggest will be most helpful depending on the situation.

Macola Progression. What is the best way to handle a price adjustment issue at order entry? Example an order is shipped and invoiced 10 items at $10 Total $100, Then it is discovered that the item price should have been $12 so an adjustment needs to be processed for the difference. What is the...

I'm working on a system using Macola/Gentran EDI producing 810 documents (invoices). My problem is that the 810 documents carry item pricing to 4 decimals, Macola has pricing set up and used at 6 decimals and due to special customer pricing it is not possible to change item pricing to 4 decimals...

You need to have ACT 2005 installed on the server first, so that the ACT instance of MSSQL gets installed. Then after stopping the MSSQL service on the laptop and on the server. I copy the database and the .PAD file to the server esentially overwriting the Act database on the server. You also...

This problem was fixed by using a Global Scratch Set. This can be set up by checking the box in Server Admin under the Admin, Configuration, Tape Engine tab. It now correctly recognizes that the tape in the drive is useable in both the PFC and the Media prediction report.