• 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…
  • Stock bin location change

    Why do I get this when trying to change bin location for a product ? "Line number 1 : Incomplete Line: No entered stock transactions / Dock type location prohibited" Just trying to clean up the warehouse and get product in the right location so it is…
  • Intercompany Accounting - Sage X3 - Non Inventory Invoicing

    Hello! We are constantly receiving summary invoices for all our child companies and wanted to know if anyone had any suggestions on how to make intercompany invoicing more efficient within Sage X3? We are open to any suggestions! Example: We receive a…
  • 69 sessions of Type Batch in Session Management and Batch Server in Starting state with no Diagnosis results

    Hi, Sage X3: v12p31 Setup is on-premise multi-tier setup with each service having own VM instance. No Runtime Application Clustering or any clustering work has been done. I have received this unusual case today. On Session management, there…
  • Transaction post date

    I am having trouble making transactions or posting anything due to this error Can anyone help with this please. Thanks
  • How to Enter Batches in Sage X3

    How to Enter Batches in Sage X3?
  • Log badge consumption?

    We would like to proactively monitor our badge usage so we aren't blindsided with capped out concurrent sessions. We're a global organization, so our badges aren't really a 1-to-1 ratio for our user counts. By the time our west cost users are logging…
  • Bank Reconciliation add supplier name

    Within the screen BNR0 Bank reconciliation has these reference tables which is OTB GACCENTRY Accounting entries GACCENTRYD Accounting entry lines BANREC Bank Reconciliation Statement BANRECD …
  • Invoicing Elements: Processing Fee Calculation Order

    Hello, I am trying to calculate one invoicing element off of another and I seem to be running into a road block. I have tried using the "Calculation order" field, but this did not work. The next step would be using the "Action" and "Processing" fields…
  • Payment Receipt Bank Transfer Posting Error

    In menu ; All > A/P-A/R accounting > Payments > Bank Transfer Received. I receive an error in sage X3. It says "No currency exchange rate", but how do i input exchange rate in this menu ? But when posting for local currency this menu is working…
  • Application error in sage x3 customer return

    Hello dear, I'm trying to make a customer return in order to do the sales order again and the below error appeared. what is this error?
  • how to make journal on hold 0 (zero) in accounting task menu

    I have 4 items stalled on Journals on hold, and this number never comes to 0 even i have started accounting task or restart Sage Server. we are using Sage X3 version 9.0.2. Please help, how to make 0 in journal on hold in accounting task menu?
  • Problems in migrating to Sage 12 an existing Java web application for calling a web service

    Hi, I have some problems in migrating to Sage 12 an existing Java web application for calling a web service. Now I have a Java web application that properly calls a Sage web service and the source code is the following public class X3WS { ... StringBuffer…
  • There is negative value in balance of Open Item under Account Receivable

    What does it mean to have a negative value in the balance field? Thank you !!!
  • Purchasing Module- applying Discounts for early payment

    When entering the invoice in Purchasing against the PO I always change the dates and terms and apply the discount if paid early. However when posting to AP the discount does not carry over on the invoce and our AP person has to go and enter it manually…
  • Purchase Order creation not generating n Database

    Hi All When one users tries to create a Purchase Order, the document number is automatically created and displayed, but the button "Create" still active. The record has not been created in the database. When the screen is closed, the entry is…
  • Is there a way to get a PO-direct to customer to hit the COGS account instead of the RNI?

    I must be missing something, or forgetting something, because I am baffled that a Direct to Customer PO invoice would DR the RNI account when there is no receipt. In fact, the programming won't allow you to create a receipt. The account is defaulted…
  • Batch Validation for Versioned BOM

    What is the standard way of migrating new versioned BOMs? After migration, there is a need to do a BOM validation. Currently, we validate manually. Our customer has thousands of BOMs in the migration. Is there a simple way to batch validate these…
  • princ ERROR

    Several of us are getting PRINC errors when trying to post a RECMI payment and RECWT payment. Same error different customers and different dates. RECPT100000000064:Actual journal entry exists: Actual journal entry exists (PRINC) How do we resolve…
  • Change sales cost in existing sales transactions

    Hello, We have a system with last cost valuation. But for example, if we have a article with a erroneous cost , all the sales documents (orders, deliveries, invocices) have al erroneous cost and margin. We repair the cost (with a miscellaneous receipt…
  • Create Automatic Deliveries for Full Order

    I would like to use the Order Delivery Generation function to automatically create Deliveries, but the caveat is that I only want to create deliveries for orders where the entire order is fully allocated with no shortages. I have found settings on the…