Edit

Share via


ISOCREDREF ER function

Note

Community interest groups have now moved from Yammer to Microsoft Viva Engage. To join a Viva Engage community and take part in the latest discussions, fill out the Request access to Finance and Operations Viva Engage Community form and choose the community you want to join.

The ISOCREDREF function returns a String value that represents an International Organization for Standardization (ISO) creditor reference, based on the digits and alphabetic symbols of the specified invoice number.

Syntax

ISOCREDREF (invoice number digits)

Arguments

invoice number digits: String

A text value that represents the digits of an invoice number.

Return values

String

The resulting text value.

Usage notes

Note

To eliminate symbols from alphabets that are't ISO-compliant, the invoice number digits argument must be translated before it's passed to this function.

Example

ISOCredRef ("VEND-200002") returns "RF23VEND-200002".

Additional resources

Other (business domain–specific) functions