[ https://issues.apache.org/jira/browse/OFBIZ-5641?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mohd Viqar updated OFBIZ-5641: ------------------------------ Comment: was deleted (was: Is there any progress on the issue? ) > 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)