Numeric fields shows ## in Preview from SAP B1

Advertisement
I created a Crystal report layout from the Production order.
If I preview the report in Crystal Reports the data is shown correctly.
When i Preview the report through SAP Business One, all numeric fields, e.g. docnum, quantity, Shows # values instead of the numeric values.
This is SAP B1 Hana.
Advertisement

Replay

Hi Janice,
Several options:
If these are discret fiels (single values from a single record), basically the size to display is too small:
The picture suggest the size of the layout for the field in CR, not the size of the field (meaning, saying 2 digits in the format while you have 4 to show),
The size of the display is too small, but I don't take it.
If a summary field, then the report is trying to mix values with different units, which is not coherent; in which case B1 display *
Regards,
Eric

The recent upgrade for i-tunes prevents me from adding and using the Field, "Show". How can I add this field in i-tunes?

The recent upgrade for i-tunes prevents me from adding and using the Field, "Show". How can I add this field in i-tunes?Hold down shift as you right-click > Get Info to get the old style dialog box. tt2Read other 2 answers

Not transfer field KNA1-STCD2 from SAP R/3 4.70 to CRM 3.0

Hello to all. We decided no to use the field KNA1-STCD2 in all the customers created in SAP R3 4.70 and we want not to transfer this field from SAP R/3 4.70 to CRM 3.0. There are several customers with value in this field  in R3 but they never were t

Qty field  value diff from SAP R/3

hi friends,     i have replicate one table datasource  from  SAP to BW................. in datasouce i m using RFMNG quantity field and in BW mapping it to 0DEL_QTY....... both having datatype lenth 17 and decimal 3................. data loading is d

Extracted Info objects from SAP R/3 not appearing in SAP BW side

Hi, I am trying to extract three fileds through generic extraction using function module, I have checked the fields(values)in RSA3 ,which shows the correct values but the values are not showing in ODS when extracted from SAP R/3 , Any one can advice

MS Excel automatically converts numeric fields to date format

I have at least 2 different spreadsheets where this happens.  I maintain them for months, adding, changing, deleting data.  They contain lots of data elements (numeric, text, date, etc).   Some columns are all numeric, some all dates, etc.  Then sudd

Extraction from SAP ECC to SAP BI

What are the steps for Extraction from SAP ECC to SAP BI? Thanks.Hi, we have two types of extractions 1) Application specific 2)cross application under applicatin specific -->we have customer genenrated and business content extractions under customer

Url Iview from SAP Portal to Infoview encounters "Access is denied"

Hi We are using URL Iview to point to Business Objects Infoview from SAP Portal. Our requirement is to launch the Infoview within the portal content area. We are able to preview the iview, but encounter "Access is denied" error when we add the i

Data not getting fetched into Flex from SAP backend

Hello.... I have tried fetching data from SAP into Flex for simple BAPIs. For Ex; there would be 2 to 3 fields and we enter some values in it and these values are wrapped into an object and sent to SAP to fetch the details. This works fine. But now,

License Status showing Invalid License for SAP CE7.2

Hi I have installed and configured SAP CE7.2 in windows with oracle. Recently when i check the CE7.2, Java engine was stopped due to invalid license. After that i requested for permanent license key from SAP then i have applied the same license file

Subject: Tabs - Show tab previews in the Windows taskbar. For what ever reason, this option doesn't show up for me to select. Why, or was this feature moved or removed?

I'm running FireFox 10 and I have Windows 7 Ultimate on my PC. I would like to have the ability to select an open tab from the Windows taskbar. For what ever reason, this option is not showing in the Tools - Options - Tabs window. So, I can't select

Scientific notation in numeric fields

I need to be able to input scientific notation in numeric fields for my adobe forms.  I can put the pattern to num{9.99E} and it will allow me to put positive exponents and negative exponents to -3.  However, I need to input the number 4.76E-19 and i

Regarding Extracting Data from SAP CRM

Hi, 1) What are steps to extract data fron  SAP CRM? I heared that we get different types of errors while extracting data from SAP CRm to BW when compared to BW 2) From which tables BW system is getting data when we extract data from SAP CRM Lead man

Regarding Outside database table acess from SAP R/3.

dear all, is it possible to access or call outside (thiird party) databse table from SAP R/3?? if it is then pls send me any useful link or any help regarding the same. i will be so thankful. regards, jigarHi jigar, 1. for this u will also require he

Cell background colors are not showing in preview - help? - DW4

Hi, I created a horizontal table for my menu bar, and gave each cell a different color by creating a separate class for each with background image - image is a block of color created in Photoshop. In design mode they look they way I want, but in prev

Format Numeric Field

I format a Numeric Field with: 88/99/8888, and now i need a script to make sure that "99" is not greater than 12. Can someone help me out on this please?Why not simply use a date control. The user would pick the date from a calendar and you woud

Problem in message mapping (outbound IDOC ORDERS05 from SAP R/3)

Hi to all, I have an outbound interface from sap r3 sap r3 --> XI --> ftp server idoc --> XI --> text file Using IDOC orders05 The problem is in segment E1EDP01/E1EDP19 Segment E1EDP01 is unbounded and i map it well. If it contains E1EDP19, wo

Large numeric field in a .csv file will not display

A .csv file contains a numeric field which in some rows contains an 11-digit number (like 14024583126).  These will not display (blank or null).  Some of the rows contain numbers of 5-digits or 7-digits and these display fine.  How can I get the 11-d

Export to Word from SAP B1 2007A

Hi all. When trying to export marketing document (sales order) to word from SAP B1 2007 A - I get error message. The error message appears in the word document and it states "unacceptable field". The template document also fails to return values

Cover Flow won't show JPG preview, only generic JPG icon

Hello, For some reasons, I don't see JPGs in Cover Flow mode. I can see them in Quick Finder no problem. I tried the following and toggle the on/off the feature without success: Go to Finder, open a window, and click View>Show View Options. From ther