I am planning to make a report, which we have been using on excel for a long time by exporting the BIN table report and then running a macro to show a pivot table report, I guess I have sent this excel sheet to you sometime back as well
Now what is this report, this report is:
So I would request the developers to kindly look into this and preferably make a report in QUERY so that we could add a column of our own logic if the need be
select t.*,
("1D:Currency:50" + "2B:Currency:50" + "BRG:Currency:50" + "BHT:Currency:50"
) as tot1,
(case when "1D:Currency:50" + "2B:Currency:50" < "SO:Currency:50"
then '1 CORD'
when ("1D:Currency:50" + "2B:Currency:50" + "BRG:Currency:50" + "BHT:Currency:50" < "SO:Currency:50" + "ROL:Currency:50"
then "2 CSTK"
end)
from (<your query>) t
Can someone shed some light on how to use this in correct syntax for my code.
Hi Aditya,
You might need to take a second look at the labels you have used. They should be exactly as that in the query.
Try using accented quotes in outer query when referring to labels. For eg. `1D:Currency:50`
Also there could be an issue in case syntax.
Without the whole query's context, this is as far as I can guess.
Hope this helps. :)
Thanks,
Anand.
--
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To post to this group, send email to erpnext-dev...@googlegroups.com.
To unsubscribe from this group, send email to erpnext-developer...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/F7SYdXLPIFIJ.
For more options, visit https://groups.google.com/groups/opt_out.
To unsubscribe from this group, send email to erpnext-developer-forum+unsub...@googlegroups.com.
Hi Aditya,
When using labels to add (+) or compare (<) in your outer query, put them in accented quotes instead of double quotes.
Eg.
`1D:Currency:50` + `2B:Currency:50` + `BRG:Currency:50` + `BHT:Currency:50`
) as tot1
Give this a try and if no/different error comes, then atleast part of the problem is solved.
Thanks,
Anand.
--
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To post to this group, send email to erpnext-dev...@googlegroups.com.
To unsubscribe from this group, send email to erpnext-developer...@googlegroups.com.
To unsubscribe from this group, send email to erpnext-developer-forum+unsub...@googlegroups.com.
Hi Aditya,
Use accented quotes and not single quotes.
Accented quotes can be found in most keyboards to the left of 1 key.
Thanks,
Anand.
To unsubscribe from this group, send email to erpnext-developer...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/wwDgzhdgMQkJ.
To unsubscribe from this group, send email to erpnext-developer-forum+unsubscr...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/F7SYdXLPIFIJ.
For more options, visit https://groups.google.com/groups/opt_out.
--
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To post to this group, send email to erpnext-dev...@googlegroups.com.
To unsubscribe from this group, send email to erpnext-developer-forum+unsub...@googlegroups.com.
To unsubscribe from this group, send email to erpnext-developer...@googlegroups.com.To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/ovOFkimy_skJ.
To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/wwDgzhdgMQkJ.
For more options, visit https://groups.google.com/groups/opt_out.
--
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To post to this group, send email to erpnext-dev...@googlegroups.com.
To unsubscribe from this group, send email to erpnext-developer-forum+unsub...@googlegroups.com.
To unsubscribe from this group, send email to erpnext-developer...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/T5yV1eefx7AJ.
If any of you have time, I could show you how this report works and I guess this would be a good report for a STANDARD product, infact I have seen the STOCK LEVEL report and I this report is more useful than that report and also it tells me which items to produce and when. Now there are some small glitches left which don't render this report useless or less important.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer...@googlegroups.com.
To post to this group, send email to erpnext-dev...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/ecwSeDg6pzEJ.
Aditya,
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+unsub...@googlegroups.com.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer...@googlegroups.com.
To post to this group, send email to erpnext-dev...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/dTqOsFDGCAoJ.