Angela Bayliss · Senior Solution Architect · Silver Crown

after checking this out, I think I may have found a possibility. The "type" of role seems to matter when trying to view these buttons. It seems that the "sales" and "marketing" roles do not see this button, but "accounting" and "shipping" do- when the exact same settings are applied in the role. You may want to confirm…

Not very clear on what you need here- are you trying to apply payments in the system to invoices you created, or are you trying to link checks written to bills entered? Once you use the write check function, and the check exists in the system, you cannot enter a bill against it. Write check is independent of enter/pay…

Thanks, Evan, you are wonderful. Works like a charm. Angela

We do this all the time, but use a non posting, exchange account. the exchange account should always net to zero, so is relatively easy to manage.

be very careful of using th "full access" permission- this allows users to delete things- will give your accounting department fits- totally skews the audit trail. I sent you an e-mail about this- please check your e-mail.

You CAN, however, write a check, place the amount to an exchange account, then immediately write a vendor credit from the same exchange account, this credit can be used to apply to future bills. ;)

The exact script I am using is: (client Side) function setCreditLimit() { if (nlapiGetFieldValue('creditlimit').length == 0) nlapiSetFieldValue('creditlimit','0') alert('Setting credit limit to 0'); } I think what I need is to set the credit limit if it is blank ONLY. I am trying to catch up and enforce these holds today,…

It seems I am running into a block here- when implementing this script, it is fouling up established customers by resetting their credit limit to zero, each time a salesman opens a customer record. What we want is to set new customer records to zero. arrggghhhh

allrighty then. When you added the permissions to the roles, did you add them with "View" "Edit" or "create" priveleges? If it is "view" thats you problem.

immensly. Makes perfect sense. I sincerely appreciate your patience and help with this. I have seen you- no weight loss is necessary- dont want to risk a good strong wind blowing you away. was worth a shot anyway :D

this one works well, with some testing. Thank you, your assistance is very, very much appreciated. Angela Bayliss

well, what do you know----- how cool is that. Evan, you need to tell your boss that you need a raise- you are worth your weight in gold to us out here. Thanks - you seriously rock!

LOL- you gotta let us know how that works out for you. can you give me a brief explanation of the difference in server script vs client? My stodgy accounting brain is having issues wrapping around that.

The alert came up, but the credit limit is still blank....no errors though, thats a good thing. My result that I am aiming for is this: we are implementing the enforce credit hold function next week- while I do not want to impede sales, we do not want sales roles to be able to modify the credit limit field. I have two…

Hi Ray, It merges the entity- they will still be customers and vendors, but transactions to both entities appear on both transaction tabs- this isnt so bad, if you understand what your looking at. However, when you start making JE's to offset, it really misleads you by listing the JE twice- it still seems to maintain the…

yes, we have run into this as well, but never got an answer back- was sent on an e-mail case. This is very important- should not be an enhancement- the idea that product can be shipped to someone who cannot be billed is a major thing- what gives, ns- was this designed that way?

Good Morning, Steve, When invoices are created from Sales Orders, and utilize fulfillments, you are not able to simply change anything on the invoice that is dependent on the other sides of the transactions. If you think of the entire cycle as a circle, Quote-Sales Order- Fulfillment- Invoice- each step, while it is…

well, dont have time to check and see if this is a setting difference, but we have a tab on each customer record, labeled "info"- on that tab, there is a field called other relationships. from here, you can make a vendor record that is linked.

From a Netsuite perspective, this is relatively simple- all you have to do is either set up a discount (for the rebate), or an actual item called rebate. On your CM's, you can then credit them for their rebate. You can also set this up for advertising, however, from an accounting perspective, be very careful. Rebates are…

You asked several questions- let me take them in order- What kind of item should the rebate be- This is up to you- one way is to set it up as a discount. However, discounts are typically used on the actual billing invoices, not as credit memos that stand alone. Another way, (for ease of accounting) is to create a service…

credit limits-my accounting brain loves these. :D For JMP-there is a simple script that can be used to prevent orders from being entered if they exceed the credit limit. However, if the credit limit is blank- it won't pick up to block the save. There is a script that can automatically set all new customers to zero credit…

Sorry, Guys. I tried, but didn't work. I find I don't know how to deploy it. I saved the script as a new user event ( there is not client side now, I don't know if this is the right choice), then applied it to "customer", "Sales order". Then I deployed it to all users. Nothing happened. Is there anything I missed? thanks…

Hi, Matt I found out this problem in my testing too. If you go through the Estimate step, nothing will stop you from the flowing steps. In our current system, we set up COD customers as credit limit $0. So they have to pay before we fulfil it. For the new customers, only our A/R can enter the customer in the system. The…

Thanks Angela Are you able to give me the script to do this? I don't know how to write the script and I don't have a programmer here. Jane It's here, somewhere in the UG, the guys in here gave it to me. Well, they gave me one of them, and I was able to reverse engineer the other one. HA! found it! amazing what that search…

A custom field may do the trick. Place it on the invoices, as well as source it into a bill payment list, and- depending on the person paying the bills paying attention, should work.

Ok, so I just read through this entire thread, and after going on a tangent, we are finally back to the core of the issue. I have the following situation: Sales Orders Default to "Pending Fulfilment" Enforce Credit Limit/Holds on Sales Orders Credit Hold placed once Customer reaches 30 days overdue The issue I have is that…

Nope, but will give that customer a credit limit of $0.00 which means they cannot save a Sales Order to them. You need to create a form that is the preferred for the Sales staff, and then the standard form is for Accounts staff only. The Sales form has the credit limit fields uneditable - that stops it... A bit messy, but…

Hi, I might be missing something here, but we are in 11.0.6 for now and we have a similar credit hold issue that I just need someone to clarify, because we seem to be setup correctly, but it makes no sense... Customer has a $1000 credit limit. Auto hold is on, and no overriding is set up for anyone, anywhere. Salesman A…

After spending quite a bit of time on this, I think I have figured out what is happening, and am hoping someone can confirm this for me. Cash sales are only happening when the customer has a credit card entered into their customer record. Is this correct? If so, can this be set to not default to a cash sale?

Angela, for the benefit of us non-accounting types :o .....what is an "exchange account"? Thanks, Cecelia An exchange account is simply a type of holding account. Since accounting must have debits and credits in equal balance, an exchange account is used to allow the offsets. For example, in my use as outlined above, it is…