on 2011 Dec 13 10:18 AM
Does anyone know how Acquisition Value is calculated in Business One? I have to create a report and need to show the Acquisition Value.
Acquisition value is not calculated, but is a value stored in the BA_OAMD3 table
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Can you show me the correct query to retrieve the acquisition value?
Thanks in advance.
This should be a good start:
SELECT T0.[U_AsstNum], T0.[U_Desc], T1.[U_DprArID],T1.[U_APC], T1.[U_APCHist] FROM [dbo].[@BA_OAMD] T0 INNER JOIN [dbo].[@BA_OAMD3] T1 ON T0.[U_AsstNum] = T1.[U_AsstNum]
Hi,
Welcome you post on the forum.
Do you use Fixed Asset add-on?
Thanks,
Gordon
Yes, we use the Fixed Asset add-on.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.