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…
  • 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
  • 1099s

    How to change the year in AP Settings?
  • Mileage

    Hello, We are going to start paying someone mileage weekly in their checks. If I want that money from reimbursements to go to a savings account, can I set that up? Mileage total WE 10-08-23 = $100. On employee's check, I want that $100 to go…
  • 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…
  • Written Down Value method configuration

    Hello, Can anyone guide me to configure the WDV depreciation method in Sage X3 V12?
  • GL Activity

    GL Activity - Items are not hitting GL for the bank account, AP, AR until bank reconciliation is completed. Is this a setting? Thank you in advance for all answers!
  • 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…
  • 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…
  • Subcontractor and Tier 2 Diversity Spend

    We are getting more requirements from our Owners to formally report our Tier 1 and Tier 2 Diversity spend. We have all of our subcontractors set up in Procore with their diversity status but it looks like getting the spend report out of there is not going…
  • 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…
  • 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…
  • Tax Exempt Jobs

    Need to find a way to track sales tax charged on invoices for tax exempt jobs. Is there a way to setup a job as tax exempt in Contracts? Sorry, but I'm new to Sage and without a lot of direction....
  • 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…
  • Changing the FIFO dates in X3. Manually.

    Currently when product is received into X3 to any location it is tagged with a receipt date. This is the date that travels with the product and drives the FIFO order for each product. Is there a way to manually FIFO inventory to give more versatility…
  • 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,…
  • 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…
  • Payment Voucher Print

    Hi All, I am facing this issue very often as I was unable to click 'Record' to print Payment voucher for one of the payment entry type and sometimes, with few transactions under this payment type as well. I am using V11 of Sage X3. I tried to set…
  • SM WO Notes - "Customer Viewable" Checkbox

    FormerMember
    FormerMember
    Is it possible to have the "Customer Viewable" Checkbox unchecked as a default?
  • Business partner settings

    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.
  • Making the Phase field in AR Invoice Distributions functioning

    I am trying to figure out how to make the Phase field in AR for Invoice Distributions functioning since clearly when setup originally that was not completed. I understand that this has to be done in GL > File > Company Settings > Custom Descriptions…