That suiteanswer is for a custom body field. I need a way to do that for suitelets. I can get it to work but I can't reference dynamic text (e.g. transaction id) for each row. Instead, it prints the same value

Option B

Sorry, correction: it is returning an error:

Hi I just tried it and it is still returning a blank where the name should be

False

Thanks @Patrick Fresnosa-Oracle I was looking to define the actual costs as being vendor bills or expense reports paid. While committed costs would be purchase orders or vendor bills pending approval. Is that possible with the profitability reports?

Thanks @Patrick Fresnosa-Oracle Is there a way I can see what transaction types make up this figure? And how it is defined? e.g. all expense claims; approved purchase orders, etc

option c

True

Thanks @Manoj Bolinjkar That is helpful. I was after a way to see what the committed costs are for transaction spend against a project (purchase orders or unapproved vendor bills for example). So far, it seems that a lot of the functionality around project budget tracking seems to be based on labour (e.g. estimated hours…

Thank you @Manoj Bolinjkar It looks like the number I had entered was excessive in terms of how many months were budgeted. I tried using 18,000 and that worked.

Thanks @Manoj Bolinjkar How did you do that? how were the project task start and end dates entered?

Thanks @Clarisa De Torres-Oracle Given that the tax code is only available on 'purchase transactions' , I can assume that the account code showing the 'sales account' will not be relevant or used since the tax code won't ever be used on a sales transaction (since it can't be). thanks

Hi @Judith Culanding-Oracle This is the bill payment screenshot: The vendor, bank account, subsidiary, etc part of it has been cropped since the only relevant part is the applied sublist and payment amount. thanks

Hi @Judith Culanding-Oracle No, the purchase history tab is not custom. I just realised that is the name of the tab on Accounts Payable roles. In the administrator view, it is just the transactions tab The field, 'amount remaining' is a standard field. There is no custom field with that name in this account: This is the…

Hi @Judith Culanding-Oracle The sublist is create from the vendor record and 'customise view' from the purchase history sub tab. The results tab has the fields: Document Date Document Number Type Amount Status Amount remaining thanks

Hi @Alex Joves -Oracle Thanks for the steps. The type would be 'Bill Payment' though and not bill. I wanted to see how much of a bill payment is unapplied. Thanks

option b

HI @Judith Culanding-Oracle There is an unusual sequence of events. A bill was entered for $36,046.77 A bill payment was created for the same amount. a user edited the original bill so that it was $35,057.06. This altered the amount applied of the bill payment to $35,057.06. leaving $989.71 unapplied. when creating a saved…

Hi @Alex Joves -Oracle Those enhancements don't appear to be related to my question. I was after the amount remaining as unapplied on a bill payment. That is definitely available on a saved search: The question is: how do I set up a custom field to pull that figure in the red box on a bill payment record.

Hi @Ayitah Tallada-Oracle What would be the use case to link a real bank account to the type "credit card" in NetSuite? That wouldn't serve any practical purpose. i.e. if you have a bank account set up as a credit card account in NetSuite, that suggests you have set up your NetSuite GL account incorrectly. Why would that…

Hi @Ivy Lopez-Oracle any updates on this?

Option A

Actually, I got it to work on customer payments when I tried again. The record join for the customer was on customer(payments and deposits). Not sure what happened the first time I tried that.

Option C

I would suggest using a reputable partner to do the implementation @m ramana They would provide the templates and carry out the set up in accordance with best practice. Trying to implement NetSuite yourself will be costlier in the long run since it isn't just a case of doing a few basic set up tasks and getting it wrong is…

true

true

@chnayak I have not used this myself, but this tool, Salto, looks like it is designed to help with deployments to track versions. It is designed to work with NetSuite It's also compatible with Git: Maybe try reaching out to them and requesting a demo?

EDIT: Please Disregard. I found the answer. It was not sourcing the bank details internal id correctly on the before submit action on the script. This meant the bank details set on the record, under the UI, was being reset to 'blank' since it was not sourced correctly by the script which was supposed to set the value