Untitled
unknown
plain_text
2 years ago
1.6 kB
4
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...