Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Getting Installments collected in Payment using SuiteQL
Hi , I am trying to prepare a report that would retrieve all the Sales Invoices along with its Payment Schedule linking those installments to the Payment details (Apply Section). The business team wants an export for all the collected amounts to identify patterns in the past as of a certain date. Our schedule per customer can span more than a decade, so tracking collection history is critical.
I found that the Sales Invoice schedule is stored in the VendorBillInstallment ! (but I couldn't figure why) , Anyway I couldn't find any way to link the TransactionLine (for Payment Screen Apply ) to the VendorBillInstallment