[jira] [Commented] (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:comment-tabpanel&focusedCommentId=14320349#comment-14320349 ]

Anahita Goljahani commented on OFBIZ-5641:
------------------------------------------

Hi,

while testing the drop shipment scenario, I made some changes to my patch  in order to correctly map the purchase invoice item types 'PINV_SPROD_ITEM' (service) and PINV_DPROD_ITEM (digital good) to the default GL Account '500000' (Cost of Goods sold) ([~sharan], please discard the older one).

As far as my tests of the drop shipment scenario are concerned, I found that the reason for the incorrect accounting posts is that the purchase invoice item type is set to 'PINV_FPROD_ITEM' (finished goods) for the product. Due to this setting, when the status of the purchase invoice is set to 'ready', the following accounting entries are posted (after application of the patch):

Debit    Uninvoiced Item Receipt
Credit   Accounts Payable

which are correct in the case of purchases for the inventory, but not for drop shipments. In the latter case, the debit to 'Uninvoiced Item Receipt' account should be replaced by a debit to 'Cost of Goods Sold' account.

One way to achieve this is to manually set the purchase invoice item type for the product to 'PINV_SPROD_ITEM' (service). It can be done by going to the 'ITEMS' tab from the purchase invoice screen (the screen from which the invoice is set to 'ready') and change 'Invoice Finished Good Item (Purchase)' to 'Invoice Service Product Item (Purchase)'. With the new item type (and the new mapping provided by the patch), when the purchase invoice status is set to 'ready', the following transaction entries are posted:

Debit   Cost of Goods Sold
Credit   Accounts Payable

Let me know whether these entries are the ones you were looking for or you have a different way of posting accounting entries for drop shipment.    

 Kind regards
Anahita

> 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: Release Branch 13.07, Trunk
>            Reporter: Sharan Foga
>            Assignee: Sharan Foga
>            Priority: Minor
>         Attachments: defaultGlAccountForPurchaseInvoiceProductItems.patch
>
>
> 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.3.4#6332)