Extraer Fecha de Facturación de la Tabla de Programas de Facturación mediante ODBC

Se aplica a

Producto: NetSuite 2025.1

Escenario

Un usuario está intentando extraer la tabla Billing_schedule en ODBC.

Solución

Unir transacciones y tablas Transaction_lines y utilizar la columna Date_closed.

Ejemplo:

SELECT
TRANSACTION_ID,
DATE_CLOSED AS DATE,SUM(AMOUNT_FOREIGN) AS AMOUNT
FROM
TRANSACTION_LINES
INNER JOIN
TRANSACTIONS
ON TRANSACTION_LINES.TRANSACTION_ID = TRANSACTIONS.TRANSACTION_ID
WHERE
TRANSACTIONS.TRANSACTION_TYPE = 'Sales Order'
AND ACCOUNT_ID IS NOT NULL
AND TRANSACTION_LINE_ID != 0
AND TAX_TYPE IS NULL
AND ITEM_COUNT != 0
AND DATE_CLOSED IS NOT NULL
AND
(
DATE_CLOSED BETWEEN TO_DATE ('2011/01/01', 'yyyy/mm/dd')AND TO_DATE ('2019/12/31', 'yyyy/mm/dd')