About christophe_averous

christophe_averous

Hi experts,I'm trying to create an analytic view on HANA, but I've still have a problem... who look quiet simple !I'm trying to use arrtibute view and calculation View to calculateI have a table who give me value, for a Zone, and for a Date. we call ...

christophe_averous

The idea was only to create user function in Excel to retrieve value from SAP Business One in excel:To do that, I just created and xlam file wich refere to Microsoft ActiveX Data Objects X.X Library.In a module I create a recordset function:Public cn...

Row_Number() in a query

To count the line in a query, use row_number(). The keyword partition allow to reset the counter:example:You have to use convert as row_number() is a bigint in SQL and SAP doesn't handdle this type of value.

Recursive query for BOM exploration

Today for my first post, I will explain how we deal with BOM here in Durieu.Everybody is aware about the BOM structure in SAP Business One:OITT and IIT1.One question that every people who deal with Bom can ask is :How do I retrieve in one query all t...

christophe_averous

Hi,I'm in SAP B1 8.82 PL08 and I have a new machine with office 2013.The excel export doesn't work.Is anybody experienced the same behavior.Best regardsChristophe

christophe_averous

Thanks Florian, I have created a calculated colum, and it's works. Regards,

christophe_averous

Hi Artem,Are you able to use others addon on your 9.1 PL03 ? (Payment engine, SBOScript ...)I do have the same issue, but with all addon, not only with Boyum Addon. I cannot connect EXCEL usine DI API / UI API...I use 9.1 PL04, and it seem to be not ...

christophe_averous

Hi everybodyI've got the same issue, but I use SAP B1 Cloud installation (9.1, PL04). and in Cloud Version, addon(extension) licence management have to be done in Cloud Control Center, not in SAP B1 Client.

christophe_averous

Hi,The reason is that row_number retrieve a bigint, and SAP B1 doesn't handle this kind of type.If you want to use it, you have to use convert:For example to have a query which count the order by docduedate:Select convert(int,row_number() over(partit...

christophe_averous

Hi Pradeep,And what about negative inventory. DO you manage it at the warehouse level, or at the item level?Could be the reason for this message.Best regardsChristophe

User Statistics

User Activity

HANA modeling - field comparison to filter records

SAP BUSINESS ONE AND USER FUNCTION IN EXCEL

Row_Number() in a query

Recursive query for BOM exploration

SAP BUSINESS ONE AND OFFICE 2013

Re: HANA modeling - field comparison to filter records

Re: error 8037 Failed to connect or logon to SLD

Re: Failed to assign SAP Business One user license to SAP Add-Ons

Re: Row_number() -SQL function throws error - SAP B1 2005 B - PL 36

Re: 1470000368 - The quantity allocated to bin locations must be positive