Jump to content
  • 1
Gavin Hargreaves

Cashbook Extracter

Question

Good afternoon folks.

 

Accountant has asked if there is away to pull out accounting cashbook for full business year, rather than printing out archived cashbooks for the whole year, and adding them up. OGI have given me a quote for the software, but I don't know whether this is the solution. Has anyone got the software?

 

I'm clueless with database enquiry as well despite using system since 1993!!!

 

Any help would be greatly appreciated.

Share this post


Link to post
Share on other sites

2 answers to this question

Recommended Posts

  • 0

Hi Gavin - good to see you on the Forum

 

Without knowing what software OGI have suggested I probably can’t answer your question fully - so apologies for a bounce back on this - but it's important ...

 

1 -

Ask OGI what software they are suggesting / name of

2 -

Ask if it will produce every cashbook for the last year in one go, without doing each one individually (I'm interpreting that that is one of the main issues / pains you have)

3 - 

Ask them to show you the format / example output you will get - and whether you will have to do any work on that output file to get what your accountant needs

 

All too easy for suppliers in general, to offer solutions without fully understanding the actual pain, the real requirement and, the best alternative options for comparison - so you need to be fully informed. I’m sure I’m closer to what you need (from your brief post) than your supplier in full conversation -#maybe 

 

Come back and let us know once they provide the info and we can go from there. If they have the right solution for what you need out of the box, I think every OGI Broker will want it ...

 

PM / Mail me if you prefer - happy to assist / advise further

 

Mis-sold cartoons, Mis-sold cartoon, funny, Mis-sold picture, Mis-sold pictures, Mis-sold image, Mis-sold images, Mis-sold illustration, Mis-sold illustrations

Share this post


Link to post
Share on other sites
  • 0
Use InfoCentre Select * From ic_brcledger Order By B@, Dt_Settled Select * From ic_brcashhist

 

Edited by GremlinIT

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Posts

    • Thanks @John Tasker   Bet that took some narrowing down   So - is that to do with the rendering process in OPM do you think - re order / time taken to render? Either way - good spot - and you may want to pass to OGI for a few $$££€€     (Hope you are well!)
    • I have solved this myself so I'll update this forum in case anybody else has the same issue and is looking for a fix.   On our print server, selected printer properties for the printer in question. Advanced >  Un-ticked the "print spooled documents first" and changed the spool settings to "start printing after last page is spooled".  
    • I doubt it - and I doubt anyone ever will - until someone comes a-hunting - or an-auditing  
    • Hi @Val interesting question    The bottom line is that in the OGI accounts system it is 99% impossible to have an incorrect entry - unless the system crashes in the middle of and accounts process - or there is a genuine system fault introduced (rare). Even then - it resets itself at Month End - with a Ledger Discrepancy. So. Unless youi have had a Month End discrepancy somewhere in the process the "correct" changes have been made to the journals / ledgers - although the result means an incorrect balance on the client in question. Just go and use that entry to offset against your clients record   The real reason why this is sometimes difficult to fix however, is that on OGI, you can delete transactions - and not leave an on screen trace that they were ever there. So. The balancing adjustment may have been against a transaction that is no longer on screen / on the ledger. This is why Batch Calcs may not work in this case - because it wont be there - let alone I suspect you wont have that software and as above, can be tricky to code up.   If you are not happy with just writing this off to fees (by creating a charge / negative charge) to balance the client account (which is what I would do), then you only have one other option - you need to find the original items - which will be a pain.   Either  Check the setting in Premium Finance which uses a "dummy" client account for offsetting errors Check the settings file and have a look at those records first If no joy, go through every cashbook since raising the original transaction and find ALL entries relating to the original record and / or dummy record It will be there - you just have to find it If you have and can use InfoCentre - that makes life easier - otherwise its a manual traaaaaaaaaaaaaaaaaaaaaawl.   Overall a bit disappointed - but not surprised - that OGI wont help. It's their Finance software after all - and they know how it would write off balances - and where / which ledger account it goes to and how to quickly fix - if they could be bothered. Poor show really ....   Anyway - Good luck and hope this helps   M    
    • Thanks Pete. The guys go into OPM where there is an ODC print queue for each day of the month. They select the date in question, then right click on the branch, Print and then Print. The default printer has already been set in the Open printer Selector so nothing to change or set in there.  They do each branch in turn. Attached refers.
×
×
  • Create New...