Credit Memo hold or database location?

Yahoo Archive
1
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
>
2
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.
3
The record is in the Invoice Detail with a regular....InvcDtl.InvoiceNum
with CreditMemo = True.



-----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.







[Non-text portions of this message have been removed]
4
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