Sage X3

Hi, For context, this folder is migrated from Sage X3 v11 to X3 v12p35. No, running backup procedure again after clearing the Accounting Task in X3 v11 is not possible due to time needed. However, I have the SQL Server copy of the X3 v11 Accounting…

A sales kit was entered on a delivery that was then validated. The sales kit was never shipped. Since the parent product is not stocked managed, SageX3 does not have the option for a stock modification. When trying to perform stock modification on the…

I'm undertaking a bit of a study of the production tracking approaches that can be employed that are without reference to a work order. I believe this approach is designed for process manufacturers that don't have a series of distinct jobs but rather…

Hi, We have noted that where transferring finished goods into stock and an error has been made, adjusting out the finished goods stock code it does not show that components are booked back into stock only that of the finished good. How can this be…

Hi, We have lots of historic orders where part of the order is showing as outstanding. I need to amend the order so that these are removed/adjusted to the only show items as fulfilled and so that I can complete orders. Many thanks

With the recent inclusion of the Preventative Maintenance module to X3 it seems to me that X3 is now ticketing all the boxes that organizations would want to see when purchasing a CMMS system. Based on my research prospects that are looking for a CMMS…

Hi everyone, I got an issue where I was unable to create B2B order in sales order screen as the option is grey out I have checked my product setup and It has the 'back-to-back order' ticked However, I am able to use the Back-to-Back order function…

Hi. If I have a purchase invoice being created in the AP/AR ledger, and the supplier is set up as 30 days payment terms from invoice date, then I am not getting what I expect to get on the calculated due date. ie if I put in an invoice date of 01/04/24…

Hello everyone, I'm using Sage-X3, with versioning and serial number management. We have a few special cases, but they happen regularly and that I must deal with. I don't see how to proceed. However, the approach is similar for these 3 points. …

I HAVE A CLIENT MIGRATING FROM ANOTHER SOFTWARE INTO SAGEX3, HOW CAN THE BALANCES BE BRINGING INTO THE X3

I compared my Stock valuation report with the Account balance (INVENTORY ) , and they don't match. How can I find the transactions that caused this discrepancy.

When I try to delete a BP (Supplier) , I encounter the error below. Upon investigation, I discovered a record in the BALANCE table. How can I find the screen related to the BALANCE table in Sage X3 or delete the records from Sage X3?

When you have a finished good item that is version controlled the system will allow you to input a sales order where the major and minor version of the item that the customer desires can be specified. If you have multiple versions of the item on hand…

In a cycle count session, I do a range of products. During entering the counts, I have a product that the system is showing zero inventory, but I find some inventory, how do I add that qty to my count? when I put in a qty it doesn't allow me to continue…

Hello, I need to create a zero "0" check in accounts payable to clear open credits and debits on a Supplier/Vendor. Can this be done?

Hi, Context: - Sage X3 v12p34. - Working with both US Dollar and Indonesian Rupiah and 1 USD = 15,888 IDR from Google as a reference. - The company is big so the client would like to know the currency max limit supported by Sage. When checking…

I have a client that would like to put a control on the Lot field in Receipts. They want more than just disabling the field in the entry transaction. They use BP Lot numbers and recently had a user assign an old Product Lot number to the receipt through…

I need to find the calculations or script for the 'Stock by product' function. Is there an SQL script for that, and how can I find it?

Hi All, I was trying to delete a record from sage x3 using SOAP web service but I cannot see any online example of deleting through SOAP. Can we delete a record using SOAP web service from sage x3 ? If yes, can anybody please provide me with an example…

Hi Sage X3 Folks! Can the 'Tax' be inputted/edited in the Customer BP invoice? I am not sure about this process. I already changed the input to enter, but still no luck. Any of you know this process?

When we are creating a credit memo for a return for a customer, we are receiving the following error message:

Is there a way to edit a posted invoice's sales rep?

I tried to run the GTEST to find out the reason that caused the error I'm curious about what caused the automatic journal to post so many lines and why no amount and lines are reflected on the credit side. Thanks in advance for your assistance…

We have a sales order that was closed by accident. Partly delivered, partially invoiced. Is it possible to reopen this somehow?

We have an invoice element and are entering a dollar amount when trying to create a proforma invoice. However, when we print, it does not appear. How can this be corrected?