{"id":2558,"date":"2021-05-31T12:38:49","date_gmt":"2021-05-31T12:38:49","guid":{"rendered":"https:\/\/help.hbsoftware365.com\/?p=2558"},"modified":"2021-07-19T09:52:23","modified_gmt":"2021-07-19T09:52:23","slug":"standard-functions-copy","status":"publish","type":"post","link":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/exsion-help-eng\/exsion-eng-06-exsion-functions\/standard-functions-copy\/","title":{"rendered":"Standard functions"},"content":{"rendered":"\n

These functions can be found in Excel’s function wizard under the category “Exsion standard<\/b>“.<\/p>\n\t\t\t\t\"Standard\n

\n\t\tEXSION_ACCBAL\n\t<\/h2>\n\t\n\t\n\n\n\n\n\n\n\n\n
Argument<\/th>\nDescription<\/th>\n<\/tr>\n
Connection<\/td>\nConnection (1 to 9999).<\/td>\n<\/tr>\n
G\/L Account No.<\/td>\nG\/L account (filter).<\/td>\n<\/tr>\n
[Date filter]<\/td>\nDate (filter).<\/td>\n<\/tr>\n
[Budget code]<\/td>\nBudget.<\/td>\n<\/tr>\n
[Dimension 1]<\/td>\nGlobal dimension code 1 filter.<\/td>\n<\/tr>\n
[Dimension 2]<\/td>\nGlobal dimension code 2 filter.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n\t\tEXSION_ACCNAME\n\t<\/h2>\n\t\n\t\n\n\n\n\n\n
Argument<\/th>\nDescription<\/th>\n<\/tr>\n
Connection<\/td>\nConnection (1 to 9999).<\/td>\n<\/tr>\n
G\/L Account No.<\/td>\nG\/L account.<\/td>\n<\/tr>\n
[Format]<\/td>\n0=Standard, 1=Capital letters, 2=Lower case letters, 3=First letter or 4=Initial letters.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n\t\tEXSION_ACCTOT\n\t<\/h2>\n\t\n\t\n\n\n\n\n
Argument<\/th>\nDescription<\/th>\n<\/tr>\n
Connection<\/td>\nConnection (1 to 9999).<\/td>\n<\/tr>\n
G\/L Account No.<\/td>\nG\/L account.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n\t\tEXSION_ANVBAL\n\t<\/h2>\n\t\n\t\n\n\n\n\n\n\n\n\n\n\n\n
Argument<\/th>\nDescription<\/th>\n<\/tr>\n
Connection<\/td>\nConnection (1 to 9999).<\/td>\n<\/tr>\n
Analysis view code<\/td>\nAnalysis view code.<\/td>\n<\/tr>\n
[G\/L account No.]<\/td>\nG\/L account (filter).<\/td>\n<\/tr>\n
[Date filter]<\/td>\nDate (filter).<\/td>\n<\/tr>\n
[Budget code]<\/td>\nBudget.<\/td>\n<\/tr>\n
[Dimension 1]<\/td>\nCode dimension 1 filter.<\/td>\n<\/tr>\n
[Dimension 2]<\/td>\nCode dimension 2 filter.<\/td>\n<\/tr>\n
[Dimension 3]<\/td>\nCode dimension 3 filter.<\/td>\n<\/tr>\n
[Dimension 4]<\/td>\nCode dimension 4 filter.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n\t\tEXSION_COMPANY\n\t<\/h2>\n\t\n\t\n\n\n\n\n
Argument<\/th>\nDescription<\/th>\n<\/tr>\n
Connection<\/td>\nConnection (1 to 9999).<\/td>\n<\/tr>\n
[Format]<\/td>\n0=Standard, 1=Capital letters, 2=Lower case letters, 3=First letter or 4=Initial letters.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n\t\tEXSION_CONCATENATE\n\t<\/h2>\n\t\n\t\n\n\n\n\n\n\n
Argument<\/th>\nDescription<\/th>\n<\/tr>\n
Range<\/td>\nRange of cells.<\/td>\n<\/tr>\n
[Delimiter]<\/td>\nA character of text.<\/td>\n<\/tr>\n
[Unique]<\/td>\nIf TRUE, then only the unique values will be combined.<\/td>\n<\/tr>\n
[Empty cells]<\/td>\nIf TRUE, empty cells will be included.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n\t\tEXSION_CUSBAL\n\t<\/h2>\n\t\n\t\n\n\n\n\n\n\n\n
Argument<\/th>\nDescription<\/th>\n<\/tr>\n
Connection<\/td>\nConnection (1 to 9999).<\/td>\n<\/tr>\n
Customer No.<\/td>\nCustomer No.<\/td>\n<\/tr>\n
[Date filter]<\/td>\nDate (filter).<\/td>\n<\/tr>\n
[Dimension 1]<\/td>\nGlobal dimension code 1 filter.<\/td>\n<\/tr>\n
[Dimension 2]<\/td>\nGlobal dimension code 2 filter.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n\t\tEXSION_CUSCITY\n\t<\/h2>\n\t

Returns the customer location.<\/strong> <\/p>\n\t\n\n\n\n\n\n
Argument<\/th>\nDescription<\/th>\n<\/tr>\n
Connection<\/td>\nConnection (1 to 9999).<\/td>\n<\/tr>\n
Customer No.<\/td>\nCustomer No.<\/td>\n<\/tr>\n
[Format]<\/td>\n0=Standard, 1=Capital letters, 2=Lower case letters, 3=First letter or 4=Initial letters.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n\t\tEXSION_CUSNAME\n\t<\/h2>\n\t

Returns the customer name.<\/strong> <\/p>\n\t\n\n\n\n\n\n
Argument<\/th>\nDescription<\/th>\n<\/tr>\n
Connection<\/td>\nConnection (1 to 9999).<\/td>\n<\/tr>\n
Customer No.<\/td>\nCustomer No.<\/td>\n<\/tr>\n
[Format]<\/td>\n0=Standard, 1=Capital letters, 2=Lower case letters, 3=First letter or 4=Initial letters.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n\t\tEXSION_DATE\n\t<\/h2>\n\t

Returns a date filter.<\/strong> <\/p>\n\t\n\n\n\n\n\n\n\n
Argument<\/th>\nDescription<\/th>\n<\/tr>\n
Connection<\/td>\nConnection (1 to 9999).<\/td>\n<\/tr>\n
Type<\/td>\nChoose 1=Day, 2=Week, 3=Month, 4=Quarter, 5=Year or 6=Accounting Period.<\/td>\n<\/tr>\n
[Cumulative]<\/td>\nNo, Yes or YTD (Year to date).<\/td>\n<\/tr>\n
[Index]<\/td>\nIndex of type (e.g. Month 1 to 12).<\/td>\n<\/tr>\n
[Year]<\/td>\nOptional year (the current year is default).<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n\t\tEXSION_D1NAME\n\t<\/h2>\n\t

Returns the global dimension 1 name.<\/strong> <\/p>\n\t\n\n\n\n\n\n
Argument<\/th>\nDescription<\/th>\n<\/tr>\n
Connection<\/td>\nConnection (1 to 9999).<\/td>\n<\/tr>\n
Dimension code<\/td>\nDimension 1.<\/td>\n<\/tr>\n
[Format]<\/td>\n0=Standard, 1=Capital letters, 2=Lower case letters, 3=First letter or 4=Initial letters.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n\t\tEXSION_D2NAME\n\t<\/h2>\n\t

Returns the global dimension 2 name.<\/strong> <\/p>\n\t\n\n\n\n\n\n
Argument<\/th>\nDescription<\/th>\n<\/tr>\n
Connection<\/td>\nConnection (1 to 9999).<\/td>\n<\/tr>\n
Dimension code<\/td>\nDimension 2.<\/td>\n<\/tr>\n
[Format]<\/td>\n0=Standard, 1=Capital letters, 2=Lower case letters, 3=First letter or 4=Initial letters.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n\t\tEXSION_DIMNAME\n\t<\/h2>\n\t\n\t\n\n\n\n\n\n\n
Argument<\/th>\nDescription<\/th>\n<\/tr>\n
Connection<\/td>\nConnection (1 to 9999).<\/td>\n<\/tr>\n
Dimension group<\/td>\nDimension group.<\/td>\n<\/tr>\n
Dimension code<\/td>\nDimension value.<\/td>\n<\/tr>\n
[Format]<\/td>\n0=Standard, 1=Capital letters, 2=Lower case letters, 3=First letter or 4=Initial letters.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n\t\tEXSION_VENBAL\n\t<\/h2>\n\t

Returns the outstanding balance of a vendor.<\/strong> <\/p>\n\t\n\n\n\n\n\n\n\n
Argument<\/th>\nDescription<\/th>\n<\/tr>\n
Connection<\/td>\nConnection (1 to 9999).<\/td>\n<\/tr>\n
Vendor No.<\/td>\nVendor No.<\/td>\n<\/tr>\n
[Date filter]<\/td>\nDate (filter).<\/td>\n<\/tr>\n
[Dimension 1]<\/td>\nGlobal dimension code 1 filter.<\/td>\n<\/tr>\n
[Dimension 2]<\/td>\nGlobal dimension code 2 filter.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n\t\tEXSION_VENCITY\n\t<\/h2>\n\t

Returns the vendor location.<\/strong> <\/p>\n\t\n\n\n\n\n\n
Argument<\/th>\nDescription<\/th>\n<\/tr>\n
Connection<\/td>\nConnection (1 to 9999).<\/td>\n<\/tr>\n
Vendor No.<\/td>\nVendor No.<\/td>\n<\/tr>\n
[Format]<\/td>\n0=Standard, 1=Capital letters, 2=Lower case letters, 3=First letter or 4=Initial letters.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n\t\tEXSION_VENNAME\n\t<\/h2>\n\t

Returns the vendor name.<\/strong> <\/p>\n\t\n\n\n\n\n\n
Argument<\/th>\nDescription<\/th>\n<\/tr>\n
Connection<\/td>\nConnection (1 to 9999).<\/td>\n<\/tr>\n
Vendor No.<\/td>\nVendor No.<\/td>\n<\/tr>\n
[Format]<\/td>\n0=Standard, 1=Capital letters, 2=Lower case letters, 3=First letter or 4=Initial letters.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n\t\tEXSION_WEEKNUM\n\t<\/h2>\n\t

Returns the weeknumber of a date.<\/strong> <\/p>\n\t\n\n\n\n\n\n
Argument<\/th>\nDescription<\/th>\n<\/tr>\n
Date<\/td>\nSpecify a date.<\/td>\n<\/tr>\n
[Format]<\/td>\n0=WW, 1=YYWW, 2=YYYYWW, 3=WWYY, 4=WWYYYY.<\/td>\n<\/tr>\n
[Separator]<\/td>\n0=none, 1=space, 2=-, 3=|, 4=\/, 5=<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

These functions can be found in Excel’s function wizard under the category “Exsion standard“. EXSION_ACCBAL Argument Description Connection Connection (1 to 9999). G\/L […]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[66],"tags":[],"class_list":["post-2558","post","type-post","status-publish","format-standard","hentry","category-exsion-eng-06-exsion-functions"],"_links":{"self":[{"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/posts\/2558","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/comments?post=2558"}],"version-history":[{"count":13,"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/posts\/2558\/revisions"}],"predecessor-version":[{"id":3073,"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/posts\/2558\/revisions\/3073"}],"wp:attachment":[{"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/media?parent=2558"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/categories?post=2558"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/help.hbsoftware365.com\/smarttrade\/st-about-smarttrade-help\/st-intro\/wp-json\/wp\/v2\/tags?post=2558"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}