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:
Formula with store 80 logic
IF(AND((GREATEREQ((STRLEN(FT_STORE_NUM)),3)),
(EQ(SUBSTR(FT_STORE_NUM,0,2),80))),"003","002")
Helpful Links: