I have recently started a new job with a company that uses Pegasus Opera II. I am now getting to grips with the database and am looking at historical debtors' reports (available, the 'Help' tells me, in Opera III). I can create a 'live' query that replicates the debtors' report in the base currency but am struggling to find where, if anywhere, Opera II stores the equivalent amounts in foreign currency, where applicable.
Can anyone enlighten me please? Any help acknowledged and appreciated.
Related resources
Replies (3)
Please login or register to join the discussion.
Hi HJE
I can see FC data in there but to get aged debtors I would need to be in sales ledger. The base currency is stored in a file something like sl_hist, (I'm not a work so cannot check). However this does not appear to include any FC data.
OperaII S/L Foreign Currency
We use Opera II but don't use foreign currencies. However in 'stran' there are a number of fields which start with 'st_fc...', have you tried these (st_fccurr, st_fcrate, st_fcdec, st_fcval, st_fcbal, st_fcmult) might help to get you started.