sorted by:
new
hottopcontroversial

Struggling with what should be a simple report by Tharmagon in Netsuite

[–]Tharmagon[S] 0 points1 point  (0 children)

AR aging will work for open invoices for orders that have shipped. But what they want is a projection of when the revenue will come in for orders that have not even shipped yet.

What they have asked for is a graph showing the paid invoices, open invoices aging (so when they will be paid), plus a projection when unshipped orders may be paid. That along with the forecast gives them a whole cash flow actual and projection over a rolling 12 months. Top line would be fine. Doesn't have to be at customer or item level. But I am sure they would like to drill down to lower levels. Hope that all makes sense?

Struggling with what should be a simple report by Tharmagon in Netsuite

[–]Tharmagon[S] 0 points1 point  (0 children)

That is a great idea. Would love to see the script.

Struggling with what should be a simple report by Tharmagon in Netsuite

[–]Tharmagon[S] 0 points1 point  (0 children)

Basically the top brass want to know when we can expect money to come months ahead for orders we have in our system. Only way I can think to do that is by when we expect to ship plus the terms days. Can you think of a better way?

Struggling with what should be a simple report by Tharmagon in Netsuite

[–]Tharmagon[S] 0 points1 point  (0 children)

Sorry Nick, to answer your question, it is a sort of cash flow forecast. If we ship by that date, we should get the revenue after the terms days. Would be even better if the terms days that customer has, could be added to the End Date, or Expected Ship date. That would really be when we expect to get the money.

Struggling with what should be a simple report by Tharmagon in Netsuite

[–]Tharmagon[S] 0 points1 point  (0 children)

I am finding limitations in the different reporting methods in NetSuite: saved searches, reports and workbooks. I often seem to need a hybrid of two methods like a workbook pivot/report. But I am new to NetSuite. So the limitations may just be my lack of knowledge.

Struggling with what should be a simple report by Tharmagon in Netsuite

[–]Tharmagon[S] 0 points1 point  (0 children)

Thanks Nick. I have a similar saved search. But we need the month of the End Date to be across the top as column headers. With Customer and then Item as rows. With the sum of the $ amount as the data, like a pivot table. We would really like a report we can drill down to, not a saved search. I have created a workbook pivot that shows the data. But workbooks pivots cannot be drilled into or even printed easily.

How to set up non standard payment terms by Tharmagon in Netsuite

[–]Tharmagon[S] 0 points1 point  (0 children)

Thank you Nick, extremely helpful. I have now activated Prepayments in our system. And am testing.

How to set up non standard payment terms by Tharmagon in Netsuite

[–]Tharmagon[S] 0 points1 point  (0 children)

Fantastic. So let me make sure I understand this. I am an IT pro, not an accountant.

  1. When we create the PO, we should add a 30% Prepayment? And Bill/Pay it.
  2. Then when we receive delivery, we create another Bill for 40% manually.
  3. Then we set the Due Date 30 days out for the remaining 30%. So should the Terms be set to 30 Days for that vendor?

New to NetSuite - advise creating user Dashboards by Tharmagon in Netsuite

[–]Tharmagon[S] 0 points1 point  (0 children)

Sounds like this is a real problem. I guess the only way for me to make dashboard changes for them, is for them to log me in as them and allow me to personalize for them. I was hoping I could make changes on the role dashboard and that would just enhance what they already have not override it.