RE: Assigning Duplicate Values

Tech-Archive recommends: Fix windows errors by optimizing your registry

I do not follow this at all. Maybe someone with financial background can help.
--
KARL DEWEY
Build a little - Test a little


"Gkann" wrote:

I will show you examples from both:

This is from an AS/400 so forgive the date format, it was not my idea.
Write Off Transaction
Date Ref Number GL Ref# Amount
1080318 123456 0 $150.00

If the transaction was not a write off, then an actual GL Ref# would be
placed in that field. However, someone thought it a good idea to skip that
step when doing write offs!!!!!????

GL Transaction:
Posting Year Posting Month Month Day Year GL Ref# Amount GL Account
2008 3 3 18 2008 45112 $150.00
225

The transaction in the GL will get a reference number, but that reference
number is not tied back to the write off transaction that created it.
Posting month and year are provided seperate as the accounting month ends on
the 25th.

What I did so far was to change the above date into the month day year
fields, and match by dollar amount. However, the GL does not have anything
to the right of the dec point, and there can be several write offs for $12 on
the same day.

The order of which write off gets which GL entry does not matter to me, I
simply need to assign them so I can show transactional details for each GL
entry.

As a last resort I am thinking about pulling both sides into excel and
sorting them then copying and pasting, importing back into access. If that
sounds easier just let me know.

I hope this helps.


Thanks for the reply Karl.

Gary


"KARL DEWEY" wrote:

First you need to use one DateTime field for the Month, Day, and Year
information.

Post an example of what your 'unique combination of Date / WriteOffNumber'
would look like. What does your ' GL Ref Num' look like?
--
KARL DEWEY
Build a little - Test a little


"Gkann" wrote:

Help - I am a long time lurker and first time poster.

Here is my issue. I am attempting to match entries of money being written
off an account to the businesses GL File. However, when these write offs are
done what is typically a link is broken. However, by adding the dollar
amount written off I can get all of the write offs and GL entries for the
same dollar amount and that day. The GL has a ref number for each
transaction. What I am trying to do is assign one reference number to one
write off, regardless of how many times it may have happened that day.

The reference number to entry match is not as important as seeing what did
not match at the end of the project, since i know I have the same number of
GL Ref# and write off entries for each, I simply need to populate it, the
order is not important.

Fields I am working with
Write Off Transaction: GL Code:
Month Month
Day Day
Year Year
Amount Amount
Date GL Ref Num
WriteOffNumber

I can match by month, day, year and amount. I need to assign a unique GL
Ref to each unique combination of Date / WriteOffNumber.

Oh - I almost forgot, I am a VBA midget, but will attempt it if it is the
only way.

PLEASE HELP!!!!!!!
.

Relevant Pages

  • RE: Assigning Duplicate Values
    ... "KARL DEWEY" wrote: ... Write Off Transaction ... Posting Year Posting Month Month Day Year GL Ref# Amount GL Account ...
    (microsoft.public.access.queries)
  • RE: Assigning Duplicate Values
    ... Write Off Transaction ... Posting Year Posting Month Month Day Year GL Ref# Amount GL Account ... The transaction in the GL will get a reference number, ...
    (microsoft.public.access.queries)
  • RE: Assigning Duplicate Values
    ... and numbers transaction amounts, and the colors are account numbers, I simply ... As an alternative I started looking at doing a count by dollar amount, ... Posting Year Posting Month Month Day Year GL Ref# Amount GL Account ...
    (microsoft.public.access.queries)
  • RE: Assigning Duplicate Values
    ... Write Off Transaction ... Posting Year Posting Month Month Day Year GL Ref# Amount GL Account ... The transaction in the GL will get a reference number, ...
    (microsoft.public.access.queries)
  • Re: Visa Debit Payment
    ... credit cards isn't always the amount entered on the card terminal. ... Sometimes the debit aquires a '0', ... Sainsburys are aware that an equal number of transaction ... I do my card reconciliations two working days after the transaction. ...
    (uk.legal)