Use the Rebate Detail Maintenance program to identify and reconcile any differences between the dollar amount you are requesting from a vendor using EDI 844 and the vendor response about that rebate request coming back by EDI 849.
The system using the following flow:
Using Booking Letters of Credit, the system creates a negative purchase order.
From the Status screen you type E in the Prt: field and select EDI 844.
The vendor checks the EDI 844 document, edits it, and sends it back through EDI 849.
The system notifies you that the document is received.
Using Rebate Detail Maintenance, you check for exceptions, export those exceptions, reconcile any issues, and send the data back to the vendor using EDI 844.
The vendor checks the document and returns it for final processing.
The Rebate Detail Maintenance queue populates information based on results received after the Customer Sales Rebates Report runs. You must have a spreadsheet program installed to view the information outside the system on your computer.
You can also use the Vendor Purchases Report to help reconcile your rebate requests and receipts. Typically run at the end of the year, this report can be used to reconcile rebates that are due. For example, if you are part of a buy group for Sylvania and they send you a rebate check based on their records, you can use this report to verify that their totals are correct and you are being paid the correct amount.
To export and edit the Rebate Detail spreadsheet:From Purch menu, select Queues.
Select Rebate Detail Maintenance.
In the P/O# field, enter the purchase order number or press F10 and select from the list.
Press Esc to display the information for that purchase order.
Use the Export hot key and select a file location when prompted.
Note: Use the Exceptions hot key to display only the exceptions that created the difference between your request and the vendor response on the purchase order.
Name the file. The file is saved with a .csv extension.
The file opens for you in your default spreadsheet program.
Edit the data as needed.
Save and close the file.
To import and resend the Rebate Detail spreadsheet:
From Purch menu, select Queues.
Select Rebate Detail Maintenance.
In the P/O# field, enter the purchase order number or press F10 and select from the list.
Press Esc to display the information for that purchase order.
Use the Import hot key.
Select the file from your directory and click OK.
Use the Update hot key to update the displayed purchase order according to the file changes.
Drill back into the purchase order's Status screen.
In the Prt: field, enter E and select EDI 844 to re-transmit the purchase order.
Press Esc to exit the screen and return to the main menu.
See Also:
Viewing and Editing Rebate Purchase Orders