Sage X3

I am trying to import/export BPs from one endpoint to another. However, when I import the file the BP numbers are chronologically assigned instead of keeping the same BP numbers from the exported file. Where do I go to adjust this?

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 am looking to join the two above tables, According to the data models, the join is supposed to happen like this: 1;ACCCOD. How is that supposed to work if STOJOU doesn't have any accounting code? Also what does the 1 mean in the data model? Any and…

As seen in the subject, I am looking to join the STOJOU table to the SINVOICED table without the use of the ITMREF column. Data models show a one way arrow from STOJOU to SINVOICED with VCRNUM;VCRLIN. I am unsure of what to do with that, with VCRNUM only…

I am setting up a batch job to export some stock information to send out through my EDI program. We've done this several times in the past and accounted for the name of the file being the same by timing of the various scheduled jobs needed to do this…

Hi everyone, I'm looking for the description of this field: Table - FXDASSETS field ACGGRP_0 Example: ACGGRP_0 CM The description must be similar, but I have not been found a table yet with this description, please someone has an…

I am trying to update a journal entry, that has wrong date to the right dates. When I export the information and change the information and re import the file, its giving me an error that the record already exist. I am using the JAS2 Template, I am…

How are subqueries performed in SEI without creating a custom DB view ? Creating an Order Shortage Report. I have a process that pull sinformation form the ITMMVT table in summary (Orders, Item info) but I need to join to the ORDERS table to find…