{"id":9750,"date":"2023-03-07T15:06:06","date_gmt":"2023-03-07T14:06:06","guid":{"rendered":"https:\/\/mjr.gmbh\/?p=9750"},"modified":"2023-10-09T11:45:55","modified_gmt":"2023-10-09T09:45:55","slug":"trdata-processing-for-infor-erp-xa","status":"publish","type":"post","link":"https:\/\/testsite.mjr.gmbh\/en\/infor-erp-xa-knowledge\/trdata-processing-for-infor-erp-xa\/","title":{"rendered":"TRDATA processing &#8211; behind the scenes"},"content":{"rendered":"<section class=\"l-section wpb_row height_medium\"><div class=\"l-section-h i-cf\"><div class=\"g-cols vc_row via_flex valign_top type_default stacking_default\"><div class=\"vc_col-sm-12 wpb_column vc_column_container\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\"><div class=\"wpb_text_column\"><div class=\"wpb_wrapper\"><p><span style=\"font-size: 14pt;\">Many years ago, to be precise in 2005, I built a concept for automated processing of TRDATA records. At this time there was no way to enter warehouse transaction through PowerLink, NetLink or SystemLink. With this concept, you can not only do automated processing, but also extend the solution in a second step to create a business object over TRDATA and use it for interactive transaction handling. Since TRDATA is still used and probably will stay for a while, here are the details how to achieve that:<\/span><\/p>\n<ol>\n<li><span style=\"font-size: 14pt;\">Create a trigger &#8222;TRDATA after insert&#8220;, doing a SNDDTAQ to DQJUA, DQJUB and DQJUC (depending on the type of transactions). That will trigger the U-Jobafter insert a new record (be sure that the u-jobs AMJUA, AMJUA and AMJUC are started). If you need to find the next transaction number use DTAARA ZNXTRN. Please lock the data area before updating to prevent concurrent updates.<\/span><\/li>\n<li><span style=\"font-size: 14pt;\">Create a file for transaction results e.g. TRDATARES with two fields: Transaction number and one (long) Text-Field.<\/span><\/li>\n<li><span style=\"font-size: 14pt;\">Create MSGQs JCAMSGQ, JCBMSGQ, JCFMSGQ in MAPICS-Library List.<\/span><\/li>\n<li><span style=\"font-size: 14pt;\"> Create a trigger &#8222;TRDATA after update&#8220; reading these MSGQs. If there was any error during transaction (see Transaction status in TRDATA) you will find the transaction number and the error message in the message queues. Evaluate this and write the error message in TRDATARES.<\/span><\/li>\n<li><span style=\"font-size: 14pt;\"> So you will get the Result of your transaction after a very short time (less then one or two seconds)<\/span><\/li>\n<\/ol>\n<h3 class=\"w-post-elm post_title entry-title color_link_inherit\">Final result TRDATA processing<\/h3>\n<p><span style=\"font-size: 14pt;\">With the final result, a business object for TRDATA which is enabled for SystemLink you can also now use <a href=\"https:\/\/uploadia.mjr.gmbh\" target=\"_blank\" rel=\"noopener\">Uploadia by MJR<\/a> to create all kind of transactions (warehouse, ON\/OFF and more) through a simple Excel upload. Many of our customers are using this, so it is time to share this idea with the XA users community. Please do not hesitate to contact us if you have any questions.<\/span><\/p>\n<div class=\"w-iconbox us_custom_9a361e25 iconpos_top style_default color_primary align_center\"><div class=\"w-iconbox-icon\" style=\"font-size:2rem;\"><i class=\"fas fa-lightbulb\"><\/i><\/div><div class=\"w-iconbox-meta\"><h4 class=\"w-iconbox-title\">You have any questions?<\/h4><div class=\"w-iconbox-text\"><p><span style=\"font-size: 18pt;\">Just contact us!<\/span><\/p>\n<div class=\"w-btn-wrapper align_center\"><a class=\"w-btn us-btn-style_1 us_custom_3e336cc9 icon_atleft\" title=\"Kontakt\" href=\"https:\/\/mjr.gmbh\/en\/contact\/\/\"><i class=\"fas fa-bullhorn\"><\/i><span class=\"w-btn-label\">We can talk about your ideas and solutions!<\/span><\/a><\/div>\n<\/div><\/div><\/div>\n<\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/section>\n","protected":false},"excerpt":{"rendered":"Many years ago, to be precise in 2005, I built a concept for automated processing of TRDATA records. At this time there was no way to enter warehouse transaction through PowerLink, NetLink or SystemLink. With this concept, you can not only do automated processing, but also extend the solution in a second step to create...","protected":false},"author":3,"featured_media":2488,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[40,38],"tags":[],"tutorial_kategorie":[],"class_list":["post-9750","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-infor-erp-xa-knowledge","category-infor-erp-xa-technology"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>TRDATA processing - behind the scenes - MJR GmbH<\/title>\n<meta name=\"description\" content=\"How to automate the TRDATA processing in Infor ERP XA and build a SystemLink enabled business object for all TRDATA tranascations.\" \/>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"TRDATA processing - behind the scenes - MJR GmbH\" \/>\n<meta property=\"og:description\" content=\"How to automate the TRDATA processing in Infor ERP XA and build a SystemLink enabled business object for all TRDATA tranascations.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/testsite.mjr.gmbh\/en\/infor-erp-xa-knowledge\/trdata-processing-for-infor-erp-xa\/\" \/>\n<meta property=\"og:site_name\" content=\"MJR GmbH\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/mjr.gmbh\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-07T14:06:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-09T09:45:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/testsite.mjr.gmbh\/wp-content\/uploads\/XA-technology.png\" \/>\n\t<meta property=\"og:image:width\" content=\"367\" \/>\n\t<meta property=\"og:image:height\" content=\"322\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Michael Raber\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschrieben von\" \/>\n\t<meta name=\"twitter:data1\" content=\"Michael Raber\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"2\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/testsite.mjr.gmbh\/en\/infor-erp-xa-knowledge\/trdata-processing-for-infor-erp-xa\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/testsite.mjr.gmbh\/en\/infor-erp-xa-knowledge\/trdata-processing-for-infor-erp-xa\/\"},\"author\":{\"name\":\"Michael Raber\",\"@id\":\"https:\/\/testsite.mjr.gmbh\/#\/schema\/person\/00d3fb6d38d0307472384eb609dc0a98\"},\"headline\":\"TRDATA processing &#8211; behind the scenes\",\"datePublished\":\"2023-03-07T14:06:06+00:00\",\"dateModified\":\"2023-10-09T09:45:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/testsite.mjr.gmbh\/en\/infor-erp-xa-knowledge\/trdata-processing-for-infor-erp-xa\/\"},\"wordCount\":417,\"publisher\":{\"@id\":\"https:\/\/testsite.mjr.gmbh\/#organization\"},\"image\":{\"@id\":\"https:\/\/testsite.mjr.gmbh\/en\/infor-erp-xa-knowledge\/trdata-processing-for-infor-erp-xa\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/testsite.mjr.gmbh\/wp-content\/uploads\/XA-technology.png\",\"articleSection\":[\"Infor ERP XA Knowledge\",\"Infor ERP XA Technology\"],\"inLanguage\":\"de\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/testsite.mjr.gmbh\/en\/infor-erp-xa-knowledge\/trdata-processing-for-infor-erp-xa\/\",\"url\":\"https:\/\/testsite.mjr.gmbh\/en\/infor-erp-xa-knowledge\/trdata-processing-for-infor-erp-xa\/\",\"name\":\"TRDATA processing - behind the scenes - MJR GmbH\",\"isPartOf\":{\"@id\":\"https:\/\/testsite.mjr.gmbh\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/testsite.mjr.gmbh\/en\/infor-erp-xa-knowledge\/trdata-processing-for-infor-erp-xa\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/testsite.mjr.gmbh\/en\/infor-erp-xa-knowledge\/trdata-processing-for-infor-erp-xa\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/testsite.mjr.gmbh\/wp-content\/uploads\/XA-technology.png\",\"datePublished\":\"2023-03-07T14:06:06+00:00\",\"dateModified\":\"2023-10-09T09:45:55+00:00\",\"description\":\"How to automate the TRDATA processing in Infor ERP XA and build a SystemLink enabled business object for all TRDATA tranascations.\",\"breadcrumb\":{\"@id\":\"https:\/\/testsite.mjr.gmbh\/en\/infor-erp-xa-knowledge\/trdata-processing-for-infor-erp-xa\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/testsite.mjr.gmbh\/en\/infor-erp-xa-knowledge\/trdata-processing-for-infor-erp-xa\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/testsite.mjr.gmbh\/en\/infor-erp-xa-knowledge\/trdata-processing-for-infor-erp-xa\/#primaryimage\",\"url\":\"https:\/\/testsite.mjr.gmbh\/wp-content\/uploads\/XA-technology.png\",\"contentUrl\":\"https:\/\/testsite.mjr.gmbh\/wp-content\/uploads\/XA-technology.png\",\"width\":367,\"height\":322,\"caption\":\"Zahnr\u00e4der rot\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/testsite.mjr.gmbh\/en\/infor-erp-xa-knowledge\/trdata-processing-for-infor-erp-xa\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\/\/testsite.mjr.gmbh\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"TRDATA processing &#8211; behind the scenes\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/testsite.mjr.gmbh\/#website\",\"url\":\"https:\/\/testsite.mjr.gmbh\/\",\"name\":\"MJR GmbH\",\"description\":\"MJR GmbH - Digitalisierung f\u00fcr den Mittelstand\",\"publisher\":{\"@id\":\"https:\/\/testsite.mjr.gmbh\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/testsite.mjr.gmbh\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/testsite.mjr.gmbh\/#organization\",\"name\":\"MJR GmbH\",\"url\":\"https:\/\/testsite.mjr.gmbh\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/testsite.mjr.gmbh\/#\/schema\/logo\/image\/\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"MJR GmbH\"},\"image\":{\"@id\":\"https:\/\/testsite.mjr.gmbh\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/mjr.gmbh\",\"https:\/\/www.instagram.com\/mjrgmbh\",\"https:\/\/www.linkedin.com\/company\/mjrgmbh\/\",\"https:\/\/www.youtube.com\/channel\/UCodd4EtgS-12wppUPRXK8QA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/testsite.mjr.gmbh\/#\/schema\/person\/00d3fb6d38d0307472384eb609dc0a98\",\"name\":\"Michael Raber\",\"url\":\"https:\/\/testsite.mjr.gmbh\/en\/author\/mraber\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"TRDATA processing - behind the scenes - MJR GmbH","description":"How to automate the TRDATA processing in Infor ERP XA and build a SystemLink enabled business object for all TRDATA tranascations.","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"TRDATA processing - behind the scenes - MJR GmbH","og_description":"How to automate the TRDATA processing in Infor ERP XA and build a SystemLink enabled business object for all TRDATA tranascations.","og_url":"https:\/\/testsite.mjr.gmbh\/en\/infor-erp-xa-knowledge\/trdata-processing-for-infor-erp-xa\/","og_site_name":"MJR GmbH","article_publisher":"https:\/\/www.facebook.com\/mjr.gmbh","article_published_time":"2023-03-07T14:06:06+00:00","article_modified_time":"2023-10-09T09:45:55+00:00","og_image":[{"width":367,"height":322,"url":"https:\/\/testsite.mjr.gmbh\/wp-content\/uploads\/XA-technology.png","type":"image\/png"}],"author":"Michael Raber","twitter_card":"summary_large_image","twitter_misc":{"Geschrieben von":"Michael Raber","Gesch\u00e4tzte Lesezeit":"2\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/testsite.mjr.gmbh\/en\/infor-erp-xa-knowledge\/trdata-processing-for-infor-erp-xa\/#article","isPartOf":{"@id":"https:\/\/testsite.mjr.gmbh\/en\/infor-erp-xa-knowledge\/trdata-processing-for-infor-erp-xa\/"},"author":{"name":"Michael Raber","@id":"https:\/\/testsite.mjr.gmbh\/#\/schema\/person\/00d3fb6d38d0307472384eb609dc0a98"},"headline":"TRDATA processing &#8211; behind the scenes","datePublished":"2023-03-07T14:06:06+00:00","dateModified":"2023-10-09T09:45:55+00:00","mainEntityOfPage":{"@id":"https:\/\/testsite.mjr.gmbh\/en\/infor-erp-xa-knowledge\/trdata-processing-for-infor-erp-xa\/"},"wordCount":417,"publisher":{"@id":"https:\/\/testsite.mjr.gmbh\/#organization"},"image":{"@id":"https:\/\/testsite.mjr.gmbh\/en\/infor-erp-xa-knowledge\/trdata-processing-for-infor-erp-xa\/#primaryimage"},"thumbnailUrl":"https:\/\/testsite.mjr.gmbh\/wp-content\/uploads\/XA-technology.png","articleSection":["Infor ERP XA Knowledge","Infor ERP XA Technology"],"inLanguage":"de"},{"@type":"WebPage","@id":"https:\/\/testsite.mjr.gmbh\/en\/infor-erp-xa-knowledge\/trdata-processing-for-infor-erp-xa\/","url":"https:\/\/testsite.mjr.gmbh\/en\/infor-erp-xa-knowledge\/trdata-processing-for-infor-erp-xa\/","name":"TRDATA processing - behind the scenes - MJR GmbH","isPartOf":{"@id":"https:\/\/testsite.mjr.gmbh\/#website"},"primaryImageOfPage":{"@id":"https:\/\/testsite.mjr.gmbh\/en\/infor-erp-xa-knowledge\/trdata-processing-for-infor-erp-xa\/#primaryimage"},"image":{"@id":"https:\/\/testsite.mjr.gmbh\/en\/infor-erp-xa-knowledge\/trdata-processing-for-infor-erp-xa\/#primaryimage"},"thumbnailUrl":"https:\/\/testsite.mjr.gmbh\/wp-content\/uploads\/XA-technology.png","datePublished":"2023-03-07T14:06:06+00:00","dateModified":"2023-10-09T09:45:55+00:00","description":"How to automate the TRDATA processing in Infor ERP XA and build a SystemLink enabled business object for all TRDATA tranascations.","breadcrumb":{"@id":"https:\/\/testsite.mjr.gmbh\/en\/infor-erp-xa-knowledge\/trdata-processing-for-infor-erp-xa\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/testsite.mjr.gmbh\/en\/infor-erp-xa-knowledge\/trdata-processing-for-infor-erp-xa\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/testsite.mjr.gmbh\/en\/infor-erp-xa-knowledge\/trdata-processing-for-infor-erp-xa\/#primaryimage","url":"https:\/\/testsite.mjr.gmbh\/wp-content\/uploads\/XA-technology.png","contentUrl":"https:\/\/testsite.mjr.gmbh\/wp-content\/uploads\/XA-technology.png","width":367,"height":322,"caption":"Zahnr\u00e4der rot"},{"@type":"BreadcrumbList","@id":"https:\/\/testsite.mjr.gmbh\/en\/infor-erp-xa-knowledge\/trdata-processing-for-infor-erp-xa\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/testsite.mjr.gmbh\/en\/"},{"@type":"ListItem","position":2,"name":"TRDATA processing &#8211; behind the scenes"}]},{"@type":"WebSite","@id":"https:\/\/testsite.mjr.gmbh\/#website","url":"https:\/\/testsite.mjr.gmbh\/","name":"MJR GmbH","description":"MJR GmbH - Digitalisierung f\u00fcr den Mittelstand","publisher":{"@id":"https:\/\/testsite.mjr.gmbh\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/testsite.mjr.gmbh\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/testsite.mjr.gmbh\/#organization","name":"MJR GmbH","url":"https:\/\/testsite.mjr.gmbh\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/testsite.mjr.gmbh\/#\/schema\/logo\/image\/","url":"","contentUrl":"","caption":"MJR GmbH"},"image":{"@id":"https:\/\/testsite.mjr.gmbh\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/mjr.gmbh","https:\/\/www.instagram.com\/mjrgmbh","https:\/\/www.linkedin.com\/company\/mjrgmbh\/","https:\/\/www.youtube.com\/channel\/UCodd4EtgS-12wppUPRXK8QA"]},{"@type":"Person","@id":"https:\/\/testsite.mjr.gmbh\/#\/schema\/person\/00d3fb6d38d0307472384eb609dc0a98","name":"Michael Raber","url":"https:\/\/testsite.mjr.gmbh\/en\/author\/mraber\/"}]}},"views":2481,"_links":{"self":[{"href":"https:\/\/testsite.mjr.gmbh\/en\/wp-json\/wp\/v2\/posts\/9750","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/testsite.mjr.gmbh\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/testsite.mjr.gmbh\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/testsite.mjr.gmbh\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/testsite.mjr.gmbh\/en\/wp-json\/wp\/v2\/comments?post=9750"}],"version-history":[{"count":0,"href":"https:\/\/testsite.mjr.gmbh\/en\/wp-json\/wp\/v2\/posts\/9750\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/testsite.mjr.gmbh\/en\/wp-json\/wp\/v2\/media\/2488"}],"wp:attachment":[{"href":"https:\/\/testsite.mjr.gmbh\/en\/wp-json\/wp\/v2\/media?parent=9750"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/testsite.mjr.gmbh\/en\/wp-json\/wp\/v2\/categories?post=9750"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/testsite.mjr.gmbh\/en\/wp-json\/wp\/v2\/tags?post=9750"},{"taxonomy":"tutorial_kategorie","embeddable":true,"href":"https:\/\/testsite.mjr.gmbh\/en\/wp-json\/wp\/v2\/tutorial_kategorie?post=9750"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}