How can I find which general ledgers my products are linked to?

How can I find which general ledgers my products are linked to?

Below is a query for you to run in your Database that will give you the Product Name, Product Number, and GL Number.

SELECT t_product_company.product_name
	,t_product_company.product_name_number
	,t_gl.gl_number
FROM t_product_company
JOIN t_category ON t_product_company.category_pk = t_category.category_pk
JOIN t_gl ON t_category.gl_id = t_gl.gl_id;

Related Articles

How do I get database access to CrunchTime?

What Prevents a General Ledger Account From Being Deleted in Enterprise Manager?