Software (include version): Ancora, DocStar IDC, Epicor IDC    


Use Case: Client needed to populate Entity value based on store number. If the Store number first 2 started with 80 (ex... 8012) then it was Entity 0003 otherwise 0002


Customer: Vineyard Vines


Prerequisites: Place in the Entity field and set flag to autocalculate. This is also will set the proper Entity if the store is #80


Instructions:

  1. Formula with store 80 logic

    1. IF(AND((GREATEREQ((STRLEN(FT_STORE_NUM)),3)),

      (EQ(SUBSTR(FT_STORE_NUM,0,2),80))),"003","002")






Helpful Links: