Hello, does anyone know if it is possible to creat...
# suitescript
n
Hello, does anyone know if it is possible to create a
Transfer
using SuiteScript? I'm trying to create a new transfer whenever a new item fulfillment is created
s
I dont think
Transfer
by itself is a thing,
transfer order
,
bin transfer
, or
inventory transfer
are all things, and I don't see why you wouldn't be able to make them. Did you try?
n
In the NetSuite UI, under
Transactions > Bank > Transfer Funds
it creates a transaction type just called
Transfer
. This is separate from a transfer order, bin transfer, or inventory transfer.
👍🏼 1
s
I would check if it is in the
record.Type
enumeration, if it is it is likely scriptable.
n
s
Theres also
SuiteScript Supported Records
that page in the help
n
I did not see a transfer type in the enum. if I look at the xml of the record I can see the recordtype says
transfer
.
Copy code
<nsResponse>
<record recordType="transfer" id="10886854" perm="4" fields="_eml_nkey_,_multibtnstate_,selectedtab,nsapiPI,nsapiSR,nsapiVF,nsapiFC,nsapiPS,nsapiVI,nsapiVD,nsapiPD,nsapiVL,nsapiRC,nsapiLI,nsapiLC,nsapiCT,nsbrowserenv,wfPI,wfSR,wfVF,wfFC,wfPS,type,id,externalid,whence,customwhence,entryformquerystring,_csrf,wfinstances,dbstrantype,bulk,createddate,lastmodifieddate,periodclosed,allownonglchanges,taxperiod,version,voided,linked,linkedrevrecje,linkedclosedperioddiscounts,entityname,trantypepermcheck,ntype,excludefromglnumbering,transactionnumber,tranid,fromaccount,frombalance,toaccount,tobalance,basecurrency,prevdate,trandate,postingperiod,ppsetbyuser,ppsetbyuservalue,pp_s,pp_e,oldtoaccount,oldfromaccount,fromcurrencyname,fromcurrency,fromexchangerate,tocurrencyname,tocurrency,toexchangerate,exchangerate,exchangeratehidden,currency,fromamount,oldfromamount,toamount,oldtoamount,memo,cleared,cleareddate,cleared2,cleareddate2,subsidiary,department,class,location">
<_csrf>
Gofm3EPdIWtViZhI74tBJhjOd26eMqB2ZgsZdpj3dtOulDtm1I7XRNpdYoyoT9FhRs0xrRz5xXOwP9-kfGfRAywMp-oO813HDxaxtf_m8X6nujO44wtGYcJmRTCOfomr4GsR45o5TO4Ach1Qp4QuxxO6-rTg_nQvqr3rM-W9dEo=
</_csrf>
<_eml_nkey_>4231331_SB1~8~3~N</_eml_nkey_>
<basecurrency>1</basecurrency>
<cleared>F</cleared>
<cleared2>F</cleared2>
<createddate>7/29/2021 10:16 am</createddate>
<currency>1</currency>
<dbstrantype>Transfer</dbstrantype>
<department>2</department>
<entryformquerystring>id=10886854&xml=T</entryformquerystring>
<exchangerate>1</exchangerate>
<exchangeratehidden>1</exchangeratehidden>
<excludefromglnumbering>F</excludefromglnumbering>
<fromaccount>718</fromaccount>
<fromamount>47.78</fromamount>
<frombalance>0.00</frombalance>
<fromcurrency>1</fromcurrency>
<fromcurrencyname>US Dollar</fromcurrencyname>
<fromexchangerate>1.00</fromexchangerate>
<id>10886854</id>
<lastmodifieddate>7/29/2021 10:16 am</lastmodifieddate>
<linked>F</linked>
<linkedclosedperioddiscounts>F</linkedclosedperioddiscounts>
<linkedrevrecje>F</linkedrevrecje>
<memo>test</memo>
<nsapiCT>1627571545597</nsapiCT>
<ntype>2</ntype>
<postingperiod>256</postingperiod>
<pp_e>8/1/2021</pp_e>
<pp_s>6/28/2021</pp_s>
<ppsetbyuser>F</ppsetbyuser>
<prevdate>7/29/2021</prevdate>
<subsidiary>1</subsidiary>
<toaccount>723</toaccount>
<toamount>47.78</toamount>
<tobalance>9939.91</tobalance>
<tocurrency>1</tocurrency>
<tocurrencyname>US Dollar</tocurrencyname>
<toexchangerate>1.00</toexchangerate>
<trandate>7/29/2021</trandate>
<tranid>TRN01</tranid>
<transactionnumber>TRANSFER1</transactionnumber>
<type>transfer</type>
<version>1</version>
<voided>F</voided>
<machine name="glimpactchanges" type="list" fields="creationdate,transactiondate,transactiontype,transactionkey,transactionnumber,transactionurl,changedby"/>
</record>
</nsResponse>
Seems odd that there is no way to create a Transfer record programatically..
I don't see a way using SuiteScript, SuiteTalk, or the REST API.
w
I don't think you can create or copy them. You can search and load them with type "transfer".
n
Is there an alternative means to programmatically move funds between accounts?
We have a requirement from the business to transfer funds from one account to another as items ship
w
If they are non-bank accounts, you can use a journal (which can be scripted).
👍🏼 1
104 Views