Best Of

Hi @User_XJTDZ, printing Sales Order number in Statements is not yet available (see SuiteIdeas: 166706). I am seeing some users use custom fields instead. Some use workflow to copy the value from Created From to the field, then printing it via custom field.

Make sure your custom transaction body field Applies To> Print on Statement is checked.

On the Statement, the tags would look like this:

Hello @Javier P. ,

We occasionally issued credit memo under the circumstance you mentioned. What we do is setting up an "Other Charge" item with proper G/L accounts (suggest to consult with the accounting team for this).

We set up an "Adjustment" item and use that for non-inventory related transaction. Below is a screenshot of what the credit memo would look like using the item code:

Below is the G/L impact for the above transaction. The G/L impact could vary depending on the item setup.

Hope the above helps.

Here is the code I used in the screenshot, I find it easier and faster to check searches using browser console. Just press F12 on any scriptable records in edit mode and change the filter of the internal ID to a sales order that has inventory details.

require(['N/search'], function(search) {

var transactionSearchObj = search.create({

type: "transaction",

filters:

[

["internalid","anyof","15603"],

"AND",

["inventorydetail.inventorynumber","noneof","@NONE@"]

],

columns:

[

search.createColumn({name: "line", label: "Line ID"}),

search.createColumn({name: "item", label: "Item"}),

search.createColumn({

name: "inventorynumber",

join: "inventoryDetail",

label: " Number"

}),

search.createColumn({

name: "quantity",

join: "inventoryDetail",

label: "Quantity"

})

]

});

transactionSearchObj.run().each(function(result){

console.log(result.getAllValues());

return true;

});

})

I hope this helps!

Hello User_4BBKV

What business problem are you trying to solve?
What do you need that NetSuite does not already provide?
Do you already have a list of requirements/business gaps?
I know you said you are in Australia do you have the OneWorld version?

Have you considered business process change instead of purchasing additional software, if NetSuite handles what you need…

Have you searched Customization>SuiteBundler>Search & Install Bundles for NetSuite Platform Solutions Group or several other terms…(payable, Bill, etc) for options.

Or look in SuiteApps>… I first search for Oracle NetSuite solutions. If you see something that will solve your business issue, discuss with your account manager (some might be included)

If you still need to look for a different solution… my advice is if a product has BOTH the features you are looking for AND a "delivered" integration to NetSuite.

Using a 3rd party integrator can work if someone in your organization is already familiar with it.

Building a custom integration is my LAST choice.

Interested in which way you go. Best Regards,

Hi Angelica

thanks for the SA reference.

the thought of solution is not working and has limitations. we will choose the scripting as guided by you. thanks for offering the help during the implementing the scripting solution. i have the refered SA ID will help us start.

thanks

Ahmed

Thank you @Angelica Mae Segador-Oracle!

Indeed, the fields were used in Workflows! :)

No Problem, did that!