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
  • 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?
  • 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…
  • Enable/Disable modification of an entry

    Normally, whenever you want to create any entry in sage X3, there are two ways, 1. either by clicking the "New Button" 2. "Modifying the existing entry", just need to remove the entry number, press TAB, and all of the attributes of the existing entry…
  • Product Description disappeared

    In Sage X3, PU9, Common data Module>Products>Products(GESITM) whenever I create a new product or modify the existing product, the data in description 2 and description 3 disappeared. ironically, the previous data in the same field for certain products…
  • 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…
  • Recurring Tasks - Month End

    Does it send out at the beginning of the last day of the month, or the end of day ? How do I get it so that X3 sends me an accounting report at the end of the day, of the last day of the month?
  • 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…
  • 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…
  • BPCUSTMVT Field differences

    What is the difference between: ORDBPCATIC ORDBPCATIL ORDBPCATIR In the technical help, the descriptions are all the same.
  • 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…
  • Fixed assets error : "Operation impossible. The ""fiscal & accounting"" context of the company must have been defined beforehand"

    Operation impossible. The ""fiscal & accounting"" context of the company must have been defined beforehand
  • Packaging Consumption in Work Orders

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