I am working in MVS 2005. I am writing a report and I am unsure how to create a conditional statement within this module.
What I want to do is to vary what table I populate a field with dependant on specific criteria.
I have a gl transaction table that holds all of the transactions that hit our gl. When the posting is an AP transaction I want to populate the description field with the vendors name from the vendors table. When the transaction is from the AR module I want to populate the description field with the customers name from the customers table.
If gl_transactions.source_module= AP
gl_ gl_transactions.source_reference =venders.vendor _number
If gl_transactions.source_module= AR
gl_ gl_transactions.source_reference =customers. customers_number
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.