3943513 Green Ribbon

I think so. For bulk billed invoices, it's clear what i need to do. however, for manually entered ones, i'm not entirely clear without testing it but i'm sure i'll figure it out. I'm guessing that i source the 'email invoices' client custom field onto the invoice form and then run a script that emails the invoice on save.…

I am trying to do the same thing and have just tried writing a cheque to the supplier but it won't let me select my accounts payable in the "Expenses" tab at the bottom of the form. Am i missing something?

Also having this problem. Seems like a random thing to lose.

HSBCNet only allows payments by one type for each upload file. Currently the app only has capability for ACH Payments (Instruction Level or File Level).

It was developed by an external contractor but I think he's happy to sell it to other users at a reasonable price. He's on ken@omegaMinus.com if you want to contact him. Tell him it's the Bank Upload app that he did for me and he should know what you mean. Thanks, Charlie

the journal we write is more complicated than a simple 2 line journal that could be replaced by a bill credit process. There are other lines in the journal that perform other functions. We could pull out the two lines that do the same steps as the bill credit credit process but that would open up room for data entry errors…

Did you get this resolved? I am having the same problem. Also, the days overdue on the parent record is always blank (which is not correct)

yep, we had to do the same thing in our business (we have two seperate companies running as departments). We just passed a journal entry to put the right funds in the right accounts and i think it all worked ok.

Do you have an accountant you can speak to? I would suggest you would be better to get your advice from them...

we have an issue that Netsuite does not appear to have automatically closed our years. We can tell this because the retained earnings account is only showing a balance of the opening balance that we entered at the beginning. How can we force NS to do it automatically??

This could be done using a script. I've got a similar problem with our business and have been trying to figure out a way to do it ourselves. If I write a script I'll post it...

Having investigated this for a while, the Mass Update function doesn't allow you to update transactions directly. However, you can do this with a server side script. We didn't do this in the end but i know it's possible. If you've not done scripting before you might need some help or you can teach yourself from a…

I had expected it not to work until i saved the transaction but i'm getting the following error: ERROR: Field Not Found in the column field after I've saved and i'm viewing/editing.

that's done it!

I tried 'amount' but was getting errors. I now realise the errors were because i was using a column field which contains a formula in my new formula. This seems to be a limitation of the the system. I.e. 1. I have a column field called 'sup total' which is a formula. 2. I tried to create a new field called 'margin' which…

Thanks - adding the Financial History permission has done what i needed!

Chirs, We're tyring to do the same thing as Justin and I've just read the above post and i don't think Days Overdue gives us what we want. The Days Overdue gives and AVERAGE days overdue. We need a MAXIMUM days overdue so that we can send letters to clients that have their oldest invoice at 30-60 days and a different…

that's great. Thanks guys.

anyone got an answer to this? I'm having the same problem. I am trying to mass update all items to change the item purchase tax code to the new 15% tax code. I can't seem to do it. Any suggestions?

a statement does work but the issue is that it's a manual process. Our new credit controller is used to SAP where she was able to batch print a letter and statement in one go. Using the statements in Netsuite would mean batch printing the letters, then going into the statements and manually chosing the ones we want then…

Julian, How did you get on with this issue? I'm having the same problem and was wondering whether you got it sorted?

have you tried running a script on page load that puts in a space or underscore or something? That way, before people start using the script it's already got some text in there...

What i'm looking for is a report that has a column month by month: Column March: Row Sales Rep1: Total value of sales orders with salesrep = "Sales Rep1" and startdate value >= 1st March and <= 31st March Row Sales Rep2: Total value of sales orders with salesrep = "Sales Rep2" and startdate value >= 1st March and <= 31st…

I am populating the start date field on the sales orders. It's the creation of the report that I'm having trouble with. I can only seem to get the report to show the value of sales orders with the transaction date in any particular month.

What features does this have over and above an development environment set up in Eclipse with Aptana and the Netsuite plugin? If there are extra features, i'll give it a go.

I have used Ken Woodhouse too and he was excellent for us also.

Another problem for me too. We use automatically posted memorised invoices extensively in our account. We provide a monthly service and invoice a fixed amount per month. I've installed the memorised transactions bundle but this only appears to work for transactions manually entered from a memorised transaction. The VAT…

I've read the documentation on the bundle for the Jan 2011 change but I have a quesition: will the bundle be automatically updating all memorised invoices / bills? We have c. 1000 memorised invoices and bills which we had to update manually last time. A NIGHTMARE as you can imagine...

We commissioned an independent developer to develop an App for us for a bank file upload tool which can be used for BACS I think. His email is ken@omegaMinus.com in case anyone wants to contact him.

I think that's standard netsuite workflow. You can work round it by using a pageInit script to set them to blank when type = create.