Hi
New to OLE Exchequer - I have a report set up by my predecessor which imports General Ledger balances, which is great and works a treat.
However, I would like to be able to import nominal transactions (for a selected GL code) line by line - I know there is a drill-down in OLE but you can't copy from that into Excel. Using the fX/User Defined button in Excel I can see a list of Exchequer functions but I can't see one that would provide transactions.
Does anyone use OLE and manage to do this?
Thank you
Graeme
Replies (3)
Please login or register to join the discussion.
Have to use the Report Writer?
My knowledge may be out of date but in my day OLE only applied to balances.
To get transactions I went into the Report Writer and selected Document Detail (TL-type) transactions. Then output as CSV.
Transactional Reports not available via OLE
Evening
The only "list" type data available via OLE is: Customer/Supplier codes, GL codes.
Only balances are available via OLE.
If you would like help with VRW (training or writing reports), please do contact me for more information.
Regards
Elliott
Nominal save functions in OLE
Hi
Try EntAddNomTransfer or one of the variants if you are trying to create the nominal.
Otherwise you need to dump the transactions to a file - standard reports ie GL History will print to excel.
Brent