3956409 Green Ribbon

Thanks, I didn't have this sample code and will try it.

Any update on this issue #394232?

Thanks for the confirmation.

Yes, I'm looking into that and will post an update.

Yes, let me provide some more details. The goal is that our AR dept. wants to send a deposit invoice to the customer. We've customized the SO approval workflow to add approval buttons for 3 separate depts. Clicking the custom "[Dept.] Approval" button will check a corresponding custom approval box on the SO. After all 3…

I can create a custom field, but the native Status field will still need to be Pending Fulfillment before we can invoice.

I'm looking for this too.

Hi, We have been working with this module for quite a while with different customers and never had any issues. It is very important that when you import your assets that everything ties. Anything that might be off, for example last depreciation period, will cause errors in the amount that is being depreciated. After…

Does entering a start date also solve an issue of having to change the date field on a billing schedule for it to invoice a new sales order correctly? [ATTACH=JSON]{"data-align":"none","data-size":"full","data-attachmentid":428376}[/ATTACH]

Is the "New Unit Cost" field from an Inventory Cost Revaluation record available to display in a saved item search results? The internal ID is {unitcost} but it's not listed.

Thanks. I did search for "Customer" in Report Builder and added various fields. I also tried Entity. But none of them are pulling the data that shows under "Customer/Project" on the vendor bill.

Thanks for the suggestion. I ended up creating a new Transaction saved search to match the existing report. I added the Name field to display the data showing on the vendor bill.

Thanks for the suggestion. I might try a Portlet Script of type HTML or List.

I was informed by NS that it's an enhancement: Enhancement # - 72177 Summary: Home > Dashboard > Trend Graphs > Ability to select a specific date range for Trend Graphs.

Thanks, I was trying to show all 12 months of a year. An alternative could be to make the columns quarterly.

Thanks, it looks like a useful article. I'll try it out.

Thanks, how is this custom date field used for reporting?

We have this same issue. Can anyone figure it out?

Thanks for the quick response!

I don't know if this will solve your problem - but you can create a custom field that sources from saved search results. Keys being to not store a value on the custom field and to filter the search by the fulfillment internal id. Netsuite Help is decent for how to set it up. Can someone please provide a link for the help…

I have a Transaction saved search with this criteria: Type = Sales Order Main Line = False It includes a column for "Applying Transaction : Document Number" that shows related Invoices and Item Fulfillments to the SO. This is causing duplicate lines in the search results for each item on the SO. I only want to see the…

I'm looking for a very similar report. Our sales are tied to the related purchases via lot numbers.

We were thinking of creating a custom item field for Total Cost. This would be the sum of two other custom fields for Standard Cost and Shipping Cost. Could the Item Defined Cost field be used for this sum?

I've been trying to add coding to the Advanced PDF/HTML Template for a Packing Slip to display sequential line numbers. Below is the outcome. Has anyone solved this? {item.line} Numbers show as 0, 3, 6, 9, 12, etc. {item.linenum} Blank {item.linenumber} Blank {item.linesequencenumber} Blank

Is this now possible?

Did you have any luck with this?

Thanks for the screenshots. I have it working now too. The next phase is to net out SO's that were closed during the month. I came up with the formula below but the tricky part is that the closed SO's are dated before the current month. My search has date criteria to look at this month. So it filters out the closed SO's if…

I'd like to show the amount of sales orders with a certain status because later I'll exclude other SO's based on different criteria. I'm trying to use a Formula (Currency) field in my transaction saved search results as follows but it's only showing 0 values: CASE WHEN {status}='SalesOrd:A' THEN {amount} ELSE 0 END…

I did that and the value shows Pending Approval, which I then replaced 'SalesOrd:A' with in my case statement but it's still 0 instead of the SO amount.

This is slightly off topic, but I've noticed that the system never keeps me logged in for the full time specified under the timeout preference. It's usually half or less.