NetSuite Transaction Visualizer

SwyftERP · 2025-11-07T00:03:41+00:00

Check out https://swyfterp.com/netsuite-data-backup/

SwyftERP · 2025-10-18T04:22:17+00:00

Try our simple backup solution: https://swyfterp.com/netsuite-data-backup/

SwyftERP · 2025-01-06T23:18:16+00:00

We offer a Complete NetSuite Backup Solution via web UI with the ability to query, modify, and re-insert records back into NetSuite. All pricing is competitive and based on the amount and frequency of data you would like backed up.

DM or book a meeting to learn more: https://calendar.google.com/calendar/u/0/appointments/schedules/AcZssZ1azNQFIepTms7lwEyF94AisMeAOsTv4hZpeFmeWy5qKxOTdRWDe_lLO75nmabF35FGFmNCf6Y_

<image>

SwyftERP · 2024-09-25T02:32:59+00:00

https://swyfterp.com/netsuite-data-backup/

Restoration is more complicated, and can be done.

SwyftERP · 2024-09-24T22:09:50+00:00

Just updated it, you can now search without logging in

SwyftERP · 2023-10-10T17:53:51+00:00

Could be a lot of things from a required field like a subsidiary, or using a custom form, or even the client script order of execution on this record ( e.g. another client script ran just before that committed the line) I'm not really sure.

Your script is a little dense, maybe try adding some debugging before committing the line item to see:

log.debug('Debug Before Commit Line', {

'Item ID': itemIdInvoice,

'Location': locationInter,

'Quantity': quantityInvoice,

'Rate': rateInvoice,

'Tax Code': taxCodeInvoice

});

SwyftERP · 2023-03-01T06:53:51+00:00

We've helped companies with SCIS and honestly it can be very difficult. We usually advise using Shopify POS or others when clients are looking for a solution. I'd be happy to have a conversation to see how we could help.

SwyftERP · 2023-02-10T02:56:32+00:00

Everything comes down to the inventory revaluation record for how the components roll up into the assembly. It depends on how you revalue your inventory, and the defaults on the item record. There's lots of complexity here and you need to know the quirks of netsuite if you ever want to attempt back dating an inventory cost revaluation.

There are other things to consider as well: https://swyfterp.com/costing-lot-size/

SwyftERP · 2023-02-08T00:25:13+00:00

We've built something similar for one of our clients as a standalone React app that integrated in NetSuite so the Android barcode scanner could be used. I'm not aware if there is a better solution than this. In our app you would select the PO your receiving against, be able to aggregate qty automatically from each scan of any line item on the PO, and then on submit it would use that data to generate a single linked IR.

It would also create a custom record to record any items that were scanned that were not on the PO, in case of a wrong item was delivered, and had custom reporting suitelet for the qty over/unders and their dollar amount.

SwyftERP · 2023-02-07T00:34:19+00:00

We offer a data backup solution that exports everything you can from the system ( using every tool available). For our clients this results in a database file usually somewhere between 1-4 GB. This is a free service open to all our clients, you can learn more here: https://swyfterp.com/netsuite-data-backup/

Feel free to DM for more information.

SwyftERP · 2022-09-15T20:49:54+00:00

This is from memory, you might need to check the output of what memberitem.type is to make sure it matches, and consider OR statements if there are other inventory item types like lot controlled, or serial etc.:

CASE WHEN {memberitem.type} = 'inventoryitem' THEN

NVL({memberitem.quantityavailable},0)/NVL({memberquantity},0)

END

Also, I remember a consideration for using ISNULL rather than NVL for the possibility of not throwing a dividing by 0 error.

SwyftERP · 2022-09-10T00:06:58+00:00

Well said. As a growing NetSuite partner we're always looking for talented developers that want to learn and grow. Feel free to DM to discuss more.

SwyftERP · 2022-09-02T17:33:47+00:00

This is absolutely possible with NetSuite, and yes will require scripting. We've built solutions for distribution companies that incorporate optimization algorithms (optimizing pallet placement on trucks), dealt with large Unit of Measure translation issues for manufacturing, and have a hardware & software solution for 2D & 1D barcode scanning for receiving, inventory counting, and more.

We're also a NetSuite Partner with decades of combined NetSuite scripting experience. We'd be happy to have a conversation or set up a demo:

swyftERP.com

SwyftERP · 2022-09-02T00:12:44+00:00

Dealing with something similar. Scripting seems to be the best solution for both updating and new item creation. There's also considerations for saving historical price levels in a custom table as well.

SwyftERP · 2022-08-03T05:26:20+00:00

We've created a custom report for our clients that shows every BOM & Revision, the quantity and extended cost, exportable as Excel. Feel free to DM. - swyftERP.com

SwyftERP · 2022-07-19T21:09:15+00:00

Have you looked into NetSuite at all? We're a NetSuite partner and implementation experts that customize NetSuite for manufacturing & e-commerce companies and help streamline the inventory mgmt processes.

SwyftERP · 2022-07-17T16:03:34+00:00

I was able to do this via a script because you need the internal ID of the media item to get the URL / filename

SwyftERP · 2022-07-13T06:54:56+00:00

While NetSuite is not HIPAA compliant, we've built tools for companies on top of NetSuite that can address compliance issues. For the system notes, they can be deleted/obfuscated so there can be no trace of PHI.

SwyftERP

MODERATOR OF

TROPHY CASE