"Sam Commar" <SamCommar@discussions.microsoft.com> wrote in message
news:D6D4BD76-CE38-4A04-A191-E6C8398675E1@microsoft.com...
> I have a Table ARTRAN where is getting populated when a AR debit memo is
> created. ( Assume Batch 0001) The fields that i am trying to work with are
> tran date and tran id which are created and captured.
>
> Then a credit memo is created which again has a tran date and a tran id.
> (Assume Batch 0002 is created)
>
> After that a batch is created where the Debit memo is matched with the
> Credit Memo. (Assume Batch 0003). This is in a different screen.
>
> What I am trying to do is capture on a Crystal report the Batch 0003 with
> the tran id's and tran date's of the Batch 0001 and Batch 0002. I though
> that a simple thing that I can do is create a stored procedure which
> populates the tranid and tran date of batches 0001 and 0002 in Batch 0003.
>
> Could someone please assist with this.
> I would be greatful.
>
> Thanks
> Sam
> s_commar@hotmail.com