I dont have the file here in my PC, but the "Query Data" activity is calling my database where all my data to be updated are saved. Can you share to me your idea?

In your "Query Data" activity, there is a place for "Query Criteria". If you do not set any criteria (filter) on the query, then you are returning all the results from the table (unless you are using a view or sp that has the filtering hard coded). The other place where you will need "Query Criteria" is in the "Update Data as Outstanding" activity. If you want more details, you will need to share some screens of these activities.

Hello,

Please see attached files for your reference.

Under "Status", that's the part that we need to update automatically.

Please see "Updating data to outstanding" that's where we inputted the outstanding part.

You can see also in our "Query Criteria" we does put any data on it.

Under "If document match" sequence please see the decision we put.

We tried to use "if Billing Doc is equals to billing doc for each row in the database" then update the data to outstanding, if not it can be blank or update also to pending. But what's happening is that it updates all the row with either outstanding or pending. Thanks for your help. :)

The problem definitely lies in your "Update data as Outstanding" activity. In the "Rows to Update" section, you must give it some criteria to limit the rows that it updates. In your case, it is the "Billing Doc" token that you need to use there. I attached a screen shot to demonstrate:

Once you have that in place, you should be good. You will need to do the same on the "Update Data as Pending".

Did this fix your issue?