I love this group. I was looking in the right places but didn't notice that my sql query was blowing up on the InvoiceDtl selecting all columns. I do see the entries now, so that's very much.
--- In vantage@yahoogroups.com, "Brian W. Spolarich " <bspolarich@...> wrote:
>
> Unposted AR Invoices are as follows:
>
> InvcGrp - One row per ARInvoice GroupID.
> InvcHead - One row per ARInvoice, joined to InvcGrp on Company and GroupID
> InvcDtl - One row per ARInvoice line, joined to InvcHead on Company and InvoiceNum
>
> Credit Memo invoices have InvcHead.CreditMemo = True.
>
> -bws
> --
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
> Â Â Â Â bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of pbparker
> Sent: Tuesday, September 29, 2009 2:00 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Credit Memo hold or database location?
>
> I'm trying to create a BPM to set the memo to be on hold initially so it's not autoposted by our finance people. Has anyone done this?
>
> If not, does anyone know where the memo is stored inside the database before it's posted? I found them in InvcMisc after they're posted, but can't find them before. Doing a trace I see it referencing the ARInvoice object, but there isn't any table of that name.
>
> I'm trying to see what the entry looks like in the database to help me know how to filter and put on hold only those ARInvoices that are credit memos.
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>