Replies posted by carolina.pullen

5 Replies

C
carolina.pullenInspiring
asked in Kinetic & Epicor ERP

Problem with Commission calculation under Quote Entry – Worksheet Tab

Thanks for your response.To clarify how the commission is calculates as £1200 it is using the formula provided:(Cost of part with mark-up) / ( 1 - Commission Rate)10,800 / (1 - 0.10) = 10,800 / 0.9 = 12,000If we sell an order with a value of 12,000 and we pay a sales agent 10% commission, their commission will always be calculated as 10% of the “sales value”.So the commission amount to be built into the quoted price needs to be based on the “Sales”, not on the “Total price w/commission” value.If it is based on the “Total price w/commission” value it will be lower, which means that we won’t build enough into the quoted price to pay 10% commission on the sales value.I hope this makes sense. 

4
T
1 month ago
C
carolina.pullenInspiring
asked in Kinetic & Epicor ERP

Problem with Commission calculation under Quote Entry – Worksheet Tab

See screen print of current calculation below: 

4
T
1 month ago
C
carolina.pullenInspiring
asked in Kinetic & Epicor ERP

How to TRIM description field

Thanks for your reply. As I don’t want to get rid of all spaces (i.e. single spaces are ok), I did try to use the replace formula with something like:  replace “  “ with “ “ (i.e. replace a double space with a single space). This works, but there are instances of 10 or more spaces.  So I “nested” the above a few times, and it reduced the spaces by a bit but not all (unless I keep on nesting). Just wondering if there is a better formula, as I don’t know what is the maximum number of spaces… PS: For the special characters, I’m currently also using the replace function (for commas, diameter symbols, microns symbols, etc). 

2
C
1 year ago
C
carolina.pullenInspiring
asked in EMEA - UK

Adding Country name onto SO Pick List (problem with RDD field type)

Hi, just checking if anyone has any other suggestions regarding the above?Thanks.

3
C
1 year ago
C
carolina.pullenInspiring
asked in EMEA - UK

Adding Country name onto SO Pick List (problem with RDD field type)

Thanks for that. How strange!  From what I can see the relationship I have on the SOPickList RDD is identical to yours (see screen print below) but I get the following error when I attempt to run the report: Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask: Parent Columns and Child Columns don't have type-matching columns.  

3
C
1 year ago
Terms & Conditions