cancel
Showing results for 
Search instead for 
Did you mean: 

how to find duplicate entries

impradeepy
Active Participant
0 Kudos

Hi all i am new to sap b1 9.0 and i want to know how can i find/see duplicate entries in the database like item number,vendor name,etc also how to close completed Purchase order that are not taken from GRPO

Accepted Solutions (1)

Accepted Solutions (1)

KennedyT21
Active Contributor
0 Kudos

Hi Pradeep ..

Welcome to forum...

Read the Rules of engagement.

1. You can write a simple sql query to find the duplicates.

2. Open the Purchase and right and you will find close option to close the purchase order....

Hope helpful

Regards

Kennedy

impradeepy
Active Participant
0 Kudos

thanks sir for the fast reply for closing purchase order we have to do manually right all the time if not copied from grpo?

KennedyT21
Active Contributor
0 Kudos

Yes offcourse if you not copied to grpo then it will be in open status you required to close..

Rgds

Kennedy

Answers (0)