Angela Bayliss · Senior Solution Architect · Silver Crown

well, neither were bins until I asked them nicely to uncover them.

Hi Sig, I see references to Job's within the customer table. Have you checked there?

Hi Carrie, You can try using the report at reports-customers-payment history by invoice. In the columns, you can remove all irrelevant columns, but add in "date due" and "date closed." You can also add in the customer info like address, name, etc. In filters, show only transaction type = invoice. you can also narrow down…

not under the vendor record, but easy enough to do in a report/search. Not the answer I bet your looking for, though.

Good Morning Luke, I noticed this late friday, and again yesterday when I was trying to finalize our physical inventory count. I did not file a case, I just worked around it, as time was quite limited. What I was (and still am) seeing is this: on a transaction search, using the criteria of serial number, I get no results.…

For the record, my searches are going haywire this morning. They keep returning with "No Search Results Match Your Criteria."- but yet I know they are there. I have been having to go in manually via customers and item records. Not sure if this is just me, but it is really weird....

yes, under filters, you can find closed date in the folder "payments by invoice" (in the history by invoice report). This will give you the option of a date range that the invoices are closed- ie paid or credited. remove the invoice dates in the filter, this will give you all invoices closed, without also restricting the…

For the record, never automatically assume I am right.....;) I went back in to check on this, and now it seems it is getting even better.... if I do an unrestricted advanced transaction search- only criteria is serial, it pulled the item fulfillment. Hey, it's a start. :confused: the problem is, related to this specific…

This is making me mental. LOL- welcome to the rest of us. Have you tried, reports-accounts receivable, payment history by invoice? THis will let you pull specific information as to payments made, as well as show the payment method. good luck.

agreed- finding information in the tables is an exercise in itself. I can tell you that I was unable to find transaction totals in the transaction table- I had to go into the transaction lines, and sum them to get the transaction totals. Not exactly the easiest way, but at least it is possible. ;)

Hi there, Two part question: we have net suite limited and don't have the commission module, but we use some of the sales order report by sales rep. However, we only want to pay out commissions once we have been paid (pay on pay). How could we modify one of the existing reports so that we pay out commission only once we…

I am not sure I understand. My statements clearly show payments as well as invoices. How are you booking the deposits?

try this: Reports-Inventory-Inventory Activity Detail-customize add a filter for the following-Quantity on hand-transaction type- long name=credit memo. You can add in dates, etc if you like, it may do the trick for you. good luck

Not in my world. The payment method is just blank until I pick one, and there's no warning at all if I leave it blank. The payment is applied correctly, but we'll never have a clue how it was paid. I can hardly believe it does this, actually - and will be calling Support to ask if there's an issue logged for it already.…

the payment method is viewed in the payments transaction, if the information has been filled in at the time the payment was received. It is not a mandatory field. In Crystal, look in the transactions or transaction lines table, (or both) make sure you are pulling transaction type=payment. Also, you may want to check in…

Would it not be easier to do a search on this field being empty? That way, you get your results, just without so much work involved.

you mean has anyone made an income statement in CR using ODBC for Netsuite? I make exec level reports in CR, Im still learning, but I have a decent grasp on it.

If you go into a Sales Order, and then go into the History tab, and then the Fulfillments & Invoices tab, you can see the lifecyle of your order - the fulfillments it had, and the invoices. Great. Now, is there a way to get this information without having to go into a specific SO and clicking the history tab? Obviously,…

This can be had via the ODBC, haven't figured out a way to do it via Netsuite. Also noticed that Credit Memos aren't linked in that history tab. I always thought that was weird. How right you are. I have done it in CR via ODBC. However, I assumed he was looking within Netsuite itself. I missed the CM info- wow, that is…

what happens if you add an account or several ?. then you have to modify n number of layouts ?. no ?. Im not a fan of modify financial statement layouts due to the maintenance aspect of it as well as potential for including or exluding accounts you do/dont want. Messy. Totally in agreement with Ray. Causes a residual mess…

I was afraid of that. I have not been able to do this. I have, however, been able to get a list of transactions (restricted to fulfillment, invoice, and SO), that are then sorted by date. Once I run the report, I can resort by customer name (will then subsort by date), that groups all of the linked transactions together.…

Evan, you are such a handy guy to know. Thanks for this info, its helpful to many of us, I am already modifying it for what I need.

Angelika, If you have the coffee on sunday morning, I can also help you with this- If it isnt raining, even earlier (I'll skip my walk on the beach with my dog). I plan on stopping in before noon. Angela

I don't see this in my system. I e-mail reports all the time, and there does not seem to be a default set- yes, there is a list of customers, also of vendors, employees and partners. I would imagine that there should always be some care taken when sending reports out. Completely removing the ability to send reports to…

Hi Guys, I have created these reports by using the item profitability report, and filtered by preferred vendor. If you use preferred vendors, it is rather slick. good luck!

wow- I thought it was just something I did - I figured I was getting them as an admin plus a report creator. Did a little checking, and my sales guys confirmed that ours all run this way as well, and gave me an earful about how annoying it is. Anyone submitted a case?

has this been addressed, or is it still a manual process? (please please please)

Any hints/errors when using Crystal? I am a new user and am assuming that any errors I am coming across are user...

Good Morning, Your question is a bit hard to answer, and here's why: There are many elements of Order Fulfillment in Netsuite that can be configured that will directly impact the ability to 'Fulfill' sales orders. For example, there are preferences found at Setup- Accounting- Accounting Preferences that control commitment…

Landed Costs are added to the item receipts or the vendor bills. They won't show up on outbound (sales) fulfillment's. Take a look at SuiteAnswer ID # 11114. It provides a great overview. Good Luck! ~angela