Wednesday, 30 July 2025

Bank payment file name in d365 FO

 CONCATENATE("Pain001_",text(CustVendProcessedPayments.'>Relations'.RefRecId.'>Relations'.VendPaymentMode.LastSequenceNumber),

CASE('$PaymentByDebtor'.'$FirstPaymentInGroup'.DebtorAccount.Identification.Number, 

"1562170545","_DFD_", 

"160985023","_DFG_",

"_None_") & DATETIMEFORMAT(SESSIONNOW(), "MMdd"))



No comments:

Post a Comment

Azure Data Engineer stack

A very common Azure Data Engineer stack is: Azure Data Factory Azure Databricks Azure Data Lake Storage Azure Synapse Analytics ...