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:
External Number (from the Accounts - Deal External screen)
Reporting (Business) Name
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 State or Province Code
Customer Postal Code