x Want to participate? Join the group to interact

  • CC Billing Contact Table in V12?

    Hello. Does anyone where credit card stubs are stored in V12? In version 6 it was XCSPSCNT. We are in the middle of a migration to V12 and I'm trying to understand how credit card stubs are stored; because I will have to update some of my integrations…

  • Calculating "velocity" of stock in a site.

    Hello, We use Netstock which has a "velocity" identifier that tells you in layman's terms how fast a product sells. It is separated into three main classifications: A, B and C and then three velocities: High (H), Medium (M) and Low (L). I am not sure…

  • Data Purge Parameters

    Hi, We are a Blending & Packaging plant and have v9 Patch 5. We have 'never' archived/purged in our Sage X3 (EM) so we have over 10yrs of data (Since June 2008...) We've started to purge out some old data like the ATRACE and investigating into the…

  • "Function not defined for the value given" when performing import to a custom table

    We are on version 11 patch 9 I created a table and a custom import template: The first record is always created (after I RTZ the table) but instead of creating all of the other records it insists on updating them instead. Here is the error received…

  • Filtering of transaction record on left list using object

    Good day everyone, I am Manuel a rookie in the use of Sage X3. Fortunately over time have gotten myself familiar with the Interface and workings of the ERP system but on the development part have been stuck with a few challenge and hoping get it it…

  • SQL REPORT IN X3

    I am trying to run the following query but its giving me an error. Any suggestion on how it can be fixed.

  • SQL & Graphical Query

    I have the following Graphical query, the two tables are BPCUST AND SINVOICE. How can I set a criteria for it to pull invoices that have a date of 5/01/2018 to 5/30/2018. When I search for this its outputting all the invoices and duplicating…

  • How can I display a value from the Purchase Order table on the Purchase Receipt line associated with the Purchase Order?

    FormerMember
    FormerMember
    Hopefully this is a simple request I have a Purchase Receipts screen, and each line item has an associated Purchase Order. I need to display a value from the purchase order (held in the PORDER table) on each line item If I just add the PORDER…

  • Linking a Miscellaneous Table through SQL

    Does anyone know how to join tables through code (with one table being ATABDIV (misc tables))? I am trying to link TSICOD (statistical group ) (dim=0) to the table on the ATABDIV table (it's table 20), but I can't do it through code. Can anyone help me…

  • RE: SQL - DateTime conversion error

    Hi Bob, This is how it runs with the basic stripped down version. As you can see there are a few '0';s that are messing up the query. The field was added as a customized field and added to the index (STO0). I may try using another table and see if…

  • how many tables can be referenced in a screen

    Hi does anyone know how many tables can be linked on a screen. the grid only allows 5 lines so is this the maximum - or some way to add a 6th? thanks

*Community Hub is the new name for Sage City