Hot topics
  • Sage X3 Support: How to dispose an asset?

    In this article I would like to discuss how to issue a main asset using unitary process (single asset).

    1.    Let me list out my general parameter settings;

    • ACCPERCTL Accounting period control (AAS chapter/ CPT group) = No

    Modification of the FY/period breakdown is authorized.

    • SALINV Sales invoice to generate (AAS/FAS) = Yes

    A customer BP invoice is automatically generated upon validation of the issue.

    • TYPINVFAS Fixed…
    • 17 Jan 2020
  • Sage X3 Support: Another Built-in SQL Server reporting tool

    In this blog I want to talk about another built-in report that is part of SQL Server.  A few blogs ago, i mentioned that Microsoft SQL Server contains some built-in reports that can help give information.  For example, the Server Dashboard report, you can see details such as how long the SQL Server has been up, or the SQL Server edition running. 

    There is another report called the SQL Server Performance Dashboard that can…

    • 15 Jan 2020
  • Sage X3 Support: Two Examples on How to Adjust the Sales Quantity on a Delivery using Modification of Issues

    We have all been there; the Sales Order has been entered, Sales Delivery has been created and then BAM! for whatever reason, sky is blue or tomorrow is Tuesday, the Quantity needs to be adjusted. Instead of crying, which is what I did the first time this happened but maybe that was because I didn't have enough coffee, the steps below can help turn a frantic thought into a  "I've got this!" positive attitude.…

    • 14 Jan 2020
  • Sage X3 Support: What is a Product usage and where to find it?

    A Product usage functionality is used to display a historical usage of a product in a rolling 36 months view. The amounts are the total product consumption each month including sales, miscellaneous issues and inter-site transfers.

    An access to the product usage can be found on a Purchase order Line in the Ordered qty field.

    Also, Enterprise planning, Purchase planning and Grouping workbench can launch Product usage from…

    • 13 Jan 2020
  • Sage X3 Support: Procrastinator's Emergency Guide to Year End

    So fellow procrastinators, year-end is upon us. What do we need to keep X3 functioning while we review all the steps to closing the year which we've been putting aside for months? Here are a couple of items to help you through:

    When users start reporting the error: “Field error ‘Date’ Incorrect date…”

    We need to set up the fiscal year, under Common data, G/L accounting tables, Fiscal…

    • 31 Dec 2019
  • Sage X3 Support: How to process an In-transit ownership reversal?

    In-transit ownership process is part of Import Tracking, and Import tracking is a North American (NA) add-on that requires a NA add-on license (activity code XA14).

    Some of the key features include, shipment management (vessels, container, etc.), cost management (flexible landed cost structure, ability to calculate charges at the shipment level or line level, duty calculations, etc.), material visibility and cost reconciliation…

    • 30 Dec 2019
  • Sage X3 Support: Four T-SQL commands for your toolbox

    I have used the following T-SQL commands quite often when working on the SQL Server side.  There are other ways to find some of this information, but you should have these commands in your toolbox. 

    Using the SQL Server Management Studio(SSMS) interface to find information about table definitions, indexes, or triggers is quite common.  It can be done by navigating to the appropriate table, then clicking the folders underneath…

    • 30 Dec 2019
  • Sage X3 Support: Why is the Gross Price for my Purchase order blank and where does it come from?

    The gross price can be blank for a few reasons:

    • The Price List has expired
    • No Price List setup
    • No Base Price entered in the Product record (Purchasing tab)

    • No Standard cost setup or STD cost is zero
    • The PURPRICE parameter is set to “No” in (General parameters, ACH, PRI)

    The Purchase price for a PO can pull from the Base price, a Price list, or the Standard cost located on the Product-site record (Common…

    • 26 Dec 2019
  • Sage X3 Insights: Sage X3 Learning Memberships are now available for Customers!

    Whether implementing Sage X3, on-boarding new employees, or building expert skills within, helping individuals understand how best to utilize Sage X3 to run your business is essential.  

    That’s why a Sage University Learning Membership is a sensible and affordable way to get the most value from your software. By giving every person in your organization access to a full library of learning and certifications.  Plus, as…

    • 18 Dec 2019
  • Sage X3 Support: SQL Server Dashboard report

    Did you know that SQL Server comes with some helpful built-in reports? I want to talk about one of those reports named the Server Dashboard.  This dashboard has a lot of information about SQL Server contained inside "gauges". These "gauges"are similar to how the instrumentation panel looks on your car's dashboard.  Each "gauge" contains related information in its own category as you can see below:…

    • 16 Dec 2019