Sage X3

We have an email that goes out with the customer's statement. The Customer Open Total on the Customer Statement is $0.54 off from the Accounting Balance that is sent out in the body of the email. This is the formula that is used in the email: "BLCC":…

anyone know of a sage standard report, or how can create a report, where can get the balance of what is in inventory of a given point in time of something that was manufacturered? I'm drawing a blank on where to start. know it would be stock transactions…

Does anyone know if there is a Sage standard report that can display the quantity sold to customer from what was produced via production tracking?

is there a way to track when & who deleted a delivery on an order? We are having some issues with duplicate deliverys.

Is it possible to share a report via an external link without the toolbar?

When I'm trying to add an SEI report to Sage X3, it shows an error. Here is the error message:

Hi There, We are looking for a Customer Transaction History report, so we can see payment of invoices but also credits that have been applied and where they were used. It seems in other versions of Sage that this kind of report exists. Thanks.

Hi There, We are looking to pull the latest invoice date for our customers onto a SEI report. The max function doesn't seem to pull it correctly, as we have it grouped by Customer and they have multiple invoices. The last transaction date isn't stored…

Hi, Context: - Sage X3 v12p34, single-tier (HTTPS; currently having issue) - AI image server (HTTP, inside Sage X3 v12p34 server, address used assume: http://localhost:58888/) - Sage X3 v12p26, single-tier (HTTPS; control) - Crystal Report 2020…

How can I create an SEI report from a SQL view or stored procedure?

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…

Hi what report can i pull to view who has unmatched receipts? thank you.

Up until the last couple of years as it relates to the financial reporting and analytical needs my clients seemed to have been satisfied with the out of the box budgeting and financial reporting capabilities that X3 has to offer and/or if they were looking…

Hello, I am a new user of Sage X3. Is there a report within Sage X3 that can list all of the Purchase/work order requisitions? If so, how do I get into it?

I need a report to pull daily for my Credit Card and EFT's.

I have a crystal report that I would like to setup a recurring task for and have it email the file each day. I setup the task using task code AIMP and in parameters set the destination to "email" but it does not allow me to choose a email recipient address…

Where can I find sub-ledger reports in Sage X3 for debtors and creditors control accounts?

What does the error message mean "$VERF_GIC Intercompany entry not validated" and how do I resolve it?

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…

Hello Everyone, We are trying to setup ZPL printer on Sage X3 but the problem we are facing is: a. ZPL printer is on a private (LAN) network - not accessible outside b. Sage X3 is on the cloud (Accessible only by a secured SSL URL) c. Sage X3…

I made a copy of the X3 Purchase Orders data model. When I try to create a new view off of that data model (only the copy, not the original), the folders inside of Dimensions and Data Measures are showing in French. Everything in set up is set to english…

Is there a report set up in Sage X3 version 12 that gives general ledger detail? We would like to see the date, the vendor, description of what was purchased, the type of transaction, the amount and the running total....in no particular order. The only…

Hello, Is it possible to change the date format on one of the fields in the payment proposal report (PAYPROPLIST)? If so, where can I do that? This report is not accessible through the normal means I am familiar with. Regards, Dave

Hi I am checking report for Goods Received Not Invoice (Clearing Account) in Sage X3 but not found any of such report. Could anyone help me how can we get the report of Good Received not Invoiced. Arshad

When I try to open a previously working report, I found this error on open. Error 403 Attempt: 0