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
0
Jassen (3)
10/4/2009 2:41:01 PM
pos 14173 articles. 0 followers. Follow

4 Replies
710 Views

Similar Articles

[PageSpeed] 47

On Oct 4, 10:41=A0am, Jassen <Jas...@discussions.microsoft.com> wrote:
> 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 ReceiptCompresse=
d.
>
> I have extracted an entry but cannot determine the file type. =A0I've tri=
ed
> 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

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.
0
jason2290 (135)
10/5/2009 6:26:17 PM
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 
0
Jassen (3)
10/5/2009 9:05:03 PM
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
Program Manager
Retail Information Technology Enterprises
320-230-2288
rsakry@rite.us
http://www.rite.us


"Jassen" <Jassen@discussions.microsoft.com> wrote in message 
news:5414582D-FD2B-4CF1-968C-A2ED9DCC2DC5@microsoft.com...
> 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 


0
rsakry (322)
10/6/2009 6:03:00 PM
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
"Ryan" <rsakry@rite.us> wrote in message 
news:%23nI%23%238qRKHA.4568@TK2MSFTNGP06.phx.gbl...
> 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
> Program Manager
> Retail Information Technology Enterprises
> 320-230-2288
> rsakry@rite.us
> http://www.rite.us
>
>
> "Jassen" <Jassen@discussions.microsoft.com> wrote in message 
> news:5414582D-FD2B-4CF1-968C-A2ED9DCC2DC5@microsoft.com...
>> 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
>
> 

0
AliaS1 (93)
10/7/2009 1:55:28 AM
Reply:

Similar Artilces:

VPC Image of RMS
Is there a VPC Image for RMS? ...

Community bank's new software doesn't export in my format
I am still using Money98 which does all of the little tasks I need (no investments at my age). Two national banks provide exports in .qif format as a matter of course, but when my local community bank went to new (better) software, ".qif" was missing from the list of available export formats. I wrote the bank and received word that the bank's vendor didn't support Money98. The bank officer said: "My guess is the contract they have with Intuit and Microsoft stipulates they not support it as those companies want consumers to always upgrade their software.&...

outlook journals
Does anyone use the journal feature in outlook to jot notes down on a contact? I have used this feature and at some point I believe an archive has either deleted or hidden older notes in my journals. Any ideas as to if journal notes dissappear after a certain point or if the archiving feature in outlook does something to old journal entries? Any help is appreciated. Thanks, ...

Autoflow of images?
I'm designing a church directory, and the plan is to make changes to it periodically. Nine photos will be shown on each page -- three rows of three photos each -- each photo showing a separate family, with a caption below each photo listing the family's names. When a new family is added, I'd like to simply drop a photo in and have all the photos that follow (and their captions) automatically move one slot to the right (or down to the next row, or over to the next page, as appropriate). So, let's say this is the original layout of one page, each letter representing a ph...

Load image in a unbound control from a attachment field in recor
I have a unbound (single not continuious) form with 16 differant records from the same recordset. No problem loading the this data from recordset in VBA. PROBLEM I need to know how to load the unbound controls with Image's from an attachment field in another recordset The normal method of control = Rs!field does not work Please advise -- Thanks Tom dans l'article 78DC5502-3A76-4562-AA20-736446AB1448@microsoft.com, Tom � Tom@discussions.microsoft.com a �crit le 21/01/08 20:28�: > I have a unbound (single not continuious) form with 16 differant records from > the same record...

windows journal hangs/ freezes when scrolling down
I am using journal with win vista and 7. Each time when i scroll down a few page in journal, it will hand and not respond. THIS ONLY HAPPEN TO PARTICULAR FILES ESP WHEN THE FILE SIZE IS BIGGER THAN 1mb ...

formatting in outlook express
I produce a newsletter containing lots of different information and links. It is sent in html format using Outlook express. However if it is written using word then copied and pasted into an outlook email the formatting changes and becomes fixed so it can't be changed. If I send the email directly from word, the formatting seems to be lost. If I sue wordpad, then copy into an email it doesn't change the formatting and outlook will allow changes, but links don't work. Obviously this means the newsletters take a lot more time to prepare and are a lot of hassle. Any sugg...

Condition formatting based on other cells values
Hi. How do I format a cell with condition formatting based on other ceels? I have cell A1 and I want that this cell appears in red whenever B1 as bad written. How?? Regards, Marco I think this is what you mean - select A1 and Format | Conditional Formatting, then select Formula Is rather than Cell Contents from the drop-down in the first panel, and in the formula panel enter: =B1="Bad" Click on the Format button, then select the Patterns tab (for background colour) and select your colour. Click OK twice to exit these pop-ups. You can copy the conditional formatting to other ...

Journal
What does the Ck in Journal do? I know it is check but check what? Where are you seeing this? I just took a look around the Journal and didn't see a "Ck". -- Jocelyn Fiorello MVP - Outlook *** Replies sent to my e-mail address will probably not be answered -- please reply only to the newsgroup to preserve the message thread. *** "Linda Kay Alkire" <lalkire@absc.org> wrote in message news:2a2e01c36811$02b22d30$7d02280a@phx.gbl... > What does the Ck in Journal do? I know it is check but > check what? ...

Using Journal to record daily tasks
Does anyone know how to make new journal entry types default to "task" instead of to "phone call?" Thanks, Marti ...

formatting cells for dates
1041908351 is the numer of seconds of my record since 1970 using the formula = DATE(1970,1,1) + A1/86400 this converts it to 7/01/2003 2:59:11 AM -which is correct if I select this cell and copy,then paste special values I get 7/01/2003 2:59:11 AM what I want to do is to format the cell so just the 7/01/2003 is returned.I know I can delete the 2:59:11 AM from the cell and this will fix it,but I have a lot more cells to do if I select format cell and use the date/custom of dd-mm-yyyy it appears ok but when I double click on the cell it still appears as 7/01/2003 2:59:11 AM Any help appre...

Images and Excel Grids
Hi, I am creating a file from a web page with a .xls extension. The user wants an excel spreadsheet to contain product data, 1 item is an image. I want to have the image appear in the spreadsheet. I can have the image appear (i just use <img src="#ThisFileNameImageURLGif#" align="center" border="0" hspace="2">) and its inserted in the sheet. However I want it to stay within a cell and be lined up with headings and its own row of data. At the moment I get a load of images just "piling in" on top of each other How an i force the image to st...

time formats #3
I have an Excel sheet with a long list of times spent on various projects. The times should all be in minutes and seconds. The first time reads 2:29 and I know that is accurate, for 2 min, 29 seconds. In the formula bar, it reads, 2:29:00 AM. Another...the cell displays 0:40 and I know that is right, for 40 seconds. But in the formula bar, I see 12:40:00 AM I want numbers, but apparently I am looking at times. I tried changing the format. When I check the format for 2:29, it comes up Custom and says it is hh:mm, not mm:ss. I tried changing it to mm:ss, but that changes the displa...

MSCRM Reports Export format
Does anyone know if there is a way to export reports as Rich Text Format (*.rtf)? or exporting to a CSV? We have a customer that still uses Wordperfect, and exporting to an Excel or Word Doc may not be an option. ...

Help Journal Names
I use the Journal all the time to help track what I'm doing For journaling items such as excel files, and word documents, it would preferable to show just the name of the document rather than the full path to the document (which appears on mouse-hover anyway). My paths tend to be long, so the only way I can find the name of the document is to mouse over. Anybody know if there is a way to just display the document name - without the path information? Thanks for any advice. -- Dab Cut off: yourhead to respond ...

Formatting Cell Using Formulae....advise please....
I am trynig to understand how to format a column to use the "Proper" argument. The help example appears to be for one cell only I whould like say all first names and second names to start with capitals. I can't seem to set this up. I end up with either the formula showing in one cell or a circular error. I don't think I have to format each cell individually in a column? I would also like to know how to format a column so the when I press the letter Y or N it enters Yes or No as typed here? Any other suggestions how I can get to grips with the formatting ffeatures would...

Converting xls format to csv format
Hi, I am trying to convert excel file (xls format), which contains name and respective e-mailn ids, to csv format. My goal is to convert this excel file to csv format so that I can import all the e-mail ids in outlook using this csv file. But when I try to save this excel file in csv format it says "this feature is not supported in csv format". But I get a csv file with which I can't import those e-mail ids into address book. I don't know what is the problem. I used to do this earlier. But now it is not happening. Any help will be appreciated. Thanks in advance, Sri...

journal not there
Hi, Odd one. One of my users can't see his journal, it's enabled and logging things correctly as I can open it from my pc and see everything, and other poeple can also open it and view it. He can't see his journal on any pc if he logs in to it. He doesn't have a roaming profile. Any ideas? ...

Journal Viewer
Hi, couple of questions on Journal Viewer 1. How do I make the Lookup in Journal Viewer to default to Current Date only (right now the From date has a week old date by default) 2. How do I customize the list of transactions window on the journal viewer so it shows the amount too? Thanks a lot in advance!!!! Did you ever get an answer as to how to default the journal viewer to the most recent batch rather that oldest to newest? I want to know the same answer. "TCWS" wrote: > Hi, couple of questions on Journal Viewer > > 1. How do I make the Lookup in Journal Viewer...

Removing Windows Format 11 runtime
I have WIndows Media Format 11 runtime AND Windows Media Player 11 both showing up on the Add/Remove Program list. The Media Format 11 runtime shows that it is rarely used but the Media Player 11 shows it is used frequently. Can I remove the Media Format 11 runtime without it affecting the Media Player? I would *definitely* not try to remove it, because you would risk breaking WMP. The "rarely used" shown by Add/Remove programs is incorrect in this case and can be safely ignored. Regards -- Tim De Baets http://www.bm-productions.tk jasonfive wrote: > I have...

format stationery
The stationery in Outlook XP sets the cursor to the center of the page. How do I change that so it starts on the left? TIA ...

Viewing Journals from outside SOM/POS
I'm using Report Server to view reports on my RMS database. I'd like to include the ability to view receipts from this environment. Does anyone know if there is a way to either 1. convert the Journal table's "compressed" image format into a common graphic format like .gif, or .bmp; or 2. launch the Journal Viewer from an API? -Dave The receipt image appears to be in a proprietary format. There has been a lot of discussion on here in the past about this. As far as I know there is no way to view them outside of RMS. There may be an add-on designed to do ...

How can I modify punctuations' formatting in Word 2007
I want NO SPACING between last text word and ; : ? or ! How can I modify desired spacing default in Word 2007? -- Sean You would get that space if Word thinks you're typing in French (and maybe some other languages). Be sure the language of your text is set to English (or whatever it should be). You can display the language in your Status Bar (the bottom frame of the document window) by right- clicking on the bar and choosing it from the list. To set the language for the whole document, select it all (Ctrl-A) and choose the language from that entry in the status bar. On ...

Conditional formatting and If function?
Can this be done? I want the value of cell g4 to depend on the text entry to cell f4 If f4 = a then g4 displays 25% value of cell c4 If f4 = b then g4 displays 50% value of cell c4 If f4 = c then g4 displays 75% value of cell c4 If f4 = d then g4 displays 100% value of cell c4 Can this be done -- don ----------------------------------------------------------------------- dond's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2547 View this thread: http://www.excelforum.com/showthread.php?threadid=38930 Hi, This has nothing to do fith conditional formatting, I...

Formating Report via SendObject - HTML Format Breaks into pieces
When using the Sendobject command with the following parameters I noticed that the reports gets broken in many HTML pieces. Is there a way to send the report to say a PDF file or other formats where I can see all the pages like a regular report should look. This is the command that's being used. Docmd.sendobject acsendreport, "pending report", acFormatHTML, myemail@aol.com, my2ndemail@yahoo.com,- , ,"pending reports","Pending Report Illustrator",False On Sep 6, 6:44 pm, "Jasmine" <lalexander...@verizon.net> wrote: > When using th...