• 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…
  • Vendor or Supplier Grading

    Group, A question from a co worker was asked of me a couple weeks back, and I'm late asking this question. Does Sage have report cards, vendor grading capabilities? Doesn't have to be anything too complicated. The basics would be a great start. I really…
  • X3 V12 - Barcode Font (IDAutomationHC39M) Not working on Crystal Reports

    On X3 version 6.5 (and version 5) we installed font IDAutomationHC39M.ttf on client computers to get barcodes to show on crystal reports. With V12 I figured I would have to install the font on the server(s). I installed the font on both the application…
  • Multi-level BOM report with costs

    I need to produce a Multi-level BOM report with costing details and totals. The "Print BOMs" report under common data gives the correct BOM structure, but I'd like this with Material, Labour, Overhead costs - and totals... Does anyone know of such…
  • How do I print a list of the invoices paid by a specific check?

    I just want a way to reprint the remittance. I can't find a report or screen to show me all the invoice numbers on a check, just a listing of the PINs that I can drill back to. Any suggestions?
  • Slow Performance during Report Phase Job Started and Printing X3 V12

    Hi, my company is in the middle of a migration from SAGE X3V5 to SAGE X3V12. R093.001.00019 When running a report in X3V12, the querying part (Job Started Phase with the green bars) takes an extra 1-3 minutes on average than it did in X3V5. In X3V5…
  • Fixed Assets vs General ledger

    What could be causing the Fixed Asset register to not balance to the general ledger.
  • 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…
  • Crystal Report Duplicating Net Invoice

    Good day It appears that when I select to print multiple copies of an invoice from the enter parameter screen it will multiply the net invoice amount based on the number of copies you select to print. Can anyone please assist?
  • Audit Reports

    If Sage x3 Doesn't have a SOC 1 report than can we get something alternative to this. As SOC1 report is mandate to get the change management authorized.
  • Positive Pay file generation

    When trying to generate the positive pay file - we experience the following error - file return error - no checks selected. There are checks generated and printed.
  • SORDER.SHIDAT_0 & SDELIVERYD.SHIDAT_0 not matching

    Hi, This may not be an error as much as a question as the internal workings of Sage X3. I've been setting up reports for our Sales department, but they weren't lining up wtih our Actuals. I realized that I was utilizing SORDER.SHIDAT_0 instead of SDELIVERYD…
  • For Pivots, why is the grouping and data staggered?

    I'm trying to automate reporting for my organization. However when utilizing SEI's pivot function, it staggers the groups from the data itself making the data useless upon exporting to Excel. I'm hoping there's some setting where I can have a more traditional…
  • Error generating and downloading lager date in Sage X3

    Hello All, I'm experiencing the below error message whenever I'm trying to download large data from Sage X3, mostly Financial Entry inquiry. Your advise will be appreciated. Sage X3 version: V11 Patch: 16 SQL Server: 2014 Error Message…
  • Positive stock balance and negative average cost in Stock Valuation Report

    Hello Guys, The available stock for a particular product in particular Site as of 31st August 2020 is 69 119.160Ltr. positive while the average and total cost is showing negative in Stock Valuation report. Average Cost: -2.40 and Total Cost: 165…
  • why aged balance report showing separate line for currency revaluation (CURVA) instead of embedded in each invoice?

    In the standard report - BALAGEHIST and normal BALAGEGRP - the detail aged balance is showing currency revaluation as a separate line. Can this revaluation entry show at individual invoice instead as for audit purpose - it will not be transparent to show…
  • Standard Accounting Code and Guidelines

    Does Sage has standard Accounting Code for product which we can refer as guidelines. For example the product code for Asset (if you have multiple asset Gl code - machine, computer, etc), should you have different product code for each asset according…
  • Parameter Prompting for Labels

    I am using Sage X3 V11 with Crystal 2013 to create a new label. Is it possible to prompt for report parameters when using the Print Stock Labels function? I am hoping to enter values for the label that are not currently stored in Sage as parameters.
  • Not Displaying in X3 Dashboard

    Hello, I have created a SQL query to show the top ten customers using SINVOICE table. Under Characteristics, Representation set to "Character and Graph". When it validates and run it shows the List and the graphs properly. But when it adds do dashboard…
  • How to print petty cash statement

    Hello, I want to use the report "Bank Account in Ledgers Report" for petty cash accounts as well. While printing the report under parameter section, i can see the petty cash accounts but when i click on bank selection it says record does not exists…
  • Packaging Consumption in Work Orders

    I'm looking for ideas as to the best way to consume packaging in work orders. We sell products in various packaging....totes, drums, pails, etc. Currently the packaging is relieved from inventory at time of sales invoicing.....packaging codes are…
  • FLUIMMOFCY and FAS246G: Entering more than one period

    In the FLUIMMOFCY and FAS246G reports, you can only choose either the whole fiscal year or one single period (January OR February OR March) in the printing criteria. You cannot enter more than one month, for example from Jan-Sep. It was asked by one…
  • Check register

    Hello, I need to get a check register from Sage X3 but the report I am getting is incomplete, as it is not pulling all the checks that have been issued. Reports->Reports->CHKREG-> I am selecting the right bank account, the right status, without…
  • CRYSTAL REPORTS - How can I find which column is used in Products application

    FormerMember
    FormerMember
    I want to create a crystal report. However, how can I find out which database column is using in the application? Suppose Common Data > Products > Department? How can I kno wwhich database couln I can refer to find out the department?
  • Tabbing through parameters in X3 V9

    Hello, has anyone had the following issues in version 9: -When tabbing through the fields in the parameters when trying to print a report, sporadically, it will enter fields with letters and not tab through properly. If so, is there a fix? -When in…