The Exact Online formulas provides access from within Excel to data contained in Exact Online. The formulas are only available when connected to Exact Online. The following formulas are available: %% Begin Waypoint %% - **Accounts** - [[I_EOL_ACT_CAN_DROPSHIP]] - [[I_EOL_ACT_CHAMBER_OF_COMMERCE_NUMBER]] - [[I_EOL_ACT_EMAIL]] - [[I_EOL_ACT_FAX]] - [[I_EOL_ACT_ID]] - [[I_EOL_ACT_IS_BLOCKED]] - [[I_EOL_ACT_IS_PURCHASE]] - [[I_EOL_ACT_IS_RESELLER]] - [[I_EOL_ACT_IS_SALES]] - [[I_EOL_ACT_IS_SUPPLIER]] - [[I_EOL_ACT_NAME]] - [[I_EOL_ACT_NOTE]] - [[I_EOL_ACT_PHONE]] - [[I_EOL_ACT_PUR_CREDIT_LINE]] - [[I_EOL_ACT_PUR_PAY_CODE]] - [[I_EOL_ACT_PUR_PAY_DAYS]] - [[I_EOL_ACT_PUR_PAY_DESCRIPTION]] - [[I_EOL_ACT_PUR_PAY_DISCOUNT_CALCULATION]] - [[I_EOL_ACT_PUR_PAY_DISCOUNT_PERCENTAGE]] - [[I_EOL_ACT_PUR_PAY_DISCOUNT_TYPE]] - [[I_EOL_ACT_PUR_PAY_END_OF_MONTHS]] - [[I_EOL_ACT_PUR_PAY_METHOD]] - [[I_EOL_ACT_PUR_PAY_VAT_CALCULATION]] - [[I_EOL_ACT_SLS_CREDIT_LINE]] - [[I_EOL_ACT_SLS_PAY_CODE]] - [[I_EOL_ACT_SLS_PAY_DAYS]] - [[I_EOL_ACT_SLS_PAY_DESCRIPTION]] - [[I_EOL_ACT_SLS_PAY_DISCOUNT_CALCULATION]] - [[I_EOL_ACT_SLS_PAY_DISCOUNT_PERCENTAGE]] - [[I_EOL_ACT_SLS_PAY_DISCOUNT_TYPE]] - [[I_EOL_ACT_SLS_PAY_END_OF_MONTHS]] - [[I_EOL_ACT_SLS_PAY_METHOD]] - [[I_EOL_ACT_SLS_PAY_VAT_CALCULATION]] - [[I_EOL_ACT_STATUS]] - [[I_EOL_ACT_WEBSITE]] - [[I_EOL_ACTCLN_PROPERTY_CODE]] - [[I_EOL_ACTCLN_PROPERTY_DESCRIPTION]] - [[I_EOL_ACTCP_BIRTHNAME]] - [[I_EOL_ACTCP_EMAIL]] - [[I_EOL_ACTCP_FAX]] - [[I_EOL_ACTCP_FIRSTNAME]] - [[I_EOL_ACTCP_GENDER_CODE]] - [[I_EOL_ACTCP_ID]] - [[I_EOL_ACTCP_INITIALS]] - [[I_EOL_ACTCP_LASTNAME]] - [[I_EOL_ACTCP_MIDDLENAME]] - [[I_EOL_ACTCP_MOBILE]] - [[I_EOL_ACTCP_PHONE]] - **Assets** - [[I_EOL_AST_COSTCENTER_CODE]] - [[I_EOL_AST_DEPRECIATEDAMOUNT]] - [[I_EOL_AST_DEPRECIATEDPERIODS]] - [[I_EOL_AST_DEPRECIATIONMETHOD_CODE]] - [[I_EOL_AST_DEPRECIATIONSTARTDATE]] - [[I_EOL_AST_DESCRIPTION]] - [[I_EOL_AST_GROUP_CODE]] - [[I_EOL_AST_INVESTMENTAMOUNT]] - [[I_EOL_AST_INVESTMENTDATE]] - [[I_EOL_AST_PURCHASELINE_ENTRYLINE]] - [[I_EOL_AST_PURCHASELINE_ENTRYNUMBER]] - [[I_EOL_AST_PURCHASELINE_JOURNALNUMBER]] - [[I_EOL_AST_RESIDUALAMOUNT]] - [[I_EOL_AST_STATUS]] - [[I_EOL_ASTGRP_DEPRECIATIONMETHOD_CODE]] - [[I_EOL_ASTGRP_GLASSETS_CODE]] - [[I_EOL_ASTGRP_GLDEPRECIATIONBS_CODE]] - [[I_EOL_ASTGRP_GLDEPRECIATIONPL_CODE]] - [[I_EOL_ASTGRP_GLREVALUATIONBS_CODE]] - **Employees** - [[I_EOL_EMP_BIRTHDATE]] - [[I_EOL_EMP_BIRTHNAME_PREFIX]] - [[I_EOL_EMP_BIRTHNAME]] - [[I_EOL_EMP_BIRTHPLACE]] - [[I_EOL_EMP_BUSINESS_EMAIL]] - [[I_EOL_EMP_BUSINESS_FAX]] - [[I_EOL_EMP_BUSINESS_MOBILE]] - [[I_EOL_EMP_BUSINESS_PHONE_EXT]] - [[I_EOL_EMP_BUSINESS_PHONE]] - [[I_EOL_EMP_CODE]] - [[I_EOL_EMP_EMAIL]] - [[I_EOL_EMP_FIRSTNAME]] - [[I_EOL_EMP_FULLNAME]] - [[I_EOL_EMP_GENDER_CODE]] - [[I_EOL_EMP_GENDER]] - [[I_EOL_EMP_INITIALS]] - [[I_EOL_EMP_LANGUAGE_CODE]] - [[I_EOL_EMP_LASTNAME]] - [[I_EOL_EMP_LOCATION]] - [[I_EOL_EMP_MANAGER_HID]] - [[I_EOL_EMP_MARITALDATE]] - [[I_EOL_EMP_MIDDLENAME]] - [[I_EOL_EMP_NATIONALITY_CODE]] - [[I_EOL_EMP_NICKNAME]] - [[I_EOL_EMP_PARTNERNAME_PREFIX]] - [[I_EOL_EMP_PARTNERNAME]] - [[I_EOL_EMP_PHONE]] - [[I_EOL_EMP_SOCIALSECURITYNUMBER]] - [[I_EOL_EMP_STARTDATE]] - [[I_EOL_EMP_TITLE_ABBREVIATION]] - [[I_EOL_EMP_TITLE_CODE]] - [[I_EOL_EMP_TITLE_DESCRIPTION]] - [[I_EOL_EMP_TITLE_HEADING]] - [[I_EOL_EMPADS_CITY]] - [[I_EOL_EMPADS_COUNTRY_CODE]] - [[I_EOL_EMPADS_LINE2]] - [[I_EOL_EMPADS_POSTALCODE]] - [[I_EOL_EMPADS_STREET_NUMBER]] - [[I_EOL_EMPADS_STREET]] - [[I_EOL_EMPSAL_AVG_DAYS_PER_WEEK]] - [[I_EOL_EMPSAL_AVG_HOURS_PER_WEEK]] - [[I_EOL_EMPSAL_PART_TIME_FACTOR]] - **Items** - [[I_EOL_ITEM_REORDER_POINT_COSTS]] - [[I_EOL_ITM_ACCOUNT_PURCHASE_CURRENCY_CODE]] - [[I_EOL_ITM_ACCOUNT_PURCHASE_LEADDAYS]] - [[I_EOL_ITM_ACCOUNT_PURCHASE_MINIMUMREORDERQUANTITY]] - [[I_EOL_ITM_ACCOUNT_PURCHASE_PRICE_VALUE]] - [[I_EOL_ITM_ASSORTMENT_CODE]] - [[I_EOL_ITM_ASSORTMENT_DESCRIPTION]] - [[I_EOL_ITM_ASSORTMENT_GLACCOUNT_CODE_COSTS]] - [[I_EOL_ITM_ASSORTMENT_GLACCOUNT_CODE_PURCHASE]] - [[I_EOL_ITM_ASSORTMENT_GLACCOUNT_CODE_REVENUE]] - [[I_EOL_ITM_COSTS_PRICE_CURRENCY_CODE]] - [[I_EOL_ITM_COSTS_PRICE_VALUE]] - [[I_EOL_ITM_DESCRIPTION]] - [[I_EOL_ITM_END]] - [[I_EOL_ITM_EXTRA_DESCRIPTION]] - [[I_EOL_ITM_GLACCOUNT_CODE_COSTS]] - [[I_EOL_ITM_GLACCOUNT_CODE_PURCHASE]] - [[I_EOL_ITM_GLACCOUNT_CODE_REVENUE]] - [[I_EOL_ITM_ID]] - [[I_EOL_ITM_IS_ASSEMBLY]] - [[I_EOL_ITM_IS_BATCH]] - [[I_EOL_ITM_IS_FRACTION_ALLOWED]] - [[I_EOL_ITM_IS_MAKE]] - [[I_EOL_ITM_IS_ON_DEMAND]] - [[I_EOL_ITM_IS_PURCHASE]] - [[I_EOL_ITM_IS_SALES]] - [[I_EOL_ITM_IS_SERIAL]] - [[I_EOL_ITM_IS_STOCK]] - [[I_EOL_ITM_IS_SUBCONTRACTED]] - [[I_EOL_ITM_IS_TIME]] - [[I_EOL_ITM_IS_WEBSHOP]] - [[I_EOL_ITM_NOTE]] - [[I_EOL_ITM_SALES_PRICE_CURRENCY]] - [[I_EOL_ITM_SALES_PRICE_VALUE_EXT]] - [[I_EOL_ITM_SALES_PRICE_VALUE]] - [[I_EOL_ITM_SALES_UNIT_CODE]] - [[I_EOL_ITM_SALES_UNIT_DESCRIPTION]] - [[I_EOL_ITM_SALES_UNIT_TIME]] - [[I_EOL_ITM_SALES_UNIT_TYPE]] - [[I_EOL_ITM_START]] - [[I_EOL_ITM_STATISTICAL_NETWEIGHT]] - [[I_EOL_ITM_STATISTICAL_NUMBER]] - [[I_EOL_ITM_STATISTICAL_QUANTITY]] - [[I_EOL_ITM_STATISTICAL_UNITS]] - [[I_EOL_ITM_STATISTICAL_VALUE]] - [[I_EOL_ITM_TRANSPORT_NETWEIGHT]] - [[I_EOL_STOCK_CURRENT_QUANTITY]] - [[I_EOL_STOCK_MAXIMUM]] - [[I_EOL_STOCK_PLANNING_IN]] - [[I_EOL_STOCK_PLANNING_OUT]] - [[I_EOL_STOCK_PROJECTED_COSTS]] - [[I_EOL_STOCK_PROJECTED_QUANTITY]] - [[I_EOL_STOCK_REORDER_POINT]] - [[I_EOL_STOCK_SAFETY]] - [[I_EOL_CRY_EXCHANGE_RATE]] - [[I_EOL_GLTXN_POST]] %% End Waypoint %%