Jump to content


Photo

Journal.dbf


  • Please log in to reply
2 replies to this topic

#1 Gus

Gus

    Newbie

  • Members
  • Pip
  • 1 posts

Posted 02 December 2004 - 12:31 PM

I'm trying to create an R & R report of journal transactions within a certain date range. Can anyone tell me if the ORD_DATE field in the Journal.dbf database will return "order dates" or "transaction dates"?

#2 Videoflicks2004

Videoflicks2004

    GLOBAL MODERATOR

  • Moderators
  • PipPipPip
  • 241 posts
  • Gender:Male
  • Location:Canada
  • Interests:~ DVD ~ BLUE RAY ~ HD DVD ~ HOLOGRAPHIC DVD ~ Quantum Computing.

Posted 07 December 2004 - 07:09 AM

Gus,

I was trying to work on a report to essentially duplicate the A/R report in MOM. I had limited success. Keep me posted on your progress.

ODR_DATE appears to be the transaction date. I just check an order that was created back in November and had been invoiced on Dec 7, 2004. The date in the journal table under the ODR_DATE column was the DEC 7 2004.

I hope you have more luck with this report than I had.

For bonus points try adding a running total on your report. That was the stumper for me due to the way mom records the transactions.

Cheers,

David
David Narciso
Ecommerce Operations Manager CVS Inc

[email protected]

mobile: 4168238175

DISCLAIMER: Always backup your MOMWIN folder before attempting to perform any updates, testing, etc. Once you blast the data away it's gone forever.
My advice is based on my 8 years of experience with MOM and Dydacomp. If you are not comfortable with data manipulation then hire someone who is.

#3 rrinker

rrinker

    Member

  • Members
  • PipPip
  • 14 posts
  • Location:Reading, PA

Posted 06 January 2005 - 12:48 PM

I am also looking for a way to duplicate this report with the added functionality of a DAILY TOTAL - Why the standard report would not sum a DAILY total is beyond me. Running totals are fine, but would like to see the daily totals as well. Plus have the ability to generate a report BEFORE anything actually gets posted - a Trial Balance if you will.

I did sort of get the functionality I need by creating a report off the GLTRANS file, of course this is AFTER the posting has been made, but I can run a quick print of daily totals with or without each account code detail.

--Randy




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users