Price Master

	Reduced Administration costs and complete control of prices Each Sales person can submit prices for his/her own customers which come in to effect from x date or special offers to run from x date to y date. When a special price finishes, Price Master reverts back to the last valid price specified automatically
	Prices submitted via Spreadsheets, can be e-mailed IN/OUT Each Sales rep receives a spreadsheet, which contains information on their own customers and current prices. The rep simply specifies new price and dates to run from or between. Price Master then reads the submitted spreadsheets, to automatically update Exchequer when the time comes.
	Updates current Orders Transactions in the daybook, which are effect by submitted price changes, can be automatically updated. These are shown when designated user logs into system, they then decide if they should apply changes to Orders already in the system.

The Price Master package allows sales persons to submit price updates to Exchequer Enterprise price matrix for single customer accounts or applied to multiple customer accounts via criteria, to be applied a future date. This information is submitted via an Excel spreadsheet from a remote sales representative.

These spreadsheets are then submitted to a user, via e-mail, for authorisation. These sheets are then submitted to a user who imports the price information into Price Master database.

Daily the Price Master Program scans entries in the price database, as a batch process, which define when Price Master will alter Special Prices in Exchequers price matrix. This process then updates any matrix entries, which need altering in Enterprise.

A plug-in then shows a designated user if any transactions in the daybook should have their prices changed, when the log into Exchequer Enterprise. These changes can then be applied either manually or automatically. This plug-in also allows users, of Enterprise to view future prices held Price Master, from the customer ledger or stock ledger.

Price Master features are:

1. Automatically updates prices in the Exchequer price matrix. Both special price and discount on Bands. Applied to individual stock items or groups of stock items.

2. Start Date can be set for new matrix entry to be applied

3. Start date and End date can be defined for Special offers or promotions

4. Updates can be applied to single Customer Accounts or by specifying criteria. Eg. Where Rep=SAM, or InvoiceTo = ABAP01 …

5. Multiple delivery address can be updated, by specifying the Head Office account code.

6. If price is applied to multiple delivery addresses simply be specifying the head office account code.

7. After Special offers have ended then reapplies original price, or previous special price

8. Optionally writes changes to Account Notes, for extra tractability.

9. Scans Daybooks to see if new price should be applied to SOR/SDN/SIN, based on delivery date. Then user can select to optionally update Transaction price. This allows future orders to be put on system and new prices are then applied automatically.

10. Logs all changes to the database for reporting

11. Price Matrix changes can be submitted by salesmen, on Excel Spreadsheet, via e-mail.

12. Can mark SOR’s as being price overridden, so the update skips the marked lines

13. Automatically updates the Price Matrix Spreadsheet to send to reps.

14. If Rep codes are specified on account records then system will create separate price sheets for each rep, which gives them access to only their customer list. These can then be e-mailed out at a click of a button.

15. When new accounts are entered manually, then optionally copies the head office price matrix. The new account will then be included on future price updates.

Requirements:

	Exchequer Enterprise V5.5+
	Microsoft Excel 2000+, with no start up errors
	MS Outlook or Lotus notes to e-mail sheets
	A dedicated PC to run updates, with Excel and Exchequer installed

About Exchequer Enterprise

[ Home ] [ Up ] [ More about Exchequer Software ] [ IRIS Enterprise Software ] [ WebRangle Linking ]

Last modified: August 18, 2006