Ah! Exporting to XML - yes, I could try that! I'll let you know how it works.
I've actually got 3 Pricing codes - M for market pricing, P for protected pricing (contracts, hyper sensitive clients), and Q for quotes (and Alternative pricing code for clients who might have different pricing for an item - cash price vs credit card, qty 5 versus qty 15 - the sales order recognizes the alternative pricing Clients and asks the user if this order is normal or alternative pricing, so it will know which Pricing field to update in the event the user changes the pricing on the fly while the order is being entered). When I buy an item on a POLines record, if the cost has changed from last time - either up or down - then the code goes looking in Pricing for every record for that ItemNum. If it's an M record, the customer pricing (and new ItemCost info) is automatically adjusted to reflect the cost increase or decrease, following the specific margin for each client/item pricing combo (although if the cost went up, it increases the margin a smidgen, and if the cost went down, it gives part of the cost decrease to the client but not all of it, thus increasing our margin on that item - I figure that over time this will increase, basically out of thin air, our overall margins by maybe up to two percentage points, which will be a huge help). If it's a P record, then the cost and new lower resulting margin get calculated, but the price isn't changed (since it's Protected), but a PriceAnalysisNeeded field is filled and a report run at the end of the day to alert us of PAN records that need human attention. And of course, the Q records (once that's written) are converted once that client actually orders that Quoted Item for the first time.
I know I'm blathering on and on, but this is the Holy Grail of what I hoped Sesame would allow us to do - enter data once and have it zoom around and touch everything it needs to touch under the hood. It's like having another 3 team members on board who are working all day for free. I'm very excited about the present and ongoing benefits that this software will provide us. And I couldn't have done it without this forum. If I could spend the rest of this year fulltime on programming Sesame instead of squeezing it in when I can due to 'running the business' demands, I'd be a happy contented camper. But I'm definitely happy to be here.
|