Hi All,
I am adding custom address in open sales o...
# suitescripts
suryaprakash598
04/09/2020, 7:45 AMHi All,
I am adding custom address in open sales order
soRecord.setValue({
fieldId: 'shipaddresslist',
value: -2
});
var subrec = soRecord.getSubrecord({
fieldId: 'shippingaddress'
});
subrec.setValue({
fieldId: 'country',
value: 'US'
});
When i try to get tax it is getting 0 and once order is placed i am able to get tax
When i read, Your new subrecord is saved at the time you save the record.
is there any way to get tax in open sales order with this custom address
Thanks
b
battk
04/09/2020, 7:51 AMtry dynamic mode
s
suryaprakash598
04/09/2020, 7:52 AMYes i am using same
var soRecord = record.create({
type: record.Type.SALES_ORDER,
isDynamic: true,
defaultValues: {
customform: 110,
entity: customerID
}
});
b
battk
04/09/2020, 7:53 AMone of NetSuite's nicest help topics is about address transactions and tax calculations
battk
04/09/2020, 8:05 AMif you are using SuiteTax, you can use record macros.
s
suryaprakash598
04/09/2020, 8:39 AMI have tried with snippet provided in first link
but i am getting 0 as response
suryaprakash598
04/09/2020, 8:40 AMrecord = {object}
arguments = {array} length=6
salesOrderRecord = {dynamic record}
shippingAddressSubrecord = {dynamic subrecord}
taxtotal = {number} 0.0
b
battk
04/09/2020, 8:42 AMsuitetax?
s
suryaprakash598
04/09/2020, 8:59 AMWe are not using SuiteTax
b
battk
04/09/2020, 9:01 AMAdvanced Taxes?
s
suryaprakash598
04/09/2020, 9:02 AMWe are using Advanced Taxes
b
battk
04/09/2020, 9:04 AMwhats the taxcode and taxrate1 of the line?
s
suryaprakash598
04/09/2020, 9:22 AMDo we need to apply taxcode with script? We are not using that line
suryaprakash598
04/09/2020, 9:22 AMLet me try with adding tax line in script
b
battk
04/09/2020, 9:26 AMtax code supplies the tax rate on the line
battk
04/09/2020, 9:26 AMno tax code no tax
battk
04/09/2020, 9:27 AMthat said, there is a lot of native functionality on automatically determining the tax of the line
battk
04/09/2020, 9:27 AMif the item line is supposed to be taxable but netsuite is not filling in the tax
battk
04/09/2020, 9:27 AMthen something is wrong with the tax setup
s
suryaprakash598
04/09/2020, 9:32 AMThank you @battk
I will check with tax setup
suryaprakash598
04/09/2020, 2:45 PMi have checked with tax setup and taxcode applied in line level and tax got calculated but when but now i am getting wrong tax
suryaprakash598
04/09/2020, 2:46 PMi placed item which is having default taxcode and when address added then that code is changing in item level
suryaprakash598
04/09/2020, 2:46 PMwhere changed tax unable to get in dynamic mode
suryaprakash598
04/09/2020, 2:46 PMany help in this case please
b
battk
04/09/2020, 2:50 PMstill sounds tax setup related
battk
04/09/2020, 2:51 PMnetsuite automatically selects the tax code by a zip code lookup
s
suryaprakash598
04/09/2020, 2:55 PMYes once i keep address then taxcode is getting changed
suryaprakash598
04/09/2020, 2:55 PMbut i am unable to get updated tax where iam getting previous tax value
suryaprakash598
04/09/2020, 2:57 PMiam getting value at last of all operations but still iam unable . can i get any help to receive original tax
b
battk
04/09/2020, 3:01 PMwhat does your current code look like
s
suryaprakash598
04/09/2020, 3:03 PMlet me share the snippet
suryaprakash598
04/09/2020, 3:07 PMsoRecord.setValue({
fieldId: 'shipaddresslist',
value: -2
});
var subrec = soRecord.getSubrecord({
fieldId: 'shippingaddress'
});
subrec.setValue({
fieldId: 'country',
value: 'US'
});
subrec.setValue({
fieldId: 'city',
value: ''
});
subrec.setValue({
fieldId: 'state',
value: ''
});
subrec.setValue({
fieldId: 'zip',
value: ''
});
subrec.setValue({
fieldId: 'addr1',
value: ''
});
subrec.setValue({
fieldId: 'addr2',
value: ''
});
subrec.setValue({
fieldId: 'addressee',
value: ''
});
soRecord.selectNewLine({
sublistId: 'item'
});
soRecord.setCurrentSublistValue({
sublistId: 'item',
fieldId: 'item',
value: Number(itemsArr[io].internalid)
});
soRecord.setCurrentSublistValue('item', 'price', -1);
soRecord.setCurrentSublistValue('item', 'rate', itemsArr[io].price);
soRecord.setCurrentSublistValue('item', 'amount', itemsArr[io].price);
sublistId: 'item',
fieldId: 'quantity',
value: 1
});
soRecord.commitLine({
sublistId:'item'
});
soDetails.soTax = soRecord.getValue({fieldId: 'taxtotal'});
b
battk
04/09/2020, 3:11 PMare you setting a real address
s
suryaprakash598
04/09/2020, 3:11 PMyes
b
battk
04/09/2020, 3:12 PMwhat state and zip
s
suryaprakash598
04/09/2020, 3:13 PMArizona 85281
suryaprakash598
04/09/2020, 3:14 PMi tried with UI , when i added item it is getting one taxcode and when i add the address then it is getting changed
suryaprakash598
04/09/2020, 3:14 PMand i tries with script iam getting previous tax only
b
battk
04/09/2020, 3:25 PMis this an existing customer with a preferred shipping address?
s
suryaprakash598
04/10/2020, 2:48 PMNo
suryaprakash598
04/10/2020, 2:49 PMOnly for that order we are using this address
b
battk
04/10/2020, 2:51 PMthen i dont know what you are describing
battk
04/10/2020, 2:52 PMthere shouldnt be a previous tax code if there is only 1 address
battk
04/10/2020, 2:53 PMespecially if you are setting the address before the items
s
suryaprakash598
04/10/2020, 3:05 PMThankyou @battk