Good morning team,
I want to add a custom field on a dashboard that I create, i want to subtract the ´On Hand Qty´ minus ´Reserved Qty´ and display that. Any advice?
Do it in the BAQ as a calculated field.
Oh ok! Just one more thing, how does the minus operation works in the editor?
this field - that field = your new field?
1 Like
to elaborate, custom fields follow SQL syntax in the BAQ editor.
1 Like
Go to your help file in the user guides, tool guides, and start reading about BAQ’s. It a really good introduction to get you started on some of the basics.
2 Likes
OK, all done! Thanks everyone.
One more little thing, does anyone know from where the ´Available Qty´ field on the Counter Sales Dtl (in Order Entry) takes the data? I want to add this data to a new dashboard.
That one is a calculated field (not in the database), and doesn’t always work right. There are a few threads about that field being problematic. You’ll probably have to defined what you want “available” to mean for your company and calculate it yourself. It will probably be a subquery and becomes a bit more of a complicated BAQ.
example:
1 Like
Do it in the BAQ as a calculated field
1 Like