Clay - we track this kind of thing thru a nightly saved search. Any SO that could have been fulfilled, but wasn't, is included in the email. Each morning, a clerk in our Quality dept investigates each one (typically it's one one or two), edits the SO, and chooses a drop-down field on the late line for the 'late reason'...…

Hm, im actually seeing a weird problem now. The formula field works fine, basically it looks like this Formula (numeric) - Summary Type: Maximum - max({quantityavailable})-sum(CASE WHEN {transaction.type} = 'Sales Order' AND {Today}-{transaction.trandate} < 60 then {transaction.quantity} else 0 end) so its showing the…

sum({field1})-sum({field2}) i.e. sum() is a valid function you can use within formulas Is there a list somewhere of all valid functions that can be used in those formulas?

Yep. On the email tab of the saved search go to the Recipients from Results subtab. Pick the Vendor:Email Address field (or Supplier:Email Address, depending on what terminology you use). This will send only the item records that belong to the vendor when you schedule this to automatically email. Is there a place to see a…

This might be due to a divide by zero error. Can you try adding NULLIF to your formula? Thanks, Thats exactly what it was, thank you!

Hm, im actually seeing a weird problem now. The formula field works fine, basically it looks like this Formula (numeric) - Summary Type: Maximum - max({quantityavailable})-sum(CASE WHEN {transaction.type} = 'Sales Order' AND {Today}-{transaction.trandate} < 60 then {transaction.quantity} else 0 end) so its showing the…

Thats exactly what it was, thank you! for anyone re-creating what i was doing, the corrected formula for column5 looks like this: (max(NVL({quantityavailable},0))-sum(CASE WHEN {transaction.type} = 'Sales Order' AND {Today}-{transaction.trandate} < 90 then NVL({transaction.quantity},0)/3 else 0 end))/(NULLIF(sum(CASE WHEN…

sum({field1})-sum({field2}) i.e. sum() is a valid function you can use within formulas That was exactly what i needed. thanks so much.

Ok I got rid of the Transaction Type Criteria, and added this result field Field: Formula (Numeric) Summary Type: Sum Formula: CASE WHEN {transaction.type} = 'Sales Order' then {transaction.quantity} else 0 end But this gives me the total sum that has sold ever. How would i modify the "case when" expression to say: CASE…

Clay, You can also get last sale date by doing a summary search. If you're starting with an item search, scroll down to the bottom of the fields listing where you'll see a listing of joinable records, represented by the record name followed by an ellipsis. Select "Transaction fields", and then pick Date. Set the summary…

You are right when the quantity is later committed it will not trigger the script on the sales order. There so many transactions that could impact this (item receipts, inventory adjustments, inventory worksheets, etc) that it would be unusable to catch all of these triggers on quantity committed. My suggestion would be to…

Right now i have a saved search for items that has a result column for "Available qty" and another column that is a formula field with a summary type of "sum" I want to make a third column that shows the difference between these 2 columns. If the two columns were regular fields, I would have no problem just making a…

The main problem with this is that you have filtered the search to a sales order transaction type, yet those items will have 0 sales orders. There is nothing to get the quantity from because no sales order transaction exists within that date period. What you can do is remove the filter for the sales order and use a DECODE…

My initial thought was to suggest playing around with the Line System Notes field through a saved search and use complex calculations to get the values you want but the Quantity Committed value cannot be accessed through them. This can be achieved through scripting. I'd suggest adding two transaction column date fields on…

I must not be doing it correctly. I created a new transaction body field Free-Form Text Clicked "Store Value" and "Global Search" applied it to "sales" and "item fulfillment" transactions went to validation and defaulting and defaulted it to {trackingnumbers} doesnt seem to be doing anything edit: to be more clear, its…

Not to get too far off subject... when you say "native bar code scanner" what does that mean? We want to start bar coding everything and use scanners during picking and or packing. We have looked at a number of Warehouse Management Systems that partner with Netsuite. You mentioned that your plan is to use the bar code…

have you tested bar code scanner? We found it slowed down packing large order and ended up not using them at all. Do you have small and large orders or are most the orders similar in size? We had tested using a 3rd part packing software from ozlink and not scanning directly to netsuite. I am not sure how a scann would work…

Do you keep accurate weights for your items? If so, you could script to compare the actual weight to the total expected weight, withing some tolerance. If scripting is the answer, then ill explore that route. Just wanted to see if there is some netsuite setting that addresses this or something.

That would require some custom scripting. If you bill or ship after packing, even if they only packed 1 of 2, they would only be charged for the 1 that was packed. In our model most of the orders coming in are from ebay, or an online store, so they have already been paid for before we even get the order.

You don't need the end of day manifest. We've been doing without it for years and if everything works just fine. BobG, my recent experiences disagree with yours. It seems as though you have been lucky, or your driver scans each package. The end of day manifest is not needed, IF the driver scans each package. However, if…

In re-reading your first post, NetSuite would not have caught the original error (a human error) because the quantity was complete in the fulfillment. Assuming you can get the bar code scanning to do what you want (adjust the qty on the fulfillment), then a 'before submit' user event would be pretty straightforward. Also…

We created a field used to show items fulfilled in house. We have a script that looks at every new order and checks the box if there are non-drop ship items on the order. On the fulfill orders screen we added a filter to only show orders that have that check box checked. So, this would only apply if you have an item setup…

well in the "setup > customization > transaction form PDF layouts section i created a custom bar code layout that has everything i need on it except for "receipt date" or "current date" and "po number" im printing the labels off of the PO so it should have access to that info, i just dont see it in the list of things to…

That would require customization. A live synch will be challenging. What is more common to see is a daily CSV import. Oliver, i appreciate the input. I would ideally like to automate the process as opposed to importing the csv file every day. There may end up being several locations that i want to sync inventory qty's from…

For current date did you try a custom element with {today}? For the PO Number, you can try {tranid} Evan, i tried that and they were blank on the label, almost like...the label creation link on the po doesnt know that its coming from a PO The {today} didnt output anything

I think you'll need to do a cost/benefit analysis on this. It will not be cheap. Each vendor will require slightly different integration channels, with each channel being rather expensive. A downgrade involving obtaining data files and doing a CSV import, even if that import is automated, will be exponentially cheaper. you…

Clay - you could upload the files (txt, csv) to a NS folder, and script it from there. That leaves you with just the manual task of uploading the file(s) to the file cabinet. If you wanted to fully automate it you could allow your vendors to upload through a suitelet, or with web services. ah, just saw this post, missed it…

You can most probably use scripting to create a customized pdf layout. Which might look something like this. http://s1337.beta.photobucket.com/user/swarajlegend/media/barcode_zps75a90be3.png.html Swarajg im talking about the item label bar codes that you stick on items in inventory to receive and fulfill with

also having the same problem and opened a case