Browse By Tags

  • Unable to add 6th Company Database in Sage 300 2022 Advanced Edition Database Setup

    Hi friends, I have a strange issue at a site operating Sage 300 2022 Advanced with Product Update 7 installed. I am receiving the "Cannot create the database profile." error when attempting to add a 6th company database into Database Setup - irrespective…
  • Enabling Return for Items?

    We are testing items to return in RMA, but we are getting the notification that the item isn't setup for returns. Where can we enable this?
  • Row Level Permissions

    Hi, Can anyone advise how to increase a limit of row level permissions (Parameters --> Users --> Users --> Organisation) in user setup? It is set to 10 in my organisation and I need to be able to add more to some users. Thanks Ania
  • QR Barcodes Length

    Hello, Our manufacturer recently changed our old barcodes to the QR barcodes, however, when we are trying to scan the products into SAGE 100 it is not taking the full serial number length. Is there a way I can update the serial length within SAGE…
  • Automate IRP - Inventory Requirements Planning

    Sage 2021.2 Advanced IRP 7.00.2.0 with PM and PO Generate based on Plan by-Inventory / Procurement type Purchase and Selection of Warehouse Code to single warehouse 13K inventory items company wide across 7 warehouses taking 8 hours to generate…
  • What is the purpose of the following: Substitution product "Field SBSITM / Screen ITS [ITS]" VS Alternate product "Field RPLITM / Screen ITM2 [ITM2]" in "Product"

    Hello All, Can someone explain the reason for these two fields listed in the subject in "Products" screen. I've read the basic break down's from "F1" help, but we are looking for more real world examples and purposes of these two fields. Could either…
  • Sales Price List By Customer Shipping Address

    Is there a way to set up price lists by the customer's city, zip, or state? Currently I only see the Ship To Address, which is the address code, and not necessarily helpful since this doesn't reference the customers' zip, city, nor state. I'd like to…
  • Creation of New Non-Financial Site that should only be warehouse and have no financial impact on existing company or sites.

    We need to create a warehouse site (Non-Financial Site), that should not have any link to the company's financials and inventory once the delivery is done. on the other hand, the site should only receive the items, and send the partial deliveries upon…
  • Item Code Setup

    In Item Code Maintenance where you set up the units of measure. What is "SALES" used for? Is it used for sales to an end user, or is it used for the recipes/bill of materials/costed bill sales?
  • Retaining history when changing item code

    Is there a way to change an item code or merge with a new item code while retaining the sales history from the original code?
  • Written Down Value method configuration

    Hello, Can anyone guide me to configure the WDV depreciation method in Sage X3 V12?
  • Setting up Auto-Fill for Inventory Items

    Hello, I was wondering if there is a way to have certain inventory account numbers auto-fill. For example, I have a subaccount cell for commercial or residential jobs on screen 12-2 (Inventory Allocation). The jobs are marked commercial or residential…
  • Deactivating tax authorities

    Hi everyone, I started using an AP automotation software by Beanworks which is tied to our Sage 300 system. When I view our tax authorities within the Beanworks environment, it shows some tax authorities as inactive but when I go to the tax authorities…
  • Sales Kits not exploding on order imports

    We are testing sales kits and placed an order originating from our e-commerce site. The first batch of orders failed because the explode kit items field was set to 'Never'. I thought this was my issue, but the kits still have not exploded after altering…
  • Global Allocation at Lot Level, Instead of Product Level

    Is it possible to configure Sage X3 to enable Global Allocation behavior but specified by Lot instead of Product? e.g. If global allocation worked as it should for our business, which is a fluid process production setup, we would globally allocate a product…
  • Locking Locations from being allocated to a production Workorder

    Is there a way to lock locations from being allocated to a production work order?
  • 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…
  • 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…
  • 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…
  • Subcontracting - but we do not receive the finished good back

    I'm wondering if any other customers have a process similar to this situation. We are sending materials to a subcontractor, where the subcontractor maintains a Kanban. We still own the materials, so we need to keep track how much is at the subcontractor…
  • Unit Cost in Stock Issues for Inventory

    When entering stock issues the unit cost always pulls the average cost and as a result we have to manually update the unit cost to our most recent stock receipt cost. Is there a way to have the unit cost when entering stock issues automatically pull the…
  • 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…
  • Delete Primary Alias in Inventory Maintenance

    Hi All - I am running MAS 200 v 4.30.0.21 and am trying to update Vendor Alias numbers in Inventory Maintenance. When I try to update it, it just creates a second alias. I can delete the one I just created, but not the Primary, the delete button is greyed…
  • 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…