Welcome to the Sage X3 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros from around the globe.
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…
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,
I am trying to build a data model based on the LOG_VIEW_USAGE table from the SEI database and I'm getting the error below when trying to add tables in the data model designer :
Nectari.DAL +++: Index was outside the bounds of the array…
We have just switched to V12. I am wanting to export information from various pages.
Is there a way to personalise an export spreadsheet to suit my requirements?
Some of the information I require is:
Product SKU
Product Description
Pack
…
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…
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
Received a request from a user that he could no longer access his account nor reset his password. Upon attempting to reset the password myself, I received the error message below: "Cannot reset password for an active directory user"
I believe the…
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…
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…
We have a US client making use of this method - and applies it across various asset classes. Can you suggest how to apply the different rates per year of useful life to satisfy this method?
This feature can be used in Elastic search, Standard inquiries, Graphical requestes, Custom made reports, SQL views, etc to extract data attached to a certain tag/s.
Say in a custom report, Client want to extracts all Sales, Purchase, Work ordres…
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…
so, we want to output some of our customer data into another system but only as the delivery documents are printed.
on V11, is it possible to tag something on the bottom of the report code that will output a CSV to a given location.
eg:
user prints…
Hi,
it's currently quite easy to create and use/add inquiries (stats)on Sage X3 homepage (for an 'advanced' end-user I mean). However quite a few clients would like to have Top 10 / 20 inquiries/stats (top 10 client per turnover YTD vs. Y-1...).
It…
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…
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.
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…
I'm trying to create a new query so that my user can have a list of new prep lists on their landing page. using table STOPRELIS, I was able to create a query but there is a line per product, when I only want the prep list, pick ticket, and so number.…
How can I make a new field on the invoice? When an invoice is created I want to use this new field with drop down options that the team can use to tag invoices. So when reporting is done they can filter for a specific report.
If you're a Sage Intelligence user and would like to keep up to date on handy ways to use the product for your business reporting, then why not subscribe to our SI Tips and Tricks and Excel Tips and Tricks mailers?
By subscribing to the SI mailer you…
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…
If I create a scheduled distribution of a worksheet, how can I make it only deliver if it pulls data. So for example I want to use this as essentially a notification for certain invoice types. I have the work sheet built and filtered, and it's scheduled…
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…
