Hello Everyone
Can anybody help me to solve the e...
# suitescripts
Sonu Kumar
03/28/2023, 6:53 AMHello Everyone
Can anybody help me to solve the error that I get when
I try to
Transform a sales order into an invoice but an error occurred i.e you must enter a calendar date into date fields
I have tried all the stuffs like
Transform the date into an appropriate form
create the date date object
But still encounter the same error.
need help to resolve this
Thanks in advance.
b
battk
03/28/2023, 7:23 AMwhat does your code look like
battk
03/28/2023, 7:23 AMand what error do you get
s
Sonu Kumar
03/28/2023, 7:27 AMMy Code is just searching sales order whose status is pending billing
and transform the sales order into invoice
and it is working okay for most of the order but for some order
I encounter error i.e
"You entered 'null' into a field where a calendar date was expected.\\n Please go back and change this value to the correct date"
t
Tyn Guardian
03/28/2023, 7:30 AMcan you display your code, where you are setting fields for invoice?
s
Sonu Kumar
03/28/2023, 7:33 AMHere is the part of the code
var soToInvoiceRec = record.transform({
fromType: record.Type.SALES_ORDER,
fromId: soId,
toType: record.Type.INVOICE,
isDynamic: true
});
log.debug({
title: "soToInvoiceRec",
details: soToInvoiceRec
});
var objectDate = new Date();
var day = objectDate.getDate();
var month = objectDate.getMonth();
var year = objectDate.getFullYear();
var dateString = month + '/' + day + '/' + year;
log.debug({
title: "Test Date created : ",
details: dateString
});
var parsedDate = format.parse({
value: dateString,
type: format.Type.DATE
});
log.debug({
title: "parsed Date || Typeof : ",
details: dateString + " --||-- " + parsedDate
});
soToInvoiceRec.setValue({
fieldId: 'trandate',
value: parsedDate,
ignoreFieldChange: true
});
var invoiceId = soToInvoiceRec.save({
enableSourcing: true,
ignoreMandatoryFields: true,
});
log.debug({
title: "invoiceId",
details: invoiceId
});
b
battk
03/28/2023, 7:52 AMthats not the usual error you get for setting or not setting date fields
battk
03/28/2023, 7:52 AMdisable workflows and user event scripts associated with invoices and try again
s
Sonu Kumar
03/28/2023, 7:54 AMokay I will try then inform to you in the channel
Sonu Kumar
03/28/2023, 8:22 AMtried but same error encountered
Sonu Kumar
03/28/2023, 8:45 AMany other solution ?
b
battk
03/28/2023, 8:51 AMmy general recommendation would be to stop setting the ignore related parameters
battk
03/28/2023, 8:52 AMif that doesnt work, try billing the order in the ui, any fields you have to set in the ui are field you have to set in script
s
Sonu Kumar
03/28/2023, 8:53 AM"stop setting the ignore related parameters"
What it means can you explain please.
b
battk
03/28/2023, 8:54 AMignoreMandatoryFields
battk
03/28/2023, 8:54 AMignoreFieldChange
battk
03/28/2023, 8:55 AMignoring field change means to stop telling netsuite you set a field
battk
03/28/2023, 8:55 AMignoring mandatory fields can hide the more helpful error messages
s
Sonu Kumar
03/28/2023, 8:56 AMokay thanks I will work on the updation that you explain
and thank you very much
for helping me 🙂
30 Views