Sage X3

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…

Does anyone know the correct syntax for a workflow if I wanted to compare 2 dates and only show those for which the dates differ by greater than 1 day? In SQL, it's a simple DATEDIFF() to find this number, but I don't know how to code this in X3. …

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…

Scenario: User JOHN creates a new purchase request PR, on the signature user assignment he is the first to sign PR. After creating the PR, the PR is automatically signed. I suppose this comes from the actions in the workflow that fires when the PR…

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…

Is there a Task Code to add a View Requester in Recurring Task Manager?

Good afternoon. With the need of one of my clients to send all kind of reporting by email we came across a problem. We used the ARP event to manage the workflows so they could send the message with their report as an attachment. This worked smoothly…

Hey folks, I'm looking to resend a (ideally all) workflow notifications that have not been signed after a certain number of days. Is there a straightforward way in workflows that I'm missing? Thanks!

Hello, I'd like to set up an alert or notification when a lot is 6 months from expiration. Additionally, I'd like to receive notifications when the the stock falls below the reordering point defined in the product-site record. Can someone walk me…

Hello, the on line support list product status definitions as follows: First value: Active — The product is available for all the processes. Second value: In development Third value: Shortage — The product does not appear in search results, but…

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

I got a problem regarding the sales order report printing , it keeps on loading but it never print . I'm just asking why was this happen . It only happen with this particular SO number.

I am trying to run the CLOPER REPORT. When I run the report it flashes but nothing happens.

Hello, Anyone having idea on email content format using workflow rule. We can able to format the text like below screen shot using "ASYRMAIL.ASEND_MAIL" . But we can not send approval URL links to email from above function . Is that possible from…

Some fields in our X3 db were renamed. SEI process currently refers to old field names. Is it possible to remap field references in process? I was hoping to be able to update references in the relevant process files in CentralPoint. But this hasn…

Is it possible to have a recurring task to email a custom report. I made a report that basically shows all Misc. Issues and Receipts for the previous weekday. I would like to set up a workflow/recurring task to email this to a user every day. …

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…

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…

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…

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…

Wondering if there are users that have found a way to exclude intersite transfers (Purchase order/Sales order) from purchase signature requirements. I've tried adding the BETFCY <> 2 in the workflow requirements, but am getting inconsistent results. Wondering…

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…

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…

Hello Everybody! How can I setup a default text in automatic email that I am sending a report from purchasing order? I have created a workflow rule to do this. I put a default text in : Setup>Workflow Rules>Message. But, It hasn't worked. When I am…