You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Muhammad Aamir <ma...@aamir.pk> on 2009/03/20 22:15:06 UTC

Uninvoiced Shipment Receipts

When I create a purchase order and finally receive the shipment it increases
the inventory and create an accounting transaction with 'Inventory; debit
and 'UNINVOICED ITEM RECEIPTS' as credit.

However when I create an invoice and after that make a payment, it deosn't
reverse the 'UNINVOICED ITEM RECEIPTS' transaction entry as debit.

Any help, comments?

Thank you
Muhammad Aamir

Re: Uninvoiced Shipment Receipts

Posted by BJ Freeman <bj...@free-man.net>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

that i would be my choice also

Jacques Le Roux sent the following on 3/21/2009 9:21 AM:
> If we are able to check, we could even considerate a dropdown if there
> would not be too much occurences, but I guess in this case a lookup
> would be better (pagination, filters to choice, etc.)
> 
> Just my 2 cts from, without any other considerations than the current
> thread...
> 
> Jacques
> 
> From: "BJ Freeman" <bj...@free-man.net>
> in my opinion there should be a check for wrong input that warns the
> user and returns them to the input page.
> 
> 
> 
> Muhammad Aamir sent the following on 3/21/2009 8:24 AM:
>>>> It is exactly like you said. The mistake I did was that I entered
>>>> Inventory
>>>> ID instead of product id while creating purchase invoice (for the
>>>> inventory
>>>> item i received).
>>>>
>>>> On Sat, Mar 21, 2009 at 4:22 AM, Sharan-F <sh...@gmail.com> wrote:
>>>>
>>>>> Hi Muhammad
>>>>>
>>>>> For a Purchase Order Receive, Invoice and Payment process I would think
>>>>> that
>>>>> you should get:
>>>>>
>>>>> Shipment Receipt = DR Inventory / CR Uninvoiced Shipment Receipts
>>>>> Purchase Invoice = DR Uninvoiced Shipment Receipts / CR Accounts
>>>>> Payable
>>>>> (Note: I havent taken any Sales Tax into account here!)
>>>>> Outgoing Payment = DR Accounts Payable / CR Company Cheque Account
>>>>>
>>>>> What accounting entries do you getting for your Purchase Invoice? I'm
>>>>> interested as I'm doing some OFBiz documentation on Accounting.
>>>>>
>>>>> Thanks
>>>>> Sharan
>>>>>
>>>>>
>>>>> Muhammad Aamir wrote:
>>>>>> Yes, this is what I am saying. How can I get 'UNINVOICED ITEM
>>>>>> RECEIPTS'
>>>>> as
>>>>>> debit as I pay for the item I received?
>>>>>>
>>>>>> Thanks
>>>>>>
>>>>>> On Sat, Mar 21, 2009 at 12:20 AM, BJ Freeman <bj...@free-man.net>
>>>>> wrote:
>>>> in a dual entry system there is a debit with a balancing credit or vice
>>>> a versa.
>>>> so you should be getting an new entry as a debit.
>>>>
>>>> or that may be what you were saying.
>>>>
>>>>
>>>> Muhammad Aamir sent the following on 3/20/2009 2:15 PM:
>>>>>>>>> When I create a purchase order and finally receive the shipment it
>>>> increases
>>>>>>>>> the inventory and create an accounting transaction with 'Inventory;
>>>> debit
>>>>>>>>> and 'UNINVOICED ITEM RECEIPTS' as credit.
>>>>>>>>>
>>>>>>>>> However when I create an invoice and after that make a payment, it
>>>> deosn't
>>>>>>>>> reverse the 'UNINVOICED ITEM RECEIPTS' transaction entry as debit.
>>>>>>>>>
>>>>>>>>> Any help, comments?
>>>>>>>>>
>>>>>>>>> Thank you
>>>>>>>>> Muhammad Aamir
>>>>>>>>>
>>>>>>>
>>>>>>
>>>>> -- 
>>>>> View this message in context:
>>>>> http://www.nabble.com/Uninvoiced-Shipment-Receipts-tp22628965p22631682.html
>>>>>
>>>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>>>
>>>>>
> 
>>

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJxR5ZrP3NbaWWqE4RAhKiAJ9IHlOYFp4RiMRkfB5skWFxh5DHEACglbBS
H/PyMUBz1V8JJOHhIMc9SgY=
=bKaB
-----END PGP SIGNATURE-----

Re: Uninvoiced Shipment Receipts

Posted by Jacques Le Roux <ja...@les7arts.com>.
If we are able to check, we could even considerate a dropdown if there would not be too much occurences, but I guess in this case a 
lookup would be better (pagination, filters to choice, etc.)

Just my 2 cts from, without any other considerations than the current thread...

Jacques

From: "BJ Freeman" <bj...@free-man.net>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> in my opinion there should be a check for wrong input that warns the
> user and returns them to the input page.
>
>
>
> Muhammad Aamir sent the following on 3/21/2009 8:24 AM:
>> It is exactly like you said. The mistake I did was that I entered Inventory
>> ID instead of product id while creating purchase invoice (for the inventory
>> item i received).
>>
>> On Sat, Mar 21, 2009 at 4:22 AM, Sharan-F <sh...@gmail.com> wrote:
>>
>>> Hi Muhammad
>>>
>>> For a Purchase Order Receive, Invoice and Payment process I would think
>>> that
>>> you should get:
>>>
>>> Shipment Receipt = DR Inventory / CR Uninvoiced Shipment Receipts
>>> Purchase Invoice = DR Uninvoiced Shipment Receipts / CR Accounts Payable
>>> (Note: I havent taken any Sales Tax into account here!)
>>> Outgoing Payment = DR Accounts Payable / CR Company Cheque Account
>>>
>>> What accounting entries do you getting for your Purchase Invoice? I'm
>>> interested as I'm doing some OFBiz documentation on Accounting.
>>>
>>> Thanks
>>> Sharan
>>>
>>>
>>> Muhammad Aamir wrote:
>>>> Yes, this is what I am saying. How can I get 'UNINVOICED ITEM RECEIPTS'
>>> as
>>>> debit as I pay for the item I received?
>>>>
>>>> Thanks
>>>>
>>>> On Sat, Mar 21, 2009 at 12:20 AM, BJ Freeman <bj...@free-man.net>
>>> wrote:
>> in a dual entry system there is a debit with a balancing credit or vice
>> a versa.
>> so you should be getting an new entry as a debit.
>>
>> or that may be what you were saying.
>>
>>
>> Muhammad Aamir sent the following on 3/20/2009 2:15 PM:
>>>>>>> When I create a purchase order and finally receive the shipment it
>> increases
>>>>>>> the inventory and create an accounting transaction with 'Inventory;
>> debit
>>>>>>> and 'UNINVOICED ITEM RECEIPTS' as credit.
>>>>>>>
>>>>>>> However when I create an invoice and after that make a payment, it
>> deosn't
>>>>>>> reverse the 'UNINVOICED ITEM RECEIPTS' transaction entry as debit.
>>>>>>>
>>>>>>> Any help, comments?
>>>>>>>
>>>>>>> Thank you
>>>>>>> Muhammad Aamir
>>>>>>>
>>>>>
>>>>
>>> --
>>> View this message in context:
>>> http://www.nabble.com/Uninvoiced-Shipment-Receipts-tp22628965p22631682.html
>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>
>>>
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (MingW32)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iD8DBQFJxQ0ArP3NbaWWqE4RAvzwAKDIvj/cZrBKGJwEVrLjKpNJe6vJ/ACeLWb/
> W+MI2AIMa6ETBY+w6Y7R2Ik=
> =J4we
> -----END PGP SIGNATURE-----
> 



Re: Uninvoiced Shipment Receipts

Posted by BJ Freeman <bj...@free-man.net>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

in my opinion there should be a check for wrong input that warns the
user and returns them to the input page.



Muhammad Aamir sent the following on 3/21/2009 8:24 AM:
> It is exactly like you said. The mistake I did was that I entered Inventory
> ID instead of product id while creating purchase invoice (for the inventory
> item i received).
> 
> On Sat, Mar 21, 2009 at 4:22 AM, Sharan-F <sh...@gmail.com> wrote:
> 
>> Hi Muhammad
>>
>> For a Purchase Order Receive, Invoice and Payment process I would think
>> that
>> you should get:
>>
>> Shipment Receipt = DR Inventory / CR Uninvoiced Shipment Receipts
>> Purchase Invoice = DR Uninvoiced Shipment Receipts / CR Accounts Payable
>> (Note: I havent taken any Sales Tax into account here!)
>> Outgoing Payment = DR Accounts Payable / CR Company Cheque Account
>>
>> What accounting entries do you getting for your Purchase Invoice? I'm
>> interested as I'm doing some OFBiz documentation on Accounting.
>>
>> Thanks
>> Sharan
>>
>>
>> Muhammad Aamir wrote:
>>> Yes, this is what I am saying. How can I get 'UNINVOICED ITEM RECEIPTS'
>> as
>>> debit as I pay for the item I received?
>>>
>>> Thanks
>>>
>>> On Sat, Mar 21, 2009 at 12:20 AM, BJ Freeman <bj...@free-man.net>
>> wrote:
> in a dual entry system there is a debit with a balancing credit or vice
> a versa.
> so you should be getting an new entry as a debit.
> 
> or that may be what you were saying.
> 
> 
> Muhammad Aamir sent the following on 3/20/2009 2:15 PM:
>>>>>> When I create a purchase order and finally receive the shipment it
> increases
>>>>>> the inventory and create an accounting transaction with 'Inventory;
> debit
>>>>>> and 'UNINVOICED ITEM RECEIPTS' as credit.
>>>>>>
>>>>>> However when I create an invoice and after that make a payment, it
> deosn't
>>>>>> reverse the 'UNINVOICED ITEM RECEIPTS' transaction entry as debit.
>>>>>>
>>>>>> Any help, comments?
>>>>>>
>>>>>> Thank you
>>>>>> Muhammad Aamir
>>>>>>
>>>>
>>>
>> --
>> View this message in context:
>> http://www.nabble.com/Uninvoiced-Shipment-Receipts-tp22628965p22631682.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>>

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJxQ0ArP3NbaWWqE4RAvzwAKDIvj/cZrBKGJwEVrLjKpNJe6vJ/ACeLWb/
W+MI2AIMa6ETBY+w6Y7R2Ik=
=J4we
-----END PGP SIGNATURE-----

Re: Uninvoiced Shipment Receipts

Posted by Muhammad Aamir <ma...@aamir.pk>.
It is exactly like you said. The mistake I did was that I entered Inventory
ID instead of product id while creating purchase invoice (for the inventory
item i received).

On Sat, Mar 21, 2009 at 4:22 AM, Sharan-F <sh...@gmail.com> wrote:

>
> Hi Muhammad
>
> For a Purchase Order Receive, Invoice and Payment process I would think
> that
> you should get:
>
> Shipment Receipt = DR Inventory / CR Uninvoiced Shipment Receipts
> Purchase Invoice = DR Uninvoiced Shipment Receipts / CR Accounts Payable
> (Note: I havent taken any Sales Tax into account here!)
> Outgoing Payment = DR Accounts Payable / CR Company Cheque Account
>
> What accounting entries do you getting for your Purchase Invoice? I'm
> interested as I'm doing some OFBiz documentation on Accounting.
>
> Thanks
> Sharan
>
>
> Muhammad Aamir wrote:
> >
> > Yes, this is what I am saying. How can I get 'UNINVOICED ITEM RECEIPTS'
> as
> > debit as I pay for the item I received?
> >
> > Thanks
> >
> > On Sat, Mar 21, 2009 at 12:20 AM, BJ Freeman <bj...@free-man.net>
> wrote:
> >
> >> -----BEGIN PGP SIGNED MESSAGE-----
> >> Hash: SHA1
> >>
> >> in a dual entry system there is a debit with a balancing credit or vice
> >> a versa.
> >> so you should be getting an new entry as a debit.
> >>
> >> or that may be what you were saying.
> >>
> >>
> >> Muhammad Aamir sent the following on 3/20/2009 2:15 PM:
> >> > When I create a purchase order and finally receive the shipment it
> >> increases
> >> > the inventory and create an accounting transaction with 'Inventory;
> >> debit
> >> > and 'UNINVOICED ITEM RECEIPTS' as credit.
> >> >
> >> > However when I create an invoice and after that make a payment, it
> >> deosn't
> >> > reverse the 'UNINVOICED ITEM RECEIPTS' transaction entry as debit.
> >> >
> >> > Any help, comments?
> >> >
> >> > Thank you
> >> > Muhammad Aamir
> >> >
> >> -----BEGIN PGP SIGNATURE-----
> >> Version: GnuPG v1.4.6 (MingW32)
> >> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
> >>
> >> iD8DBQFJxAiIrP3NbaWWqE4RAsYjAKCGM+d8rcpwS2Oo/ly1IIANw9Px6gCgnzix
> >> 1h6Ngc7NUQXpY1PKi8kwDwE=
> >> =tF/M
> >> -----END PGP SIGNATURE-----
> >>
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/Uninvoiced-Shipment-Receipts-tp22628965p22631682.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>

Re: Uninvoiced Shipment Receipts

Posted by Sharan-F <sh...@gmail.com>.
Hi Muhammad

For a Purchase Order Receive, Invoice and Payment process I would think that
you should get:

Shipment Receipt = DR Inventory / CR Uninvoiced Shipment Receipts
Purchase Invoice = DR Uninvoiced Shipment Receipts / CR Accounts Payable
(Note: I havent taken any Sales Tax into account here!)
Outgoing Payment = DR Accounts Payable / CR Company Cheque Account

What accounting entries do you getting for your Purchase Invoice? I'm
interested as I'm doing some OFBiz documentation on Accounting.

Thanks
Sharan


Muhammad Aamir wrote:
> 
> Yes, this is what I am saying. How can I get 'UNINVOICED ITEM RECEIPTS' as
> debit as I pay for the item I received?
> 
> Thanks
> 
> On Sat, Mar 21, 2009 at 12:20 AM, BJ Freeman <bj...@free-man.net> wrote:
> 
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>> in a dual entry system there is a debit with a balancing credit or vice
>> a versa.
>> so you should be getting an new entry as a debit.
>>
>> or that may be what you were saying.
>>
>>
>> Muhammad Aamir sent the following on 3/20/2009 2:15 PM:
>> > When I create a purchase order and finally receive the shipment it
>> increases
>> > the inventory and create an accounting transaction with 'Inventory;
>> debit
>> > and 'UNINVOICED ITEM RECEIPTS' as credit.
>> >
>> > However when I create an invoice and after that make a payment, it
>> deosn't
>> > reverse the 'UNINVOICED ITEM RECEIPTS' transaction entry as debit.
>> >
>> > Any help, comments?
>> >
>> > Thank you
>> > Muhammad Aamir
>> >
>> -----BEGIN PGP SIGNATURE-----
>> Version: GnuPG v1.4.6 (MingW32)
>> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>>
>> iD8DBQFJxAiIrP3NbaWWqE4RAsYjAKCGM+d8rcpwS2Oo/ly1IIANw9Px6gCgnzix
>> 1h6Ngc7NUQXpY1PKi8kwDwE=
>> =tF/M
>> -----END PGP SIGNATURE-----
>>
> 
> 

-- 
View this message in context: http://www.nabble.com/Uninvoiced-Shipment-Receipts-tp22628965p22631682.html
Sent from the OFBiz - User mailing list archive at Nabble.com.


Re: Uninvoiced Shipment Receipts

Posted by Muhammad Aamir <ma...@aamir.pk>.
Yes, this is what I am saying. How can I get 'UNINVOICED ITEM RECEIPTS' as
debit as I pay for the item I received?

Thanks

On Sat, Mar 21, 2009 at 12:20 AM, BJ Freeman <bj...@free-man.net> wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> in a dual entry system there is a debit with a balancing credit or vice
> a versa.
> so you should be getting an new entry as a debit.
>
> or that may be what you were saying.
>
>
> Muhammad Aamir sent the following on 3/20/2009 2:15 PM:
> > When I create a purchase order and finally receive the shipment it
> increases
> > the inventory and create an accounting transaction with 'Inventory; debit
> > and 'UNINVOICED ITEM RECEIPTS' as credit.
> >
> > However when I create an invoice and after that make a payment, it
> deosn't
> > reverse the 'UNINVOICED ITEM RECEIPTS' transaction entry as debit.
> >
> > Any help, comments?
> >
> > Thank you
> > Muhammad Aamir
> >
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (MingW32)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iD8DBQFJxAiIrP3NbaWWqE4RAsYjAKCGM+d8rcpwS2Oo/ly1IIANw9Px6gCgnzix
> 1h6Ngc7NUQXpY1PKi8kwDwE=
> =tF/M
> -----END PGP SIGNATURE-----
>

Re: Uninvoiced Shipment Receipts

Posted by BJ Freeman <bj...@free-man.net>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

in a dual entry system there is a debit with a balancing credit or vice
a versa.
so you should be getting an new entry as a debit.

or that may be what you were saying.


Muhammad Aamir sent the following on 3/20/2009 2:15 PM:
> When I create a purchase order and finally receive the shipment it increases
> the inventory and create an accounting transaction with 'Inventory; debit
> and 'UNINVOICED ITEM RECEIPTS' as credit.
> 
> However when I create an invoice and after that make a payment, it deosn't
> reverse the 'UNINVOICED ITEM RECEIPTS' transaction entry as debit.
> 
> Any help, comments?
> 
> Thank you
> Muhammad Aamir
> 
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJxAiIrP3NbaWWqE4RAsYjAKCGM+d8rcpwS2Oo/ly1IIANw9Px6gCgnzix
1h6Ngc7NUQXpY1PKi8kwDwE=
=tF/M
-----END PGP SIGNATURE-----