Ic item pricing discount by

Question

What field in IC item pricing table determines discount by percentage or by amount?

Jay Converse Acumen · Answer

ICPRIC. PRICEFMT. 1 = Percentage, 2 = Amount 
 Here are all the fields: 
 Roto ID:IC0480 DLL Name: ICPRIC Item Pricing 
 View Composition - 11 view(s) IC0490 - ICPRTX Price List Tax Authorities IC0310 - VI0500 Items IC0390 - ICPCOD Price List Codes IC0750 - ICUNIT Units of Measure IC0395 - ICPCTX Price List Code Tax Authorities TX0002 - TXAUTH Tax Authorities IC0481 - ICPRICC Pricing Price Checks IC0482 - ICPRICP Item Pricing Details IC0758 - ICWCOD Weight Units of Measure IC0392 - ICPCODC Price List Codes Checks IC0290 - ICILOC Location Details 
 Index List - 3 Index(es) 0 - Currency Code CURRENCY, ITEMNO, PRICELIST 1 - Item Number ITEMNO, CURRENCY, PRICELIST 2 - Price List Code CURRENCY, PRICELIST, ITEMNO 
 Field List - 90 fields 
 Name Type Size Prec Description Index Attrib Initial Value CURRENCY String 3 0 Currency Code 1 RKEA USD Mask Presentation - %-3N ITEMNO String 24 0 Unformatted Item Number 2 RKEA Mask Presentation - %-24C PRICELIST String 6 0 Price List Code 3 RKEA Mask Presentation - %-6N DESC String 60 0 Description 4 EA PRICEDECS Integer 2 0 Decimals in Price 5 EA 2 List Presentation with 7 items in the list: 0 - 0 1 - 1 2 - 2 3 - 3 4 - 4 5 - 5 6 - 6 MARKUPCOST BCD 10 6 Markup Cost 14 EA 0 MARKUPUNIT String 10 0 Markup Unit of Measure 15 EA Mask Presentation - %-10w MARKUPCONV BCD 10 6 Markup Conversion Factor 16 EA 0 PRICETYPE Integer 2 0 Selling Price Based on 17 EAP 1 List Presentation with 7 items in the list: 1 - Discount 2 - Markup on Markup Cost 3 - Markup on Standard Cost 4 - Markup on Most Recent Cost 5 - Markup on Average Cost 6 - Markup on Last Unit Cost 7 - Markup on Landed PRICEFMT Integer 2 0 Discount/Markup Price by 18 EA 1 List Presentation with 2 items in the list: 1 - Percentage 2 - Amount PRCNTLVL1 BCD 5 5 Discount/Markup Percentage 1 19 EA 0 PRCNTLVL2 BCD 5 5 Discount/Markup Percentage 2 20 EA 0 PRCNTLVL3 BCD 5 5 Discount/Markup Percentage 3 21 EA 0 PRCNTLVL4 BCD 5 5 Discount/Markup Percentage 4 22 EA 0 PRCNTLVL5 BCD 5 5 Discount/Markup Percentage 5 23 EA 0 PRICEBASE Integer 2 0 Price Determined by 24 EA 1 List Presentation with 2 items in the list: 1 - Customer Type 2 - Volume Discounts PRICEQTY1 BCD 10 4 Quantity Level 1 25 EA 0 PRICEQTY2 BCD 10 4 Quantity Level 2 26 EA 0 PRICEQTY3 BCD 10 4 Quantity Level 3 27 EA 0 PRICEQTY4 BCD 10 4 Quantity Level 4 28 EA 0 PRICEQTY5 BCD 10 4 Quantity Level 5 29 EA 0 MARKUP BCD 5 5 Markup Factor 30 EA 1 LASTMKPDT Date 5 0 Last Markup Cost Change Date 33 EA PREVMKPCST BCD 10 6 Previous Markup Cost 34 EA 0 LASTEXCHDT Date 5 0 Last Exchange Rate Change Date 35 EA PREVEXCHRT BCD 8 7 Previous Exchange Rate 36 EA 0 ROUNDMETHD Integer 2 0 Rounding Method 37 EA 1 List Presentation with 3 items in the list: 1 - No Rounding 2 - Round Up 3 - Round Down ROUNDAMT BCD 10 6 Round to a Multiple of 38 EA 0 AMOUNTLVL1 BCD 10 6 Discount/Markup Amount 1 39 EA 0 AMOUNTLVL2 BCD 10 6 Discount/Markup Amount 2 40 EA 0 AMOUNTLVL3 BCD 10 6 Discount/Markup Amount 3 41 EA 0 AMOUNTLVL4 BCD 10 6 Discount/Markup Amount 4 42 EA 0 AMOUNTLVL5 BCD 10 6 Discount/Markup Amount 5 43 EA 0 PRICEBY Integer 2 0 Price By 44 EAX 1 List Presentation with 2 items in the list: 1 - Quantity 2 - Weight MRKUPWUNIT String 10 0 Markup Weight Unit of Measure 45 EA Mask Presentation - %-10w PRICEWGHT1 BCD 10 4 Weight Level 1 46 EA 0 PRICEWGHT2 BCD 10 4 Weight Level 2 47 EA 0 PRICEWGHT3 BCD 10 4 Weight Level 3 48 EA 0 PRICEWGHT4 BCD 10 4 Weight Level 4 49 EA 0 PRICEWGHT5 BCD 10 4 Weight Level 5 50 EA 0 CPRICETYPE Integer 2 0 Price Check Type 51 EA 0 List Presentation with 4 items in the list: 0 - None 1 - Warning 2 - Error 3 - Approval CCHECK Integer 2 0 Check 52 EA 1 List Presentation with 2 items in the list: 1 - Unit Price 2 - Sales Margin CCHECKBASE Integer 2 0 Check Base 53 EAP 1 List Presentation with 3 items in the list: 1 - Cost Plus a Percentage 2 - Cost Plus a Fixed Amount 3 - Fixed Amount CBASE Integer 2 0 Cost/Margin Base 54 EAP 1 List Presentation with 6 items in the list: 1 - Markup Cost 2 - Standard Cost 3 - Most Recent Cost 4 - Average Cost 5 - Last Unit Cost 6 - Landed DEFBUNIT String 10 0 Default Base Unit 55 CEA Mask Presentation - %-10w DEFBWUNIT String 10 0 Default Base Weight Unit 56 CEA Mask Presentation - %-10w DEFSUNIT String 10 0 Default Sale Unit 57 CEA Mask Presentation - %-10w DEFSWUNIT String 10 0 Default Sale Weight Unit 58 CEA Mask Presentation - %-10w STOCKITEM Boolean 2 0 Stock Item 59 CA True List Presentation with 2 items in the list: False - No True - Yes DBASEPRICE BCD 10 6 Base Price 60 EA 0 DBASEUNIT String 10 0 Pricing Unit of Measure 61 EA Mask Presentation - %-10w DBASEWUNIT String 10 0 Pricing Weight Unit of Measure 62 EA Mask Presentation - %-10w DBASECONV BCD 10 6 Base Conversion Factor 63 EA 1 DSALEPRICE BCD 10 6 Sale Price 64 EA 0 DSALEUNIT String 10 0 Sale Unit of Measure 65 EA Mask Presentation - %-10w DSALEWUNIT String 10 0 Sale Weight Unit of Measure 66 EA Mask Presentation - %-10w DSALECONV BCD 10 6 Sale Conversion Factor 67 EA 1 DSALESTART Date 5 0 Sale Start Date 68 EA DSALEEND Date 5 0 Sale End Date 69 EA FMTITEMNO String 24 0 Item Number 70 CA Mask Presentation - %-24C STOCKUNIT String 10 0 Stocking Unit of Measure 71 CA Mask Presentation - %-10w BPRICETYPE Integer 2 0 Base Price Type 72 EAP 1 List Presentation with 3 items in the list: 1 - Base Price for Single Unit of Measure 2 - Base Price for Multiple Units of Measure 3 - Base Price Calculated Using a Cost BDEFUSING Integer 2 0 Default Base Price Using 73 EAP 0 List Presentation with 3 items in the list: 0 - No Default 1 - Cost Plus a Percentage 2 - Cost Plus an Amount BLOCATION String 6 0 Base Location 74 EA Mask Presentation - %-6N BBASE Integer 2 0 Base Cost Base 75 EAP 1 List Presentation with 5 items in the list: 1 - Standard Cost 2 - Most Recent Cost 3 - Average Cost 4 - Last Unit Cost 5 - Landed BPERCENT BCD 5 5 Base Percentage 76 EA 0 BAMOUNT BCD 10 6 Base Amount 77 EA 0 BRATETYPE String 2 0 Base Rate Type 78 EA SP Mask Presentation - %-2N BRATEDATE Date 5 0 Base Rate Date 79 EA 10/17/2018 BEXCHRATE BCD 8 7 Base Exchange Rate 80 EA 1 BRATEOP Integer 2 0 Base Rate Operator 81 CEA 1 List Presentation with 2 items in the list: 1 - Multiply 2 - Divide BRATEOVRRD Boolean 2 0 Base Rate Overidden 82 EA False List Presentation with 2 items in the list: False - No True - Yes SPRICETYPE Integer 2 0 Sale Price Type 83 EAP 1 List Presentation with 3 items in the list: 1 - Sale Price for Single Unit of Measure 2 - Sale Price for Multiple Units of Measure 3 - Sale Price Calculated Using a Cost SDEFUSING Integer 2 0 Default Sale Price Using 84 EAP 0 List Presentation with 3 items in the list: 0 - No Default 1 - Cost Plus a Percentage 2 - Cost Plus an Amount SLOCATION String 6 0 Sale Location 85 EA Mask Presentation - %-6N SBASE Integer 2 0 Sale Cost Base 86 EAP 1 List Presentation with 5 items in the list: 1 - Standard Cost 2 - Most Recent Cost 3 - Average Cost 4 - Last Unit Cost 5 - Landed SPERCENT BCD 5 5 Sale Percentage 87 EA 0 SAMOUNT BCD 10 6 Sale Amount 88 EA 0 SRATETYPE String 2 0 Sale Rate Type 89 EA SP Mask Presentation - %-2N SRATEDATE Date 5 0 Sale Rate Date 90 EA 10/17/2018 SEXCHRATE BCD 8 7 Sale Exchange Rate 91 EA 1 SRATEOP Integer 2 0 Sale Rate Operator 92 CEA 1 List Presentation with 2 items in the list: 1 - Multiply 2 - Divide SRATEOVRRD Boolean 2 0 Sale Rate Overidden 93 EA False List Presentation with 2 items in the list: False - No True - Yes PROCESSCMD Integer 2 0 Process Command 94 CEA 0 List Presentation with 5 items in the list: 0 - Nothing to Process 1 - Default the Base Price 2 - Default the Sale Price 3 - Set Price List Maintenance Status 4 - Reset Price List Maintenance Status CHECKITEM Boolean 2 0 Check Item Existence 95 CEA True List Presentation with 2 items in the list: False - No True - Yes BRATEEXIST Integer 2 0 Calc. Base Exch. Rate Exists 96 CA 0 List Presentation with 3 items in the list: 0 - Rate does not exist 1 - Rate exists 2 - Rate is calculated SRATEEXIST Integer 2 0 Calc. Sale Exch. Rate Exists 97 CA 0 List Presentation with 3 items in the list: 0 - Rate does not exist 1 - Rate exists 2 - Rate is calculated LOCCOSTOK Boolean 2 0 Item Location Cost Allowable 98 CA True List Presentation with 2 items in the list: False - No True - Yes PRICESTART Date 5 0 Price List Start Date 99 EA PRICEEND Date 5 0 Price List End Date 100 EA

Sage 300

Ic item pricing discount by

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING