Journal image format?

Hello-
Our Accounting department requires a hard copy of receipts for the audit trail.
I'd like to write a utility to print all the journal receipts.
The database field is in the Journal table and is called ReceiptCompressed.
I have extracted an entry but cannot determine the file type. I've tried unzipping it, viewing it as a TIFF/BMP/JPG/GIF.
The header is ZIP01PK which made me think it is compressed using ZIP but that didn't work either.
Any thoughts how to extract and view these database entries?
Thank-you!
Jassen
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

My first thought is to tell the accounting department to go pound sand (or something slightly more diplomatic). Explain to management why this is extremely wasteful and tedious. Maybe you can convince them there is another solution.
You aren't going to be able to extract the images like you think. What I suggest is you develop a report (can pull data into Excel or another format to get exactly what you want). You can pull every line item from every transaction and get all of the data they could ever want. If they want to view it in a nice friendly format, tell them they can audit the report to the journal viewer at their convenience and save a tree. Don't let them tell you there is some sort of legal requirement. It is an internally developed procedure, probably by an old-school CFO who does not trust electronic records.
Sorry - overly harsh on our bean counting friends. But in the end, you aren't going to get anywhere extracting the register receipts unfortunately.
Now, if you MUST do this, the solution I have used is to use a keystroke macro program. I was able to "manually" print every receipt in a "reasonable" amount of time for an overzealous auditor who apparently did not know how to use a computer. I hit ALT-F12 hundreds of times to print a series of receipts from a time frame required. It was not fun, but it did the job.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
I am trying the plan B as you suggested. At this time the Accounting department doesn't trust the sub-ledger. I will try again! Your post made me laugh. Considering we are just about to finish our first physical inventory with RMS a laugh is a great thing. Thank you!
Jassen
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Jassen, The format of the data in the Journal table is XML. XML that is encrypted and compressed. The plain-text equivelant is just the RMS Receipt template with the variables replaced and loop unrolled.
We have created a tool for decompressing/decrypting the journal then renders it into an image. If you need more information, please drop me an email and we an discuss.
--
Thank you,
Ryan Sakry
  Click to see the full signature.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
We had a similar requirement - after I told them that the printer was a thermal printer and that THEY would have to photocopy all the receipts - so that it could be kept for x number of years, we never heard back from them. But I like "the pounding sand answer better" - good for you Jassen.
Dan

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Hi Ryan, I'm using QSRules to create a transaction and journal entry and it requries to have ReceiptText (in XML i think). So, I'm very excited knowing that yo u have a tool to decrypt the ReceiptCompressed field into XML. Please conta ct me at snipped-for-privacy@beehexa.com. I would love to here responses from you. On Wednesday, October 7, 2009 at 1:03:00 AM UTC+7, Ryan wrote:

d

te

ers

and

t
ed

t
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

BeanSmart.com is a site by and for consumers of financial services and advice. We are not affiliated with any of the banks, financial services or software manufacturers discussed here. All logos and trade names are the property of their respective owners.

Tax and financial advice you come across on this site is freely given by your peers and professionals on their own time and out of the kindness of their hearts. We can guarantee neither accuracy of such advice nor its applicability for your situation. Simply put, you are fully responsible for the results of using information from this site in real life situations.