shaker Khzym | 10 Nov 18:53 2009
Picon

Question

Dear Chris,

In is.pm , in post_invoice function,

     When the program try to save payment record in the acc_trans table.
   
     There are two fields , memo and cleared . the program try to save it.

     I know the memo,The user add his/her comment but what about the cleared field.

     Please, advise me.
   
Best wishes,
Shaekir,


Get a great deal on Windows 7 and see how it works the way you want. Check out the offers on Windows 7now.
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
Chris Travers | 10 Nov 19:05 2009
Picon

Re: Question



On Tue, Nov 10, 2009 at 9:53 AM, shaker Khzym <shakerramses-PkbjNfxxIARBDgjK7y7TUQ@public.gmane.org> wrote:
Dear Chris,

In is.pm , in post_invoice function,

     When the program try to save payment record in the acc_trans table.
   
     There are two fields , memo and cleared . the program try to save it.

     I know the memo,The user add his/her comment but what about the cleared field.

Whether the field has "cleared" the bank.  This is used in reconciliation.

Best Wishes,
Chris Travers

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
shaker Khzym | 10 Nov 19:11 2009
Picon

Re: Question

Dear Chris,
       Thank you so much for your replay.
Best wishes,
Shaekir,

Date: Tue, 10 Nov 2009 10:05:34 -0800
From: chris.travers <at> gmail.com
To: ledger-smb-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
Subject: Re: [Ledger-smb-devel] Question



On Tue, Nov 10, 2009 at 9:53 AM, shaker Khzym <shakerramses-PkbjNfxxIARBDgjK7y7TUQ@public.gmane.org> wrote:
Dear Chris,

In is.pm , in post_invoice function,

     When the program try to save payment record in the acc_trans table.
   
     There are two fields , memo and cleared . the program try to save it.

     I know the memo,The user add his/her comment but what about the cleared field.

Whether the field has "cleared" the bank.  This is used in reconciliation.

Best Wishes,
Chris Travers


Get Windows 7 for only $39.99-CDN College or University students only. This offer ends Jan 3-upgrade now!
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
shaker Khzym | 16 Nov 23:31 2009
Picon

Please, Advise me

There are some invoices have a mystery situation.

This invoice was created and the customer paid it and everything was OK as you see.

 select * from acc_trans where trans_id =302860;
 trans_id | chart_id | transdate  | source | cleared | fx_transaction | project_id | memo | invoice_id | amount  | entry_id
----------+----------+------------+--------+---------+----------------+------------+------+------------+---------+----------
   302860 |    10033 | 2009-09-17 |        | f       | f              |            |      |      76322 |   79.95 |   131026
   302860 |    10037 | 2009-09-17 |        | f       | f              |            |      |      76320 |    37.5 |   131027
   302860 |    10033 | 2009-09-17 |        | f       | f              |            |      |      76321 |   14.95 |   131028
   302860 |    10007 | 2009-09-17 |        | f       | f              |            |      |      56583 |     4.7 |   131029
   302860 |    10045 | 2009-09-17 |        | f       | f              |            |      |      56583 |    -4.7 |   131030
   302860 |    10004 | 2009-09-17 |        | f       | f              |            |      |            | -145.64 |   131031
   302860 |    10025 | 2009-09-17 |        | f       | f              |            |      |            |    6.62 |   131032
   302860 |    10024 | 2009-09-17 |        | f       | f              |            |      |            |    6.62 |   131033
   302860 |    10004 | 2009-09-17 |        | f       | f              |            |      |            |  145.64 |   131144
   302860 |    10002 | 2009-09-17 | Debit  | f       | f              |            |      |            | -145.64 |   131145


on 2Oct 2009
    6 records were added to the invoice to be that:

 select * from acc_trans where trans_id =302860;
 trans_id | chart_id | transdate  | source | cleared | fx_transaction | project_id | memo | invoice_id | amount  | entry_id
----------+----------+------------+--------+---------+----------------+------------+------+------------+---------+----------
   302860 |    10033 | 2009-09-17 |        | f       | f              |            |      |      76322 |   79.95 |   131026
   302860 |    10037 | 2009-09-17 |        | f       | f              |            |      |      76320 |    37.5 |   131027
   302860 |    10033 | 2009-09-17 |        | f       | f              |            |      |      76321 |   14.95 |   131028
   302860 |    10007 | 2009-09-17 |        | f       | f              |            |      |      56583 |     4.7 |   131029
   302860 |    10045 | 2009-09-17 |        | f       | f              |            |      |      56583 |    -4.7 |   131030
   302860 |    10004 | 2009-09-17 |        | f       | f              |            |      |               | -145.64 |   131031
   302860 |    10025 | 2009-09-17 |        | f       | f              |            |      |               |    6.62 |   131032
   302860 |    10024 | 2009-09-17 |        | f       | f              |            |      |               |    6.62 |   131033
   302860 |    10004 | 2009-09-17 |        | f       | f              |            |      |               |  145.64 |   131144
   302860 |    10002 | 2009-09-17 | Debit  | f       | f              |            |      |             | -145.64 |   131145

   302860 |    10007 | 2009-09-17 |        | f       | f              |            |      |      76604 |      38 |   132090
   302860 |    10045 | 2009-09-17 |        | f       | f              |            |      |      76604 |     -38 |   132091
   302860 |    10045 | 2009-10-02 |        | f       | f              |          0 |      |               |      38 |   132138
   302860 |    10007 | 2009-10-02 |        | f       | f              |          0 |      |               |     -38 |   132139
   302860 |    10007 | 2009-09-17 |        | f       | f              |            |      |      76632 |      38 |   132154
   302860 |    10045 | 2009-09-17 |        | f       | f              |            |      |      76632 |     -38 |   132155
(16 rows)



my question is , any part from the ledgersmb can be responsible about that. How can I debug this situation , I don't know any form can do that.

Because, If Ar form is responsible about that, The entry_id must be sequences .
If Cash - Receipt is responsible , it's always care with the amount not the part amount.

I miss something.

any advise please.

Best wishes,
Shaekir,

Get a great deal on Windows 7 and see how it works the way you want. See the Windows 7 offers now.
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
Schmiechen | 17 Nov 05:12 2009

Re: New to list + SMTP authentication when sending email

On Tuesday 11 March 2008 11:50:52 Ryan MacFarlane wrote:
> Hello. I am a computer science student taking an open source software
> development course. I have been following LedgerSMB because a previous
> employer was using sql-ledger and is switching over to LedgerSMB.
>
> I am relatively new to Perl, so in order to better understand both Perl and
> LedgerSMB I asked my previous employer for a simple task that would help me
> with both. We have set up LedgerSMB to use SMTP authentication when sending
> email by a SMTP server.
>
> Is this a function that the group would be interested in?
>
> I have read in a previous post that a technical proposal should be
> submitted to this list, a usage proposal submitted to the user list, and
> submit the proposal to the proposals tracker.  What would the technical
> proposal include?
>
> It is my goal to continue working with this project after the course is
> finished. I feel LedgerSMB is an excellent product and the experience I can
> gain is invaluable.
>
>
> Ryan MacFarlane

Do you still have this code?
I am interested in it.

-- 
Sincerely
Turtle

_________________________________________

FYI the .asc file is a digital signature
see http://en.wikipedia.org/wiki/Pretty_Good_Privacy for more info.
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
Ryan MacFarlane | 17 Nov 15:22 2009
Picon

Re: New to list + SMTP authentication when sending email

Schmiechen wrote:
> On Tuesday 11 March 2008 11:50:52 Ryan MacFarlane wrote:
>   
>> Hello. I am a computer science student taking an open source software
>> development course. I have been following LedgerSMB because a previous
>> employer was using sql-ledger and is switching over to LedgerSMB.
>>
>> I am relatively new to Perl, so in order to better understand both Perl and
>> LedgerSMB I asked my previous employer for a simple task that would help me
>> with both. We have set up LedgerSMB to use SMTP authentication when sending
>> email by a SMTP server.
>>
>> Is this a function that the group would be interested in?
>>
>> I have read in a previous post that a technical proposal should be
>> submitted to this list, a usage proposal submitted to the user list, and
>> submit the proposal to the proposals tracker.  What would the technical
>> proposal include?
>>
>> It is my goal to continue working with this project after the course is
>> finished. I feel LedgerSMB is an excellent product and the experience I can
>> gain is invaluable.
>>
>>
>> Ryan MacFarlane
>>     
>
> Do you still have this code?
> I am interested in it.
>
>   
> ------------------------------------------------------------------------
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
> trial. Simplify your report design, integration and deployment - and focus on 
> what you do best, core application coding. Discover what's new with
> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> ------------------------------------------------------------------------
>
> _______________________________________________
> Ledger-smb-devel mailing list
> Ledger-smb-devel@...
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>   
The patch file should be available for download from SourceForge. It is 
located under Tracker->Patches->Authentication to SMTP server for email.

If the patch file is not sufficient or you are unable to retrieve it, 
please let me know.

Ryan MacFarlane

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
markus | 18 Nov 02:45 2009

Re: New to list + SMTP authentication when sending email

Hey Ryan,
       Markus here (Former Employer), Shaekir wrote an SMTP auth module
that we are using on our copy of LedgerSMB.  I don't know if this
is what is in the code repository right now but you are welcome to
come by and chat about it.  Don't forget we all like double double
coffee's (no cream in Shaekir's on Wed or Fri ;-)

            Markus

> Schmiechen wrote:
>> On Tuesday 11 March 2008 11:50:52 Ryan MacFarlane wrote:
>>
>>> Hello. I am a computer science student taking an open source software
>>> development course. I have been following LedgerSMB because a previous
>>> employer was using sql-ledger and is switching over to LedgerSMB.
>>>
>>> I am relatively new to Perl, so in order to better understand both Perl
>>> and
>>> LedgerSMB I asked my previous employer for a simple task that would
>>> help me
>>> with both. We have set up LedgerSMB to use SMTP authentication when
>>> sending
>>> email by a SMTP server.
>>>
>>> Is this a function that the group would be interested in?
>>>
>>> I have read in a previous post that a technical proposal should be
>>> submitted to this list, a usage proposal submitted to the user list,
>>> and
>>> submit the proposal to the proposals tracker.  What would the technical
>>> proposal include?
>>>
>>> It is my goal to continue working with this project after the course is
>>> finished. I feel LedgerSMB is an excellent product and the experience I
>>> can
>>> gain is invaluable.
>>>
>>>
>>> Ryan MacFarlane
>>>
>>
>> Do you still have this code?
>> I am interested in it.
>>
>>
>> ------------------------------------------------------------------------
>>
>> ------------------------------------------------------------------------------
>> Let Crystal Reports handle the reporting - Free Crystal Reports 2008
>> 30-Day
>> trial. Simplify your report design, integration and deployment - and
>> focus on
>> what you do best, core application coding. Discover what's new with
>> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> Ledger-smb-devel mailing list
>> Ledger-smb-devel@...
>> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>>
> The patch file should be available for download from SourceForge. It is
> located under Tracker->Patches->Authentication to SMTP server for email.
>
> If the patch file is not sufficient or you are unable to retrieve it,
> please let me know.
>
> Ryan MacFarlane
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008
> 30-Day
> trial. Simplify your report design, integration and deployment - and focus
> on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> _______________________________________________
> Ledger-smb-devel mailing list
> Ledger-smb-devel@...
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
David Godfrey | 18 Nov 07:09 2009
Picon

Re: Please, Advise me

Hi Shaker,

I can't help much, but a couple of things that will help others answer you....

When you post something in table form can you change at least the font for the table to fixed width (or not true type depending on the software).  This means that the columns all line up properly.

Now to your problem.

It may be a great help to those on this list to have a brief description of the relevant chart_id's
  especially these ones 10045,10007,10025,10024,10004,10002

Also some basic information about the invoice, such as....
    Number of items on Invoice: ?
           Total invoice value: 145.64
                Tax On Invoice: ????
    Any Reversals or other "special things" about the invoice
      This includes anything that may make it more difficult to understand the information you provide.
        eg 2 items had 10%   tax
           2 items had 16.5% tax
           1 item had  0%    tax
           (possibly including the tax amounts in $ for each)
Any other information that may be relevant, such as there is a project shown on the query results but we don't use projects......


In your case the original transaction was on 2009-09-17,
with 3 additional transactions occurring on....
  2009-09-17
  2009-10-02
  2009-09-17
2 of these add $38 to acc 10007 and subtract $38 from 10045
with the Project 0 transaction on 2009-10-02 subtracting $38 from acc 10007 and adding $38 to 10045
This transaction cancels one of the transactions on 2009-09-17 for a net result of
 account 10007 having $38 added and account 10045 having $38 subtracted.

So now to specific questions,
Do you have any projects assigned?
if you view project 0, what do you see.
Probably a dozen other questions when I get a chance to look further, but these will do to start.

Sorry not a lot of help, but fire some more info back and I will look further.

Regards
David Godfrey

 shaker Khzym wrote:
<!-- .hmmessage P { margin:0px; padding:0px } body.hmmessage { font-size: 10pt; font-family:Verdana } -->There are some invoices have a mystery situation.

This invoice was created and the customer paid it and everything was OK as you see.

 select * from acc_trans where trans_id =302860;
 trans_id | chart_id | transdate  | source | cleared | fx_transaction | project_id | memo | invoice_id | amount  | entry_id
----------+----------+------------+--------+---------+----------------+------------+------+------------+---------+----------
   302860 |    10033 | 2009-09-17 |        | f       | f              |            |      |      76322 |   79.95 |   131026
   302860 |    10037 | 2009-09-17 |        | f       | f              |            |      |      76320 |    37.5 |   131027
   302860 |    10033 | 2009-09-17 |        | f       | f              |            |      |      76321 |   14.95 |   131028
   302860 |    10007 | 2009-09-17 |        | f       | f              |            |      |      56583 |     4.7 |   131029
   302860 |    10045 | 2009-09-17 |        | f       | f              |            |      |      56583 |    -4.7 |   131030
   302860 |    10004 | 2009-09-17 |        | f       | f              |            |      |            | -145.64 |   131031
   302860 |    10025 | 2009-09-17 |        | f       | f              |            |      |            |    6.62 |   131032
   302860 |    10024 | 2009-09-17 |        | f       | f              |            |      |            |    6.62 |   131033
   302860 |    10004 | 2009-09-17 |        | f       | f              |            |      |            |  145.64 |   131144
   302860 |    10002 | 2009-09-17 | Debit  | f       | f              |            |      |            | -145.64 |   131145


on 2Oct 2009
    6 records were added to the invoice to be that:

 select * from acc_trans where trans_id =302860;
 trans_id | chart_id | transdate  | source | cleared | fx_transaction | project_id | memo | invoice_id | amount  | entry_id
----------+----------+------------+--------+---------+----------------+------------+------+------------+---------+----------
   302860 |    10033 | 2009-09-17 |        | f       | f              |            |      |      76322 |   79.95 |   131026
   302860 |    10037 | 2009-09-17 |        | f       | f              |            |      |      76320 |    37.5 |   131027
   302860 |    10033 | 2009-09-17 |        | f       | f              |            |      |      76321 |   14.95 |   131028
   302860 |    10007 | 2009-09-17 |        | f       | f              |            |      |      56583 |     4.7 |   131029
   302860 |    10045 | 2009-09-17 |        | f       | f              |            |      |      56583 |    -4.7 |   131030
   302860 |    10004 | 2009-09-17 |        | f       | f              |            |      |            | -145.64 |   131031
   302860 |    10025 | 2009-09-17 |        | f       | f              |            |      |            |    6.62 |   131032
   302860 |    10024 | 2009-09-17 |        | f       | f              |            |      |            |    6.62 |   131033
   302860 |    10004 | 2009-09-17 |        | f       | f              |            |      |            |  145.64 |   131144
   302860 |    10002 | 2009-09-17 | Debit  | f       | f              |            |      |            | -145.64 |   131145

   302860 |    10007 | 2009-09-17 |        | f       | f              |            |      |      76604 |      38 |   132090
   302860 |    10045 | 2009-09-17 |        | f       | f              |            |      |      76604 |     -38 |   132091
   302860 |    10045 | 2009-10-02 |        | f       | f              |          0 |      |            |      38 |   132138
   302860 |    10007 | 2009-10-02 |        | f       | f              |          0 |      |            |     -38 |   132139
   302860 |    10007 | 2009-09-17 |        | f       | f              |            |      |      76632 |      38 |   132154
   302860 |    10045 | 2009-09-17 |        | f       | f              |            |      |      76632 |     -38 |   132155
(16 rows)



my question is , any part from the ledgersmb can be responsible about that. How can I debug this situation , I don't know any form can do that.

Because, If Ar form is responsible about that, The entry_id must be sequences .
If Cash - Receipt is responsible , it's always care with the amount not the part amount.

I miss something.

any advise please.

Best wishes,
Shaekir,

Get a great deal on Windows 7 and see how it works the way you want. See the Windows 7 offers now. ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Ledger-smb-devel mailing list Ledger-smb-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
shaker Khzym | 19 Nov 19:17 2009
Picon

FW: Please, Advise me



 Hi David,
 Thank you so much for your email.

 10045 = COGS / Hardware
 10007 = Inventory/Computer parts
 10025 =GST
 10024 =PST
 10004 =Account Receivable
 10002 = Chequing account


 Total invoice value : 145.64
 Tax on invoice : GST 5% and PST 5%

 Project id . : No
 different thing : No


 From my discussions with Chris, this problem has been ongoing and occurs
 when the OH is minus and I insert an AP invoice with this item, at this
 time the Ap invoice will try to update COGS in retrospect.
 
 This process appears to not work correctly and the item is sometimes added
 to COGS many times.
 
 I am relieved to know where the logic error is and will appreciate any
 help in solving this problem.

  Thank you again for your advise and your explanation.
 Best wishes,
 Shaekir,


Windows Live: Keep your friends up to date with what you do online.
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
shaker Khzym | 19 Nov 19:27 2009
Picon

Re: Please, Advise me

ExternalClass .ecxhmmessage P {padding:0px;} .ExternalClass body.ecxhmmessage {font-size:10pt;font-family:Verdana;} .ExternalClass .ecxhmmessage P {padding:0px;} .ExternalClass body.ecxhmmessage {font-size:10pt;font-family:Verdana;}
 Hi David,
 Thank you so much for your email.

 10045 = COGS / Hardware
 10007 = Inventory/Computer parts
 10025 =GST
 10024 =PST
 10004 =Account Receivable
 10002 = Chequing account

 Total invoice value : 145.64
 Tax on invoice : GST 5% and PST 5%

 Project id . : No
 different thing : No

 From my discussions with Chris, this problem has been ongoing and occurs
 when the OH is minus and I insert an AP invoice with this item, at this
 time the Ap invoice will try to update COGS in retrospect.
 
 This process appears to not work correctly and the item is sometimes added
 to COGS many times.

 In fact that had happened in a few invoices , not all invoices
 
 I am relieved to know where the logic error is and will appreciate any
 help in solving this problem.

  Thank you again for your advise and your explanation.

 Best wishes,
 Shaekir,

Get a great deal on Windows 7 and see how it works the way you want. Check out the offers on Windows 7now.
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

Gmane