I have setup 3 internal organizations in PartyManager. Two of these internal organizations have a relationship of "Group Member of the top level organization (ID=10000)". The 2 lower level internal organizations process sales orders independently, they also share the same Facility (10000). The owner of this facility is the top level Organization (10000). I'm having an issue with the accounting transactions being generated for those sales orders as described below:
1) I create and completed a sales order for one of my lower level organizations (ID=10012). 2) All AcctTransTypes of Sales Invoice, Incoming Payment and Payment Applied are created for Organization 10012. This is what I expected. 3) The AcctTransType of Sales Shipment is created for Organization 10000. I did not expect this. I would like to see the accounting transactions related to the shipment to be part of Organization 10012. Did this happen because the facility owner is Organiztion 10000? Is this a bug? Shouldn't all the accounting transactions be driven by the Internal Organization in the Sales Order record? Thanks, Eva |
Eva,
Its getting too late for me now but I'll get to this issue first thing in morning. Regards Anil Patel On Jul 22, 2009, at 9:51 PM, Eva Bowman wrote: > > I have setup 3 internal organizations in PartyManager. Two of these > internal > organizations have a relationship of "Group Member of the top level > organization (ID=10000)". The 2 lower level internal organizations > process > sales orders independently, they also share the same Facility > (10000). The > owner of this facility is the top level Organization (10000). I'm > having an > issue with the accounting transactions being generated for those sales > orders as described below: > > 1) I create and completed a sales order for one of my lower level > organizations (ID=10012). > 2) All AcctTransTypes of Sales Invoice, Incoming Payment and Payment > Applied > are created for Organization 10012. This is what I expected. > 3) The AcctTransType of Sales Shipment is created for Organization > 10000. I > did not expect this. I would like to see the accounting transactions > related > to the shipment to be part of Organization 10012. Did this happen > because > the facility owner is Organiztion 10000? Is this a bug? Shouldn't > all the > accounting transactions be driven by the Internal Organization in > the Sales > Order record? > > Thanks, > Eva > -- > View this message in context: http://www.nabble.com/Sales-Shipment-Accounting-Transactions-posted-to-the-wrong-Organization-tp24609652p24609652.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > |
I changed the owner of the facility to be the lower level Organization (10012) and ran another test. I created and shipped another sales order for Organization 10012. The Sales Shipment GL transaction still hit the 10000 Organization. So, I believe, the system is not posting the Sales Shipment GL transactions based on the Facility owner. I now believe this might be a real bug because all of the other GL transactions are being posted against the 10012 Organization except for the Sales Shipment.
Thanks, Eva
|
In reply to this post by Eva Bowman
Hello Eva,
Here is the reason why the AcctgTransType for Sales Shipment is created for organization - 10000. In the system, for all transactions where entries are posted against inventory Item (e.g. shipment issuance/receipt, cancel shipment issuance, Inv item cost_change/produced/maint etc... ) the value of "Inventory Item ownerPartyId" is used as organizationPartyId in GL transactions. I guess, in your case inventoryItem.ownerPartyId is set to 10000, This is why accounting transactions are posted to GL of 10000. To fix this you need to set 10012 as owner of Inventory sold on sales order placed to 10012. Here are the way to set/update the Inventory Item owner party Id - 1) Via create/edit inventory item screen - https://localhost:8443/facility/control/EditInventoryItem?facilityId=WebStoreWarehouse 2) Via Receive inventory tab -> https://localhost:8443/facility/control/ReceiveInventory?facilityId=WebStoreWarehouse 3) In quick receive purchase order process, The screen for receive inventory has an option to set Inventory Item Owner id. Note - Default behavior, in case if Inventory Item's owner party id is not set from screen then - process sets it will set Facility's Owner Party Id in InventoryItem.owerPartyId field. Let me know for more clarifications. -- Regards Sumit Pandit On Jul 22, 2009, at 9:51 PM, Eva Bowman wrote: > > I have setup 3 internal organizations in PartyManager. Two of these > internal > organizations have a relationship of "Group Member of the top level > organization (ID=10000)". The 2 lower level internal organizations > process > sales orders independently, they also share the same Facility > (10000). The > owner of this facility is the top level Organization (10000). I'm > having an > issue with the accounting transactions being generated for those sales > orders as described below: > > 1) I create and completed a sales order for one of my lower level > organizations (ID=10012). > 2) All AcctTransTypes of Sales Invoice, Incoming Payment and Payment > Applied > are created for Organization 10012. This is what I expected. > 3) The AcctTransType of Sales Shipment is created for Organization > 10000. I > did not expect this. I would like to see the accounting transactions > related > to the shipment to be part of Organization 10012. Did this happen > because > the facility owner is Organiztion 10000? Is this a bug? Shouldn't > all the > accounting transactions be driven by the Internal Organization in > the Sales > Order record? > > Thanks, > Eva > -- > View this message in context: http://www.nabble.com/Sales-Shipment-Accounting-Transactions-posted-to-the-wrong-Organization-tp24609652p24609652.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > |
Free forum by Nabble | Edit this page |