SAP B1 Query - SAP Community

202

SAP Managed Tags:
SAP Business One

HI Experts!

i want to get query for Document No(Yellow one) but i don't know which table is including Doc No

anyone know where is it?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

you should join the table and can find.

select * from ORCT

inner join RCT2 on ORCT.DocEntry=RCT2.DocNum

where ORCT.DocEntry=4762

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hello

RCT2 is definitely is corrct for incoming Table

but it seems DocNum in RCT2 has Wrong Number it is not DocNumber...

Ask a Question

Top Q&A Solution Author

User

Count

111

8

8

6

6

5

4

3

3

3