Browse By Tags

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…

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?

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…

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…

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…

Hey All, Just received our upgrade from Mas90 4.3 to Sage 100 2019 a couple of weeks ago! Woohoo. One thing I'm trying to sort out is how to eradicate Phantom Users. I'll explain: We are having trouble fixing some valuations in Sales Order Entry…

Hi, Our current business process has us creating BTB work orders during Sales Order creation. Sometimes, the material produced from the resulting BTB work order is needed to fullfill a different, more urgent sales order. We were originally consulted…

When invoicing RMA's, we use logic in a custom script to set the cost account key and the sales account key on the line items based on based on the customer division. When I go to the newly created invoice, the sales account key has the correct value…

I'm hoping someone will have experienced something similar. Today our Sales Dept. reported that the columns in the Lines tab for Sales Order Management had suddenly changed. As you can see below there are now EDI PO Line, EDI L UDF1, & EDI L UDF 2 being…

Is there any ways to enable Sage 100 auto send email notification to a certain group of recipients upon SO is entered / invoiced? I assume this has to involve scripting, right? Thanks, Haibo

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…

'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…

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…

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,…

We're running Update 9 Patch 10. We have an EDI project that calls for a (Sales) Order Confirmation; Scenario; - Customer sends Purchase Order - We create Sales Order and reference PO. - We need to be able to confirm or reject the PO from…

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…

What is the fundamental logic difference MAS uses when entering line items to sales order that exceed available quantity? To be clear, suppose you're entering a sales order line item that has an available quantity of 5. If you enter quantity 6, you…

Hi Everybody. I try to active workflow signature to Sales order. I receive email with 2 links and the standard text of if I like Accept or Reject Sales order. When I click the link of Accept or Reject, system redirect to web who say : Your validation…

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?

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…

Hi Is it possible to prevent duplicate lines on a sales order? (duplication on Product (ITMREF)). Can you use control tables for this, and if yes how? I am looking forward to your response.

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

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…

I'm looking for ideas as to the best way to consume packaging in work orders. We sell products in various packaging....totes, drums, pails, etc. Currently the packaging is relieved from inventory at time of sales invoicing.....packaging codes are…

Is it possible to limit a business partner to a company ? E.g. allow issuing an invoice for company #1, but block it for company #2.