Hi, 

What is the difference between Amount and Primary Amount fields in the following tables: 

 - Order

 - OrderProduct

There are some other fields with primary counterparts like (Total, TaxAmount) in OrderProduct and InvoiceProduct tables. I have seen the orders section documentation on Academy but only the "Amount" field is documented. Similarly, what is the rationale of having Quantity and BaseQuantity fields in OrderProduct table?

In addition, is there any Use Case where these fields have a different value. Like Amount and Primary Amount fields with a different value.

Thank you,

Like 0

Like

1 comments

Dear Hatim, 

Regarding to the Primary Amount there is no such column in the base configuration, could you please specify the column name?

Regarding to the Base quantity: when editing product you can add units of measure that indicate the number of pieces in singular product transaction (pieces, packages, etc.) When choosing anything besides pieces you specify the amount of pieces (when choosing pieces the correspondence to the Quantity is 1 to 1). See the first screenshot in attachments. After that when you add product on the detail you specify in which units it would be purchase (See the 2nd screenshot). After adding product Base quantity is updated following the equation Quantity * Pieces in unit and Total is calculated as Base quantity * price (See the 3rd screenshot). When the Quantity is updated the Base quantity gets updated and the Total is recalculated.

https://prnt.sc/lz06nz

https://prnt.sc/lz06y7

https://prnt.sc/lz0735

Here is the example, lets say that I want to ship bottles of water and i want to ship them in packages of 6 bottles. In this case i add unit measure of package in my product and set the number of units in a package to 6. When I add this product on a detail and add packages as unit of measure if i choose to ship 1000 packages the quantity would be 1000, the Base Quantity, however, would be 6000 as I ship 6*1000 bottles in total. The total cost would be calculated based on the Base quantity amount. 



Best regards,

Dennis

Show all comments
case
Business Process
Numbering
7.12_()
sales_enterprise

Hello Community! I need create a case for each collection recived in a web service call and i can make it with a script task but the problem is the number of case. How can generate a ordinal number for each record in the loop?

Regards,

Like 0

Like

1 comments

If you could do it as a separate task in the process, you could use a User Task with "Generate ordinal number" to populate that. If you wanted to do it in the loop in your script task code, you could read the system settings for CaseCodeMask (which contains the prefix string) and CaseLastNumber (which contains the last number used). Then increment the value for each case and then write back the last value used to the CaseLastNumber setting.

FYI this is how the UserTask does this: https://github.com/CustomerFX/BpmOnlineBase/blob/9a8a337a470d914a6ec00f…

Show all comments
Import
large data
excel
7.12_()
sales_enterprise

Hi all,

I'm starting a contract project helping to convert an automated workflow-based system to BPM Online. Our Database is fully 3rd normal form with over 60 tables. In the grand scheme of things, it's a pretty small database, however for import into BPM Online, it seems to be pushing the limits when it comes to importing data.

BPM Online will be substantially customized with forms and workflow. 

At this point, I'm struggling with two different issues:

1. I've been told that Excel spreadsheets are the only way to import legacy data, and each spreadsheet can only be a maximum of 10 MB. Some of our tables have almost a million rows each and will be 20+ spreadsheets each. That means we'll have more than a hundred separate import runs.

2. A test loading one spreadsheet of one of our tables with 60 columns took an hour. It appears that we're looking at over 100 hours runtime, just to load our data.

This seems burdensome for import into an enterprise class appplication like BPM Online. Is there another approach?

BTW, I'm not sure which product and version we'll be on. I marked Enterprise.

Thanks in advance to all,

Bill

Like 1

Like

1 comments

Dear Bill,

You can create a webservice which will transfer data from your system to BPM'online. It will still impact performance of your system but it will be more flexible for your business task. I have picked a couple of articles from our academy that should help you to implement this functionality:

https://academy.bpmonline.com/documents/technic-sdk/7-13/integration-bp…

https://academy.bpmonline.com/documents/technic-sdk/7-12/web-services-c…

https://academy.bpmonline.com/documents/technic-sdk/7-13/odata

https://academy.bpmonline.com/documents/technic-bpms/7-13/studying-web-…

You may also refer to sub articles in the "See also" section below the main article.



Best regards,

Angela

Show all comments
ProtectedExcel
ExcelReportBuilder
7.12
sales_enterprise

Hi. 

how can I use password protected excel for Template in Excel Report Builder ?

 

It showing below error when I generate the report.

 

 

Like 0

Like

1 comments

Dear Visitor,

Most likely it is not possible to use password protected excel file as a template in the application. I would suggest you to contact the developer of this extension by email for more details - bpmonlinelabs@bpmonline.com

Best regards,

Dean

Show all comments
7.12
sales_enterprise

Hello Community!

 

I´m not available to replace the ProductSelectionViewModel. I need add a new column with the Product.Category.

Just following the post in community: https://community.bpmonline.com/questions/adding-product-image-product-selection-page

 

Any ideas?

 

Like 0

Like

1 comments

Try set System Setting with code 'Feature-ValidateConfigurationOnChange' disabled

Show all comments
data binding
7.12
sales_enterprise

Hi,

I have on-premise installation of bpmonline by local vendor.

however when I do verify configuration check, it showing list of error on data binding.

 

how to fix this ?

I tried to delete it but it showing this message:

 

Thank you

Like 0

Like

1 comments

Dear Antonius, 

Please contact your vendor or our support regarding this issue. Our support email is support@bpmonline.com We will be happy to help you! 

Regards, 

Anastasia

Show all comments
7.12
sales_enterprise

Hello Community! 

Is posible increase the numbers of digits in a decimal type to 5 after comma?

Regards,

Like 0

Like

1 comments

There is no such option

You can try to create an integer type column and assume that it contains everything on a scale of 1 to 100,000

Show all comments
price list
pricing model
7.12
sales_enterprise

Background: We have term pricing for products and we've created a product for each term (12, 24, 36 and M2M), but this is a nightmare to manage for a few hundred products. We'd like to explore using price lists to better manage the pricing differences.

Questions: Are price lists the best way to manage the term pricing differences in products? If so, can someone point us towards documentation to help us properly configure it?

If price lists aren't the best way, we are open to suggestions as we'd like a better way to manage our product catalog.

Thanks in advance, -Toby

Like 0

Like

1 comments

Dear Toby,

In the "Products" section on the correspondent product's page you can find a tab called "Prices and availability" where you can find a correspondent detail called "Price" (see screenshot http://prntscr.com/l264sz). In this detail there is the lookup field called "Price list" where you can choose the term. You can specify terms in the correspondent lookup in the "Lookups" section. Once they will be registered you can apply them for each product and after that you can choose them. Here is the regarding academy article on this topic. Hope this helps.

Best regards,

Oscar

Show all comments
7.12
sales_enterprise

Hello Community! Is posible apply css style to a specifict column un a detail? Example change the border to red in the field cell.

 

Like 0

Like

4 comments

Hello Federico,

1. You need to create a new module. 

In my example, I named it as UsrAccountContactsDetailV2Css. Then you need to navigate to the LESS tab and write your custom styles. In my example it was:

div#grid-AccountContactsDetailV2DataGridGrid-wrap > div>div:nth-child(2){

    border-color: red;

    border-style: solid;

    border-width: 1px;



Leave the source code for the module empty. Please, see my screenshot - http://prntscr.com/l21yvf

2. Create a replacing module for your schema detail and add the created earlier module as a dependency.

Please, see my example - http://prntscr.com/l21zft

As a result,  AccountContactsDetailV2 detail looks in the following way - http://prntscr.com/l21zzx

Hello Tetiana, the screenshots in your reply are no longer visible. Would you please upload them again? Thank you very much!

Andrew Sheng,

 

Hello,

 

Sure, here they are:

 

1) Creating CSS in the Less tab of the module:

2) Connecting CSS to the detail schema:

Oleg Drobina,

Hello,

 

I tried to follow your example above but it's just didn't work on me. i don't know which part is wrong, can you help me to check it please

1. tried changing css in inspect browser and its work like what i want

 

2. create CSS in LESS tab module

 

3.Connecting CSS to the detail schema

 

but nothing changes happen to my form.

and if you don't mind, please check my question in here https://community.creatio.com/questions/custom-image-size for the subject.

Thank you

Show all comments
7.12
sales_enterprise

Hello Community! Is posible cast the field Currency to add the $ simbol before the number? I want make the same with the % simbol in the integer fields.

 

Regards,

 

Like 0

Like

3 comments

Hello.

You can add the following symbols to the field by simply adding a mask to the field like in the academy article below:

https://academy.bpmonline.com/documents/technic-sdk/7-12/how-add-field-…

However, that would be applicable only to the string fields and will render you unable to perform calculations and such.

Alternatively, I would recommend you to use multi-currency fields instead:

https://academy.bpmonline.com/documents/technic-sdk/7-12/how-add-multi-…

Best regards,

Matt

How can we do this in FreedomUI pages?

Hello,

 

Our R&D team has a task to implement a multicurrency field in Freedom UI in the 8.2 application version.

 

Unfortunately, there are no examples in the documentation or application of implementing it in the current application versions. So please wait until 8.2 when this column will be available out-of-the-box and could be used on the pages.

Show all comments