Claytonm_21949 Red Ribbon

Searching google, i was able to find this: http://blog.prolecto.com/2016/09/25/accept-credit-cards-without-a-netsuite-web-site/

j.j i mean the webstore search, the one at the top of our netsuite webstore. that customers use to find parts. Not the internal netsuite global search that employees use

Well, I guess it depends a lot. I don't know how they supply the file. Let's say they place the file on an FTP server - well, you could have a Web Services process monitor that FTP and as soon as the file is there, the WS process starts feeding it into NS. However, if there isn't a way for you to ping and check if the…

Depends on what your updating. For pricing updated. We created temporary "future price" price levels. Then it takes a few days to import all the pricing into the future price. But then when its time to go live we use the swap price levels function and we get the new pricing live quickly. The File is a daily inventory feed…

Well a scripted solution would have a 5 MB file size limit, so that doesn't look like a good avenue. Doing an integration using either Web Services or RESTlets might be an option, slowly eating up the file, but this requires development cooperation with the Vendor. what type of cooperation? you mean cooperation further…

How big (in Mb) is the file? the biggest one is about 39MB, but if you break them down into 16 smaller files for 25000 rows each for csv import, each file ends up being 2-3MB

I just tried something else that seemed to be more accurate, but still has a lot of holes in it. I did a line-level transaction saved search of invoices within a certain date range (last month). i had columns for "amount" and "estimated cost" of each line item on each invoice, and a last column that was an equation that…

Well if you're seeing 0-cost Inventory Items, you have a much bigger problem than commissions. If like you say you have 0 cost because the item was never purchased, then you're selling items you don't have stock for. Which is physically impossible, but the problem here is going to be serious accoutning issues. You have…

There is another way. From the cash sale, click refund. On the refund record, set the line item to zero, but put a dollar amount in for the item. Yes, NS accepts this type of line. So, if it defaults the refund to... [CODE]Item Quantity Rate Amount ----------------------------------------------------- Brass Widget 4 $5…

I saw the following bit of information on cybersource's website (my credit card merchant) Answer As a general rule, a successful authorization is typically valid for 3 to 10 days after it is issued. This time frame varies widely, and can be more or less than this range, as it is dependent on the credit card issuing bank as…

Create a Return Authorisation, then upon receiving the item there's is a line item option called 'Restock?' un-check this and the quantity on hand will not increase. Finally transform the Return Authorisation into a credit. When i try that, its asking me to setup a "write off" account. Why would it need to "write it off"…

Alison, its just the way we always did it with quickbooks before we got netsuite. It might need adjusting now that we have a different system. Is there any way that between the date that the sales order funds are "authorized" and the sales order amount is actually charged to the card, that the funds could no longer be…

Why are you billing the Sales Order to create an Invoice, only to turn around and pay that invoice with a credit card on the spot? First off, I thought Invoices were primarily for situations where you don't have the payment in hand, whereas Cash Sales are to receive payment immediately. Even if you were billing the Sales…

as long as the payment is categorized as a credit you can go to Transactions>Customer>Issue Customer Refund to accomplish this. You need to un-apply the customer payment from the invoice so it shows up as a credit. ah, i didnt know that. Thank you Clay

You can simply close the order (or delete the invoice) and then issue a refund to the customer. how do you issue a refund without an invoice?

You can do a saved inventory item search and and just show available inventory. We use this frequently. I did this, made a saved search that sums the value of the cost multiplied by the available qty for each item in inventory But the only time frame this report can be viewed over is "Current" ... its a live snapshot. What…

the existing code looks like this: $POservice = new NetSuiteService(); $POsearch = new TransactionSearchAdvanced(); $POsearch->savedSearchId = "708"; //Search internal ID $POrequest = new SearchRequest(); $POrequest->searchRecord = $POsearch; $POsearchResponse = $POservice->search($POrequest);

Our partner Epiphany helped us write this formula in a sales order report since this is the only transaction that links actual income to actual cost. Formula (Percent) Maximum Round to Hundredths (sum(DECODE({applyinglinktype},'Order…

Hi; I struggled with a similar issue recently. The thing is that the report will include anything that hits income accounts in the G/L. Not only sales transactions. I created a transactions search that includes cash sales, credit memos, invoice, cash refund, ccard refund, check, credit card, customer deposit, customer…

It was a while ago, but I believe so. Maybe rounding level differences. What field did you use for "date"? Because if you use "date" then it only counts invoices that were CREATED in the date range, it wouldnt count invoices from the previous time period that were paid this time period.

You could probably just change the format of today to be the same by using To_Char({today}, 'MM/DD/YYYY') and then do your calculation. I didn't test the formula but I just used that function to put my date field in the format I needed. using the to_char() function causes an error, i think that can only be used in text…

k_dunk thats not exactly what i was looking to do. I was more interested in finding single-line-item orders that met some further criteria to determine if an order would be ideal for dropshipping However, upon further reflection, it would be more appropriate to say "if all line items on an order have the same preferred…

It's not wholly possible, no. Commitment is affected by what becomes available through stock modifications. That means any and every transaction that affects your stock levels can affect commitment. That's a long list of possible transactions. You would need to place an after submit script to execute on every single one of…

Using the INSTR function you can easily do a formula like that. Basically INSTR returns the position of the substring you are searching for or 0 if it's not found so the following would work. CASE WHEN INSTR({memo},'Call Type:Unt 2') != 0 THEN 'Sales Call' WHEN INSTR({memo},'Call Type:Unt 1') !=0 THEN 'Customer Service'…

i think i didnt explain the question well enough. I have a report that shows a value. "value of available inventory" but its a "snap shot" style report. It only shows whatever the value is at the current moment. How would record that statistic over time? for example, what was the value of available inventory 30 days ago?…

Is there a way to tell what date an order becomes fully comitted? meaning...the date that all items on a sales order show fully committed?

For committed, I use a summary criteria filter of 'Quantity Committed' >= 1. This also captures partially committed. If you only want fully committed lines, you could set up a filter for 'Quantity' - 'Quantity Committed' = 0. For date tracking, we use the 'Ship Date' field -- the date the order is supposed to ship. It…

Is there any way to bring the "SUM" function into the formula itself? or is the summary type drop down the only way to get a sum?

A date field can be converted to show the day by using a formula(text) field in your results: Try Formula (Text) --- to_char({createddate}, 'day') --- for the text day Thanks, That worked perfectly, thank you!

Hello, I need some help with a CASE Statement I'm writting because you cannot get the total weight of a package in an item fufillment or sales order. My syntax must be off becuase I get an invalid expression result. CASE Statement: sum(CASE WHEN {item.weight}*{quantity}<.81 AND {trackingnumbers} LIKE'%1ZT7%') THEN 1 ELSE 0…