Notice of Maintenance on October 9th. Click here for further details.

  • Error while editing Navigation pages

    Hi All, I am trying to edit an page content of a navigation page but this error occurs: Can anyone kindly guide how to get a correction for this error? We are in 2024 R1, syracuse version SyracuseServer_12.20.0 Best Regards, William Alm…
  • Error (Invoice Number) Modification not possible

    Helloo.. I’m encountering an issue while updating sales invoices through the import template. The error message I’m receiving is: “Error (Invoice Num) Modification not possible.” Initially, I thought this might be related to user access permissions…
  • Document attachment

    Is it possible to attach a document to a component in a specific work order?
  • MRP phase

    Would anyone know why receiving this error/warning or where it is configured? I'm not familiar with MRP but a user is asking.
  • Technical sheet modification by template

    Hi People, I tried to modify technical sheets by importing using template, bur when uploaded the template the system showing "record already exists'. Then how can I update technical sheets in bulk? The 'Update allowed' check box is checked. Can anyone…
  • Intersite Stock Transfer (GESSIS) - Is there an Import option and if so, what tables would be used?

    Hello! I understand that there are Stock Status Change and Stock Misc Iss/Rec import options but I haven't seen this for Intersite Stock Transfers. I know i can create a PO to the group supplier which creates the mirror SO but we're looking to perform…
  • Card Info Missing in Multi-Line Payments—Which Table Holds It? Need Card Type and Last 4 Digits.

    In the PAYMENTH table, there are fields for card information, such as the last 4 digits and card type. However, if it's not a single-line payment and the PAYMENTD table has multiple entries, that information doesn't appear. Does anyone know which table…
  • PO selection on Purchase Invoice function

    Is there a way to not have PO's displayed in the selection on the purchase invoice function? Assume we can manually flag as invoiced in the table so they won't display. Else is there a utility which can be run to exclude? thanks, C
  • Importing Sales orders and changing BPCNAM, BPDNAM, BPINAM

    Hi All I'm sure this is a common scenario. We have 1 Sage X3 customer account, I'll call it WEB001 where we import website orders onto when customers do guest checkout. I want to pass BPCNAM and corresponding address, BPDNAM and address and BPINAM and…
  • LOT CREATE DATE- STOLOT- UPDATE

    I had posted similar question few years back with no reply but will try again. Does anyone know if there is a feature where we can update the Lot Create date , BPSNUM field in the STOLOT table without going directly into the table to update? I would be…
  • Sage X3 Posted Payments

    I want to identify which transactions in the PAYMENTH table have been posted through to the GL. The STA_0 flag shows a 9 "In the Bank" when a transaction has been pushed through to the Remittance stage but what fields in what tables do I need to look…
  • Cycle count import INV Template

    I am working on setting up a cycle count template with specific stock codes that I can use on a weekly basis. These form part of a bigger store but we need to just count specific items. If I understand correctly I can use the Inv template to import and…
  • product density and BOM configuration

    I am having some difficulty understanding the relationship between the Density field on the product and the BOM configuration. I have a density as .79 on a raw material that is STK in Gallon. We weight the RM in LBS so I tried to configure the BOM based…
  • ITMSTA field- ITMMASTER

    This is a long-shot asking, but is there a way to backtrack to know when a products status was changed to active if we do not have the Audit feature on? I was hoping there was a date activation field in itmmaster but do not see one. going forward I can…
  • What is the point of the "ORDERS" table?

    We used to do manufacturing; but not anymore. Its been a couple years since we stopped utilizing work orders. We don't do quotes either. Just sales orders. I'm wondering why with just normal sales orders its creating entries into the ORDERS table…
  • Import Template fails when in a Recurring Task

    Hello, We have an import template that imports payments from a server location [YIMPORT]. It works correctly when run manually, but when run in a recurring task, it gets cancelled with the error "Query Interrupted (reason unknown)" and the file on the…
  • Error No -27 @SEED.FIL/ACTIV : Problem with Access to a File - ACTIV - 'valfil -s SEED ACTIV' exited with status code -27. Elapsed time: 00:00:04

    Sage X3 v12p35 A customized SEED folder, using BCP from Sage X3 Console. When I restore the customized SEED folder, I got the following error from the Sage X3 Console's log when using BCP import (I used 2 parallel processors out of 4 processors…
  • ORDERS Table, Stuck Records throwing off inquiry screens

    Hi all, I have this problem that has been a headache for me for a long time ever since Sage V6 and this problem still exists in V12. What's happening is we are having our inquiry screens ( such as Available Stock ) reporting incorrect information. We…
  • Sage X3 v12p31 BCP import of custom views issue

    Sage X3 v12p31. Using BCP import. From Sage X3 Console, when I import the folder, I get the following error from an earlier custom view referring to a later custom view . The later custom view got imported in later in the list but the final answer…
  • Accounting cancellation in supplier invoice

    I know performing this function will delete the original journal entry, but is there any way to know who performed the task? Is there any other function or table which would hold this information? Appears invoices are 'mysteriously' being unposted and…
  • Quality control responses

    Is there a way to update the responses other than doing an Analysis Request? What if material has been used/sold and we need to update results? Is there another function where we can make changes to the results? any help appreciated.
  • Sage X3 Mass Update Sales Tax on Open Order Lines

    Is there a way to mass update the Tax Level 1 and SST tax codes on all open order lines after this information has been updated on the Product setup? I know we can run the Sales Tax Initialization to update the Tax Rule and Entity on open orders once…
  • Sales invoice history table

    Is there a table that keeps sales invoice history by product? I need to get data that shows product stock changes by period, already calculated.
  • Import to ACLOB Table

    Similar questions have been asked but never answered directly. Simply put, I need to be able to create an import template to upload "comments" to product records. I do not want them in the purchasing text fields, rather the comment bubble. I know…
  • How to setup payment terms: 2% 15 Net 30

    We have a few customers with terms noted above. Currently we have configured as 100% due on the 30th day. Is there a way to automate somehow if the customer pays before the 15th day to automatically display the 2% discount when creating the payment receipt…