madwill

Many thanks. I've checked the settings, double-checked everything, uninstalled and reinstalled FMPro ans *still* the problem persists. So I shall just have to do the last-minute tweaks after installing on his system. However, my problem remains... Thanks for your patience. Madwill

No, I get a mixture of English months and some Spanish terms like Quarter (Trimestre). I trust there's a remedy! After all, the FMPro is in Spanish. I have Spanish menus! Thanks again. Madwill shot3.bmp

The same result. I've just tried it.

Again, many, many thanks. I'm impressed. But it's not working for me. I've seen that your clone example works great - indeed, I've never had this problem before. But I've checked my OS setting and recloned the files and I still get the date options in English. I attach screenshots of the 2 dialogues. Maybe I've got something else wrong. Otherwise, I think it's my FMPro that perhaps requires reinstalling(?) Very grateful for your help. Madwill shot1.bmp shot2.bmp

Thank you for your prompt reply. Unfortunately, having cloned the 3 files concerned with the OS set to Spanish formats (as it always is), there is no change. The options still only appear in English (e.g. Thursday, 25 April). Very grateful for any further suggestions. Madwill

Hi experts, I'm a long-time user of FMPro, but untrained and dangerous! Though English, I live in Spain, working in Windows XP Pro (in English) and FMPro 6.0 (in Spanish). I'm developing a (for me) complex sales and invoicing solution for a friend and decided to adapt some ISO starter files from the Scriptology book/CD I bought some years ago. Everything seems to work fine, except that I cannot format the date fields to display (month names) in Spanish, as the user wants on his invoices. The options only allow for English. I've tried toggling things like Use system formats, but to no avail. The Default language for indexing and sorting is greyed-out for some reason, so I have not been able to experiment with that. I've been toying with the idea of using a calculation to get it to produce the goods, but if there is a solution I've overlooked, I'd be very grateful for your help. If the calculation is the only way, I should also appreciate help with that. Many thanks, Madwill

Sounds excellent, David. I shall initially go with solution 2) as I can grasp the logic better and already know and use the technique. Many thanks for your help. Madwill

I can concede that average time to pay is not efficient, but I cannot see beyond the impracticalities of applying a discount or surcharge to a particular invoice depending on when it is paid (I have to send out a discount/surcharge notice? All clients pay either by banker's draft or cheque by post - I cannot alter either. I would need to re-charge or refund - altogether too complicated). Tigers do not tend to change their stripes. And slow-paying clients are not going to be swayed by the lure of a 5% discount. BTW, a client averaging 130 days over 9 paid invoices can generate any number of new invoices without skewing the average. Only paid invoices enter the equation. Number of invoices would not be too useful to me. The calc could include a surcharge on invoices over a certain sum (say $1000) 130 past due; that would seem far more logical to me. Thanks for your comments, Madwill

Hi, David, Thanks for your reply. In fact the above solution has not worked, maybe because, as you say, the calc is in the Job (not client) file, whereas it should be in the invoice file. I'll experiment a little but I don't want to screw all 2000 invoices, so I'll have to go easy. Either way, I certainly don't want to have to reconsider the general premise for applying discounts and surcharges, and doing so on individual invoices is not an option. Clients in Spain are very slow to pay in general and it is in my interests to pre-apply a discount to those who regularly pay quickly, just as the surcharge penalises those who regularly take over 130 days to pay. I need to set the calc so that when a client whose average was 125 days slips over into surcharge zone, the surcharge is applied only to invoices issued from that point on. Maybe this explanation should have been given in the first place. If so, I apologise for not being altogether clear. Hope you or someone else can help. Many thanks Madwill

Hi, Phil, I think this has solved the problem. In fact, the calc was already a Case function, but I've now modified it to (hopefully) only apply discount/surcharge on new invoices. It now looks like this (my FMP is half in Spanish): Case( IsEmpty(Timing) or Timing < "1"; ""; Timing >= 130 and Fecha >= Today; Sum(ImporteEuros) * 0,05; Timing <= 45 and Fecha >= Today; -Sum(ImporteEuros) * 0,08; "" ) with Timing being the average number of days client takes to pay, Fecha being Date and ImporteEuros being net cost. I may have to get back to you should this fail, but it seems to work for now. Thanks again. Madwill

Thanks very much, Phil. I'll try this straight away. However, it isn't a "record lock" solution. Is that because there is no way, or because it's trickier to implement, or what? Many thanks, Madwill

My homegrown (homegroan?) invoicing solution includes a calculation that simultaneously applies a discount to the invoices of clients who pay in X days and a surcharge to those of clients who fail to pay in under Y days. This has worked well until today, when one pesky client has slipped over the threshold and will now incur a surcharge on his invoices. However, I realise that the surcharge has been applied to all the client's past invoices, whether paid or pending, and this is definitely not OK. How can I lock the records to prevent the calculation from modifying these invoices? I appreciate any help, though I'm reluctant to send the entire db for perusal. Many thanks, Madwill

Thanks to you both. I reckon the flag method, for its simplicity, is probably my best bet, as users are strictly limited to 2 (it's our invoicing system!). But the third method is the one that seems to ring a bell. Anyway thanks again. Regards MadWill

I know I've seen it somewhere. I've scanned the forum. I've searched my Scriptology index and contents. I've even stopped and thought for a few minutes. But I cannot remember how to Save a Found Set of Records. Can anyone help please?