This SuiteQL query returns the invoices to which a customer payment was applied. SELECT Invoice.TranID AS InvoiceID, REPLACE( BUILTIN.DF( InvoiceMainLine.CreatedFrom ), ‘Sales Order #’, ” ) AS SONumber, Invoice.OtherRefNum AS CustomerPO, PTLL.ForeignAmount AS AmountPaid FROM Transaction AS Payment INNER JOIN TransactionLine AS PaymentLine ON ( PaymentLine.Transaction = Payment.ID ) AND ( PaymentLine.MainLine = ‘F’ )… Continue reading suiteQL query to get the customer payment application details
Tag: payment
Resolve Error: “Cannot process determined Credit operation…” When Processing a Refund
Scenario When entering a Customer Refund for a credit card from the following scenarios: from a Credit Memo record and only the card details are entered but not the P/N Ref. number; as a Standalone (e.g. from Transactions > Customers > Issue Customer Refund) where P/N Ref. is not provided; or any situation where a refund is entered without a P/N Ref. number The following error… Continue reading Resolve Error: “Cannot process determined Credit operation…” When Processing a Refund
Payment Document saved search and get Applied to Invoice fields
Requirement: We have a transaction saved search for type = ‘Payment’ and we are able to get all the information needed with the exception of Applied to Invoice field. Tried Applied to, Originating Invoice fields and no result. Is this a limitation or is there a way to get Applied to Invoice information for the… Continue reading Payment Document saved search and get Applied to Invoice fields
Remove Discover Credit Card option on Web Store
Oftentimes, users encounter issues on their ordering process by having the “Discover” Credit Card option displaying on their Web Store. Solution On NetSuite UI Navigate to Setup > Accounting > Accounting Lists On the Filters section, select Payment Method from the Type dropdown Click on the Discover payment method record On the Payment Method record… Continue reading Remove Discover Credit Card option on Web Store
Payment Notification to Customer Contact
Map/Reduce Script to send the payment notification email for Billing Contact of Customer, using Merge template function. Script uses all externalized, searches, email templates etc. /** * @NApiVersion 2.1 * @NScriptType MapReduceScript * @NModuleScope SameAccount */ /************************************************************************************* Update tax item for customers * Description : Map/Reduce Script to send the payment notification email for Billing… Continue reading Payment Notification to Customer Contact
Resolve Error – Please select payment method when an Expired credit card s used in Suitecommerce Advanced
Scenario: Shoppers who possibly used an expired credit card will not be able to place their orders in the webstore. The only way to checkout is to update the card’s expiration date. Solution: Navigate to Commerce > Web Site > Web Site List Click Edit on the web site you need to change and navigate… Continue reading Resolve Error – Please select payment method when an Expired credit card s used in Suitecommerce Advanced
Adding custom fields in Bulk Payments Page
The Payment Processing page can be customized. You can add up to six standard or custom transaction fields. This enables you to view more transaction details, to help you to prioritize bills for payment. This can be done by the administrator. To add custom transaction fields: Go to Customization > Lists, Records, & Fields >… Continue reading Adding custom fields in Bulk Payments Page
Expense Report not Showing on EFT Bill Payments Page
Scenario There are instances when an Expense Report does not show on the EFT Bill Payments Page even after it has been Approved. Solution An Expense Reports will shown on the EFT – Bill Payment* screen when the following conditions are met: The Company’s Payment File Format and the Employee’s Payment File Format are the same The A/P Account set in the EFT – Bill Payment Page and in the Expense Reports are the… Continue reading Expense Report not Showing on EFT Bill Payments Page
Resolve Error: “Posting and non-posting discounts/markups are not allowed on the same transaction”
Scenario: While creating sales order with a markup item as well as a discount item. Error throws “type”:”error.SuiteScriptError”,”name”:”USER_ERROR”,”message”:”Posting and non-posting discounts/markups are not allowed on the same transaction”. 2. When we try to apply promotion in a sales order from webstore/netsuite where we are adding a markup item also through script. Solution Consider a salesorder… Continue reading Resolve Error: “Posting and non-posting discounts/markups are not allowed on the same transaction”
How to add pay now button for making payment in the My account invoice.
Created a new extension as invoice pay now button and extend the view and template . Added the button in the template and created the pay now button. Stored the link in a variable and passed the link to the button. Made the invoice ID dynamic by getting the invoice id and stored in… Continue reading How to add pay now button for making payment in the My account invoice.