Invoice Print Question - URGENT

N

nate100

Member
When we do an invoice print, it generates an invoice number.
What QAD table is that invoice number stored at and is it possible to find out what the entity is for that invoice number.

Thank you.
 
When you print the invoice . The invoice number is stored in so_mstr table in field so_inv_nbr .
When you do the posting of that invoice , the whole history of invoice ih_hist gets generated and it gets stored in ih_inv_nbr .ih_hist carries properties of so_mstr (sales order header) and idh_hist carries properties of sod_det (sales order lines).

Remember that when you post the invoice so_mstr table gets deleted (based on if whole order is closed).
 
You must log in or register to reply here.
Back
Top