'Packed amount does not match reserved amount for item' issue

[Venky]

Hi,
 I am looking after Order Manager Module. When I try to "complete" the packing order at PackOrder page, it is showing "Packed amount does not match reserved amount for item ofbiz  [1 / 0.000000]" error and gone through jira, found that we need to change in PackingSession.java, PackingServices.java. So, compared PackingSession.java, PackingServices.java with  stable version, everything is same in these files. When Am forcing to complete the order it is showing following errors:

ERROR: Could not complete the Issue OrderItemShipGrpInvRes to Shipment [file:workspace/svn_07082012/applications/product/script/org/ofbiz/shipment/issuance/IssuanceServices.xml#issueOrderItemShipGrpInvResToShipment] process [problem removing the orderItemShipGrpInvRes value: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Error in simple-method [Create an accounting transactions for a sales shipment issuance (D: INVENTORY_ACCOUNT, C: COGS_ACCOUNT) [file:workspace/svn_07082012/applications/accounting/script/org/ofbiz/accounting/ledger/GeneralLedgerServices.xml#createAcctgTransForSalesShipmentIssuance]]: ; {COGS costing method is not supported: }]

Am new to this. Where am I missing, please help me out here?

Thanks in advance

[Paul Foxworthy]

Hi Vanky,

I think you don't have a Cost Of Goods sold (COGS) method defined in your accounting preferences.

On the demo site, look at

https://demo-trunk.ofbiz.apache.org/accounting/control/AdminMain?organizationPartyId=Company

I had to log in as admin in order to see this screen.

On the demo site, the COGS method has been set to LIFO (Last In First Out).

Check the equivalent screen in your own setup, or in the Web Tools look at the entity PartyAcctgPreference. On the demo site, the URL is

https://demo-trunk.ofbiz.apache.org/webtools/control/FindGeneric?entityName=PartyAcctgPreference&find=true&VIEW_SIZE=50&VIEW_INDEX=0

Hope that helps.

Cheers

Paul Foxworthy

[Venky]

Hi Paul,

    Thanks for your reply.
 Yeah, it was the problem of Account settings. I have solved that one with your suggestion. Now I got another issue. The issue is:

 Actually I am using Mysql  as our Database server. The problem is when I try to receive inventory for a product, it is showing  "right value is null, can't compare null with Big decimal". So, I added bit code in InventoryServices.xml#balanceInventoryitems  :

<if-empty field="inventoryItem.quantityOnHandTotal">
       <set field="inventoryItem.quantityOnHandTotal" value="0" type="BigDecimal"/>
 </if-empty>
 
for just resolving the issue(to check whether we can make inventory if we avoid null comparison problem). Now, the null comparison problem got resolved. But, the product inventory values( total Quantity On Hand, Available to Promise) are still getting displayed as empty(null).

Is this a problem with MySql DB?. I hope so, because I tried with Derby DB, it's working fine. If it's problem with MySql, can you please give me suggestion to resolve this?. It's the important issue we got to resolve ASAP, as we are using the Mysql DB and unless we make the inventory for a product we can't proceed to fulfill order.  

Thanks in advance.