User_FZNHI Red Ribbon

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…

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…

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…

I have it - as I administrator - and I am already in suite ideas - per my message - 183033 is nothing to do with bank recs. Would love to vote for it but can't find it at all!

Something is wrong when you link enhancements. 183033 is this one and if I click your link... it says not allow access to case mgt... I am searching suiteanswers but i am having trouble finding it - can you please give me the description of the enhancement - that may help! Thanks

I have lost my mind - so auto create only works when you create "deposit" or "charge"... and not journals. Is that the case?

Thanks for the fast response but that is sad... Saved Searches CAN'T deal with CTA... So creative or not, it is not good to hear that. What a shame! Whilst I am on the topic of 90 subsidiaries, in the days I used Epicor - we used to have a reporting tree concept - this was either entity, or department driven and it had a…

So i need to:- and make 31120 be on it own! WOW - it works - do you know how many clients have that issue. Now the problem is clients like aggregating the retained earnings accounts but i suppose we can get around that via modifying those reports! Absolutely AWESOME - this is a winner!

What role are you using when doing this journal? You need to be an administrator!

No it does NOT work... Look at the above example This is clearly NOT right!

You need a set of books with retained earnings. When you have more than 2 years of data - the account number does not work... Also nice to know about the show last sub account...

Correct - just simply the account name with its number So for the first line 11276 - KB etc and for retained earnings - actually show the number 31100 and NOT multiple lines re the source of the retained earnings.

This tells me the equivalent of the subsidiary bank balance in my parents base currency. The report you have suggested, if my base currency was CAD Bank 123 $10,000 Subsidiary 123 but this bank account Bank123 is really in GBP and i want to see what the GBP on hand for that account. If i add currency - like my screen…

Any ideas on this - was truly hoping for a solution as it really should NOT be that hard to get a report of all bank accounts that shows me the actual bank balance in its currency and the equivalent in the subsidiary base currency. Was using the trial balance with the foreign currency - but that gets destroyed when anyone…

This is not the requirement. The requirement is a vendor issues bills to five of our subsidiaries. They are legit bills that belong in the relevant subsidiary books. Now my requirement is that the parent pays these vendor bills. So i get that i have to do advanced interco journals to record the cash leaving the parent…

Good to know - i have had issues making that field blank. Would be nice if it was a checkbox to state the preference of the report!

Good to know - but my position remains that NetSuite clients should NOT have to do this workaround - it is Netsuite decision to make bank statements redundant and they should be supplying EASY migration tools to handle this change. Not every client has knowledge of SuiteTalk Rest Web Services solution!!

Note for users - amount (gross) does not work for consolidated TBs. But it is great for standalone entities...

Thanks. You would think that given the latest release is making bank reconciliations redundant, that this "enhancement" should be a priority... afterall NetSuite is forcing everyone to move to the new functionality... not thrilled at all to manually edit more than 150 bank account. Customer Support should be able to…

This scenario is different. We have 5 vendor bills belonging to 5 subsidiaries. They are all the same vendor. To save on wire fees, one subsidiary sends one wire to pay for ALL 5 vendor bills - but we need the payment allocated down to the various subsidiary via intercompany. I suppose my point is we have the ability to…