Sage City Community
Sage City Community
  • Groups
    • Africa & Middle East
    • Australia
    • Canada
    • France
    • Ireland
    • Portugal
    • Spain
    • United Kingdom
    • United States
    • Global Solutions
  • Blogs
  • Town Hall
  • Cancel
  • User
  • Site
  • Search
  • User

Sage X3
  • United States
  • More
Sage X3

Sage X3 Support

  • Forums
  • Blog
  • Videos
  • Ideas
  • Global Hub
  • Sub-Groups
  • Members
  • Resources
  • More
  • Cancel
x This group requires membership for participation - click to join
  • Subscribe by email
  • More
  • Cancel
  • Tags
  • Subscribe by email
  • More
  • Cancel
  • What would a Costing Component Type on a Production BOM do?

    What would a Costing Component Type on a Production BOM do?

    VanessaQ
    VanessaQ

    A production Bill of Materials (BOM) has four different component types:

    Normal: This can be a raw material or simi-finished goods that go into the production process to make the final product, and it is part of the BOM.

    By-product: unplanned or a secondary product that is not needed to produce the finished product. 

    Text: This allows the adding of a text to be displayed on the work order without having to enter a product…

    • 18 May 2022
  • Replacing Apache with the X3 Native Platform Protocol (SADSFQ)

    Replacing Apache with the X3 Native Platform Protocol (SADSFQ)

    Darius Arnold
    Darius Arnold

    Today X3 Family, we will be discussing a new platform component change regarding Apache. The Apache web server is no longer needed as of Sage X3 2022 R2 (12.0.30). 

    The Apache web server was used in earlier releases of Sage X3 to transfer static files from the Sage X3 application server to the Web server (Syracuse). Sage has replaced the Apache component with a native application service that transfers application elements…

    • 18 May 2022
  • How to clear temp tables on a schedule rotation?

    How to clear temp tables on a schedule rotation?

    chris hann
    chris hann

    Evening readers,

    This blog is going to be a slight continuation of my previous one, which was about the purge function (you can read HERE). We’re going to look into how you can schedule temp tables, like ALISTER, to be cleared periodically, via recurring task. How Purge is involved is we utilize that via batch to clear out the ALISTER table. So, utilizing a function via batch process is pretty common practice and people…

    • 17 May 2022
  • Wonder why Direct sales invoices have $0.00 Cost price?

    Wonder why Direct sales invoices have $0.00 Cost price?

    pnightingale
    pnightingale

    Have you ever done a Direct Sales Invoice (GESSIH) under Sales, Invoices and noticed that the Cost price was equal to $0.00?

    If you turn around and create a sales order, delivery, and a regular sales invoice, you have a Cost price value. What is the difference? You’ve used the same product, customer and quantity. Your Totals Excluding tax and Including tax are the same. This is the type of question that drives…

    • 30 Apr 2022
  • Understanding the Purge Functionality in Sage X3 (INFORMATIONAL)

    Understanding the Purge Functionality in Sage X3 (INFORMATIONAL)

    chris hann
    chris hann

    Evening Readers,

    I have another topic “by request” for you all to read about. We are going to look into how the Purge utility functionality works. This came along because there is a series of temporary tables in Sage X3 and a colleague of mine wanted to know how to clear them, specifically a safe way to do so. Sage X3 has a purge function just for this type of request. We are going to take a look at purging and how you…

    • 27 Apr 2022
  • Best practices to manage currency rounding and matching issues?

    Best practices to manage currency rounding and matching issues?

    Joel Singam
    Joel Singam

    Companies that transact in multi-currencies do come across instances where their aged account balances do not match with the aged reports. For example, accounts inquiry account balance for an accounts receivable account does not match with the aged balance (BALAGEGRP) report.

    In this blog we will look at the best practices to enable a perfect matching.

    Prerequisites:

        a. In Setup, General parameters, SUP chapter, FM…

    • 27 Apr 2022
  • MongoDB 4.0 End of Life!

    MongoDB 4.0 End of Life!

    Darius Arnold
    Darius Arnold

    Hello X3 Family! This post is in relation to a 3rd party component that Sage X3 utilizes, MongoDB.

    MongoDB is an open-source general-purpose document database built on a horizontal scale-out architecture that uses a flexible schema for storing data. Instead of storing data in tables of rows or columns like SQL databases, each record in a MongoDB database is a document described in BSON, a binary representation of the…

    • 25 Apr 2022
  • How to setup and calculate landed cost for an Intersite transfer with an average cost product?

    How to setup and calculate landed cost for an Intersite transfer with an average cost product?

    VanessaQ
    VanessaQ

    When processing an Intersite transfer, it is possible to calculate the landed cost even if the value of the product is an average cost. In order to do the calculation, a price list for the Intersite must exist first. To create a price list for an Intersite with an average cost product, in Setup, Purchasing, Price list, create a new price list with Suppliers set to Group, tables Criteria are ITMMASTER and BPARTNER. In…

    • 7 Apr 2022
  • What's Happening with the Avalara (Sage Sales Tax) TLS Deprecation?

    What's Happening with the Avalara (Sage Sales Tax) TLS Deprecation?

    Darius Arnold
    Darius Arnold

    Hello X3 Family! Today, will be an informational session about the status of Avalara's TLS 1.0 and 1.1 Deprecation and how this affects Sage X3.

    If you're unfamiliar with the TLS (Transport Layer Security) protocol, this short YouTube - TLS Basics video provides a brief introduction. 

    I understand that the information presented may be confusing and I hope to provide clarity today about what we expect to occur as…

    • 30 Mar 2022
  • How to set the allocation type on a pick ticket to “Global”?

    How to set the allocation type on a pick ticket to “Global”?

    Joel Singam
    Joel Singam

    A sales order allocation type can be set to 'Global' or 'Detailed'.

    Depending on the general parameter "ALLTYP" we can default the allocation type to either ‘Global’ or ‘Detailed’.

    For this discussion we will set this parameter to ‘Global’, create a sales order, generate a pick ticket with global allocation and finally pick it using the mobile automation (ADC…

    • 15 Mar 2022
  • Where can I find current instructions for setting up…

    Where can I find current instructions for setting up…

    pnightingale
    pnightingale

    During a recent conversation with a colleague, I was asked where to find a current copy of instructions for setting up Sage Sales Tax. She had a set dated 2017 and thought there had to be something more current that she could send out to a partner. She had scoured her hard drive. She couldn’t remember if she ever had a more recent one.

    It’s not the first time, I’ve come across people with old copies of setup instructions…

    • 9 Mar 2022
  • What happen when you run the WIP accounting interface FUNWIPACC?

    What happen when you run the WIP accounting interface FUNWIPACC?

    VanessaQ
    VanessaQ

    When a work order is created then sent to production for processing and completion, the system creates several records in the WIPCOST (WIP value) table with different TXNTYP information. The WIPCOST table is the source table for all WIP posting that will update to the general ledger.

    The TXNTYP fields which identify the origin of the cost are the main criteria driving the accounting posting. The common TXNTYP in the WIPCOST…

    • 3 Mar 2022
  • How does the system calculate the number of fixed assets allowed?

    How does the system calculate the number of fixed assets allowed?

    Joel Singam
    Joel Singam

    Often you might have come across an error when accessing any Fixed assets function… “The number of fixed assets allowed by your license has been exceeded, extension of this license is to allow the use of the software, please contact your supplier”.

    This message indicates that you have more managed assets than what is granted by the license.

    To verify if we have exceeded the number of assets granted…

    • 28 Feb 2022
  • Exploring our Sage Developer Site

    Exploring our Sage Developer Site

    chris hann
    chris hann

    Hello Readers,

    Today we are going to be exploring our Sage Developer site. Lately I have been getting inquires on APIs and REST information. I figured it was a good time to write a short blog on our developer site where you can find all sorts of information on APIs, REST, GraphQL and more. Originally, in the beginning, the developer site mainly helped developers with XML/JSON calls for our Web server component. It shows…

    • 25 Feb 2022
  • Creating an SDA Dashboard in X3!

    Creating an SDA Dashboard in X3!

    Darius Arnold
    Darius Arnold

    Hello X3 Family! Today, we'll discuss how to integrate or embed SDA (Sage Data and Analytics) dashboards and analytics into X3. SDA combines data sources and allows reporting from multiple internal and/or external sources within one system and interface. More information can be found here: Sage Marketplace - Sage Data & Analytics .

    This blog will not cover how to configure SDA. If more information is needed regarding…

    • 24 Feb 2022
  • Exploring auto journals: the “V_” formula

    Exploring auto journals: the “V_” formula

    pnightingale
    pnightingale

    Time to go on another adventure exploring the automatic journals. A few months ago our travels brought us to Exploring auto journals: the descriptions.  Today our adventure leads us to the auto journals and the “V_” formula. Before I proceed, as I mentioned in the previous blog, it is better to do our exploring in the test environment. It is too easy to accidentally click Save and alter our auto journal.

    Our…

    • 22 Feb 2022
  • What parameters influence the costing of a work order?

    What parameters influence the costing of a work order?

    VanessaQ
    VanessaQ

    When the work order is created, the provisional production cost calculation can be done automatically if the general parameter Auto provisional costs CLCWOCAUT (GPA Manufacturing, COS) is set to “In WO creation and modification”. The other two options are “No” which means the WO Provisional cost calculation needs to be manually executed upon the creation of the work order by clicking on the WO provisional…

    • 3 Feb 2022
  • How to create a Web service specific user profile.

    How to create a Web service specific user profile.

    chris hann
    chris hann

    Evening Readers,

    This Blog post is somewhat of a continuation for my previous one about web server testing. This blog will cover how to create a web specific user that doesn’t use a badge. You can do this at any time in the process. A web user is not required to complete the previous blog, but if you have a high volume and high user count, this might help out. Before we start, make sure you have an X3 user that is part…

    • 25 Jan 2022
  • Why am I getting this message “Valuation price null not authorized”!

    Why am I getting this message “Valuation price null not authorized”!

    VanessaQ
    VanessaQ

    When processing a miscellaneous receipt or receiving a purchase order, sometimes this message is encountered when the create or saved button is clicked:

    “Valuation price null not authorized!” and the message will prevent the user from creating or saving the receipt.

    What is causing the message to happen and why the receipt cannot be created or saved till this message is addressed?

    This message will happen…

    • 25 Jan 2022
  • How to setup and test the Syracuse integrated web services on Version 12

    How to setup and test the Syracuse integrated web services on Version 12

    chris hann
    chris hann

    Evening readers,

    Today’s blog will be about how to setup and test the web services in V12. There are several ways to test (like SOAPUI and POSTMAN) but one way to setup. We will cover the most basic way to setup and test to get it up and running for something like a test environment or just for messing around.

    Before you start you will need access to the Administration module. So, that means you will need a login…

    • 25 Jan 2022
  • Stock movements, the Data Models and the STOTRACE parameter

    Stock movements, the Data Models and the STOTRACE parameter

    pnightingale
    pnightingale

    Have you ever wondered what tables and/or fields are populated by a stock movement? Do you need this information to create a query or a report? Are the auditors asking? Where can you get this data? We'll take a  look at the Online help Center’s Data models and the STOTRACE User parameter and see what data each option provides.

     

    One area to check out is for data flow information is the Data models section in the…

    • 22 Jan 2022
  • How to Manually Recreate the V12 Accounting Task

    How to Manually Recreate the V12 Accounting Task

    Darius Arnold
    Darius Arnold

    Today, I'll be demonstrating and discussing a troubleshooting step that some may be unaware of regarding the accounting task. What's this mysterious and obscure troubleshooting technique....so you say? Disclaimer, I would not consider this troubleshooting step as my first option when troubleshooting the V12 accounting task. However, I do consider this technique to be a useful tool in my tool bag, that I would like to…

    • 20 Jan 2022
  • How to track an operation using VXAPT?

    How to track an operation using VXAPT?

    Joel Singam
    Joel Singam

    Function VXAPT (Production reporting) is designed to create production reports and material consumption documents according to the selections made on the entry transaction.

    It can also be used to launch an automatic label printing. It is also designed to work with the RF terminals (handheld devices).

    When we can track only the finished goods and the materials, how to track the operations? Good question!

    To track the operations…

    • 18 Jan 2022
  • How to process a value change for a FIFO valued item?

    How to process a value change for a FIFO valued item?

    Joel Singam
    Joel Singam

    For an item that is valued at FIFO (First in First out), we can use the value change function to modify the FIFO basis lines.

    This will generate a stock movement record in STOJOU with a TRSTYP of 23.

    Lately there have been some changes in this area and the recommendation is to modify each FIFO layer at a time.

    For example, let’s take an item whose valuation method is FIFO.

    • Go to value change function under Sto…
    • 23 Dec 2021
  • It's 2021 1099 time!

    It's 2021 1099 time!

    pnightingale
    pnightingale

    Hi All!

    It’s time once again to start preparing for 1099 filings!

    What’s a 1099 form?

    Some of you may not be familiar with 1099s. For those, a 1099 form is used to report various types of wages, salaries and tips that aren’t reported on W-2s to the IRS. They are prepared by 3rd parties such as employers, banks, etc. The forms are sent to individuals to assist them in preparing their tax returns.

    The…

    • 21 Dec 2021
>
  • facebook
  • instagram
  • linkedin
  • twitter
  • youtube
  • Sage logo
  • © Sage Group plc 2022
  • Privacy and cookies
  • Community guidelines
  • General data protection regulation