Sage 200 Customer Price Band Assignments
A PostTrans template can be used to quickly extract your customer list, with any price bands, order value discounts, or discount groups the customers are assigned to.
You can you then simply edit those assignments within Excel, and pressed the import button to post back any changes into Sage 200.
| Customer Price Band Assignment using PostTrans: | |||
| 1:00 | Open Example Template for editing Customer Price Band Assignment | ||
| 4:00 | How to find more information and Training | ||
Download Customer Price Band Assignment Extract/Import Template
see 'Cust Assigned Price List' sheet
To use the template, with Sage 200, install PostTrans. Download
Trial with Sage demo company. Purchase a month subscription for Live Sage Company. Price
Watch the On-line Training course on how to use and customise the templates.
Tags of interest:
| Tag | Description |
| CuPriceBand | Price Band assigned to customer |
| CuGroupDisc | Group Discount assigned to customer |
| CuOrderValDisc | Order Value Discount |