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 Mike Lewis 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. LouieGrandie

    How to get Yield Field from BOM Maintenance Screen

    It is stored in the Bill of Material header or the BM1 depending on which version you are on. Visit Sage's Online Community http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc
  2. LouieGrandie

    MAS 90 VI Payroll Import Job

    It would help if you posted the error messages. Visit Sage's Online Community http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc
  3. LouieGrandie

    Custom filters operand

    First what version of MAS90 is this? And please explain where the word "discontinued" would be. What field would it be in. In Crystal you would use the Select Expert. Visit Sage's Online Community http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc
  4. LouieGrandie

    Need help to create Visual Integrator Import function to Sage 4.40 and Kronos

    What version are you on? And normally you would work with your reseller on something such as this. Have you ever done VI imports? Visit Sage's Online Community http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc
  5. LouieGrandie

    Query for Desired Quarter

    Thanks, let me give that a try. Visit Sage's Online Community http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc
  6. LouieGrandie

    Query for Desired Quarter

    Currently have a report that shows current month sales, year to date sales, last year current month sales and last year year to date sales. Now the sales department wants it changed so they can select which quarter, 1, 2, 3, 4 and show that quarters sales instead of the current month sales...
  7. LouieGrandie

    Last cost not accurate on Kit Bills. What am I missing?

    Kit Bills if used in Sales Order are not treated by the system as an actual item but as a way to list items that are sold at once. It assumes the Kit never goes through production. Therefore the Kit itself is not updated, just the component items. Visit Sage's Online Community...
  8. LouieGrandie

    Unable to Update Job Billing Register

    Something is wrong here because SY_03 is a system tax file and would not have a job number in a record. Are you sure that is the error message. Visit Sage's Online Community http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc
  9. LouieGrandie

    Sage ERP 100 2014 Advanced

    Your best source is probably Elliot over on the Sage Community. I would send him a direct message there. Visit Sage's Online Community http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc
  10. LouieGrandie

    Applying a Credit memo or prepayment on one

    You would do a zero dollar deposit. For Customer 123 apply each to zero them out and then use a GL entry to balance. For customer 789 apply the amount to the invoice and use the same GL account that you used with customer 123 to balance. All transactions should total to zero. Visit Sage's...
  11. LouieGrandie

    MAS90 support

    Where do you want to show the components? In the Bill of Materials module you would just setup a Standard Bill. In Inventory Maintenance you would set up the item as Buy and not Make. No this would not be a Phantom Bill. A phantom bill is for a non-existing part. Visit Sage's Online Community...
  12. LouieGrandie

    External Link to SO Invoice History

    On v4.3 you can open the file from NAV using VB and the Business Object Interface of MAS200 v4.30. You would need the assistance of a consultant versed in this. Visit Sage's Online Community http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc
  13. LouieGrandie

    External Link to SO Invoice History

    It depends on your version. On the recent versions you can create something in VB Visit Sage's Online Community http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc
  14. LouieGrandie

    Error #47, substring reference out of string

    What version are you on? This was first reported 6 years ago. I believe it was fixed in later versions. Here was the post in Sage City concerning the error. Has anyone seen this error at all? The error occurs when starting to enter a comment for a sales kit, but instead of finishing the...
  15. LouieGrandie

    Open Order Report

    In MAS errr Sage 100 Orders are in the SO_SalesOrderHeader and SO_SalesOrderDetail files until they are invoiced. Once invoiced they are purged from those files and exist only in the SO_SalesOrderHistoryHeader and SO_SalesOrderHistoryDetail files. The Invoices files have data in them only until...
  16. LouieGrandie

    Union Query Problem - Need some 'Splain'

    OK so you feel it should be SELECT {Field Names} FROM {Broker Table} UNION ALL SELECT {Field Names} From {Pass Through Query} One more question. Does it matter which is listed first, the Broker table or the Pass Through QUery? Visit Sage's Online Community...
  17. LouieGrandie

    Union Query Problem - Need some 'Splain'

    I have a database that is the data source for some Crystal reports. One table holds data sent from a broker of invoices of my client's product sold to the broker's customers. A SQL Specific Pass Through query reads the invoice history files in the clients accounting system. There is a Union...
  18. LouieGrandie

    Silent DSN for Crystal

    I have a Crystal report that uses SQL as the data source. I am going to use a business monitoring software to run and distribute the report. My problem is that I need a "silent" DSN so that when there is no log in prompt for SQL. How would I do that? The DSNs I have created don't see to hold the...
  19. LouieGrandie

    Silent DSN For SQL

    I have a Crystal report that uses SQL as the data source. I am going to use a business monitoring software to run and distribute the report. My problem is that I need a "silent" DSN so that when there is no log in prompt for SQL. How would I do that? The DSNs I have created don't see to hold the...
  20. LouieGrandie

    Mas 90 4.0 lost keys, have 3.71 working

    Everyone goes through a vendor. If you can create a profile and log in, you should be able to retrieve the keys. Visit Sage's Online Community http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc

Part and Inventory Search

Back
Top