Hi, I'm stuck and needed some help.On my purchase order in SAP Business One we have the field "ShipDate" i have created a UDF field called U_InDelDate, and created a FMS so the Ship date = U_InDelDate. This works not a problem. But the issue i'm faci...

 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...