Hello All,
I'm trying to get a profit and loss statement using only the project as a reference. When I do that, there are certain heads that are showing up as 0. When I looked further, I realized that when a delivery note or A/R Invoice is entered, the system doesn't update the project code on the row level of the JE for that DN or AR Inv and that this is a "System Functionality" according to this thread:
Though I don't see the reason behind this functionality, I accept it but I want to create a formatted search that will update the project code on the row level of the JE of the corresponding DN or AR INV. I created this FS:
SELECT T0.Project FROM ODLN T0 WHERE T0.DocNum = $[$76.10.10]
and set it on the Project field on the row level of the JE. I also set it on Auto Refresh "When Exiting Altered Column" G/L Acct/BP Code. When I tried to enter a delivery note, I got this error:
[Microsoft][SQL Native Client][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. (CINF)
Could someone please tell me what I'm doing wrong?
Reza