Best Of

User_XMFHV

Not sure what your business need is, but if it is a list bills that are not paid, does the Open Bills report help?

For future transactions, leaving the Vendor name off the Journal Entry the A/P Aging Summary and your custom A/P Register by Vendor would sort them to the top. 🤷‍♀️ I realize the Vendor Name on the journal entry is invaluable so you would have to decide the trade off.

Not sure about this one, & it would only be a go forward potential solution…. but… if you have a sandbox or development environment, you could test creating an Accounts Payable Adjustments account and use it for journal entries instead of the Accounts Payable "control" account. This may not help because I see SuiteAnswer 7764 says "This report combines data from all accounts payable accounts and offers more display options than the register."… again 🤷‍♀️

Hope someone has a better solution.
Best Regards,

Hello @dle_35705, thank you for posting your question in the NetSuite Support Community!

Try this navigational path instead:

• Setup > Manufacturing > Manufacturing Preferences > Product Execution section

Hello @Nicole Mendoza-Oracle - This code works for one client perfectly. Is there any issue with feature. Could you please verify it.

Thank You

/**
@NApiVersion 2.x
@NScriptType ClientScript
@NModuleScope
*/
define(['N/record', 'N/currentRecord'], function (record, currentRecord) {
function fieldChanged(context) {
var rec = context.currentRecord;
var sublistName = context. context.sublistId;
var sublistFieldName = context.fieldId;
if (sublistName == 'inventory' && sublistFieldName == 'item') {
var location = rec.getValue({
| fieldId: 'adjlocation'
});
log.debug('location', location);
rec.setCurrentSublistValue({
sublistId: 'inventory', fieldId: 'location', value: location, ;
})
rec.setCurrentSublistValue({
sublistId: 'inventory', fieldId: 'adjustqtyby', value: parseFloat(1)
});
}
return {
fieldChanged: fieldChanged,
});
};

Script answer:

/**
* @NApiVersion 2.x
* @NScriptType ClientScript * @NModuleScope SameAccount */define(['N/currentRecord', 'N/log'], function(currentRecord, log) {

function fieldChanged(context) {
var rec = context.currentRecord;
var sublistName = context.sublistId;
var sublistFieldName = context.fieldId;

if (sublistName === 'inventory' && sublistFieldName === 'item') {
var location = rec.getValue({ fieldId: 'adjlocation' });
log.debug('location', location);

rec.setCurrentSublistValue({
sublistId: 'inventory',
fieldId: 'location',
value: location
});

rec.setCurrentSublistValue({
sublistId: 'inventory',
fieldId: 'adjustqtyby',
value: parseFloat(1)
}
}

return {
fieldChanged: fieldChanged
};

});

Hello @Dext3r,

This is possible with scripting.

You can use the code we worked with in the discussion thread below as your reference.

I hope this helps!

If you find this reply to your question useful, others might as well. By clicking the “Yes” button for “Did this answer the question?” below, you’ll be able to help the community members who might have a similar concern find the answer easier and you will also get closer to earning your next Answer Accepter badge.