Invoice payment reports

Yahoo Archive
1
Try looking at the cashdtl file - trees up cashhead and cashgrp.

Available fields in file:

assign
CashDtl.Company /* x(8) */

CashDtl.GroupID /* x(8) */

CashDtl.HeadNum /* >>>>>>9 0 */

CashDtl.InvoiceNum /* >>>>>>9 0 */
CashDtl.InvoiceRef /* >>>>>>9 0 */

CashDtl.TranType /* X(6) */
= cashhead.trantype
CashDtl.Posted /* yes/no yes */

CashDtl.FiscalYear /* >>>9 0 */
= cashhead.fiscalyear
CashDtl.FiscalPeriod /* >9 0 */
= cashhead.fiscalperiod
CashDtl.GLPosted /* yes/no no*/
CashDtl.TranDate

CashDtl.CheckRef /* X(15) */
checknum
CashDtl.TranAmt /* ->>>,>>>,>>>,>>9.99 0 */

CashDtl.DocTranAmt /* ->>>,>>>,>>>,>>9.99 0 */

CashDtl.CustNum /* >>>>>>9 0 */
= cashhead.custnum
CashDtl.Discount /* >>>,>>>,>>>,>>9.99 0 */

CashDtl.DocDiscount /* >>>,>>>,>>>,>>9.99 0 */

CashDtl.DebitDiv /* x(50) */

CashDtl.DebitDept /* x(50) */

CashDtl.DebitChart /* x(50) */

CashDtl.CreditDiv /* x(50) */

CashDtl.CreditDept /* x(50) */

CashDtl.CreditChart /* x(50) */

CashDtl.Comment /* X(1000) */

CashDtl.Reference /* X(30) */

CashDtl.ExchangeRate /* >>>,>>9.999999 0 */

CashDtl.RefCode /* X(4) */

CashDtl.DocToRef /* yes/no no */
= no
CashDtl.RefToBase /* yes/no no */
= no
CashDtl.RefToBaseRate /* >>>,>>9.999999 0 */
= 1
CashDtl.LegalNumber /* X(20) */

CashDtl.GLRefType /* X(8) */

CashDtl.GLRefCode /* X(8) */

CashDtl.RefAcctDiv /* X(50) */

CashDtl.RefAcctDept /* X(50) */

CashDtl.RefAcctChart /* X(50) */

CashDtl.Character01 /* X(1000) */

CashDtl.Character02 /* X(1000) */

CashDtl.Character03 /* X(1000) */

CashDtl.Character04 /* X(1000) */

CashDtl.Character05 /* X(1000) */

CashDtl.Character06 /* X(1000) */

CashDtl.Character07 /* X(1000) */

CashDtl.Character08 /* X(1000) */

CashDtl.Character09 /* X(1000) */

CashDtl.Character10 /* X(1000) */

CashDtl.Number01 /* ->>>,>>>,>>9.99999 0 */
= 0
CashDtl.Number02 /* ->>>,>>>,>>9.99999 0 */
= 0
CashDtl.Number03 /* ->>>,>>>,>>9.99999 0 */
= 0
CashDtl.Number04 /* ->>>,>>>,>>9.99999 0 */
= 0
CashDtl.Number05 /* ->>>,>>>,>>9.99999 0 */
= 0
CashDtl.Number06 /* ->>>,>>>,>>9.99999 0 */
= 0
CashDtl.Number07 /* ->>>,>>>,>>9.99999 0 */
= 0
CashDtl.Number08 /* ->>>,>>>,>>9.99999 0 */
= 0
CashDtl.Number09 /* ->>>,>>>,>>9.99999 0 */
= 0
CashDtl.Number10 /* ->>>,>>>,>>9.99999 0 */
= 0
CashDtl.Date01

CashDtl.Date02

CashDtl.Date03

CashDtl.Date04

CashDtl.Date05

CashDtl.CheckBox01 /* Y/N no */

CashDtl.CheckBox02 /* Y/N no */

CashDtl.CheckBox03 /* Y/N no */

CashDtl.CheckBox04 /* Y/N no */

CashDtl.CheckBox05 /* Y/N no */

CashDtl.DebitNote /* yes/no no */

CashDtl.DNComments /* x(1000) */

CashDtl.DNAmount /* ->>>,>>>,>>>,>>9.99 0 */

CashDtl.DocDnAmount /* ->>>,>>>,>>>,>>9.99 0 */

CashDtl.DNCustNbr /* x(50) */


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
vantageuser13
Sent: Friday, January 09, 2009 2:15 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Invoice payment reports

I will need to create a Invoice reports, I will need to add a payment
receipt dans date. But I don't know the table for the payement receive
for this invoice. The table for the invoice is invchead, invcdtl, but
I don't remember for the payement receive ?

Thansk.

Vantage 8.0.808



[Non-text portions of this message have been removed]
2
I will need to create a Invoice reports, I will need to add a payment
receipt dans date. But I don't know the table for the payement receive
for this invoice. The table for the invoice is invchead, invcdtl, but
I don't remember for the payement receive ?

Thansk.

Vantage 8.0.808