The SuiteQL query below returns all customer invoices issued in the past 30 days. SELECT Transaction.ID AS Invoice, Transaction.TranID AS InvoiceNumber, Transaction.TranDate AS InvoiceDate, Transaction.Entity AS Customer, BUILTIN.DF( Transaction.Entity ) AS CustomerName, Transaction.OtherRefNum AS CustomerPONumber, TransactionLine.CreatedFrom AS SalesOrder, BUILTIN.DF( TransactionLine.CreatedFrom ) AS SONumber, Transaction.Employee AS SalesRep, BUILTIN.DF( Transaction.Employee ) AS SalesRepName, Transaction.ForeignTotal AS TotalAmount, REPLACE(… Continue reading suiteQL query to get invoices by a date range
Tag: Invoices
Grouping Invoices with Sub-Customer Reference on Child Invoices
If NetSuite Invoice Grouping is being used, and each Invoice being grouped has different customers, all of which are sub customers of the same parent, the Invoices cannot be grouped – even if that parent is paying on their behalf. All Invoices in the proposed group must have the same customer populated in the native… Continue reading Grouping Invoices with Sub-Customer Reference on Child Invoices
Manual Invoice Closing using Journal
To manually close an open invoice when it is certain that the remaining amount will not be received from the customer, a Journal entry can be used. The Journal entry will involve crediting the Accounts Receivable account and debiting the Revenue account, essentially reversing the impact of the original invoice. Subsequently, the created Journals will… Continue reading Manual Invoice Closing using Journal