• Supplier cannot be edited on Purchase Order

    Hi, I'm trying to update the purchase order to change the supplier, but it won't let me. Am using Sage x3 Version 12.
  • Purchase receipt document missing

    Hi everyone, I have encountered an error where the purchase receipt document is missing but the Stock transactions have recorded the product line in the purchase receipt. I found this problem when creating a new purchase receipt and the 'Record already…
  • Issue accessing old sage kb entries for na

    Prompted by a thread: Database Move When I am looking at old threads in Sage City (now Sage Community Hub) in an attempt to resolve a problem faced by my client which were asked before, the thread comment may ask to check the NA KB referring to code…
  • How do I create a single dedicated syracuse node dedicated for batch server?

    Hi, Reference on: RE: 69 sessions of Type Batch in Session Management and Batch Server in Starting state with no Diagnosis results On-premise Sage X3 installation. CPU upgrade is impossible to be an approved request without a proven Sage reference…
  • I am not able to delete the pick ticket.

    I have created a delivery and validated it. Then, I went to 'Modification of Issue' and changed 'TO SHIP' to 0. After deleting the delivery, I am not able to delete the pick ticket.
  • Calculator SIGMA(GTEST=0,1,0) : Non-authorized Expression Even login as ADMIN

    Hi, What code be the reason cannot perform Calculator expression : SIGMA(GTEST=0,1,0) Error message is Non-authorized expression. How to authorized it? Thanks, Jacky
  • Period closing problem

    hello guys i have a problem with period closing we changed the currency to 4 decimals to add 0,0004 so i can match correctly after that we try to close the period and i get this error in trace here is what i changed in currency i tried…
  • Legislation impossible to delete

    Hi all, Pardon my lack of knowledge on legislation implementation as legislation issue found was an uncommon occurrence. [1] I have a scenario where I need to delete a legislation after a folder validation following an implementation disagreement…
  • re-open work order

    is it possible to reopen a closed work order? we entered incorrect values and closed accidentally.
  • Balance unbalance due to rounding value

    Hello everyone, I encountered a balance unbalance error while running the CLOPER report. Upon investigation into the database and journal entries, I discovered that the rounding value was incorrectly allocated to the debit side instead of the credit…
  • Creating Multiple Invoices for Combined PO Shipments

    I can combine multiple POs into one shipment. However, one shipment will result in one invoice. I need to find out a way to create multiple invoices for each of their POs.
  • Multiple Purchase Requests (PR) in single Purchase Order

    How to create a Purchase order(PO) by consolidating Multiple Purchase Requests (PR) in Sage X3??? Example PR1, PR2, PR3 -----> PO1 PO1 will be created by consolidating PR1, PR2, PR3
  • FUNBENCHR - What is the best way to return an item consumed 3 levels under the current Work Order?

    Hi everybody! I Have in the most of the cases, semi-finished goods inside other semi-finished goods and then the finish good. Imagine a scenario that i have this kind of BOM: Product A : Finished good 1 x Product B : Semi finished good 1…
  • InterCompany Price By Site

    I have two companies, say QFL & PBL. The QFB sites in Company QFL needs to sell to the PCB site in Company PBL, using a specific price list. The following setup has been tried but does not work. However when I try to enter an intracompany…
  • Year Closing

    Hello, I'm trying to close 2014, when I run the function of fiscal year closing in simulation the log doesn't shows any mistake, but when I untick the simulation box (real mode) the log shows 1 error: Document Unbalanced in currency of the ledger…
  • AP sub-ledger balance not tie to the control account balance total.

    Hi everyone, I'm encountering an issue with exchange rates in Sage X3. Problem Overview: In the account balance inquiry, the amount is $1411.15. In the AP sub-ledger balance, the amount is $1403.26. The difference is $7.89. …
  • Duplicated stock journal

    Hello everyone, I've noticed that two stock journals, Journal 1 and Journal 2, have been generated with identical details: Goods delivered : 9265.30 (Credit Side) Cost of Sales - Goods & Services: 9265.30 (Debit Side) Upon reviewing the stock…
  • Re-invoice a Sales Delivery after a credit note

    Basic scenario: Create Sales Order 1 line quantity 10, price 50; Create Sales Delivery 1 line quantity 10, price 50; Create Sales Invoice 1 line quantity 10, price 45, made a mistake; Sales Delivery is now fully invoiced, but price is wrong;…
  • STOJOU.PITVALFLG not update to 2 after stock accounting

    Hi, It may happen since p33 (23R1), and, after launching the stock accounting, several of stojou records keep the field PITVALFLG to 0 instead of 2. This field is important for Stock valuation report by accounting date since the stojou records are…
  • How to calculate available qty before trying inter-site transfer.

    I need to prevent errors due not existent or insufficient stock when doing inter-site transfers, I have tried calling the standard x3 procedure STODISPO from library STKLIB. The error happen when passing the parameters. I've found only information…
  • Year-end Entries in non calendar year period

    First, I am sure this question is out there somewhere, but could you please tell me how to post year-end jnl entries to a different period. We are a calendar year company and would like to post year-end entries into a seperate period vs. normal 1-12.…
  • MRP is not writing into ORDERS table in some items, saying that for that suggestion - Record already exists

    After executing the FUNBCN for MRP, it gives me this error for 2 items: <0001 Table : ORDERS [ORD] <0001 Key : 6 SUG103240000669629 ITM000021322 <0001 Record already exists I looked into ORDERS table and there is nothing created with that number.…
  • Sage X3 - Creating Debit Notes against specific GL accounts

    Hi All! We're using Sage X3 in the US but I think this question would apply across all continents! We have been trying to build out a process for Chargebacks where Debit Notes are created that post against the AR account. Here's the scenario we have…
  • Batch Server running but not processing new tasks.

    Hi, Lately, some of our X3 servers are having problems with the batch server. It's running normally until it stops processing tasks, while maintaining the status as running. I've enabled the logs under Administration, Settings, Global Settings for…
  • Unable to verify my address when setting up my Sage Customer Portal

    When I am trying to create my Sage account through customer portal - it will not allow me to go further than my address - as it keeps saying unable to verify my address. How do I fix this? I am putting in the correct address. It just keeps saying the…