Best Of

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!

Hi @KevinWong

You could use the filling steps:

(1) Create a custom Created By field.

Type = List/Record.

Store Value = T.

List/Record = Employee.

Validation & Defaulting> Dynamic Default = Current User.
Save.

(2) Create a custom field Created By Email

Type = Email Address.

Store Value = T.

Source & Filtering> Source List = custom Created By

Source & Filtering> Source From = Email.

Save.

Then you can pull the send field onto your report.

HI @Nicole Mendoza-Oracle,

Great! I'm finally on top of it. I really appreciate your help with this matter.

Many thanks,

Edo

Hi @Elina Kourouzidou

Yes @Patrick Fresnosa-Oracle is correct, Pls check your NS license

NetSuite Advanced Financials brings additional financial management functionality. It includes budgeting, expense allocations, and amortization, and statistical accounts.