Renato Gabas Blue Ribbon

Thanks for the reply. Since it's not possible to fetch the payment date for each installment via saved search, is it possible to do it through a SQL query using ODBC? I ask this because surely there is a link between the installment and the payment, since you can select the installments you want to apply the payment to,…

Thanks for the reply but it didn't work. When using the paying transaction : date field, it duplicates the vendor bill lines. From what I've seen, it only links the transactions but not the installments

A, C and D

Thank you folks... Amazing. I'll try that.

Great @"JohnCirocco", I was trying to do a report but I think as a Saved Search will be easier indeed. Thank you very much.

HI @"Shamaine Chan-Oracle" thank you for your answer... But I think I wasn´t very clear in my question, my point is not if the invoice is open or not, but to show the profit of that specific sale, instead of showing by customer. I want that because if I use a different REP Sales on the Sales Order, from the one linked in…

Yesssss, as a Cash Back it worked perfectly.... Amazing! We can use Cash Back Deposit as a Credit Payment using a bank.

Wrong, didn´t think it right, that transaction will raise the AP not lower, it´s wrong

Dear Friends @"Sujeet Singh katariya"@"Sujeet Singh katariya" I found a solution, we don´t need to use Pre payment we can use Deposit, if we go to Deposit and put Other Deposit and put the Vendor Name there and on the account Balance put AP it will automatically give a credit to Vendor that we can use to pay a Bill, change…

But @"Sujeet Singh katariya" do you know what is the name of the field that I can view these vendor prepayments?

I have the same problem, don´t know where to check what has been prepaid to that vendor and it doesn´t change the balance, so the unbilled orders are more than the negative balance, which I used to use to match what I have paid from what it´s still in purchase order. @"Shamaine Chan-Oracle" have any idea on this?

I had never entered on Suite Ideas, just because of that I had to enter and vote for this enhancement ...

HI @"Shamaine Chan-Oracle", thank you for your answer... I think Netsuite does have this functionality, you can set installments on the payment terms and NS automatically sets recurring payment, but only after the invoice is made, not before... Since we receive the customer payment before making the invoice, and some times…

Amazing Herdi, it worked perfectly, I was just hanging myself here ... I have a intention to integrate 10 subsidiaries together you can imagine the mess.. Thank you.

Perfect Pauline, thank you very much...

Hi Herdi, that is what I did, I have enabled and I could get an estimate of the gross profit, but anyway, it gives me some trouble, I will think here if I come back to sales order and don't use invoice or I keep this way... THe problem on leave it in sales order and not invoicing is the customer payment, that I have to…

Hi Pauline, so do I still need to make this script? I thought since we have already a field with this image I could "call" the image directly from the Advanced Template Code. Instead o using item.custcol_product_image use like "item.storedisplaythumbnail" cuting this script process, because I would like to keep it all…

Herdi, I did that and it worked thank you, but now I find a new problem ... In my profit & loss statement it's raising my income but it's not adding the cost of good solds, is there any resouce that I could enable to make this report shows COGS of these invoices that were not fulfilled, because although I didn't send my…

Hi Pauline thank you very much, I appreciate a lot your attention.... Can't I use the field that already exist from the webstore?

Perfect... Thank you.

I can't open a case, the option here to contact support online or by phone is blank to me, and in BRasil the support is terrible, the guys just don't answer me, it's a nightmare. Is there any way to open a case besides Suite Answers?

I see the role developer, but don't see the account. Even choosing me as a developer the account doesn't show up.

Just as a tip I used Write Checks and put an ordinary customer there and it worked.

Hi, where can I find this service? I searched online but didn't find.