We're trying to build a form that records employee remuneration and builds a history of it. At this stage we aren't looking to link it to our accounting reports and general ledger. The plan is to store the data, run a search to bring it up and export the information to excel to further analyze. We need to use the exchange rate information that netsuite stores.
The current form uses some custom fields, but also these fields standard fields - amount, currency, foreign exchange and foreign amount which converts the amount to the foreign amount.
Our biggest 3 hurdles are:
1. The employee transaction expense form feeds into to accounting reports and appears on there as an entry - even if the amount field is $0. Do we just need to change the report or scripts attached to all this?
2. If you put the amount field to $0 the exchange rate goes from the actual amount to back to 1, if you have any $ figure in the amount field then the exchange rate stays in the record at the correct rate.
3. When I do a search for these testing records I've created using a saved search, it pulls up the exchange rate as being Australian $1. So in the input form I might put Canadian as the currency and the amount as $5, but in the search it will show the exchange rate as $1 Australian - I think this is to do with the currency that is attached to the subsidiary that the employee is a part of. Again I can't work out why I can see the information in the input form, but the saved search brings back the incorrect currency and exchange rate.
Any help would be appreciated.