Hi everyone,I'm working on a complex query in SAP Business One that uses subqueries. However, I'm encountering an error when trying to use a dynamic parameter.The query works perfectly when:The parameter is hardcoded.The problem arises when:I try to...
Hi,
I’m trying to create a query in SAP business one for ageing stock inventory. There is a system build report in SAP called Ageing Stock Report, how can I extract the query so I can modify it? Or the next best option of to write the query.
I’v...
Hi,
Do you know if its possible in SAP or any addons where the line in a sales order changes colour depending on a validation. Eg if Item Code property is checked then the item code box turns to a different colour or highlights it?
Thanks
HS
Hi,
I'm trying to write a query with using financial week numbers from DocDate table in OINM table in SAP Business One
My financial year is April to March.
Example April 4rd 2022 will be Financial Week 1
April 11th 2022 will be Financial Week...
Hi,
Currently we have users working on SBO Web Browser (Dispatcher) externally. It works fine, you can connect and use it etc. But we are finding it is behaving very odd.
When using the web browser when you right click you see a list of menus, fr...
Thank you for your comment nearly there, i cannot join the OINM and OFPR table as there is no link.I'm trying to get the opening balance of Stock (Inventory) by week number for the financial year.Thanks