Untitled

mail@pastecode.io avatar
unknown
plain_text
a year ago
1.6 kB
1
Indexable
Never
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));