Search results for query: *

Don: Thanks for the info. Customer is set to allow backorders. Both of the items on the order are set to allow backorders in the Item Master. It turns out that one item was backordered and one was not according to the audit trail report. When I run the reset allocations report it shows that...

Greetings, All: We are running Progression SQL 7.6.300C on SQL 2000. One of my salesmen converted a quote to an order this morning and now we cannot find the order. We have looked in the open order, history and consolidated views and the order doesn't come up by order number. It also doesn't...

Greetings, All: We are running Progressions SQL 7.6.300C on MSSQL 2000. I want to know how folks are handling mis-shipments through the RMA module. By mis-shipment I mean the wrong item is shipped to the customer. Example: Our customer orders Item A, we mistakenly ship Item B. Now, our...

Greetings: I'm running Progression SQL 7.6.300C on SQL Server 2000. The Credit Hold flag on some orders have mysteriously been set to H (credit hold). When I look at the audit trail report, it never shows the orders having been set to hold. I've also checked credit and payment terms during...

Donna: If you do not need to lock the document, Macola PRT files open well in Windows Notepad and other text editors such as TextPad. Chris Poulin

Randva, Thank you for the reply. Are you saying that you include this non-stocked item called SETUP in the Feature Option Configuration? If so, how do you charge only once per job? If I order 20 Feature Option items on a customer order, each option will be mulitplied by the quantity ordered...

Greetings: I am running Progression 7.6.300C on MSSQL 2000. I'm trying to find a way to deal with set up charges in metal fabrication. We fabricate metal face plates. When we punch metal to accomodate connectors, each punch type has an associated setup cost. This set up cost is amortized...

Thank you, Don. That's good news.

Hello MacolaHelp: Thank you for the reply. You post pretty much addresses my fears. I DON'T know what other tables and reports this change would hit and I wanted to make sure that I didn't irrevocably trash my live data. My hope was that someone DID know for sure if this would work well or...

Hello, again. Can anyone weigh in on this? My ulitmate goal is to make the orders that are being switched to a status of H disappear from the PO Cash Requirements report and at the same time allow the PO to be viewed by Item Number in PO Views. I did a test in a test company where I ran a...

Hello Adrian: What is the issue with concatenating the note field? Are you getting NULLS? If so, have you tried using: SET CONCAT_NULL_YIELDS_NULL OFF at the beginning of your query? SQL Server, by default, has this set to ON. Therefore, if you try to concatenate a non-NULL field with a...

Greetings: I am running Progression 7.6.300C on MSSQL 2000. My PO system is a mess. There are open orders showing back to our start with Macola in 1995. This causes all sorts of issues that are too numerous to list as I'm sure all here know. What I would like to do is close those orders...

Hello Again, MacolaHelp: Now that I have fixed this issue, I did some looking and found that I have an issue with Orphaned OE Order Headers rather than the other way around. I have 295 Order Headers that do not have associated Order Line records. The really weird thing here is that for each...

Good morning, MacolaHelp: Thank you very much for providing a second set of eyes. The problem turned out to be an orphaned Blanket order. I was concentrating on O type orders. By joining on both the order number and order type and using a full outer join, I was able to find the missing order...

Hi MacolaHelp: Thanks for the reply. This started out of the blue. When I queried the Header and Line tables I joined on the order number. But I did a left outer join on the order number from the line to header table so that I would see the missing headers. I repeated the process with the...

Greetings, All: I am running Progression SQL 7.6.300C on SQL Server 2000. I'm having a very strange issue. For one particular item, I cannot see the open OE Orders in any view when looking for it by item number. For instance, I cannot see the open orders for this item when I look in Multi...

Greetings, All: We're running Progression SQL 7.5.300C on SQL Server 2000. In the Macola Help files, there is a reference to Order STATUS Codes (NOT Select or Selection Codes) as seen below. · Status - The status of this order: C = Credit Hold P = Price Hold Z = Credit/Price Hold H =...

You should be able to use CHARINDEX in conjuntion with SUBSTRING to achieve this. You can find info in BOL.

Greetings, Folks: We're running Progression SQL 7.6.300C on SQL Server 2000 on Windows Server 2003. I got the following error after creating a "Reshipment" in the RMA module and then modifying the order. Anyone know what this is? MSL Technical Error Info: An error occured in MacMSL.dll...

Hello Andy: You have hit the nail right on the head. The ultimate goal has always been to create self maintaining Type 3 and Type 4 price codes for a new customer type called EC that would be based on Type 3 and Type 4 price codes for our Customer Type G. This will really cut down on price...