Hi guys,
If I run a query on the OCRD table, I can view three balances: foreign currency [BalanceFC], system currency [BalanceSys], and some other balance that seems to duplicate the system currency.
All I want is the BalanceFC field, but what I've noticed is that it only returns the balance until the point in time at which the BP account changed from FC to multi-currency (MC).
Part of me understands this - how does SAP know what FC to return if it's a MC account? But at the same time, if I go to Modules -> Business Parterns -> Business Partner Master Data -> Account Balance, there is a regular, up-to-date FC column with a correct balance for that same BP (in GBP, i.e. just the one FC).
So my question is, can I view the same FC figures in the Account Balance view when running a query on BalanceFC field?
Thanks for any help!
James.