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.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Packing slip refuses to print - SQL query with Billing Schedule related error
advanced pdf packing slip will not print - nor can it be edited without throwing the following error
NoticeUnexpected Error:
java.sql.SQLException: ORA-00904: "BILLINGSCHEDULE"."KFREQUENCY": invalid identifier
https://docs.oracle.com/error-help/db/ora-00904/BAD SQL STATEMENT:/* Start: SQL for Machine: item, Type: itemship */
SELECT
tranline.nId line,
tl2.kDoc orderdoc,
tl2.nId orderline,
….etc (huge sql query). Have raised a ticket but wondered if anyone had seen this error before?
0