cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Status "Delivered" in Reservation Invoice

mario_galeano
Participant

on ‎2023 Feb 18 1:10 PM

0 Kudos
339

I am wanting to identify the value of "Delivered" in the OINV table, but I am not able to identify it, in this case it is to be able to differentiate those reservation invoices copied to deliveries

Know the answer?

Help others by sharing your knowledge.

Answer

Need more details?

Request clarification before answering.

Show replies
Show replies
View Entire Topic
Abdul
Active Contributor
‎2023 Feb 18 9:58 PM
0 Kudos

You can identify it from INV1 there is a field targettype that stores the object code of target document in case of delivery it should have 15.

Show replies
Show replies
mario_galeano
Participant
‎2023 Feb 20 11:31 AM
0 Kudos

Hi abdul.mannan6

But that would be making a query from Deliveries (ODLN), in this case what I want is to know which invoices have not yet been delivered, is there a field in debtor invoices (OINV) that allows me to know that? Or should I start from the delivery to validate that?

Abdul
Active Contributor
‎2023 Feb 21 7:39 PM
0 Kudos

You have to start from INV1, INV1 is the child table of OINV

Ask a Question