• Finding Lot numbers on Unconfirmed Deliveries

    Our business would like to print packing slips before delivery confirmation. In most cases, I can see the lot numbers from screen WK4STD1 but I cannot find the table where that lot is stored. SDELIVERYD seems to only have a lot number for some records…
  • Excluding a Sales Invoicing Element from Credit Memo

    Hi, We have an automatic damage allowance set up as a sales invoicing element; this element value is set on the customer and is populating on both invoices and credit memos. Is there a way to exclude this invoice element from credit memos only?
  • Highlight shipment number after the record was loaded?

    We recently migrated to V12 and I'm looking for a way to simply have the shipment number be re-highlighted after loading a record...that way when scanning in another shipment it would overwrite the current shipment number and load the next record... Right…
  • ActiveFax Codes Not Reading on PDF Exports with Version 12 (Solved)

    The problem: When printing PDF files generated through X3 V12 to ActiveFax with the goal of automating email & print jobs; ActiveFax cannot read the codes despite having the font successfully installed on the server, pointing to the font in the crystal…
  • PURCHASE REQUEST WORFKLOW ESCALATION

    Good Afternoon, We would like to find out if anyone has ever setup workflow escalations on purchase request workflow approvals. under WORKFLOW FURLES, there is a ESC - ESCALATION option when the EVENT TYPE SIGNATURE is selected. However, despite testing…
  • Lack of screen table lines

    V12 has the issue where, multi line grids of data don't have clear markings around each line, so users cant easily scan along the grid and it can result in accidentally looking at another line of data. V11 had clear borders around each line and had…
  • Failed to open collaboration database: date constant not terminated:

    Context: I am moving over a X3 pu9p5 MongoDB over to X3 v12p32 as a test run. I have done the necessary grind from MongoDB from 3.0 (pu9) to 4.4.12 (v12p32) as per MongoDB requirements. I have also rerun the syracuse install to confirm Syracuse…
  • Folder restriction to single user

    Hello, Is it possible to restrict a user to acces a folder? I'm trying to give acces to only one of the 2 folders we have but the workaround i've done is to create a new group and give acces only to said folder. Is this the correct way or i am doing…
  • Sage X3 V12 Shortcuts

    Hi everyone, I came across these excellent and useful to improve navigation on X3 V12. A. Right Panel Actions ESC + N – new ESC + B - save ESC + C - create ESC + D - delete ESC + E - cancel ESC + ALT + U - refresh ESC + ALT + P - print…
  • Variable to show the transaction code used to enter screen

    I would like to take action in a screen based on which transaction code was use to enter the screen. Is there a variable available that will show which transaction was chosen when launching the function?
  • Purchase Receipt Function in Datalinx

    Hello Group, I'm hoping for some help or insight into an issue we've encountered using Datalinx & Sage Purchase Receipt Function. This is what we're trying to do: We are trying to use the purchase receipt function in Datalinx and receive an error…
  • How to store Blob image's type in a table ?

    I created a custom screen where I am displaying images related to a driver. I am using a datatype of ABB, input of Display, and Graphic object of Photo.I have an issue on how to store those images. I know that it is stored in the CBLOB table. In the screen…
  • Having error while using BIS import template to import file

    I am having problem while import using BIS import template, there is error on DUDDAT field. But when using import simulation, DUDDAT can get the value from my import file. Is anyone facing this problem or anyone can advise me on this? The attachment below…
  • SUBSCS - Inter-site transfers - CWSIS

    Hello On V12 Patch 27 Sage introduced CWSIS webservice in order to respond to the new ADC options. However, since it was done in order to work with ADC, Sage limited the use to just that. We can't use the same service for other third party integrations…
  • RTF Pasting adds many carriage returns

    Just upgraded to V12 P27 and when we copy to clipboard from an outlook email in rich text format, when we paste it into a comment box in any screen (customer, supplier, sales or purchase order etc), it is adding _many_ carriage returns after each sentence…
  • Resolve Pending Issues for Lot Managed products

    Hello wise people of the Sage City, For a customer we had allowed negative stock on ingredients/raw materials to prevent constantly having to stop production because tracking returns an error due to stock being unavailable. Allowing negative stock results…
  • Passing list of values as Criteria parameter

    Hi there, Is there any way of passing a list of values (comma separated or equivalent) as a Criteria parameter in the printouts > SQL Query Tool Also, how to remove character limitation from that field... what i'm trying to achieve is something like this…
  • 1) Mass delete BPS Invoices 2) DocLink/DocAlpha

    1) Is there a way to mass delete BPS Invoices? I have 1900 to delete. 2) Duplicate and triplicate Invoices have imported into Sage X3v12 p17 from DocLink/DocAlpha. This is the second or third time it has happened. Does anyone have advice on what might…
  • New ADC - Error message on Picking Function

    I am using the new ADC and all the functions seem to operate properly except Pick Ticket. I can select a picking list or a pick ticket, I am then shown the items on the pick ticket, but as soon as I press Update on the first line I picked .I get this…
  • Facing issue while choosing the endpoint of the imported folder v12.0.21 on a new servers of Sage X3 version 12.0.26

    I got an error while choosing the endpoint of the imported folder v12.0.21 on the X3 version 12.0.26. "Create session error : The folder version is different from the version of the root folder." , As shown in the screenshot below : Has anyone…
  • Carry Forward entries - Accumulated Depreciation

    Please assist. The Carry Forward entry (Opening balance) for accumulated depreciation does not agree to the closing balance at year end on the Fixed Asset register. I am not sure what the issue is. The Fixed Asset register appears to have processed…
  • Sales Kits -Commercial BOM

    I am trying to set up a sales kit - it is a bundle of 6 bottle of wines. I couldn't change the unit of component product. It is grey out. And the system default as "CA" - case. Is there any solution that i can change it to a different unit? Below…
  • Switching between edit and read only Mode with global variable GCONSULT

    Hello everyone, For our customer we developed a specific screen to manage plans. In order to edit a plan the user has to press a check out button. The user who checked out the plan can modify the plan. In the FILTRE action we use the global Variable…
  • Tax Determination Rules and Alcohol Volume Tax

    Ok X3 Tax experts. This one is for you! There are now several states that are beginning to charge Alcohol Volume Taxes. The Tax determination rule function appears to be the perfect solution for the following: ABV Tax = Volume * Rate. In addition, the…
  • Multiple Margin calculation methods in sales process

    Hi all, We have a finished good product that is managed using AVC (Average cost). We have a scenario where we need create a quote or sales order and have the standard cost value for the product load into the Cost field with the margin calculated based…