• COGS reporting

    Looking for any insight. As far as I can tell there is not direct report that links COGs to deliveries. I've created a quick SQL query that provides me the necessary details from GACCENTRYD based on the TYP = stock. This works for a very base understanding…
  • Running a Crystal Report with a range parameter from Web Services using (CWSGPRTRT) Generic Print Report

    We have set up an outside App that calls the Generic Print Report (GWSGPRTRPT). You pass the report name, language, destination, and an array of parameter names and values separated by "~". We have gotten this process to work, but only if the specific…
  • 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…
  • 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…
  • Print Codes - Adding a report to BP Supplier Invoice Print List

    I'm having trouble adding a new report I've created to the AP/AR Accounting>BP Supplier Invoice record print list. I've looked all over the Setup>Destination>Print Codes list and cannot find a place I can add this report in order for it to show up as…
  • AP / AR Aging Report Shows Fully Applied Invoices

    Hello, When i run the aged trial balance it shows fully applied invoices and payments. It is matched already and customer wants to see only outstanding documents. Are there any way to remove all applied documents from aging reports. Eranda
  • 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…
  • How do you create a report for Work Center Capacity Variation

    I'm trying to create a report so that the maintenance team can see how many "variations" they have scheduled across multiple work centers. the table CAPVAR is not at all structured like the grid in the work center page. Does anyone have a report already…
  • Pulling Calculated Values from One Report or Data Model Into another for further calculations.

    I have 2 different reports one is a Statement of Financial Position while the other is an Income statement, how can I get calculated fields value from my Income Statement Into my Statement of Financial Position noting that the IS has it's Data Model just…
  • Using SQL Function in SQL Requester

    Hi, I am creating a simple SQL Requester which will pull back data from 2 tables - PREQUIS and ACLOB. I wish to use a SQL Function I have to convert the CLOB Text from RTF to 'readable' text. This works fine in SQL, but when I try in the SQL Requester…
  • Open Items Report for BP

    Hi, I want to run a report for a specific BP/Customer and I would like this report to show a complete list of all transactions for the customers - open and closed, invoices, CMs, DMs. I want to see 2 columns, one showing original amount and one column…
  • Daylight Savings Time shifted Scheduled Reports in SEI

    Hello, As the title suggests, my business' reports are now being sent out an hour earlier than they should due to DST. When looking at the admin guide in SEI, it suggests I set a Time Zone for the scheduled job. However, as you can see below the option…
  • 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…
  • 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…
  • 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.
  • 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…
  • Functional Profile Report

    Hi, I wonder if you can help me please? I'd like to create a report / pull data from SQL which would show a list of all User Profiles, along with all of the Functions they have access to - is this possible? If so, which tables would I use? Thank…
  • Generate a report to get the list of Products without customer through SEI

    Dear All, I am facing some problem to generate a report through sage enterprise intelligence. I want information from the report is 'product without customer' but when i apply criteria/filter to the customer i.e. 'customer code=null', the output…
  • Blank Report

    Hi there, We have an issue where a few users are trying to run a report but it is producing a blank PDF. The same users can run other reports fine. Other users who have a different user profile can run this report fine. This points to the user…
  • Is there a report that shows me the 12 month usage for all raw materials within a certain category?

    Is there a report that shows me the 12 month usage, current inventory, and the safety stock for all raw materials within a certain category? I buy hundreds of chemicals for my company, and I want to be able to view on one report the 12 month history/usage…
  • REPORT NOT RUNNING

    I am trying to run the CLOPER REPORT. When I run the report it flashes but nothing happens.
  • Printing a Set of Reports

    When we have created a Works Order, we need to print a set of reports. We have created the reports on the Entry Transactions and they list on the File>>Print Menu. We have to then print the set of reports one by one. I would like to find out how can I…
  • Unable to find language and/or path in general registry

    FormerMember
    FormerMember
    Hi! i´m trying to edit the SBONFACP crystal report with the parameters values. So i tried to print it in rpt format and later open with the SAP crystal reports. When i tried to open it i have this error: "Unable to find language and/or path in…
  • Adding A new Crystal Report

    Does anyone have details notes on how to add a new crystal report to show up in SAGEX3. The report has been developed on crystal but I want it to show up as an option under printer in PO. It is a copy of BONCDE report with a little modification but I…
  • Table Does Not Exist

    I have a report I built from scratch. Pretty simple, only 4 tables and one parameter to fill. I added it to the directory, then thereport dictionary, then set up the default values and then the print code. The report is visible after I hit "Record…