Robert Cotran Red Ribbon

Hi @Jervin Nicholas Teopengco-Oracle , Thanks for letting me know that the list is evolving. Netsuite responded to my request directly saying that the balance field is not available when you have multi-currency enabled which sounds really strange to me as it was available before. Why not just show the balance in the…

Basically, I just need a way to view the current balance on every account in the system. I find it hard to believe that I'd need to add up all transactions on that account in order to get the current balance. Running a query like that would take ages. It certainly looks like the system stores the account balance somewhere,…

Hi all, I just wanted to say I got it working by adding the Billable Expense at the time of creating the invoice and it's perfect. Thank you all for your help! Robert

Of course! I will need to link the billable expense at invoice creation time. I should have thought of that. Thank you so much, I'll re-write my script to do that. Thank you! Robert

Oh my goodness, so I basically have to resend the entire invoice with the data I eventually want it to have? Eek, that might be complicated... Can I ask another question which may allow me to do something else? I basically have some costs I'm associating to invoices by clicking the "Apply" button in billable expenses. I…

Hi Shamaine, I've been looking further into the "Record Type" issue and I really can't seem to find any record type that would match invoice item. I do have a unique key for it, but I think often times those records are referenced using the transaction id and line number. Please let me know if you find a way to do this,…

Hi Shamaine, I did provide the reason, and I have a new problem now. I also need to specify the record type I want to delete, but "InvoiceItem" isn't a valid record type that I can provide, so I can't seem to be able to delete that record. Please let me know if you hear anything on your end. Thanks! Robert

Hi Shamaine, Thanks for pointing that out. It could be that the PHP Toolkit I'm using isn't passing a delete reason. Still not quite sure how to delete the InvoiceItem record (unless it's really straightforward), but let me check on adding that delete reason. Thank you! Robert

Hi Shamie, Yes, I would like to delete just one line item from an invoice, not the entire invoice. Thank you very much for looking into this for me! Robert

You are a LIFE SAVER! It worked, my code works and I'm super happy. Spent HOURS on this. Thank you so much Erick! Robert

Hi Erick, Thank you for the above. I'm really sorry to bother you again. I've started working on this and although I was able to retrieve the internal ID of the "Expense Cost List" entry by doing a transaction search given the customer:job, I can't seem to be able to get it by doing a transaction search on the invoice it…

Thanks so much Erick, that's EXACTLY what I was looking for!!