About jimmyl

jimmyl

Hi Community, I would like to give another try and see if anyone from the community has come across a similar scenario and can shed me some light. The company is currently in the distribution business using B1 9.2. It will be entering...

jimmyl

Dear all,I am working in a B1 function extension project and hoping the community will shed me some light. The company I am working for is changing the business model from purely wholesale/distribution to have some field service added to deals if nee...

jimmyl

Hi all,I had a Dashboards 4.0 installed and licensed previously in my environment. However, my OS got re-installed as well as the dashboard designer. Can I still use the previous license or how can I update it?Thanks,Matt

jimmyl

Hi all,I recently upgraded my Personal Version Lumira from a previous 1.0.1 to 1.12. However, when I tried to connect with our HANA database, it stopped responding in the Dataset Creation window (please refer to attachment).I've tried to reinstall, 2...

jimmyl

Hi all,I am new as an BA and new to HANA modeling. With our HANA server installed, I used to work with HANA Studio at my desktop on some BI projects. We recently performed a reboot and it seems HANA server got upgraded as I saw some new UI5 and XS pa...

jimmyl

Hi Stephen, B1's price list should be able to manage different price lists. That one column in your screenshot doesn't mean you can have only one price for an item. The idea is that, you need to setup and manage different price lists first (by g...

jimmyl

Hi Deepak, If you export the current layout and open it on Crystal Reports designer, you should be able to see the logic in use and modify it towards your requirements. Thanks, Jimmy

jimmyl

Hi Hon Ping, In my B1 environment, there is NOT the "Stage" column that I can add to my Sales Order window. (It could be because the screenshot you showed is in a different B1 version). If the "Stage" value is already added to th...

jimmyl

Hi Diogo, Can you call the stored procedure in HANA studio? If no, it might the syntax difference. If the stored procedure can be run in HANA studio, then it could be the data source not being up-to-dated in Crystal Reports. If something has bee...

jimmyl

Hi Ayoub, There are two types of BPs in B1 - Customer and Vendor. The query for your FMS must look at both the AR and AP side to fulfill your requirement. In your test case, "RYM1992" is created as a Customer (Ventes), so it will be shown ...

User Statistics

User Activity

Subscription Billing Model with B1 9.2

Non-Inventory and Inventory Items

OS and Dashboard Designer Re-installed

Stopped Responding in Dataset Creation

Error Occurred While Opening Views

Re: Price List

Re: GRPO Crystal report layout

Re: Assign "Project Stage" in Sales Order document row

Re: Stored Procedure SAP BUSINESS ONE on Crystal Reports

Re: hello everybody!! Can i use a formatted search to indicate a Radio Button ?