Re: Non real-time synchronization

[Carl Davis <..hidden..>]

On Thu, 3 Jan 2008 09:41:58 -0800
"Chris Travers" <..hidden..> wrote:


> 
> Ok.  Here are the tables you are going to have to hit:
> 
> ar:  This represents the transaction where the customer is charged.
> customer_id links to customer.id in 1.2.x.
> acc_trans:  this represents the line items in the accounting transaction.
> You will need 2 entries here for a charge, and another 2 for a payment.
> chart_id links to chart.id, trans_id links (in this case) to ar.id.  Do you
> need help determining these records and what accounts they need to hit?
> 

I would appreciate the additional help. I have attached a csv file for
charges, credits, and payments. I suppose I could combine these into
one file and make the tendnum a descr so that I still have the check
number in ledgersmb? If you are willing I would really like to see a
psql line that would allow me to import these. Thanks for the help! I
will promise if we switch from Quickbooks to this we will make a
donation to your project in money and I will help with documentation.

amount,account,tendnum
75.0000,1240,"1195"
225.0000,1241,"7230"
209.9800,1230,"844"
209.0800,1235,"3919"
39.0000,1008,"7838"
37.9800,1024,"1822"
102.5700,1237,"5058"
40.0000,1122,"1927"
40.0000,1242,"10337"
14.9500,1121,"9677"
559.8600,1099,"2485"
50.9700,1139,"8422"
39.0000,1176,"2391"
100.0000,1026,"72017"
209.0800,1245,"2922"
25.9900,1126,"2344"
55.9900,1022,"5255"
25.9900,1142,"8663"
39.0000,1214,"3562"
39.0000,1079,"7584"
37.9800,1029,"4093"
69.9800,1134,"8655"
37.9800,1015,"5236"
55.9900,1149,"39079"
132.9400,1017,"5417"
110.0000,1159,"9060"
100.0000,1188,"7247"
39.0000,1190,"4797"
25.9900,1137,"5023"
35.9900,1174,"5943"
67.9800,1115,"9085575453"
117.9800,1063,"5801"
26.9300,1213,"1018"
156.0000,1039,"3129"
29.9900,1182,"4491"
2092.5400,1243,"68050"
57.9800,1072,"1055"
35.9900,1169,"6069"
115.9300,1168,"2875"
78.0000,1184,"5723"
118.4900,1232,"7723"
37.9800,1125,"3102"
39.0000,1092,"5053"
31.9800,1070,"10335"
41.9800,1041,"3489"
35.9900,1101,"5398"
55.9900,1185,"1917"
35.9900,1110,"1158"
35.9900,1074,"6596"
65.9900,1131,"6482"
35.9900,1010,"5281"
27.9800,1049,"5885"
27.9800,1090,"1058"
37.9800,1036,"1214"
41.9900,1089,"1854"
29.9900,1103,"5019"
32.3400,1235,"3921"
27.9800,1193,"12090"
35.9900,1204,"4478"
35.9900,1133,"4207"
37.9800,1034,"3986"
35.9900,1135,"7151"
364.4400,1163,"5117"
21.9800,1123,"1772"
29.9900,1162,"2416"
41.9800,1066,"1583"
14.9500,1050,"1431"
37.9800,1172,"2100"
37.9800,1011,"1810"
305.4000,1111,"1654"
29.9900,1069,"8289"
39.9900,1128,"1015"
29.9900,1167,"7099"
29.9900,1085,"4120"
41.9800,1059,"3721"
121.8700,1157,"2618"
179.9500,1043,"2623"
69.0400,1164,"5661"
415.9000,1200,"12604"
402.4500,1220,"3433"
39.0000,1152,"9078993067"
29.9900,1021,"2399"
39.0000,1007,"1116"
29.9900,1162,"2361"
55.9200,1247,"2890"
199.0000,1247,"2889"
27.9900,1240,"1198"
29.9900,1218,"1472"
29.9900,1181,"11994"
29.9900,1181,"12027"
59.9800,1025,"5562"
29.9900,1144,"1237"
85.0000,1060,"8292"
78.9900,1197,"5518"
131.2100,1098,"6198"
14.9500,1065,"17361"
39.9900,1208,"5931"
29.9900,1165,"9812"
312.9900,1224,"6237"
19.9900,1146,"1101"

amount,account,descr
39.9900,1099,"512K Wireless Service"
39.9900,1099,"512K Wireless Service"
39.9900,1099,"512K Wireless Service"
39.9900,1099,"512K Wireless Service"
39.9900,1099,"512K Wireless Service"
39.9900,1099,"512K Wireless Service"
39.9900,1099,"512K Wireless Service"
39.9900,1099,"512K Wireless Service"
39.9900,1099,"512K Wireless Service"
39.9900,1099,"512K Wireless Service"
39.9900,1099,"512K Wireless Service"
39.9900,1099,"512K Wireless Service"
39.9900,1099,"512K Wireless Service"
39.9900,1175,"512K Wireless Service"
1.9900,1175,"Email"
39.9900,1118,"512K Wireless Service"
1.9900,1118,"Email"
29.9900,1070,"128K Wireless Service"
1.9900,1070,"Email"
39.9900,1173,"512K Wireless Service"
39.9900,1066,"512K Wireless Service"
1.9900,1066,"Email"
29.9900,1081,"128K Wireless Service"
39.9900,1128,"512K Wireless Service"
39.9900,1202,"512K Wireless Service"
39.9900,1156,"512K Wireless Service"
29.9900,1141,"128K Wireless Service"
39.9900,1105,"512K Wireless Service"
29.9900,1165,"128K Wireless Service"
39.9900,1071,"512K Wireless Service"
39.9900,1047,"512K Wireless Service"
29.9900,1218,"128K Wireless Service"
29.9900,1218,"128K Wireless Service"
39.9900,1089,"512K Wireless Service"
29.9900,1218,"128K Wireless Service"
2.0000,1089,"Email"
29.9900,1218,"128K Wireless Service"
29.9900,1218,"128K Wireless Service"
29.9900,1218,"128K Wireless Service"
29.9900,1115,"128K Wireless Service"
29.9900,1218,"128K Wireless Service"
39.9900,1222,"512K Wireless Service"
39.9900,1201,"512K Wireless Service"
39.9900,1184,"512K Wireless Service"
39.9900,1157,"512K Wireless Service"
39.9900,1097,"512K Wireless Service"
39.9900,1093,"512K Wireless Service"
1.9900,1093,"Email"
39.9900,1044,"512K Wireless Service"
55.9900,1072,"1024K Wireless Service"
1.9900,1072,"Email"
39.9900,1059,"512K Wireless Service"
1.9900,1059,"Email"
39.9900,1208,"512K Wireless Service"
39.9900,1188,"512K Wireless Service"
1.9900,1188,"Email"
39.9900,1064,"512K Wireless Service"
6.9500,1087,"Web Hosting"
14.9500,1009,"Web Hosting"
14.9500,1219,"Web Hosting"
29.9900,1048,"128K Wireless Service"
14.9500,1050,"Web Hosting"
14.9500,1030,"Web Hosting"
39.9900,1062,"512K Wireless Service"
39.9900,1224,"512K Wireless Service"
14.9500,1106,"Web Hosting"
39.9900,1094,"512K Wireless Service"
14.9500,1121,"Web Hosting"
14.9500,1026,"Web Hosting"
1.9900,1094,"Email"
14.9500,1065,"Web Hosting"
20.0000,1076,"Web Hosting"
55.9900,1086,"1024K Wireless Service"
35.9900,1058,"256K Wireless Service"
55.9900,1033,"512K Wireless Service"
35.9900,1130,"256K Wireless Service"
55.9900,1104,"512K Wireless Service"
1.9900,1104,"Email"
35.9900,1102,"256K Wireless Service"
55.9900,1127,"512K Wireless Service"
35.9900,1135,"256K Wireless Service"
35.9900,1159,"256K Wireless Service"
35.9900,1035,"256K Wireless Service"
35.9900,1034,"256K Wireless Service"
1.9900,1034,"Email"
55.9900,1212,"512K Wireless Service"
25.9900,1126,"64K Wireless Service"
35.9900,1146,"256K Wireless Service"
1.9900,1146,"Email"
35.9900,1024,"256K Wireless Service"
1.9900,1024,"Email"
35.9900,1187,"256K Wireless Service"
35.9900,1029,"256K Wireless Service"
1.9900,1029,"Email"
55.9900,1163,"512K Wireless Service"
1.9900,1163,"Email"
55.9900,1209,"512K Wireless Service"
1.9900,1209,"Email"
35.9900,1018,"256K Wireless Service"
35.9900,1151,"256K Wireless Service"

amount,account,descr
-32.0000,1040,"Wrong Service Activated"
-59.9800,1194,"Got billed after canceled"
-156.0000,1196,"Contined to receive Bill after canceled"
-100.0000,1019,"Billed 99 for install which should have been 9"
-44.8000,1122,"Singed up for wrong service"
-270.1200,1024,"Check #1790 should have been posted to Dawn Butcher not Butcher's Electric"
-10.0000,1081,"No service for 10 days 4/8-4/18/05"
-80.0000,1213,"Billed for wrong service"
-7.9600,1104,"Calceled email and continued to get billed for it"
-8.3200,1134,"Billing Error .04 X 8 months"
-10.0000,1066,"Billed for wrong service"
-100.0000,1164,"Wrong install billed"
-4.1600,1116,"Billing Error"
-35.9900,1119,"Service Outage for first month"
-49.0000,1119,"Installation credit"
-71.9800,1061,"Continued billing after customer canceled"
-390.0000,1157,"Problem with service"
-39.9900,1066,"Credit for 00026f-36764c"
-55.9900,1122,"Credit for 00026f-3678f8"
-55.9900,1113,"Credit for 000625-4577cc"
-24.2600,1126,"Credit for 00026f-3467b6"
-124.9900,1240,"Used own equipment"
-105.4400,1060,"Double billed"
-37.3200,1008,"Credit for 00026f-33a7be"
-1.8600,1177,"Credit for ..hidden.."
-1.8600,1118,"Credit for ..hidden.."
-5.9700,1040,"did not want email"
-709.2900,1201,"Check 6233 previously posted to Ty"
-20.0000,1244,"Credit for Self-Install"
-44.7300,1098,"Not in area"
-100.0000,1238,"Mansfield Install"
-20.0000,1207,"Split service charge"
-8.8300,1213,"credit 1.04 per month since beginning of service"
-55.9900,1229,"referral credit (Kathy Hutchcraft)"
-10.6400,1105,"Error in Posting Check"
-98.9400,1228,"referred Rob Harper and was billed incorrectly"
-1.2000,1213,"Credit for xx15"
-112.9400,1217,"Free Service"
-85.9300,1222,"Free Service"
-5.9500,1245,"Refund of late charge"
-39.9900,1062,"company credit"
-35.9900,1032,"Check 3308 Posted to Wrong Account"
-5.9500,1032,"Check 3308 Posted to Wrong Account"
-55.9900,1234,"Credit for 00026f-387342"
-312.5500,1255,"Cancel"
-106.5000,1222,"Retrun of AP and Wireless Card"
-5.9500,1029,"late fee removed"
-1962.2900,1300,"14.95 X 24; 19.99X2;55.99X24;Install"
-106.4900,1290,"Returned WET11"
-40.0000,1116,"one time credit for computer being serviced"
-5.9500,1116,"late fee removal due to disputed amount"
-1.9900,1116,"email charge removal"
-5.9500,1245,"recieved statement late"
-5.9500,1246,"No Late Fee's for Rikki!!"
-11.6100,1275,"Change Quantity 1.00 to 2.00"
-22.6500,1275,"Change Quantity 2.00 to 1.00"
-0.0400,1258,"Good Customer"
-99.0000,1302,"Special Install Price for Mansfield"
-14.2500,1301,"Credit for 00026f-386c82"
-40.0000,1051,"Service charge Error"
-8.9900,1032,"Posted Check to wrong account"
-39.7300,1163,"Credit for 00026f-367901"
-55.9900,1163,"Credit for 00026f-367901"
-55.9900,1163,"Credit for 00026f-367901"
-55.9900,1163,"Credit for 00026f-367901"
-55.9900,1163,"Credit for 00026f-367901"
-49.0100,1285,"account to be closed- previous tenants paid in full"
-50.3000,1288,"account to be closed- previous tenants paid in full"
-50.3000,1284,"account to be closed- previous tenants paid in full"
-19.9900,1268,"Free Service for Summer"
-40.0000,1023,"Balance merged from account 1024"
-0.0400,1274,"she requested cancellation- am closing account as of 7-31-05"
-39.0000,1095,"Check 5269 posted to wrong account on 9/29/04"
-5.9500,1164,"late fee removed, disputing amount"
-5.9500,1115,"refund of late fee- have made billing arrangements"
-100.0000,1163,"per Brad- overcharge on install at home"
-3.9800,1151,"charged separately for each email account for 2 months"
-5.9700,1153,"Move Balance to Account 1129"
-5.9500,1139,"No late fee for good Math Teacher"
-29.9900,1139,"Good teacher credit"
-120.0000,1310,"Carl's portion of service in Paris already billed as monthly service"
-24.9500,1272,"closing account"
-12.1600,1297,"removal of late fee: had not received statements"
-5.9500,1292,"late fee removal"
-26.1200,1312,"Credit for 00026f-3a6a78"
-39.9300,1250,"credited account balance by amy, jeff will mail equipment to TSG"
-0.7100,1213,"removal of $.71 balance"
-26.9400,1213,"thank you !"
-5.9500,1116,"amount disputed, no late fee"
-2.6300,1116,"credit"
-35.9900,1164,"1 month credit for service"
-13.3300,1279,"credited 3.33  (prorated amount for August), is closing account."
-13.3300,1279,"closing account, credit for prorated amount for August"
-18.5500,1267,"credit for prorated amount in August, is closing account"
-19.9900,1269,"cancelled service on august 1"
-39.9900,1166,"credit for 1 month service"
-25.9900,1228,"not charged for August due to fire (account suspended until further notice)"
-35.9900,1248,"changing to 64k service for August"
-26.7000,1248,"Credit for xx30"
-0.9900,1311,"credit"