Browse By Tags

  • Expanded Customer Number

    We have a client that has one company that would like to use the Expanded Customer Number, but they have another company that doesn't need the Expanded Customer Number. They set up the first company with the box checked. Now they are trying to set up…
  • Antivirus Exclusion for Sage

    I have got a server where I would like to install antivirus. I have got sage X3 installed on the server. Can someone please provide me any advice on how should I move forward with this? Are there any important files/folder that I need to exclude…
  • Positive Pay Bank File Definition - Separate Detail Lines per Column

    Customer's bank wants the Excel file generated with the check details to have each required field in a separate column. Does anyone know how to specify this within the Bank File Definition?
  • Dimension Codes Not Flowing From Supplier Record to Supplier Invoice

    Common Data >> Bps >> Supplier, Financial Tab, Analytical Dimensions Currently only codes listed in AX1 flow through to the supplier invoice (Supplier BP invoices). How do I change the other dimensions to flow through to the supplier invoice as…
  • Sage 100 Application Server Startup

    Within the application server startup, what method or argument can be used to have Sage 100 application server "Start" when it launches.
  • Production Scheduler Sage X3

    Hello, We have been using the Sage X3 with production scheduler and production scheduler is the most important tool for our operations and work order planning. Sage X3 version : Enterprise Management V 12.0.19 Production Scheduler : 6.0.2014…
  • VI for Transaction Entry

    Hello, I setup a VI import Job for Transaction Journal Entry and it was working fine until recently. It is taking the offset account number and using it for the line account number as well. I am telling it to get the number from column, but it ignores…
  • Delivery Notes Report - default values

    Where do you assign the defaults for a report? Specifically, when I print the BONLIV report I want it to default the customer value from the record so that I don't have to change the parameter lines each time. Where do you make these kinds of default…
  • How to change default tax class on ci_item?

    Hello, We are making some changes regarding taxes at our company and are wanting to change the default tax class when adding new items. Currently, when a new item is added it is assigned 'NT' (non taxable) tax class, and we want it to default to …
  • Restricting system date in January...Sage allows me to use December 2021 date in January 2021

    Hello Even though our settings say to " Restrict Accounting date to current and one future Period," I am able to set our system-wide date to 12/31/21 in January of 2021. I am able to enter and update invoices in that future date. I do NOT want to be…
  • Sage Alerts HTML email color coded table

    I am writing an html email alert for Sage Alerts and Workflow v9.0 for Sage 100 and I have a table in the email alert and I want the table to be shaded for every other row. I'm using the nth-child(even) method and I can't get it to work. If someone has…
  • VI Bat File Error

    Attempting to create my first bat file to run a VI job outside of Sage 2018 Advanced 6.00.5.0, getting a Connection Time Out error. Can anyone tell me where I went wrong? I followed the steps carefully to create the new app in the Sage Application Server…
  • Creation of New Folder creation from user screen, unable to get full access?

    Hi All, I created a new folder from the front by using authorized Admin role access. But am not able to get full access rights to the newly created folder. it giving me an error while accessing the folder. needed suggestions on how to get full access…
  • Inventory Issues

    Hello, my company currently uses inventory management to track in house supplies. We are a medical facility, that has 70+ departments. We do not sell the inventory outside of the company, however as departments need supplies we do an "Inventory Issue…
  • Nice if 'PAC complete' could be on a line by line rule basis - believe would be much more versatile allocation and issue setup

    'Pac complete' as an overall function does not allow smaller units to break into larger units when needed for picking. Those smaller units need to be made manually available (or already available). Our orders need to be shipped in cases and pallets. Pallets…
  • Using/Understanding FIFO

    It seems that X3 defaults to some form of FIFO. Is there any documentation that goes into detail how to control this feature? A specific example of what we are trying to do that relates to full pallet product pulling. We have X3 set up to pull full…
  • How to add an access code to attach a file to a specific function?

    Good Afternoon, Initially, I created a storage volume on X3 and defined an access code for this volume, so that when a file was attached to that function, it automatically selected for the folder corresponding to the function. The result I got was,…
  • Is there a way to view invoices in Customer Inquiry for the Sold To Customer when National Accounts is Enabled?

    Is there a way to view invoices in Customer Inquiry for the Sold To Customer when National Accounts is Enabled? Currently, I can only view the invoices in the Bill To Customer. When someone is inquiring on an Invoice on a Sold To Customer there does…
  • SO Invoice Entry - Default qty ordered and shipped to 1

    I want to have all SO Invoice lines default to an order quantity of 1 and a ship quantity of 1 (currently the default is zero). This is Sage 100 2019. I wrote the following script and attached it as a post-validation event to the Item Code column, but…
  • Setup of Purchasing Signature Management

    Is it possible to setup Purchasing Signature Management in a way that when a user that is part of the signature workflow enters a PO, it is not automatically signed, but is pushed to the next level of signers for approval?
  • Windows authentication - Invalid windows user

    Client migrating to new server, Winsows 2019 with Sage 300 2020. Existing server is Windows server 2008, running Sage 300 2016. On the old existing server, Sage uses Windows authentication for many users. On the new server, when I try to change the…
  • Script to run Rebuild Sort files

    Is there a way to run the "Rebuild Sort Files" utility from a command line or through some sort of BOI script?
  • Update Order Class Picklsit under Purchase Order

    Hello, i am now the default the admin for Sage for my company (I am a Salesforce Analyst by Profession), and I am just learning Sage Admin as issues or requests come up. I am not sure if this is the right group to ask, but overall in Sage if I want to…
  • I am trying to create Fixed asset, following error occurred

    I am trying to create Fixed asset, following error occurred. help required. Fixed Assets>Fixed Assets> in the field Accounting code>ITEQP ITEQP The Co. fixed asset account associated with the accounting code is invalid or its nature is incorrect
  • Can't Add New Product Codes in Item Maintenance

    When we enter a new item code into "Item Maintenance," it used to create a new product in the system. However now when we enter a new product code, everything goes blank, but it says "NEW" right by the Description (as it would do before). Everything else…