• Sage V12 Exporting Information from Various Pages

    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 …
  • How do I join STOJOU to GACCCODE?

    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…
  • How can I go about joining the SINVOICED table to the STOJOU table?

    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…
  • SAGE x3v11 ACGGRP field description

    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…
  • PORDERQ - RETRCPDAT field ?

    Hello guys, I hope you are well. I made some researches but surprisingly, i didn't find any answer. In the table PORDERQ, do you know, how the field RETRCPDAT is populated and what its purpose ? Many thanks for your help,
  • SEI Subqueries

    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…