Automating Daily Purchase Order Entry into ERP Using UiPath - Need Assistance

[pdcampagnini (Paulo Diego Campagnini)]

Hello everyone,

I’m currently working on automating a process that involves entering purchase orders into an ERP system. Each purchase order contains several items from a specific supplier, including product codes, quantities, and unit prices. The orders must be entered into the correct branch within the system.

Each branch may have multiple orders from different suppliers, and each order is separated by supplier.

I’m trying to figure out the best approach to automate this process. The automation needs to run daily. I was considering consolidating the data into a single spreadsheet where each row would represent a specific product for that order. This means the spreadsheet would have many rows of products, categorized by branch and supplier.

I found that UiPath can read this spreadsheet and filter the data according to the combination of branch and supplier, which would cover part of the process. However, I’m running into issues when trying to assign the function in the Assign activity—it throws an error.

Does anyone have any ideas or suggestions on how I could proceed with this? Any help would be greatly appreciated!

[ashokkarale]

@pdcampagnini,

Kindly share more details about the error you are facing.

Thanks,
Ashok

[pdcampagnini (Paulo Diego Campagnini)]

Yesterday I was trying to start modeling the database, to create a key, but I couldn’t get past this step, I was using gpt 4 to help me with this part

[fernando_zuluaga]

Hi @pdcampagnini

Give a try this way:

(From r In dtPedidos.AsEnumerable()
Select r("ID LOJA").ToString() + "-" + r("ID FORNECEDOR").ToString()).Distinct().ToList()

Ex:

Regards

[pdcampagnini (Paulo Diego Campagnini)]

@fernando_zuluaga

(From r In dtPedidos.AsEnumerable()
Select r("ID LOJA").ToString() + "-" + r("ID FORNECEDOR").ToString()).Distinct().ToList()

Thank you for your help, the error has been corrected, I will be carrying out some tests here.

If anyone wants to contribute a strategy, I would be very grateful.