Browse By Tags

  • Full Inventory Inventory List w/filters

    Hello fellow Sagers! Happy Holiday's or Merry Christmas! I need a report that shows all inventory items WITH "Inventory Cycle" and "Active/Inactive" status displayed. I have years of incorrect inventory items/status modifications that were entered and…
  • Implementation problems with specific inquiry

    Hello everyone We have programmed a specific inquiry for our client. There should be a back and next button. Only a part of the data records should be displayed. When you click on next other records should be loaded. In the function GESGTC (Inquiry…
  • Inquiry functions - Number of records selected and search tool

    In the inquiry functions (like CONSCSO), it would be useful if the total number of selected records of the inquiry were displayed in the inquiry functions (and not only the number of records on the displayed page). It would be useful too if the "Search…
  • Printing invoices from AP Inquiry

    We use Timberscan to import invoices in Sage for electronic copies. I sometimes have to print a stored invoice from the AP inquiry screen. It has always worked fine up until this week. Now when I print any invoice (no matter how old) the print out has…
  • Inquiry Sorting

    Why can't I sort data in inquiries? Will this functionality ever be added to Sage 300 CRE?
  • Customize permissions on inquiry screens

    Hi, I need to create a new screen code a assign to specific user. This is because the user does not have to see certain specific fields. I tryinng to use access code but alway watch the STD screen.
  • Inquiry - Excel Export Error

    Hi, Run a Dimension Inquiry, and select the Excel Export to export the data, system alerts the error message, Error Message, @X3.TRT/SUBAEXP1$adx(554) Error 31 No more memory available adg_realloc3 failed to free memory - diff:27018000 free:480204…
  • Inquiry Design Help Needed

    I'm trying to create / modify a GL Account inquiry to add an additional drill down layer. Initial Level: GL Accounts 2nd Level : GL Transaction based on the GL Account selected in the 1st level 3nd Level: GL Transaction of the batch selected in…
  • Sage 300 Web Screen Inquiry

    Hi, In older version I remember there is a possibility for us to custom and add more inquiry into the web screen. Now in 2019 is this features is still available? That we can add more data to be part of the standard Inquiry which is available. If yes…
  • Tables Being Used in A screen Stock Location Inquiry

    On of the inquiries under stock is "Location. How can I add the price to this inquiry. Also, if I can setup a query without altering the screen that would be ideal as well..
  • Inquiry Screen Product Pricing Stock

    Is it possible to get the product prices to show up on this screen. Or does anyone have an SQL Query setup that would do the trick?
  • Customer BP invoices Report

    How can I pull a report that will show the customer BP invoice. We have the sales invoice by lines report. But we want to connect information from the Customer BP Invoice. We want all the information under this: The inquiry does not output the…
  • Adding Delivery Address Option to Inquiry Screen

    I am working on a project to modify the sales order line inquiry to include the option of selecting an address to search on. I understand that I need to do some code modifications to get the filtering to work correctly but I haven't gotten that far yet…
  • How to add a inquiry under the printer icon

    How do I add an inquiry to the list that is under the printer icon is most functions. I want my user to be able to print a specific report while they are looking at the shipment screen.
  • Inquiry Screen

    How can I edit the opttion on the delivery inquiry screen to show lot numbers?
  • How to add left list in Enquiry window and populate data in it?

    Hello All, For one of my project. I want to add the left list in my Enquiry window. I already attached object to browser tab of window but it only shows the empty left list. My main problem is to populate the data in this left list. I also tried…
  • PU9 - Bring back * search or give us the option to always filter on "contains"

    We have recently upgraded a few clients to PU9 and all of them are unhappy about the wildcard(*) search functionality that has been removed and replaced by the default "starts with" filter on the left list. Please give us the ability to default the left…
  • Being able to choose Inquiry screens as Inquiry Entry Transactions before entering an Inquiry!

    Hi Community, Currently we can setup different Inquiry screens to show/hide the number of columns and lines thanks to the function "Inquiry Screen" in setup module which later will be helpful for Exporting to excel based on different columns. The issue…
  • Show monthly balance in Account inquiry

    In the Account inquiry (CONSCPT) the tab "Balances" shows the balances of the selected account. It also shows a monthly balance, but accumulated over the months (February is not only February but January + February and so on). It would be helpful to…
  • Attachments not found

    I'm having an issue where one of our Mas users is simply unable to load up any invoices from the Invoice History Memo Inquiry. I didn't find a permissions issue for the Sagesoftware folder. I also had the user try a different computer to see if the problem…
  • Refunding a customer

    Hello, I have a customer who was issued a credit memo for product they were unhappy with. They are now requesting a check instead of having an open credit with us. The product has been returned to inventory and the proper G/L accounts were expensed…
  • Inquiry -> Print to File -> Excel....Missing rows

    Hi, I've been having an issue with Sage while trying to export inquiries and reports to excel. It has happened with both a custom generated report, and with inquiries. When I generate the inquiry, and look at the print preview, everything is there…
  • More than 36 Bank Codes needed

    Does anyone have any suggestions on what to do with greater than 50 separate bank accounts. We use MAS90/ERP100, I am aware of the use of special characters, even though they are unsupported, but we have exceeded all of that. Is anyone aware of…
  • Other Committed field

    I'm using MAS 200. When in inventory maintenance (or inquiry), there is a column under the Cost Detal section called "Other Committed". Can anyone tell me what this field represents?
  • What is Sage MyAssistant and why is it important?

    What is Sage MyAssistant and why is it important? MyAssistant is a proactive reporting tool that is integrated with Sage 300 CRE (Timberline Office). Its main purpose is to actively search the database for specific circumstances based on your custom…