[
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.
I've also added some comments on another possible error that I've found around
payments while I was doing these tests.
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..
-----------------
During my tests I did find another potential issue and this is related to
payments. I’ve come across a variation of it before replying to a query on the
Drop Shipment process.
• When you receive Purchase Order into inventory a “payment” is created under
the “Payment Information” section of the Purchase Order.
• Using the example above, the Payment is created for an amount of $15 with a
status of “Not Paid”
• When you receive the Purchase Order, the Pro Forma invoice is also created
and is displayed below the payment on the view order screen.
• If you click the link to the Pro Forma Invoice and look at the “Terms”
section which shows the “Outstanding Amount” you will see that it is now
showing zero. (I don’t think this is correct because you haven’t paid the
supplier yet! I think the Outstanding Amount on the Pro Forma invoice should
still be $15.)
If you then go to Accounting Manager / Payments to locate Purchase Invoices by
due date then this invoice isnt displayed even though the Due Date is the
current date. I think this is because the Outstanding Amount is zero, OFBiz
thinks that the invoice has already been paid (when it hasn’t).
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.
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..
> 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.
>
> I've also added some comments on another possible error that I've found
> around payments while I was doing these tests.
> 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..
> -----------------
> During my tests I did find another potential issue and this is related to
> payments. I’ve come across a variation of it before replying to a query on
> the Drop Shipment process.
> • When you receive Purchase Order into inventory a “payment” is created under
> the “Payment Information” section of the Purchase Order.
> • Using the example above, the Payment is created for an amount of $15 with a
> status of “Not Paid”
> • When you receive the Purchase Order, the Pro Forma invoice is also created
> and is displayed below the payment on the view order screen.
> • If you click the link to the Pro Forma Invoice and look at the “Terms”
> section which shows the “Outstanding Amount” you will see that it is now
> showing zero. (I don’t think this is correct because you haven’t paid the
> supplier yet! I think the Outstanding Amount on the Pro Forma invoice should
> still be $15.)
> If you then go to Accounting Manager / Payments to locate Purchase Invoices
> by due date then this invoice isnt displayed even though the Due Date is the
> current date. I think this is because the Outstanding Amount is zero, OFBiz
> thinks that the invoice has already been paid (when it hasn’t).
--
This message was sent by Atlassian JIRA
(v6.2#6252)
