x Want to participate? Join the group to interact

  • 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…

  • Customer BP invoices Report

    How can I pull a report that will show the customer BP invoice. We have the sales invoice by lines report. But we want to connect information from the Customer BP Invoice. We want all the information under this: The inquiry does not output the…

  • Crystal Report Sales Invoice Form Back Order

    We currently have customer that accept Back orders. On the sales order the user is able to input items that are on back order. However, if a product is on back order the invoice form drops that product. The sales order: This is the invoice: The…

  • INVOICE INQUIRY TABLES

    I am trying to report on the invoice inquiry screen. The fields are exactly what i need. Anyone has an idea what those tables are that are running?

  • Crystal Report Invoice Report field with No data

    I did the following to the YSBONFAC Report. When I print the report, the report does not break. But it does not out put the lot number either. Any recommendation. The lot number is on the delivery.

  • AR Balances Report

    Hi, Does X3 have a report that shows what is owed by a customer. This would be any open invoices that have not been paid. FAHAD

  • Changes to report pre-processor not affecting report generation

    I have a Crystal report that runs a script to generate a table which is then used to create the report. I have edited the script to alter the data in the report but the changes I made are not showing up in the report or in the table that the script builds…

  • What does the create date in the STOJOU table mean?

    I'm trying to track the health of our shipping department and I just want to ensure I fully understand the create date in the StoJou table. does that mean when the delivered qty is taken out of stock ? and if yes, does that also mean when the shipment…

  • SEI Budget Analysis reporting

    The budget analysis is only including reporting debit code 1 dimension for actual amounts. How do I include a reporting credit cod 1 dimension into this SEI budget analysis?

  • Sage Intelligence - Error When trying to configure Auto-Emailing of BI reports

    Hello, I keep getting this error message when attempting to e-mail myself a BI report created on our system. I'm not sure what the issue is but it appears to be generating based on the FROM send address. Perhaps it is a email server authentication issue…

  • Question about modifying the PRTSCN report

    When users print that Available stock screen using the PRTSCN report the dates don't line up with the columns they represent. Is there a way to modify the PRTSCN report? It's not listed in the Reports > Reports section. Not sure if the picture below will…

  • Need to set report parameters to current date plus 2 weeks

    I have a recurring task set up to run a shipping availability report for our warehouse. The report parameters include a date which needs to be the current date plus 14 days. Is there a way to set the report parameters to accomplish this?

  • Reading the XML file using RDSEQ

    Hi there, I am reading the XML file by using RDSEQ, but the problem here is its not reading line by line, instead its reading no. line at time. Please advise !

*Community Hub is the new name for Sage City