• Restricted Characters for Imports and Exports

    Hi! I have searched multiple blogs and sites for this answer (along with the online help center) and can't find a clear document that states which characters are restricted in Imports/Exports per table. I've been told by Consultants that certain characters…
  • Deleting Sage X3 folder from database

    Dear Fellows, As you may all know that when you delete a folder in X3 it will not be deleted from database with all its references which will eventually increase your database size, and therefore i created an sql procedure that safely delete the folder…
  • Adding A New field

    I am looking to a add new field at the product Level. The field should have the option to hold options the user can pick from. Does anyone have steps on how I can do that.
  • Mass Update Product Pricing

    What would be the safest way to mass update the pricing for all the product in the system. On the product site- Under the cost tab I want to update Standard cost for all the products.
  • The quantity to be delivered is in shortage and negative stock is prohibited, or shortage quantities are not deliverable

    When trying to create a delivery for a sales order I got the following error: On the sales order, line item number one is has order quantity of 14784. On the stock by site inquiry; The product shows on sales order 14784 and available stock at…
  • Lot Number From Delivery Onto Invoice

    How can I have the lot number that appear on the delivery, also appear on the invoices. This will help the warehouse pick the product more accurately. Currently on the invoice screen, the LOT number columns shows up but the Lot Number information is not…
  • Mass Processing and Updating of periods

    Good day all. Is it possible to do a mass update of opening and closing periods using the mass processing or batch updates? I know that it can be used to do mass updates of standard fields, but when it comes to running validation rules I am not exactly…
  • Disaster Recovery

    Is there any documentation outlining what needs to be backed up for Disaster Recovery? SQL backups are done, but what happens if the server is lost? What steps can one follow to recover a system having only the SQL backups?