Sales Shipment Accounting Transactions posted to the wrong Organization

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Sales Shipment Accounting Transactions posted to the wrong Organization

Eva Bowman
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
Reply | Threaded
Open this post in threaded view
|

Re: Sales Shipment Accounting Transactions posted to the wrong Organization

Anil Patel-3
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.
>

Reply | Threaded
Open this post in threaded view
|

Re: Sales Shipment Accounting Transactions posted to the wrong Organization

Eva Bowman
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
Anil Patel-3 wrote
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.
>
Reply | Threaded
Open this post in threaded view
|

Re: Sales Shipment Accounting Transactions posted to the wrong Organization

Sumit Pandit-3
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.
>