Account Statement Variables

Get a copy of the customization guide. If your ms partner can't get you one write me an email: snipped-for-privacy@davidstea.com

Here are all variables for the account statment receipt:

Accountstatement.Homeaddress.City City of the customer's address. Accountstatement.Homeaddress.Company Company of the customer's address. Accountstatement.Homeaddress.Country Country code of the customer's address. Accountstatement.Homeaddress.Faxnumber Customer's facsimile number. Accountstatement.Homeaddress.Name Customer's full name. Accountstatement.Homeaddress.PhoneNumber Customer's telephone number. Accountstatement.Homeaddress.State State code of the customer's address. Accountstatement.Homeaddress.StreetAddress First line of the customer's address. AccountStatement.HomeAddress.StreetAddress2 Second line of the customer's address. AccountStatement.HomeAddress.Zip Postal code of the customer's address. AccountStatement.HomeAddress.CityStateZip City, state code, and postal code of the customer's address. AccountStatement.HomeAddress.Zipcity Postal code and city of the customer's address. AccountStatement.AccountNumber Account number of the customer's account. AccountStatement.DateDueType Type of the due date for the account. This is one of the following values:

AccountDueCloseOfBillingCyclePlusGracePeriod

AccountDueAccountReceivableDatePlusGracePeriod (Valid only for printing account statements) AccountStatement.Activities.ActivityDate Date of the most recent activity for the account. AccountStatement.Activities.Description Description of the most recent activity for the account. AccountStatement.Activities.Details Details of the specified account activity, including item lookup codes and descriptions. AccountStatement.Activities.FullDetails Full details of the specified account activity, including item lookup codes, descriptions, and comments. AccountStatement.Activities.Charge Charge for the specified account activity, or zero if the activity is a credit. AccountStatement.Activities.Credit Credit amount for the specified account activity, or zero if the activity is a charge. The credit amount is returned as a positive value. AccountStatement.Activities.Count Total number of account activities. AccountStatement.CreditLimit Credit limit of the account. AccountStatement.MinimumPayment Minimum payment for the account. AccountStatement.AvailableCredit Available credit on the account. AccountStatement.ActivitiesCreditsPayments Sum of all payments and credits for this statement period. The sum is returned as a negative value. AccountStatement.ActivitiesCharges Sum of all charges for this statement period. AccountStatement.PresentStartingBalance Starting balance for this statement period. AccountStatement.DueDate Due date for the current statement. AccountStatement.LastClosingBalance Balance as of the most recent closing date for this statement. This value may be different than PresentStartingBalance because the statement may not cover the most recent statement period. AccountStatement.FinanceCharge Finance charge for the account. AccountStatement.PresentClosingBalance Closing balance for the current statement. AccountStatement.PresentClosingDate Closing date for the current statement. AccountStatement.AgingAmount0 Current amount owed on the account. AccountStatement.AgingAmount1 Amount owed that is 1 to 30 days overdue. AccountStatement.AgingAmount2 Amount owed that is 31 to 60 days overdue. AccountStatement.AgingAmount3 Amount owed that is 61 to 90 days overdue. AccountStatement.AgingAmount4 Amount owed that is over 90 days overdue. AccountStatement.HistoryTotalDebit Sum of all debits. AccountStatement.HistoryTotalCredit Sum of all credits. AccountStatement.HistoryTotal Sum of all account receivable balances. AccountStatement.Receivables.Count Number of account receivables. AccountStatement.Receivables.Reference Type and reference number for the specified account receivable. AccountStatement.Receivables.DueDate Due date for the specified account receivable. AccountStatement.Receivables.Balance Remaining balance on the specified account receivable at the end of the statement period. AccountStatement.Receivables.Histories.Count Total number of account history entries for this statement, where a history is a payment, charge, or adjustment. AccountStatement.Receivables.Histories.RunningBalance Running balance for all account receivables in the specified history. AccountStatement.Receivables.Histories.Debit Debit amount for the specified history, or zero if the history is a credit. The debit amount is returned as a positive number. AccountStatement.Receivables.Histories.Credit Credit amount for the specified history, or zero if the history is a debit. The credit amount is returned as a negative number. AccountStatement.Receivables.Histories.Description Description and comment for the activity for the specified history. AccountStatement.Receivables.Histories.Details Details of the specified history, including item lookup codes and descriptions. AccountStatement.Receivables.Histories.FullDetails Full details of the specified history, including item lookup codes, descriptions, and comments. AccountStatement.Receivables.Histories.Date Date of the specified account receivable. Statement.LogoFilename File name of the logo image printed on the account statement.

"Mick Hardy" wrote:

Hey Sad, I'm sorry. I don't actually have the full customisation guide. I have a complete list of variables gathered from these news groups. If you search for variables, you'll find them.

The elusive guide is for partners only and they sign some sort of agreement so they can't pass it on. I've seen heaps of posts requesting a copy but I've never managed to obtain one myself.

I have a couple of knowledge base articles from the customersource site as well but everything I have is from this forum.