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!

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

Recent content by NEmacGuy

  1. NEmacGuy

    Macola ES / Macola 10 Database Size

    Just wonder what an average accounts database size is today ? How much server space is dedicated for the SQL Server, and how much backup room ? We are approaching 1Tb for the backoffice database, and 610Gb for the frontoffice / synergy db. Server is a DL560 with 128gb Ram and 8TB across...
  2. NEmacGuy

    Item Master and Location Limits?

    Guessing you are similar to a screw or fastener business. Lengths, diameters, coatings, thread types the possibilities lead to a lot of part numbers. I had a client in the same spot. 7.5 million item masters and added 200k per year. Had no problems due to the item count.
  3. NEmacGuy

    Received Not Invoiced Question

    Could you just manually close the PO and not include closed PO's on the report ?
  4. NEmacGuy

    Macola Progression 7.9.340 EFT Prenotification

    My first thought is to check the "Unzip the files of ‘APEFT.zip’" file and did it contain a new APOPNFIL_SQL MSL file ? Did it get saved to the MSL folder ? Probably best to call ECI. You could also check does the structure of the APOPNFIL_SQL MSL file (in the MSL directory) match the...
  5. NEmacGuy

    Flex question

    Thanks Don, That article tickled the memory bank and I found an old project with the SendKeys function. Curiosity, which version of Visual Studio do you use when working with Macola. I mistakenly updated to 2022 and then the older Crystal Reports would not work, downloaded a new Crystal IDE...
  6. NEmacGuy

    Flex question

    Prior to Windows 10, we use to use SendKey {Tab} to move from field to field. Is there a way move fields anymore? Thanks
  7. NEmacGuy

    GL Account (MacolaES 9.8.400)

    Check in the chart of accounts. In Progression I believe you could pick which modules could use the account. In MacolaES/10 you just check the Blocked box.
  8. NEmacGuy

    OE - Sales comparison report - purge history by mistake

    The backup and restore idea sound 100% the safest thing to do. Only other option would be to purge the rest of the month. Then update the Order Header History file, and uncheck the posted to sales history flag for the date range in question. Then relaunch the post sales history for the period...
  9. NEmacGuy

    Errors after install of exact macola progression workflow explorer Win10 Client - Help Please!

    Are you familiar with the Path Environment on Windows. Check the following tech note: https://www.exactsoftware.com/docs/DocView.aspx?DocumentID=%7B75fb8620-dd8c-49bc-ab64-e23719422f5a%7D
  10. NEmacGuy

    AR Aging Report Not Matching

    If the amount match on a real apply to number, then they should not show. Rebuild may not be a bad idea, first thought is running a currency reset. Alway make sure you have a good backup before running any processes. Also a good idea to make sure you have a good backup each and every day.
  11. NEmacGuy

    Finance Charges?

    Some advise. I setup Finance Charge a long time ago in Progression for a client. It worked very well, and was almost too easy. The client ran for about 6 months and generated lot of Finance Charge Invoices. Well after a low payment rate, and high complaint rate, they decided to stop. It took...
  12. NEmacGuy

    cus_item_no and OECUSITM_SQL

    If there is a customer item number on file, the source code of the program will automatically populate the cus_item_no will populate. The field wouldn't change per order, the key is the customer and the item_no. I think you are fighting the source code with the sdk. Can you use one of the...
  13. NEmacGuy

    Shop Floor Order Entry failing due to missing Shop Calendar Detail Record

    1 System Mfg - Global - Calendars - Check both the Shop Calendar and the Reporting Calendars 2 System - Package Setting - Mfg Setup - Check which Calendar Numbers are your defaults
  14. NEmacGuy

    Allow user_def_fld_5 to be edited in OE

    I thought you couldn't directly use this field on the Order Entry window. I thought you had to use the OE Order Line User Defined Fields Push Button, due to a Cobol control limitation.
  15. NEmacGuy

    Inventory Report

    The problem is, it does not show balances before or after the given transaction and there is no way to know if it’s a positive or negative transaction. I have to believe someone has figured this out and does not mind sharing SQL that will help me pull a descent inventory transaction report out...
See more

Part and Inventory Search

Back
Top