About joseih

joseih · 11-03-2023

Hi experts, I would like to know if it is possible to add a new column in the table ORCP. Why? We use recurring transactions to remind ourselves that we need to charge some of our clients. However, these clients are separated into groups. For this...

joseih · 04-18-2023

Hi experts! I'm trying to learn how to develop add-on in SAP Business One Hana using visual studio. I already have all the components installed, but, i'm not getting much information in the videos that i'm watching, if you guys could give me some lin...

joseih · 02-15-2023

Hi guys! I'm trying to learn on how to make add-ons for SAP B1 using Visual Studio 2019 in c#. What are some good documentations for that?

joseih · 02-15-2023

Hello guys! As the titles says, I'm trying to fill up a grid using a field in my form (this field contains the CardCode ) but it isn't it returning anything. Before that, I was running some tests, and when I use the querry "SELECT * FROM OCRD" it wor...

joseih · 02-07-2023

I have this querrySELECT DISTINCT CURRENT_DATE AS "Current_Date" FROM ORDRThat i will put in a date type field.But i want only this querry to trigger when she's empty. How do i do that?

joseih · 02-08-2023

Sorry Charles! Basically i created a field in SAP B1 that indicates the month of the document, here in Brasil is a crucial thing to have. But, everytime i open a marketing documment, this field is empty, so, i wanted to have a querry that will give m...

joseih · 02-07-2023

I was trying to alter the table with this codeALTER TABLE "SBO_JC_TST"."ORDR" ADD CONSTRAINT "CurrentDateComp"DEFAULT CURRENT_DATE FOR "U_Competencia"but it keeps giving me a syntax error

joseih · 02-07-2023

Heres some image

joseih · 01-19-2023

I got it by making an conditional in the section expert of details {OINV.CANCELED} in ['Y','C']

joseih · 11-03-2022

Hello, Dell! I have four formulas, one for getting a specific client, another to get the date range, one for getting a specific type of invoice and the last one to not get any invoice that was canceled

User Statistics

User Activity

ORCP - Adding a new column

Sap business one SDK Learning

SAP B1 SDK how to

SAP Visual Studio How to fill a grid using a field in the form

Formatted Search Query in SAP B1

Re: Formatted Search Query in SAP B1

Re: Sap hana studio date field how to set default value

Re: Sap hana studio date field how to set default value

Re: Cancelled Invoices Report

Re: How to make data that don't fit a criteria show in the report