wtools Posted July 6, 2018 Share Posted July 6, 2018 (edited) Hi, When i go through the invoiceitems table, for some invoice details both type and relid are empty. Why it's happening? Is there anyway to know which product is this one item belongs to? Edited July 6, 2018 by wtools 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted July 6, 2018 Share Posted July 6, 2018 2 hours ago, wtools said: Why it's happening? Is there anyway to know which product is this one item belongs to? if you've created custom invoices before, they will have an empty type field and relid will be set to 0 - is relid empty for you or just set to zero ? 0 Quote Link to comment Share on other sites More sharing options...
wtools Posted July 7, 2018 Author Share Posted July 7, 2018 Yeah, What you said is correct. relid is 0. So a custom invoice item don't have to be associated with a product? Is there anyway to know which product is this invoice item related? 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted July 7, 2018 Share Posted July 7, 2018 5 hours ago, wtools said: So a custom invoice item don't have to be associated with a product? no it doesn't - it could be for anything, e.g design work that is unrelated to any specific product for sale. 5 hours ago, wtools said: Is there anyway to know which product is this invoice item related? assuming it is even related to a product, not really - unless you mention it in the invoice line item description I suppose. 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.