Settings: Mosaic Art Group (Demo)

Everything on this page is a row in a per-company table. Another distributor runs the same code with different rows: different price columns, minimum chop, footage constants, tax codes and number series. Nothing here is a code branch.

Moulding rules

Minimum cut frame

3 ft per frame (min_chop_len = -3)

Footage formula

((W + H) x 2 + 8 x moulding width) / 12, plus 0.33, rounded up to steps 0.33 / 0.67 / 1

Time zone

America/Chicago

Default price code

Price columns

Column 1	Price 1 List (length)
Column 2	Price 2 Wholesale (length)
Column 3	Price 3 Sample / max
Column 4	Price 4 Join
Column 5	Price 5 Chop / rail / fit

Number series

Series	Next number
credit memo	005001
debit memo	006001
invoice	072409
on account	008001
order	042425
purchase order	020001

Tax codes

Code	Locality	Rate
10000000	Resale, no tax	0%
48000000	State	6.25%
48201000	Demo County	1%
48201010	Fairview city	1%

Terms

2/10	2% 10, net 30	30 days, 2% in 10
COD	Cash on delivery	0 days
N15	Net 15	15 days
N30	Net 30	30 days

Line types

Code	Prefix	Label	Price column	Cut frame	Footage divisor	Minimum applies	Height = width	Special slot	Manual price	Qty decimals	Pick section	Enabled
0		Length or item	customer price code	no	1	no	no	regular	yes	1	LN	yes
1	:	Text	customer price code	no	1	no	no	regular	no	1	SP	yes
3	,	Chop	5	yes	1	yes	no	cut frame	yes	2	WC	yes
4	<	Join	4	yes	1	yes	no	join	yes	2	WJ	yes
5	/	Max	3	yes	1	yes	no	cut frame	yes	2	WC	no
6	&	Corner sample	3	yes	2	no	no	cut frame	no	1	LN	yes
7	+	Misc charge	customer price code	no	1	no	no	regular	no	1	SP	yes
8	#	Cut mat	customer price code	no	1	no	no	regular	yes	1	CM	yes
10	!	Cut glass	customer price code	no	1	no	no	regular	yes	1	CM	yes
11	%	Mount	customer price code	no	1	no	no	regular	yes	1	CM	yes
12	-	Rail	5	yes	4	no	yes	cut frame	yes	1	WC	yes
13	;	To-fit	5	yes	1	yes	no	cut frame	yes	1	WC	yes
50		Package component	customer price code	no	1	no	no	regular	yes	1	SP	no
51	@	Framing package	customer price code	no	1	no	no	regular	yes	1	SP	no

Pick ticket sections

1	LN	Length to pull (wood and metal)
2	WC	Wood chops
3	MC	Metal chops
4	WJ	Wood joins (chop then join)
5	MJ	Metal joins
6	CM	Cut mats, glass and mounts
7	SP	Supplies and hardware

Discount levels

Level	Group	Counts	Breaks and discounts
Bronze	CF	frames on the order	12+: 2%, 30+: 3%
Bronze	LF	feet / quantity	200+: 2%, 500+: 3%
Gold	CF	frames on the order	6+: 5%, 15+: 8%
Gold	LF	feet / quantity	100+: 5%, 300+: 7%
Silver	CF	frames on the order	8+: 3%, 20+: 5%
Silver	LF	feet / quantity	150+: 3%, 400+: 5%

Product codes

Code	Description	Pricing
AP	Acrylic cut	table G1 x 1.6 + $0.50
FB	Mount on foam board per united inch	$0.12 per united inch
GM	Museum glass cut	table G1 x 4.6
GR	Regular glass cut to size	table G1 x 1
GU	UV conservation glass cut	table G1 x 2.1
HW	Hardware	item price columns
LN	Liners and fillets	item price columns
MB	Matboard standard, cut per united inch	$0.36 per united inch
MR	Matboard rag, cut per united inch	$0.58 per united inch
MT	Metal moulding	item price columns
SH	Sheets	item price columns
SP	Supplies	item price columns
WD	Wood moulding	item price columns

Glass size table (united inches)

Group	Up to UI	Size	Price
G1	18	10X10	$4.40
G1	25	14X14	$5.90
G1	36	20X20	$8.75
G1	44	24X24	$11.60
G1	54	30X30	$15.90
G1	70	40X40	$23.50
G1	100	60X60	$38.00