Help with automation: Invoice number extraction and validation

[Enzo_Marcigliano]

Hi, SAP community.

I'm working on an automation project and need your help to solve a specific challenge. Here's the context and my question:

Project context

1. I've created a schema to extract data from invoices in PDF format.
2. The data extraction is working correctly.

My current challenge

After the data extraction, I need to:

1. Detect the invoice number within the extracted data.
2. Verify that the invoice number follows a specific format:
   • 3 letters
   • 1 hyphen
   • 4 numbers

For example, a valid invoice number would be: ABC-1234

My question

Could anyone guide me on the best way to implement this invoice number format verification within the automation flow in SAP?

I would appreciate any advice, code examples, or references to resources that could help me accomplish this task.

Thank you in advance for your help!

[wuttichai_s]

Hi, @Enzo_Marcigliano 

I have created a JavaScript function that verifies if an invoice number follows the specified format (3 letters, 1 hyphen, and 4 numbers). Here’s the function:

function isValidInvoiceNumber(invoiceNumber) {
// Define the pattern using Regular Expression
const regex = /^[A-Za-z]{3}-\d{4}$/;

// Check if the string matches the pattern
return regex.test(invoiceNumber);
}

// Example usage
const invoice1 = "ABC-1234";
const invoice2 = "AB-12345";

console.log(isValidInvoiceNumber(invoice1)); // true
console.log(isValidInvoiceNumber(invoice2)); // false

This function takes an invoice number as input and returns true if it matches the format, and false otherwise. You can integrate this into your automation flow to verify the invoice numbers you extract.

[Sankara1]

Hello Enzo,

Thank you for reaching out. Have you had a chance to try the custom script to verify the invoice number format? Please let us know if you’re still encountering any issues.

[FMarby]

Just wanted to check in since we haven’t heard back anything on this. Since there hasn’t been any activity we wanted to let you know this issue is no longer on our radar.

If you’re still looking for a solution, you might want to check out the SAP Builders or the Application Development Group in the community—it's a great place to connect with others and find helpful insights.