Most tragic and appreciate your time in looking into this. It is weird that given both are financial reports - that they have inconsistent outputs. All reports under financials should be done the same method! Thanks

thanks for your detailed response. The challenge i have is if we run revenue by item - it agrees to the consolidated income statement irrespective of the months I put in the filter. and the subsidiary context. However when i run cash sales by item - it moves around within the months So for this report - no changes But for…

Do you have foreign currency involved in your demo account? It is a standard report. Accounting periods and not dates - not that it should matter.

Revenue by Customer Revenue by customer is working but sales by item is not consistent within the months itself..

Sorry i was away... and yes still need further assistance We are NOT cash based. It is the idea that when running a detailed sales report - the report called - Sales by Item Summary - so this is NOT a balance sheet or income statement report - but on a consolidated basis - the exchange rate used is dependant on the start…

Well done - I just stumbled on to this as well! Most appreciated.

If i run the report for the periods Jan 23 to Feb 23 and show monthly numbers, and then run the say report from Jan 23 to March 23, and show monthly numbers. The total number for sales i have for Jan 23 changes between reports. It is a cash sales report. It seems to be using a different exchange rate.

and in case anyone else is looking - it cant be done on a workflow. Has to be a scripted solution!

yes i am referring to this functionality.

It is insane and really sad!

I am looking into this as well and it is disappointing that with all the sophistication of billing schedules, it can't simply calculate the billing period based on this. I was hoping to add a custom field to the billing schedule itself. But that does not even seem possible. Is there an enhancement open for this simple…

Good to know... i will file a support ticket. Thanks

We have two custom fields - one is Billing Region and the other is Hotel Region - i want both on my saved search - the region of our customer is used for Billing Region and hotel region is self explanatory. and to confirm i am creating a revenue recognition plan saved search. is on the revenue arrangements Is on the…

The first two lines of my saved search works well - they are simply turning a date into a mth-year format. (to_char({revrecstartdate},'MON') || '-' || to_char({revrecstartdate},'YY')) (to_char({revrecenddate},'MON') || '-' || to_char({revrecenddate},'YY')) It is the second screen shot - that is the issue - the moment i add…

Perfect - this needs to be put in Suiteanwers. Now i can see it!

So without this enhancement, you cant use allocations when you are simply trying to deal with the fact of a company growing in size, expanding its departments, divisions and they have future Revenue Recognition entries that need "fixing"... Went a voted for it. Only 20 votes! So hopeless

We are having the same issue - more from the perspective that we have decided to use departments and locations - but we have all these open revenue elements that do not have these attributes - so want to push this information via a script. Investigating what is possible.

Thanks. Does the issue becomes that the vendor bill might be expensed to her department, but in order for her to be able to search on a vendor BILL doc ID - we need our users to add the department to the actual liability itself - aka the header record. I think we are saying she can run a department report of her expenses…

Sorry for the delay This is not about creating a vendor or vendor bill. This is about the legal secretary knowing that bill 12345 and wanting to know if it is in the system. We only want the legal secretary to see expenses coded to their department, aka legal. We do not want them to see accounting department expenses or…

Memorized transactions are broken in that vendor bills can not be automatically posted as it need a document ID. So that should be resolved. I agree I should be able to do Rent-Mth-YY as the "template" for the document ID. So when it processes Jan 21 rent, the doc id defaults to "Rent-Jan-21". However in our situation we…

Unfortunately it is NOT good enough. Even Open Air has the ability to track budget changes on a project. It is the exact same concept for purchase orders and/or sale orders. The ability to have versioning on these. We have related records. The vendor knows the PO number - we do not want to start again in order to make it…

No it does NOT work for us. Firstly we have 10 departments. So that is 10 scheduled reports But we do not know exactly WHEN we are going to be finished month end. Either way Netsuite is forcing us to run 10 reports to then email them out to users. The way it should be is you have row and column layouts. That we have in…

I just wonder if anyone ever looks at the percentage of support's responses that return with "that is an enhancement"... It must be so hard being in support always having to give such a response. Especially when we go and vote on these enhancements and we see that they started in 2013.... Netsuite can and should be better…

The problem with our terms is the dates are totally unknown at the time of issuance. this works well for us somewhat... There needs to be co-ordination of amortization templates as well here. I think this could be a separate topic. But i found if i do a purchase order for 12k that is to be paid 4k a year, i should be able…

It is all about wanting version control on a purchase order. Probably an enhancement no doubt. Potentially the same idea should be available on a sales order. I could not see anything but i suspect it should be offered. I agree to spend xxx, and there are subsequent changes, i want to be able to save as a new version - and…

Our purchase orders are for non inventory items and do not require fulfilment. The item would be RENT/Lease Payment 12 months qty with monthly amount being $1000 We want a vendor bill created on a monthly basis for $1000 to ensure we pay the rent on time. We want the PO to confirm that we have signed paperwork for the year…

This weight average calculation should be at the choice of the entity - that is it should be in enable features - use weighted average or mathematical average. This causes issues for those people who have entities NOT on Netsuite but are uploading trial balances as the end of each month - this weight average approach means…

Thanks It is very sad to see that the enhancement has been around since 2012. Makes you wonder if it will EVER be worthy of being fixed... I have voted for it.

and no parent.. The header of my TB is larger than usual - but - the simple one also has this issue:- So a tad sad that i still can't get account number right for retained earnings. Any suggestions as it worked at another client but not this one!

we are working on getting a GL extract from the system and were having all sorts of issues in getting the tax details. In our instance the transactiontaxdetail table is not even there which was most weird. We have 90 companies - and running individual TBs just takes too long. So we are doing SQL query to get this…