What currencies do yoiu have set up? On Mon, Dec 5, 2011 at 4:34 PM, <lbml...@hethcote.com> wrote: > > > Loaded up 1.3.8rc1 and did the setup.pl > > New error: > > > Error! > > > UPDATE ap > SET invnumber = ?, > ordnumber = ?, > quonumber = ?, > transdate = ?, > amount = ?, > netamount = ?, > paid = ?, > datepaid = ?, > duedate = ?, > invoice = '1', > shippingpoint = ?, > shipvia = ?, > taxincluded = ?, > notes = ?, > intnotes = ?, > curr = ?, > department_id = ?, > language_code = ?, > ponumber = ? > WHERE id = ? > ERROR: new row for relation "ap" violates check constraint "ap_check" > > > > > On Sun, 4 Dec 2011, Chris Travers wrote: > >> So this is the query I have added to sql/fixes. It is safe for multiple >> runs. >> >> UPDATE parts >> SET income_accno_id = (SELECT account.id >> FROM account JOIN lsmb12.chart USING (accno) >> WHERE chart.id = income_accno_id), >> expense_accno_id = (SELECT account.id >> FROM account JOIN lsmb12.chart USING (accno) >> WHERE chart.id = expense_accno_id), >> inventory_accno_id = (SELECT account.id >> FROM account JOIN lsmb12.chart USING (accno) >> WHERE chart.id = inventory_accno_id) >> WHERE id IN (SELECT id FROM lsmb12.parts op >> WHERE op.id = parts.id >> AND op.income_accno_id = parts.income_accno_id >> AND op.inventory_accno_id = parts.inventory_accno_id >> AND op.expense_accno_id = parts.expense_accno_id); >> >> It will run on upgrade from 1.2 and on upgrade within 1.3.x starting with >> 1.3.8 >> >> Best Wishes, >> Chris Travers >> On Sun, Dec 4, 2011 at 6:59 PM, Chris Travers <chris.trav...@gmail.com> >> wrote: >>> >>> Hi Louis; >>> >>> I will have queries to fix this that can be rerun out to you today. >>> >>> Best Wishe,s >>> Chris Travers >>> >>> On Sun, Dec 4, 2011 at 6:03 PM, <lbml...@hethcote.com> wrote: >>>> >>>> >>>> >>>> On Sat, 3 Dec 2011, Chris Travers wrote: >>>> >>>>> Ok. So a couple questions: >>>>> 1) Is there an appropriate AP account set up? >>>> >>>> >>>> there are two service items on the invoice, each have income_accno_id of >>>> 10033 and expense_accno_id 10103. I can't find an id of 10033 or 10103 >>>> in >>>> account_heading or account. >>>> >>>> select id,accno,description,category,heading from account where id=43; >>>> id | accno | description | category | heading >>>> ----+-------+---------------------------+----------+--------- >>>> 43 | 6221 | ABE Commissions and Fees | E | 10098 >>>> >>>> is where I expect the charges to go. >>>> >>>> select id,description,income_accno_id,expense_accno_id,project_id from >>>> parts where partnumber ~* 'F'; >>>> >>>> id | description | income_accno_id | >>>> expense_accno_id | project_id >>>> >>>> -------+-----------------------------------+-----------------+------------------+------------ >>>> 14299 | ABE Commissions on sales | 10033 | >>>> 10103 | >>>> 14300 | ABE Credit Card handling fees | 10033 | >>>> 10103 | >>>> >>>> are the parts. >>>> >>>> >>>> >>>> >>>> >>>>> 2) If hte parts were migrated check to see if the income_accno_id, >>>>> inventory_accno_id, and expense_accno_id values are found in >>>>> account.id. >>>>> >>>>> Best Wishes, >>>>> Chris Travers >>>>> >>>>> >>>>> ------------------------------------------------------------------------------ >>>>> All the data continuously generated in your IT infrastructure >>>>> contains a definitive record of customers, application performance, >>>>> security threats, fraudulent activity, and more. Splunk takes this >>>>> data and makes sense of it. IT sense. And common sense. >>>>> http://p.sf.net/sfu/splunk-novd2d >>>>> _______________________________________________ >>>>> Ledger-smb-users mailing list >>>>> Ledger-smb-users@lists.sourceforge.net >>>>> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users >>>>> >>>> >>>> >>>> ------------------------------------------------------------------------------ >>>> All the data continuously generated in your IT infrastructure >>>> contains a definitive record of customers, application performance, >>>> security threats, fraudulent activity, and more. Splunk takes this >>>> data and makes sense of it. IT sense. And common sense. >>>> http://p.sf.net/sfu/splunk-novd2d >>>> _______________________________________________ >>>> Ledger-smb-users mailing list >>>> Ledger-smb-users@lists.sourceforge.net >>>> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users >> >> >> >> ------------------------------------------------------------------------------ >> All the data continuously generated in your IT infrastructure >> contains a definitive record of customers, application performance, >> security threats, fraudulent activity, and more. Splunk takes this >> data and makes sense of it. IT sense. And common sense. >> http://p.sf.net/sfu/splunk-novd2d >> _______________________________________________ >> Ledger-smb-users mailing list >> Ledger-smb-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > > > ------------------------------------------------------------------------------ > All the data continuously generated in your IT infrastructure > contains a definitive record of customers, application performance, > security threats, fraudulent activity, and more. Splunk takes this > data and makes sense of it. IT sense. And common sense. > http://p.sf.net/sfu/splunk-novd2d > _______________________________________________ > Ledger-smb-users mailing list > Ledger-smb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users >
------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-novd2d _______________________________________________ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
