Open Forum

1.  FST Translation for Multiple Companies - PV List Edit

Posted 12 days ago
Hi,

We currently use FST to translate our foreign currency ledgers into USD. We just created a second company in our Euro based database. We'll have to convert both companies into USD. As far as I can tell, it is only possible to convert one company at a time. This is fine. My concern is during the batch reversal, screen 25.510.00. It appears as if I am able to reverse the translation for  company A or company B from either company. I think it would be a problem if company A translation were to be reversed from company B.

I'd like to mitigate this risk by limiting the PV list to only show translations for the current company. If I am logged into company A, I only want to be able to see and reverse translations that were done for company A. How can I modify the PV to add that stipulation to my parameter?

I do have PV Editor. Thanks in advance for any help.




------------------------------
Jake Malyemezian
Senior Accountant/SL Administrator
HMT LLC
------------------------------


2.  RE: FST Translation for Multiple Companies - PV List Edit

Posted 11 days ago
​You can change the where clause in the PV so it says "WHERE CpnyID = @parm1 and RefNbr like @Parm2".  Then in the screen customize the fields PV property so that the first parameter is your current company by using "bPes.CpnyID" and then the second paramter is the RefNbr with the wildcard checked.  You may not be able to customize the PV​ if it's a standard field.  You may need to swap out the field on the screen with a user field to use the custom PV setting and then syncrhonize the value between the oringal field and the new user field through VBA code.


------------------------------
James Moore
Software Engineer & Senior Consultant
SBS Group - SoCal
JMoore@SBSGroupUSA.com
------------------------------



3.  RE: FST Translation for Multiple Companies - PV List Edit

Posted 5 days ago
Thanks for the response, James! I'll give it a shot a report back.

------------------------------
Jake Malyemezian
Senior Accountant/SL Administrator
HMT LLC
------------------------------