SAP Support

How to set BrowseBy in SAP B1

Browse option is set in SAP B1 so that the navigation button work properly.

form.DataBrowser.BrowseBy = "txtDcEntry ";

<DataBrowser BrowseBy=" txtDcEntry "/>

where txtDcEntry edit text control must be bounded to DocEntry field then next previous menus will automaticaly managed

Refer link of sap.sdn : http://scn.sap.com/thread/1709240

Convert Total Amount to Words in Crystal Report

The Below code is to convert the Total Invoice amount to word with decimal points to paise. Place this below code in a formula field. In the below code there is {@GrandTotal} field that is to be replace with the field which you need.

Advertisement

//ToWords ({{@GrandTotal}},0 )
numbervar RmVal:=0;
numbervar Amt:=0;
numbervar pAmt:=0;
stringvar InWords :=" ";
Amt := {command.DocTotal};
if Amt > 10000000 then RmVal := truncate(Amt/10000000);
if Amt = 10000000 then RmVal := 1;
if RmVal = 1 then
InWords := InWords + " " + ProperCase (towords(RmVal,0)) + " crore"
else
if RmVal > 1 then InWords := InWords + " " + towords(RmVal,0) + " crores";

Amt := Amt - Rmval * 10000000;
if Amt > 100000 then RmVal := truncate(Amt/100000);
if Amt = 100000 then RmVal := 1;
if RmVal >=1 then
InWords := InWords + " " + towords(RmVal,0) + " lakhs";

Amt := Amt - Rmval * 100000;
if Amt > 0 then InWords := InWords + " " + towords(truncate(Amt),0);
pAmt := (Amt - truncate(Amt)) * 100;
if pAmt > 0 then
InWords := InWords + " and " + towords(pAmt,0) + " paisa only"
else
InWords := InWords + " only";
ProperCase(InWords);

Create a simple report for SAP Business One 8.8

SAP B1 8.81 Highlights

Video Explains the Highlights of new SAP 8.81

Crystal Reports

Crystal Reports is a business intelligence application used to design and generate reports from a wide range of data sources. Several other applications, including Microsoft Visual Studio, at one time bundled an OEM version of Crystal Reports as a general purpose reporting tool. Crystal Reports is a popular report writer, especially when Microsoft bundled it with Visual Studio versions 2003 through 2008. Microsoft discontinued this practice and later released their own competitive reporting tool, SQL Server Reporting Services (SSRS). Crystal Reports for Visual Studio 2010 is still available as add-on software.

^{http://en.wikipedia.org/wiki/Crystal_Reports}

SAP B1

SAP Business One is an integrated enterprise resource planning solution for small and medium-sized businesses, as well as divisions and subsidiaries of larger companies. Produced by SAP, the solution is intended to assist companies by providing support for sales, customer relationships, inventory, operations, financials and human resources. The application has over 30,000 customers.

SAP Business One provides essential business functions out-of-the-box, including:

Financial management: automate financial and accounting processes. Includes support for multiple currencies, budgeting, and bank reconciliation
Warehouse and production management: manage inventory across multiple warehouses, track stock, and manage production orders based on material requirements planning
Customer relationship management: offers sales and opportunity management, and after-sales support
Purchasing: automate procurement – from purchase order through vendor invoice
Mobility: for iOS, SAP releases an app for iPhone or iPad to interact with SAP Business One in the backend:
Reporting and Business Intelligence: provides access to data in order to create new reports and customize existing ones with integration with Crystal Reports
Analytics Powered by SAP HANA: using in-memory computing technology / SAP HANA database for instant access to real-time insights:

SAP Business One is delivered with 41 country localizations, and supports 26 languages.

Continue reading in http://en.wikipedia.org/wiki/SAP_Business_One ,
www.sap.com

SDK Help : Custom line numbers for sales orders ?

We need to integrate our system with B1. We create sales orders with our system and then we export them to B1 using DI API.

Our system enumerates order lines starting from 10 and incrementing by 10 (so: 10, 20, 30,...).
I see B1 enumerates order lines starting from 0 and incrementing by 1 (so: 0, 1, 2,...).

Can we change this behaviour in B1, so we can make it work like our system? I saw that LineNum property in Document_Lines object is read-only...
It would be a good improvement even if we could make it start from 1, instead than 0.

Many thanks!

Correct Answer by Simone Pastorin

I also realized that, while LineNum and VisOrder starts from 0, the line number the user sees starts from 1, both in order lines grid and in order prints.
This counter the user sees doesn't care about what LineNum or VisOrder are (0,1,2 or 1,2,3 or 34,51,58 etc.), it always shows 1,2,3.
So we must rely on it, not to confuse the user, we are obliged to adapt our system to this numbering.
Anyway I appreciate Sakthi's answer, it could be useful for other issues!

Thread Link : http://scn.sap.com/thread/3281559