Invoice Automation challenge failed

Help Something Else
, , , ,
1

Hi,
Just tried the Invoice challenge getting an failed. I didn’t find what was the reason.

image
image1901×814 54.5 KB

image
any one have suggestion for this issue.
Thanks,

2

@kowsi

The issue might be with the dates…Just check and validate with the given output sample

cheers

3

Hi @Anil_G given sample also have like the same format dd-MM-yyyy mine also like same. but getting an issue.

4

@kowsi

I see few dates are having / in the given screenshot

cheers

5

@Anil_G , In code I was given as dash but in excle it automatically shows slash when as single digit date.

6

@kowsi

Try giving the data as 01-03-2023 using date conversion

Cheers

7

@Anil_G Converted as like same format.but same failed.

image
image844×270 9.39 KB

8

@kowsi

One thing I see is there are 12 invoices and you got only 6

are you getting only 6 when you try?

and the format of csv should be exactly same as the given sample

format as of now looks proper …order of invoices also matters

cheers

9

@Anil_G
I checked many times there was condition given as passed dates or current date.
so, I get only 6 documents under that criteria.
I was set the condition at my code like,
DateTime.ParseExact(Due Date.ToString,“dd-MM-yyyy”,System.Globalization.CultureInfo.InvariantCulture) <= DateTime.Now

10

@kowsi

If you can send your code…I can verify and let you know as from output I cannot see any issue

cheers

11

Invoice Extract.xaml (118.1 KB)
@Anil_G
for sure, let me share.

12

@kowsi

Few issues that I observed dates particularly invoice dates are fetched wrong

and total due also for few are wrong…may be its ocr extraction issue…please check the same

the invocie dates mostly are in month of June but few are read as august

The problem I saw is 6 is read as 8 and 9 is read as 0 or 6

correct them and it should work

cheers

13

@Anil_G actually, I cross checked but In my system extracted data are fine. I couldn’t find any issue on that…did you think any other issue on the flow.

image
image1287×942 113 KB

14

@kowsi

Even in your system if you see the message box in the company name space is missing before LLC

For few we are getting correct for other its wrong…try making it proper

Cheers

Cheers

1 Like
15

Thanks @Anil_G , Issue is that company name. Now getting resolved.

1 Like
16

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.