Sage 100

Have you ever set up a customer who has light multi-currency needs by adding a UDF for the foreign currency and using that UDF for any printed forms (PO, etc) but record all the transactions in US$? I'm thinking that I can manage the currency fluctuation in PO by setting the PO Variance to a currency fluctuation type account. At the time they receive the invoice they could wash any currency difference through a GL. I know it won't be perfect but until the customer does more in foreign currency it may be enough. They pay everything in US and really their biggest need (for now) is to issue PO's to their overseas suppliers in that supplier's home currency. Seems like I'd have fluctuations at: - Time of PO invoice receipt - Time of cash payment (may have to pay invoices when received to somewhat avoid) Are there other issues that I'm overlooking? All their reporting is in US$ with the exception of a small R&D facility overseas.

I did this for a client who had to bill one specific customer in Canadian dollars. Created a UDF in the Customer file and instructed them to put in an exchange rate. Then I modified the Invoice Printing form by creating my own formulas for the Unit Price and Extended Price to use the value in the UDF to convert if the customer number matched. Then changed the totals and it worked fine. When the customer paid, the bank converted back to USD and they posted that amount to A/R and the balance to Gain/Loss on Foreign Exchange. Not a great solution if it needed to be used for a lot of customers or a large portion of the business, but it did solve the issue. Before I did this for them, they were entering the order by overriding each price to the Canadian Price (from the customer PO), and then after printing the invoice, they would change all the prices back to USD before updating...when they remembered to.

Thanks. That's kind of what's happening here only they are contemplating deleting the PO which I'm trying to discourage. The numbers are small now so a workaround like this seems to be the best idea.

Client orders in Euro (put UDF in CI_item for Euro purchase price). Pull value to PO at time of entry. Modify forms to print Euro values. When item is received, put a UDF value in PO header for exchange rate at time of receipt. Hire Dan Burleson to write script to change US$ unit price to one based on Euros and exchange rate at time of receipt. Has been working for client for many moons. Their PO's may have 30 plus lines to modify. They are very happy. I probably have skipped a step. Been a while.

Not worth looking at DSD Multi-currency?

Not yet - we don't have enough volume but that could change

I believe we do this using divisions (with a GL segment to isolate the different currency amounts) but @RobertWhite knows vastly more about the setup than I do.

Similar story, created UDF for exchange rates linked to a UDT that they update each month. Created UDFs on PO hdr/line for other currency with script to convert USD amount to the other currency