Dear Experts,I have some scenarios where i have to run some sql queries dynamically , i went through many threads and found some useful and tried to use them but unfortunately i am still not done with this.below is my code i want to executeRegards,M...
Hi All,I have a scenario where i have common table across multiple Schema's, now i want to pull the data from all the schema's using one query or SP or View.I can do it using the Union function but my challenge is what if i have some new schema's i...
Dear Experts,I have a crystal reports which works fine on execution 3 to 4 times but on 5 or 6th turn it throws me the below error.i tried to fix the connection many times but did not work.any help will be appreciated.--Manish
Hi Experts,I have done the grouping in specified order, once i save & close the formula and refresh the window it works but when i close the report and reopen, it gives me the below error and again i have to do the changes in the formula . i tried so...
Hi Experts, I am trying to achieve the current logged in user detail , below query i tried on SAP B1 on SQL and it is working fine SELECT T0.U_NAME FROM OUSR T0 WHERE T0.INTERNAL_K = $[USER] but it is not working in B1 on HANA , I trie...
Hi,
I guess its because of that Last Purchase Price and Last Calculated price are picked by system automatically which is updated automatically on any transactions you do related to selected Product.
for other price lists, these are entered by...
Hi,
all dimensions are independent, for expense postings if you wants to see by department then allocate it to maintenance department or relevant department, also remember that when you create any cost center a distribution rule is also created aut...