Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ChrisP520
  • Content: Threads
  • Order by date
  1. ChrisP520

    Missing Order

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

    Mis-Shipments

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

    Mysterious Order Header Credit Hold

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

    Feature Option Setup Charge

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

    PO Status H

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

    Orders Not Showing in views

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

    Status Code P = Price Hold

    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 =...
  8. ChrisP520

    MacMSL.dll Error on OEORDDTL_SQL Table

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

    SAP Business One

    Greetings: My company is planning to move to new ERP software. We have been using Exact Macola Progression for about 12 years now. I would like to gain some insight into some of your experiences with the SAP Business One product which we are considering. I'm not even sure that this is the...
  10. ChrisP520

    OE Invoice Unit Price Rounding

    Greetings: We are running Progression 7.6.300C on MS SQL Server 2000. We are having an issue with the UNIT PRICE that shows up on our invoice forms. The problem is that it rounds to 2 decimal places. We sell items like wire and cable and those typically go to 3 decimal places. So, on a line...
  11. ChrisP520

    Bulk Price Code Insert

    Greetings: We are running Progression 7.6.300C on MSSQL Server 2000. I am trying to do a bulk insert of Type 4 price codes into the OEPRCFIL_SQL table. I am trying to do this because Macola's COPY PRICE CODES application doesn't work with Type 4 Price codes. The goal is to create price codes...
  12. ChrisP520

    Vendor Returns in 7.6.300C

    I'd like to ask how folks out there are handling vendor returns in Progression 7.6.300C. You can't print a vendor return form unless the item is selected for receiving inspection. We are a distributor and have thousands of active items so going through a receiving inspection process (even just...
  13. ChrisP520

    Require Approval for Items Based on Price

    Greetings: We have a customer that has hundreds of locations that have the ability to order products on their own based on the needs of that location. The mother ship, however, wants to require approval from the main office on any item that has pricing of $200 or more. The problem here is...
  14. ChrisP520

    Product Category Update / Pricing Issue

    Hello All: We made changes to the pricing of a particular vendor that made it necessary to create a new product category. Becuase we have products in the thousands from this vendor, we thought it would be very time consuming to go into each item record in the item master to change the prod...
  15. ChrisP520

    OE Blanket Releases on Hold

    Greetings: For some reason, the latest round of releasing OE blanket order has caused the regular "O" type orders that were created to be created with the Credit Hold flag on the order header set to "H". We ran audit trail reports on the customer table for the customers in question and we do...
  16. ChrisP520

    Calculated Size Error

    Greetings, All: During period end processing when we run the Update Calculated Values application, we are getting a "Calculated Size Error" on one of our items. This happened last month as well. When I look in the Item Location Table, I see that the Sum of Errors Field and the Average...
  17. ChrisP520

    Incorrect AP Accumulator Data

    Greetings, All: I believe that my Prior Year AP accumulator data is incorrect. It is looking like the PURCHASES LAST YEAR number is about twice what it should be. I need a way to confirm what those numbers should be. I know that the data resides in the APOPNHST_SQL table. I'm just not...
  18. ChrisP520

    Starship Freight Upgrades

    Greetings: We would like to do some promotional freight upgrades for some of our customers. For instance, we would ship via UPS Next Day Air but would charge only the ground rates. What I want to know is there any way that I can have Starship use the Next Day Air ship method, write the ground...
  19. ChrisP520

    Update Calculated Values

    Greetings: When I run the Update Calculated Values in IM->Processes, does it automatically update the values in ALL locations? Running 7.6.300C on MSSQL. Thanks for your help. Chris
  20. ChrisP520

    Bank Book Expected Cash Flow Report

    Greetings: We recently installed Bank Book. When we try to run the Expected Cash Flow report, it just hangs at the "Print Status" screen. We've tried to run the report in several different ways, i.e., bi-weekly, weekly, etc. to no avail. If I initialize the BBEXPCSH table do you think that...

Part and Inventory Search

Back
Top