Account Statement

Hi,

I have modified the customer statement in RMS. Can you give me the code that I need in order to keep the details contained in the footer section of the statement glued to the bottom of the page. At the moment if the statement runs over the first page the footer details appear just below the details section instead of at the bottom of the next page. I hVE includeD the code for the document below. Any suggestions would be of great help.

Kelly Account Statement Microsoft Corporation Version 1.03 8.50 11.00 3.00 0.2 0.25 0.25 0.50 0.50 AccountStatement.DateDueType AccountDueAccountReceivableDatePlusGracePeriod PaperWidth - MarginLeft - MarginRight PaperHeight - MarginTop - MarginBottom True "" "" 0 "" MarginTop MarginBottom MarginLeft MarginRight orPortrait "Arial" 12 False False False vbBlack "Arial" 10 False False False vbBlack "Arial" 8 False False True vbBlack "Arial" 18 True False False vbBlack MarginTop "Large" tbNone "~" PageWidth * 0.38 "Account Statement" tbNone "Small" "~" PageWidth * .20 "" ">~" PageWidth * .20 "" "|"" ""|Account Number:|" AccountStatement.AccountNumber ActivityStyleCondition "|" "|Balance: |" AccountStatement.PresentClosingBalance "|||" "||Amount Enclosed:|__________________" "|" AccountStatement.HomeAddress.Name "||" "|" AccountStatement.HomeAddress.Company "||" "|" AccountStatement.HomeAddress.StreetAddress "||" "|"" ""|Due Date:|" AccountStatement.DueDate "||Balance: |" AccountStatement.PresentClosingBalance "||Minimum Payment:|" AccountStatement.MinimumPayment "|" AccountStatement.HomeAddress.Name "||" "|" AccountStatement.HomeAddress.Company "|Amount Enclosed:|__________________" "|" AccountStatement.HomeAddress.StreetAddress "||" Len(AccountStatement.HomeAddress.StreetAddress2) "|" AccountStatement.HomeAddress.StreetAddress2 "|" "|" AccountStatement.HomeAddress.CityStateZip "|" msS3of9 msUPCNBelow AccountStatement.AccountNumber StubHeight - 0.6 MarginLeft + PageWidth * 0.8 PageWidth * 0.2 0.4 bcaRight False 0 psDot StubHeight StubHeight MarginLeft MarginLeft + PageWidth psSolid StubHeight StubHeight 0 0 "Tiny" "Please detach and enclose top portion with payment." "^" "Large" "" "Account Summary" "Small" tbBox vbYellow "~" PageWidth * .25 "" "" "Account Number:|" AccountStatement.AccountNumber "|Closing Date:|" AccountStatement.PresentClosingDate ActivityStyleCondition "Name:|" AccountStatement.HomeAddress.Name "|" AccountStatement.HomeAddress.Company "|" AccountStatement.HomeAddress.StreetAddress "||" LEN(AccountStatement.HomeAddress.StreetAddress2) "|" AccountStatement.HomeAddress.StreetAddress2 "|Previous Balance:|" AccountStatement.PresentStartingBalance "|" AccountStatement.HomeAddress.CityStateZip "|New Charges:|" AccountStatement.ActivitiesCharges "||Credits / Payments:|" AccountStatement.ActivitiesCreditsPayments "||===================|===================" "||New Balance:|" AccountStatement.PresentClosingBalance "|" AccountStatement.HomeAddress.CityStateZip "|Previous Balance:|" AccountStatement.PresentStartingBalance "||New Charges:|" AccountStatement.ActivitiesCharges "||Credits / Payments:|" AccountStatement.ActivitiesCreditsPayments "||===================|===================" "||New Balance:|" AccountStatement.PresentClosingBalance "" "Name:|" AccountStatement.HomeAddress.Name "|Due Date:|" AccountStatement.DueDate "|" AccountStatement.HomeAddress.Company "|" AccountStatement.HomeAddress.StreetAddress LEN(AccountStatement.HomeAddress.StreetAddress2) "|" AccountStatement.HomeAddress.StreetAddress2 "||" "|" AccountStatement.HomeAddress.CityStateZip "|Previous Balance:|" AccountStatement.PresentStartingBalance "||New Charges:|" AccountStatement.ActivitiesCharges "||Credits / Payments:|" AccountStatement.ActivitiesCreditsPayments "||===================|===================" "||New Balance:|" AccountStatement.PresentClosingBalance "|" AccountStatement.HomeAddress.CityStateZip "||" "||Previous Balance:|" AccountStatement.PresentStartingBalance "||New Charges:|" AccountStatement.ActivitiesCharges "||Credits / Payments:|" AccountStatement.ActivitiesCreditsPayments "||===================|===================" "||New Balance:|" AccountStatement.PresentClosingBalance "" "Small" tbBoxColumns vbYellow "^~" PageWidth * .16666 "Current" "^~" PageWidth * .16666 "1 - 30 Days" "^~" PageWidth * .16666 "31 - 60 Days" "^~" PageWidth * .16666 "61 - 90 Days" "^~" PageWidth * .16666 "Over 90 Days" "^~" PageWidth * .16670 "Balance Due" AccountStatement.AgingAmount0 "|" AccountStatement.AgingAmount1 "|" AccountStatement.AgingAmount2 "|" AccountStatement.AgingAmount3 "|" AccountStatement.AgingAmount4 "|" AccountStatement.PresentClosingBalance "Large" "" "Account Activity" "Small" vbYellow tbBoxColumns "" PageWidth * 0.15 "Charges" ">" PageWidth * 0.15 "Credits" AccountStatement.Activities.Count = 0 "|||" "| *** No account activity during this period *** ||" "|||" AccountStatement.Activities.Charge 0 AccountStatement.Activities.ActivityDate "|" AccountStatement.Activities.Description "|" AccountStatement.Activities.Charge "|" "|" AccountStatement.Activities.Details "||" AccountStatement.Activities.ActivityDate "|" AccountStatement.Activities.Description "||" AccountStatement.Activities.Credit "|" AccountStatement.Activities.Details "||" "Large" "" "Account Receivable Activity" "Small" vbYellow tbBoxColumns "~" PageWidth * 0.10 "Date" ">~" PageWidth * 0.10 "Due Date" "~" PageWidth * 0.10 "Debit" ">~" PageWidth * 0.10 "Credit" ">~" PageWidth * 0.10 "Balance" AccountStatement.Receivables.Count = 0 "||||||" "|||*** No account Activity during this period ***|||" "||||||" True AccountStatement.Receivables.Reference AccountStatement.Receivables.DueDate AccountStatement.Receivables.Balance AccountStatement.Receivables.Histories.Details FirstHistory AccountStatement.Receivables.Histories.Debit

0 RcvRef "|" AccountStatement.Receivables.Histories.Date "|" RcvDate "|" AccountStatement.Receivables.Histories.Description "|" AccountStatement.Receivables.Histories.Debit "||" RcvBalance RcvRef "|" AccountStatement.Receivables.Histories.Date "|" RcvDate "|" AccountStatement.Receivables.Histories.Description "||" AccountStatement.Receivables.Histories.Credit "|" RcvBalance Len(ActivityDetail) "|||" AccountStatement.Receivables.Histories.Details "|||" False "" 0 "" AccountStatement.Receivables.Histories.Debit 0 "|" AccountStatement.Receivables.Histories.Date "||" AccountStatement.Receivables.Histories.Description "|" AccountStatement.Receivables.Histories.Debit "||" "|" AccountStatement.Receivables.Histories.Date "||" AccountStatement.Receivables.Histories.Description "||" AccountStatement.Receivables.Histories.Credit "|" "||||||" "Small" vbYellow tbBoxColumns ">~" PageWidth * 0.70 "Total" ">~" PageWidth * 0.10 AccountStatement.HistoryTotalDebit ">~" PageWidth * 0.10 AccountStatement.HistoryTotalCredit ">~" PageWidth * 0.10 AccountStatement.HistoryTotal PaperHeight - MarginBottom - FooterHeight "Small" tbNone "~" PageWidth * 0.7 "Account Number: " AccountStatement.AccountNumber "|Page \p of \t" "Purchases payed by the 28TH of month following are interest free " "Thereafter interest will be charged at 1.5% per month (APR 19.5) " "PrintFooter" "PrintFooter" "PrintFooter" "PrintFooter" "PrintStub" "PrintSummary" ActivityStyleCondition "PrintActivityByInvoice" "PrintActivity"
Reply to
datapac_bs
Loading thread data ...

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.