[jira] [Updated] (OFBIZ-5641) Problem with Purchase Order Accounting Entries

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-5641?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sharan Foga updated OFBIZ-5641:
-------------------------------

    Description:
Hi

I'm logging a Jira issue reported by Mohd Vigar on the mailing list. I have been able to replicate the problem and think that this is a bug. Details are below.

Thanks
Sharan

I'm facing the below problem with accounting entries of purchase order, would appreciate any help with the same

When I create a purchase order for lets say $15 and receive the inventory for that purchase order, I get the following accounting entry.

Inventory Dr $15
Uninvoiced Item Receipts Cr $15

Then when I go to the purchase invoice that's automatically generated by receiving the product and change its status to "Ready', it  creates a new accounting transaction entry as follows

Inventory Dr $15
Accounts Payable Cr $15

thus the Trial balance show:

Account Code Account Name                    Dr        Cr        Ending Balance
140000 INVENTORY                                 $30.00 $0.00   $30.00
210000 ACCOUNTS PAYABLE                  $0.00   $15.00 $15.00
214000 UNINVOICED ITEM RECEIPTS     $0.00   $15.00 $15.00

It should have ideally reversed the uninvoiced item receipts as follows

Uninvoiced Item Receipts Dr $15
Accounts Payable Cr $15

Account Code Account Name                    Dr        Cr        Ending Balance
140000 INVENTORY                                 $15.00  $0.00   $15.00
210000 ACCOUNTS PAYABLE                  $0.00    $15.00 $15.00
214000 UNINVOICED ITEM RECEIPTS      $15.00 $15.00 $0.00

I've tested this on the trunk with the below mentioned data and it give me the same results..

Product : GZ-1000-0 - Tiny Gizmo  
Quantity : 2
Price : $7.5
Total value: $15
Supplier : Demo Supplier

so i'm wondering if I'm doing something wrong or if this is a bug..

  was:
Hi

I'm logging a Jira issue reported by Mohd Vigar on the mailing list. I have been able to replicate the problem and think that this is a bug. Details are below.

I'm facing the below problem with accounting entries of purchase order, would appreciate any help with the same

When I create a purchase order for lets say $15 and receive the inventory for that purchase order, I get the following accounting entry.

Inventory Dr $15
Uninvoiced Item Receipts Cr $15

Then when I go to the purchase invoice that's automatically generated by receiving the product and change its status to "Ready', it  creates a new accounting transaction entry as follows

Inventory Dr $15
Accounts Payable Cr $15

thus the Trial balance show:

Account Code Account Name                    Dr        Cr        Ending Balance
140000 INVENTORY                                 $30.00 $0.00   $30.00
210000 ACCOUNTS PAYABLE                  $0.00   $15.00 $15.00
214000 UNINVOICED ITEM RECEIPTS     $0.00   $15.00 $15.00

It should have ideally reversed the uninvoiced item receipts as follows

Uninvoiced Item Receipts Dr $15
Accounts Payable Cr $15

Account Code Account Name                    Dr        Cr        Ending Balance
140000 INVENTORY                                 $15.00  $0.00   $15.00
210000 ACCOUNTS PAYABLE                  $0.00    $15.00 $15.00
214000 UNINVOICED ITEM RECEIPTS      $15.00 $15.00 $0.00

I've tested this on the trunk with the below mentioned data and it give me the same results..

Product : GZ-1000-0 - Tiny Gizmo  
Quantity : 2
Price : $7.5
Total value: $15
Supplier : Demo Supplier

so i'm wondering if I'm doing something wrong or if this is a bug..

> Problem with Purchase Order Accounting Entries
> -----------------------------------------------
>
>                 Key: OFBIZ-5641
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-5641
>             Project: OFBiz
>          Issue Type: Bug
>          Components: accounting, order
>    Affects Versions: SVN trunk, Release Branch 13.07
>            Reporter: Sharan Foga
>            Priority: Minor
>
> Hi
> I'm logging a Jira issue reported by Mohd Vigar on the mailing list. I have been able to replicate the problem and think that this is a bug. Details are below.
> Thanks
> Sharan
> I'm facing the below problem with accounting entries of purchase order, would appreciate any help with the same
> When I create a purchase order for lets say $15 and receive the inventory for that purchase order, I get the following accounting entry.
> Inventory Dr $15
> Uninvoiced Item Receipts Cr $15
> Then when I go to the purchase invoice that's automatically generated by receiving the product and change its status to "Ready', it  creates a new accounting transaction entry as follows
> Inventory Dr $15
> Accounts Payable Cr $15
> thus the Trial balance show:
> Account Code Account Name                    Dr        Cr        Ending Balance
> 140000 INVENTORY                                 $30.00 $0.00   $30.00
> 210000 ACCOUNTS PAYABLE                  $0.00   $15.00 $15.00
> 214000 UNINVOICED ITEM RECEIPTS     $0.00   $15.00 $15.00
> It should have ideally reversed the uninvoiced item receipts as follows
> Uninvoiced Item Receipts Dr $15
> Accounts Payable Cr $15
> Account Code Account Name                    Dr        Cr        Ending Balance
> 140000 INVENTORY                                 $15.00  $0.00   $15.00
> 210000 ACCOUNTS PAYABLE                  $0.00    $15.00 $15.00
> 214000 UNINVOICED ITEM RECEIPTS      $15.00 $15.00 $0.00
> I've tested this on the trunk with the below mentioned data and it give me the same results..
> Product : GZ-1000-0 - Tiny Gizmo  
> Quantity : 2
> Price : $7.5
> Total value: $15
> Supplier : Demo Supplier
> so i'm wondering if I'm doing something wrong or if this is a bug..

--
This message was sent by Atlassian JIRA
(v6.2#6252)