Contents
- Index
Interfaces: Coupons - Export
This is used to export all of the deals for which external coupons have been requested.
Layout / How To
Requested coupons will appear in account-deal order. If the coupon information for a specific account is incorrect, then you need to exit this screen and re-request the coupons. Re-requesting the coupons will replace what is on this screen for that account-deal.
You may delete a coupons request by selecting the account-deal in the grid and then pressing the Delete from Batch button.
To create the batch for the external processor, click the Export Coupons button at the top of the screen. This will open a save dialog window. Choose where to save the batch and what to name it. By default, the batch will be named, "Coupons-yyyymmdd-hhnnss-b", where "yyyymmdd-hhnnss" is the current date and time, and "b" is the batch number. It is recommended to save all batches into the ALMSysSQL\Export folder. Once the batch has been created, the records will be moved to history and the Coupons Batch Report will be run.
Coupon Export File Layout
The file created will be a comma-separated value (CSV) file. It may be created with either a TXT or CSV extension. Both types will be comma separated, but the CSV type will contain a header record for the field names.
The layout of this file is as follows:
Account number
Deal number
External Number (from the Accounts - Deal External screen)
Control Number
First Name
Middle Name
Last Name
Reporting (Business) Name
Coupon Number
Amount
Due Date
Vehicle Year
Vehicle Make
Vehicle Model
Remit to Name
Remit to Address Line 1
Remit to Address Line 2
Remit to City
Remit to State or Province Code
Remit to Postal Code
Make Checks Payable To Name
Customer Address Line 1
Customer Address Line 2
Customer City
Customer State or Province Code
Customer Postal Code