Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
AE: ODBC amortization schedule of transactionline
I have a Journal Entry with status "APPROVED FOR POSTING CREATED FROM AMORTIZATION SCHEDULE"
I do see Amortization Schedule numbers in the "SCHEDULE NO." field of lines.
Using ODBC connection I try to find a connection between transactionlines table and AmortizationSchedule table.
In the Records Catalogue it says the join is:
transactionLine.amortizationsched = AmortizationSchedule.id
But in the transactionlines table the amortizationsched field is empty.
I found amortizationScheduleRecurrence table, there is a jounal field, but no line field.
I need to know how to I get an amortization schedule to each LINE of Journal Entry.
Please help.
0