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 Chriss Miller 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: *

  1. JonathanR

    Anyone have 6.00 GL diskettes

    I am trying to recover some old data that won't convert to 7.5. Does anyone have any 6.00 GL diskettes that they could email to me? GLPROG01 and GLPROGUP Thanks! - jonathan@powershiftsystems.com
  2. JonathanR

    Updating MAS 90 through ODBC

    We used 3.22. It is not a simple task to update the files, though, as we need to update the whole file, not just a field within as is the case with other ERP software we use. The latest version of Customizer is supposed to allow field updates, but we have not got this to work yet! Cheers, Jonathan
  3. JonathanR

    Create custom PO report

    Crystal is a fine tool for writing reports, and it comes with every MAS 90 install - can I suggest that you try it, and compare it's speed with that of Access? If you can do the report in Access, you'll have absolutely no trouble in Crystal, and you can then put the report on your users' MAS 90...
  4. JonathanR

    Purchase Order Recap Report

    The program is POWRHA. You can run this from file, run. The source for this information is the T R S G, which is a CD that you'll probably have in the green CD binder when the software was installed. Cheers, Jonathan
  5. JonathanR

    Updating MAS 90 through ODBC

    Is is possible to update MAS 90 Databases through ODBC with some kind of SQL "update query"? I know that the VI module allows file updates, but I'd like to update the sale price from another file during Sales Order Entry. Someone mentioned that alternative ODBC Drivers that allow...
  6. JonathanR

    New Year Tax Table Update

    If your company is up to date with Best Software, and is paying annual maintenance fees on the Payroll Module, then you will receive the tax tables whenver they change. Do you deal with a reseller? If not, you could work through my company, jonathan@powershiftsystems.com.
  7. JonathanR

    New Year Tax Table Update

    Every year, Best sends out Tax Tables, for use with MAS 90, 200 and SQL, and the latest one I got was fro 2003-Q1 Tax Tables. Are these not what you need?
  8. JonathanR

    Sage Job Costing Help!

    You are in the wrong place! Sage is the UK only software, here in North America the software is completely different, being MAS 90, 200 and 500. Cheers!
  9. JonathanR

    Error msg= Record: G/L PO2 is missing from SYOCTL.SOA

    Sounds like you are having trouble with SVDATA. I have had similiar troubles, and the suggestion from Best was to re-set up General Ledger module after running SVDATA. This does not work every time, but you may be OK.
  10. JonathanR

    Create custom PO report

    To do this you need to have installed Crystal at your PC, and then start up Crystal, create a new report using the report expert, selecting standard, then selecting sotamas90 as the database source. In the tables PO1 and PO2 you will find all of the records for open purchase orders, PO1 being...
  11. JonathanR

    Year-End Close Time Line

    This is potentially a very long question! The simple answer is that in each module, there is a year end closing procedure that clears out accumulators prior to starting with the new year. This means that you can not start entering 2003 transactions until you have closed 2002, as the accumulators...
  12. JonathanR

    Display account description on PO

    In Crystal (Form), you will need to "add database to report", which should be the GL1 file. You can then link GLAccount in the PO2 file to Account Number in GL1. You can then place the Account Description onto your PO form. This is easy - you don't need SQL statements! Hope this helps!
  13. JonathanR

    How to import into Mas 90

    Could mpemberton briefly outline how to import using ODBC into MAS 90? I was not aware that the SOTAMAS90 ODBC drivers allowed update of MAS 90 data. Thank you!
  14. JonathanR

    need to change item no. value

    Peak Data Systems has a utility that allows you to change the Item Number, and this utility changes all affected files. They are a developer of enhancements for Macola. I do not know if the program works with Netcellent - I doubt it - but you could certainly give them a call at (973) 659 1990 or...
  15. JonathanR

    MAS90 Inventory Mgt Capabilities

    As they are using MAS 90, they could use "add-on" solutions from Scanco (www.scanco.com) or Radio Beacon to get detailed bar coding bin tiers and so on. The basics of inventory control are otherwise quite powerful enough in MAS 90/MAS 200 to satisfy most users.
  16. JonathanR

    mas 200 odbc very slow access and transfers the mas 200 ---

    Can I suggest that you re-install MAS 200, as normally the response time is very fast. Is the Server busy doing other tasks, such at NTTS? What are your NIC connection speeds? 10 or 100 or are they really slow? When you re-install, be careful to follow on line manual instructions for the UNC path.
  17. JonathanR

    MAS 90 Commission Calculator

    I am trying to create a report of Commissions Due based on either Gross Profit or Percentage of Sales, depending on the Salespersons ID. Has anyone done this? The regular MAS reports do not handle such variables, as the same sales order may have rep 100 getting 10% of GP, and Rep 200 getting 3%...
  18. JonathanR

    Visual Integrator (VI) book

    Have you tried the User Manual, which is part of the software when you install MAS 90?

Part and Inventory Search

Back
Top