DocTypeDesc = switch(FORMAT('32ItemLedgerEntry'[Document Type],"#"),"0","",
FORMAT('32ItemLedgerEntry'[Document Type],"#"),"1","Sales Shipment",
FORMAT('32ItemLedgerEntry'[Document Type],"#"),"2","Sales Invoice",
FORMAT('32ItemLedgerEntry'[Document Type],"#"),"3","Sales Return Receipt",
FORMAT('32ItemLedgerEntry'[Document Type],"#"),"4","Sales Credit Memo",
FORMAT('32ItemLedgerEntry'[Document Type],"#"),"5","Purchase Receipt",
FORMAT('32ItemLedgerEntry'[Document Type],"#"),"6","Purchase Invoice",
FORMAT('32ItemLedgerEntry'[Document Type],"#"),"7","Purchase Return Shipment",
FORMAT('32ItemLedgerEntry'[Document Type],"#"),"8","Purchase Credit Memo",
FORMAT('32ItemLedgerEntry'[Document Type],"#"),"9","Transfer Shipment",
FORMAT('32ItemLedgerEntry'[Document Type],"#"),"10","Transfer Receipt",
FORMAT('32ItemLedgerEntry'[Document Type],"#"),"11","Service Shipment",
FORMAT('32ItemLedgerEntry'[Document Type],"#"),"12","Service Invoice",
FORMAT('32ItemLedgerEntry'[Document Type],"#"),"13","Service Credit Memo",
FORMAT('32ItemLedgerEntry'[Document Type],"#"),"14","Posted Assembly"
)
No comments:
Post a Comment