Hi Greg. I'll repost this because I think most people would want see
returns as negative buys or sales.
If you delete this:
AND i.qty < 0
from line 645 of SL/IC.pm
and this:
AND i.qty > 0
from line 680 of SL/IC.pm
The bought report and the sold report show the AP or AR returns as
negatives.
This is on 1.8.5 - function all_parts. Looks like this originally:
644 if ($form->{bought} && !$form->{sold}) {
645 $where .= " AND i.parts_id = p.id AND i.trans_id = a.id AND i.qty
< 0";
And you'll want to do these as negative quantities so the inventory is
correct. If you won't be returning it to inventory (broke or something)
set up a dummy service called credit memo and invoice them a negative
amount.
The bought AND sold report still shows an AR return in the bought
column, but I don't know how to change that right now.
Gregory Malsack wrote:
>Hi All,
>
> I've asked this question before and now that I'm ready I can't find the
>e-mail that I got an answer on. Plus I can't find the thread or the main
>question in the archives.
>
> I want to record an item returned. if I enter a negative qty on the invoice
>my inventory adjusts correctly, but then the inventory sold report doesn't
>match the ar transactions net total amount. if I enter a positive qty with a
>negative amt then I get a matching report total but then my inventory is
>off. How can I fix this?
>
>Thanks,
>Greg Malsack
>
>
>
>-------------------------------------------------------
>This sf.net email is sponsored by:ThinkGeek
>Welcome to geek heaven.
>http://thinkgeek.com/sf
>-------------------------------------------------------
>(un)subscribe: http://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>Archive: http://www.mail-archive.com/[email protected]/
>
>
>
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
-------------------------------------------------------
(un)subscribe: http://lists.sourceforge.net/lists/listinfo/sql-ledger-users
Archive: http://www.mail-archive.com/[email protected]/
