Best Of

I saw that article as well and how I had found that putting an Income account there it would make the Rev Rec field available to set.

We were just trying to figure out why we used to be able to and now we can't so will now have to go with a different approach during our migration.

Thanks for your help!

Hello @Ivan Babiichuk,

Good day.

Per checking similar cases raised with NetSuite Support, the Last Inventory Count Date is not supposed to be modifiable via Script and even if you are able to modify it, it could be subject to change and stop working anytime. In this case, you will be advised to use a workaround which would be to use a custom field instead.

I hope this helps.

No. The last count date is set based upon the last inventory count transaction. It cannot be modified by scripts (and shouldn't be). This field is designed to report accurately for audit purposes. If it were editable, inventory counts wouldn't be reliable.

~angela

Hello @CK Job ,

With a multi-location inventory setup, a location will always display the cost for the specific location, not the group average cost.

To understand this better, let's say you have an item fulfillment out of location 1 for the remaining 4 units at a sales price of $5.00 each. The gross profit for the order would be ($5-$4)x4 = $4, not ($5-$3.83)x4=$4.68.

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
};

});