Hey there.
We're working towards extracting the transaction data out of Dynamics SL to be used in a Oracle Hyperion.
I've successfully written the query out of Dynamics to give me a list of all the Transactions - no problem. This data matches the transactional data coming out of Dynamics/Trial Balance - win.
Hyperion would prefer to have the "Net" value of each transaction, not separate columns for Debit/Credit.
Is there a way to know if an account is normally a debit or credit account such that I can calculate the "Net" value of the transaction?
Do you have any guidance in this area? - Or have some sample SQL code to help?
Would appreciate any direction you may have.
Thank you.
Mike