Bob Wilcox - how are your intercompany clean ups going... I ask as i am helping a company with 90 subsidiaries where intercompany features were enabled but none of the entries had an "entity" attached to them - so of course intercompany is not doing a THING!! Would love to hear your thoughts on intercompany!! Thanks from…

For those that look here - i was done in by having the customer <> matching the receivable interco account vs. vendor <> payable intercompany account.

Still getting both errors. I have multiple csv files but did not want to share on a public forum. If i moved to cdn dollar i got rid of the base currency. But that is not what we want to upload. All accounting books gets these entries...

Invalid linesubsidiary reference key Snapcommerce Technologies Inc. for subsidiary 1. is the error message Had to save as a txt file re the csv import. It is not book specific. It is advanced interco. Thanks for responding so quickly.

So i have the next bill date now appearing on the sales order.... But i wanted it to appear on the invoice just issued. So the customer know when we will be billing them next! So i suspect since the value is NOT stored, it can't come over to the invoice itself! Argh. Any suggestions to make this feasible?? Thanks, and…

Thanks I would be interested if any users out there have done this. Downsizing from one world to single subsidiary... have a great day!

Thanks - will try this!

I have created a saved search:- Criteria:- Type - Sales Order Billing Schedule <> -None Results Group - Next bill date Filter Internal ID This saved search has the right data... But this saved search does NOT show on the drop down choices for the custom transaction body field... Can't work out why as i have compared to…

Jack - you are AWESOME. So of course there is a lead on question - can i have the next invoice aka billing date on the invoice? Sales order is for 12 months We bill them monthly So the invoice date is typically the start date. and the next bill date, minus 1 day, is really the end date of this invoice itself.... Cheers

Transaction Body Field - Free Form text - and make it based on a formula {startdate} || '-' || {enddate} This formula works in a saved search but i can't seem to get it on the sales order itself! All suggestions are appreciated

AWESOME - that works - need to get this added to the suite answers, ID 23079... Would be so helpful if it was there as well. Many thanks.

So i have determined that this functionality does NOT exist. Crazy. Enhancement # 177737 - Home> KPI portlet > Add Custom KPI = Saved Transaction Search: Available Filters tab: have the ability to select "As of date" like in Balance Sheet reports, as the basis when comparing data for date ranges instead of just Date…

I already have the formulars for months and I have 12 columns in my report for each month. Now i want the 13th column which is a sub total of all those months. I have followed answer ID23079 - if you look at that, it might help. Thanks again.

Relative date should be Same period last year - ok that gives for the month listed in the start month. Last fiscal year gives me the entire year. I am hearing your pain... Darn it is an enhancement - Answer Id: 49042 - 180825 - we all need to vote on that! And if you do relative to today's date - it will pick up the month…

Thanks. This is what i suspected... Either way, this should be an enhancement request as it is crazy given how much users want to rely on their dashboard for key information. How we are going against budgets is a critical aspect in managing a business! I was hoping that Analytics would give me a way but i could not see it…

I wonder... if you create a custom field that converts the netsuite posting period to a date. To convert posting period to a Date, use the below Formula (Date): to_date(ConCat('01 ', {postingperiod}), 'dd.mm.yyyy') and then do saved searches based on that field?

You have two AMOUNT Columns First with a NONE alternative period range type and then second column being - relative to report date - and select - same fiscal qtr last And when you run the report, the dates at the bottom are important, well the first one drives the value of the second column Is this what you were looking…

Steve - i think you want a saved search where an mount column is the results for May 2020, and another amount column is for April 2020 - aka the last two relative months? In the output - this is how you get Quarter One... Answer Id: 26968 Set the following fields in the Results tab: Formula (Currency) Summary Type: Sum…

No... I am doing a Dashboard KPI - so i can't have the date in the criteria at all It is a balance sheet account... So if i went live in Jan 2013 and i am looking at Sept 2020 results End of last month would be ALL data till Sept 2020 End of month before last month would be ALL data till Aug 2020. I am looking at Answer ID…

I am doing a DASHBOARD KPI. So i can't have a date in the criteria. What does ROLLING mean - since inception? I am looking at answer ID - Answer Id: 39678 re Period Selectors i need to find a period selector that says End of last month i think...

The standard list of KPIs is Total Bank Balance However we wish to exclude some bank accounts. So we wrote a saved search - made it available for dashboard view. However when we put this in the KPI dashboard - the choices for date comparison does NOT deal with balance sheet accounts. last month to date - just simply means…

and I spoke too soon! The one balance sheet account i was working on only had data this fiscal year so the dashboard appeared correct. But when i went to work on another custom KPI - it had transactions in prior year so i need a data range that is since inception to last month vs since inception to month before last.... I…

Solved it - the trouble with those dashboard descriptions of periods makes it very confusing. I had last period but I really needed This Year to Date vs. Last Month to Date So the saved search gives me what i need for the dashboard. The next desire is to have Revenues Actuals vs Budget on the dashboard.... The saved search…

Following this one as well - i want a KPI saved search for bank balance. I saw this suiteanswers - Answer Id: 37870 - re creating a saved search for EBITDA... But the dashboard is supplying the date range... What about the saved search picking up budget numbers as well. Have to work on that concept too!

This makes sense and i will now look into how we are setting up our billing schedules!!

So we do cash sales as all our transactions are captured via our own interface and stripe. Recently we have integrated with Avalara and we are just bringing in one line for the amount of taxes collected. Originally we set up these tax items as "direct posting" But quickly determined that you can NOT have a cash sale with…

So i solved it... All the entries I was looking at were Rev Rec Destination journals I had in the search these fields:- and that caused it to say no results but the far right imply there is some data... The moment I removed all these "Revenue Element" fields - the report produced data. To me the report should have produced…

Running as administrator Transaction saved search Criteria is real simple:- and i know there are journal entries... The screen says:- yet Very weird... Will clear browser next.

i will look into this and get back to you.... Thanks

Yes i needed a way to modify the revenue recognition rule for a particular LINE of a Revenue Arrangement. Basically all my lines had started bar one and that was due to it being Direct Posting as a opposed to a rule.... Discovered that it was NOT starting... Start and End dates are the same day - basically it should be…