Untitled
unknown
plain_text
3 years ago
1.6 kB
5
Indexable
IF (Type = CONST(" ")) "Standard Text"
ELSE
IF (Type = CONST("G/L Account"), "System-Created Entry" = CONST(false)) "G/L Account" WHERE("Direct Posting" = CONST(true), "Account Type" = CONST(Posting), Blocked = CONST(false))
ELSE
IF (Type = CONST("G/L Account"), "System-Created Entry" = CONST(true)) "G/L Account"
ELSE
IF (Type = CONST("Fixed Asset")) "Fixed Asset"
ELSE
IF (Type = CONST("Charge (Item)")) "Item Charge"
ELSE
IF (Type = CONST(Item), "Document Type" = FILTER(<> "Credit Memo" & <> "Return Order")) Item WHERE(Blocked = CONST(false), "Purchasing Blocked" = CONST(false))
ELSE
IF (Type = CONST(Item), "Document Type" = FILTER("Credit Memo" | "Return Order")) Item WHERE(Blocked = CONST(false))
else
if (Type = const(Resource)) Resource
else
IF (Type = CONST("G/L Account"), ATC_CA_ProductSubcategoryCode = FILTER(<> '')) ATC_CA_ProductCategoryMapping."ATC_CA_No." WHERE(ATC_CA_Type = CONST("G/L Account"), "ATC_CA_No." = FIELD("No."), "ATC_CA_Product Category Code" = FIELD("ATC_CA_Product Category Code"), ATC_CA_ProductSubcategoryCode = FIELD(ATC_CA_ProductSubcategoryCode))
ELSE
IF (Type = CONST(Item), ATC_CA_ProductSubcategoryCode = FILTER(<> '')) ATC_CA_ProductCategoryMapping."ATC_CA_No." WHERE(ATC_CA_Type = CONST(Item), "ATC_CA_No." = FIELD("No."), "ATC_CA_Product Category Code" = FIELD("ATC_CA_Product Category Code"), ATC_CA_ProductSubcategoryCode = FIELD(ATC_CA_ProductSubcategoryCode));Editor is loading...