I need a script to list all PO numbers for a specific range of accounts code. The script is used for inventory valuation.
Grateful if anyone can help.
Please, if this reply is late; just ignore it
The following SQL select statement assumes that you know the charge/inv. valuation natural accounts and natural account segment is 2:
select po_num, authorization_status, closed_code
from PO_DISTRIBUTIONS_INQ_V a
where destination_type_code = any ('INVENTORY', 'EXPENSE')
and a.code_combination_id in
(select b.code_combination_id from GL_CODE_COMBINATIONS_V b where segment2 = any ('170702110', '720201000'))
'170702110', '720201000' are sample natural accounts