Connecting Vendor Bill to a Product Ledger

[sarangdj]

Hello Community,

First of all, thanks all the community members for creating such a robust
software and application development framework.

I have a business case where I want to achieve something as follows:

1. Create a Vendor Bill for Trucking Charges to transport my Product from
my supplier to my warehouse.  How can I associate this cost to my Product
Asset? This way, I know the exact cost of my product including the
miscellaneous expenses I have incurred for a product.

Similarly,

2. Create a vendor bill for trucking charges to transport the product from
my warehouse to the Customer. How can I associate this trucking cost
against the Customer. In my case, the customer gets free shipping under
product promotion, but I incur this cost.

Appreciate your expert technical advice to achieve this. Thanks for your
responses in advance.
 --
Best Regards,

Sarang Deshpande

[Pierre Smits]

Hi Sarang,

First of all, OFBiz allows you to register such cost as trucking charges to
be associated with any cost carrier in the accounting module for spend
analysis.

For purchase invoices the way to do this is to set the product ID in the
line item of the created purchase invoice.

Regards,


Pierre Smits

*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com


On Wed, Jul 30, 2014 at 1:58 PM, Sarang Deshpande <[hidden email]>
wrote:

> Hello Community,
>
> First of all, thanks all the community members for creating such a robust
> software and application development framework.
>
> I have a business case where I want to achieve something as follows:
>
> 1. Create a Vendor Bill for Trucking Charges to transport my Product from
> my supplier to my warehouse.  How can I associate this cost to my Product
> Asset? This way, I know the exact cost of my product including the
> miscellaneous expenses I have incurred for a product.
>
> Similarly,
>
> 2. Create a vendor bill for trucking charges to transport the product from
> my warehouse to the Customer. How can I associate this trucking cost
> against the Customer. In my case, the customer gets free shipping under
> product promotion, but I incur this cost.
>
> Appreciate your expert technical advice to achieve this. Thanks for your
> responses in advance.
>  --
> Best Regards,
>
> Sarang Deshpande
>

[sarangdj]

Hi Pierre,

Thanks for the prompt response. I am clear with the second advice you
mentioned. My product COGS is not increased with the trucking cost when I
selected Product in the AP invoice. You made my day.

However, I am not clear with the first advice. Can you elaborate please?

Thanks,

Sarang


On Wed, Jul 30, 2014 at 5:46 PM, Pierre Smits <[hidden email]>
wrote:

> Hi Sarang,
>
> First of all, OFBiz allows you to register such cost as trucking charges to
> be associated with any cost carrier in the accounting module for spend
> analysis.
>
> For purchase invoices the way to do this is to set the product ID in the
> line item of the created purchase invoice.
>
> Regards,
>
>
> Pierre Smits
>
> *ORRTIZ.COM <http://www.orrtiz.com>*
> Services & Solutions for Cloud-
> Based Manufacturing, Professional
> Services and Retail & Trade
> http://www.orrtiz.com
>
>
> On Wed, Jul 30, 2014 at 1:58 PM, Sarang Deshpande <[hidden email]>
> wrote:
>
> > Hello Community,
> >
> > First of all, thanks all the community members for creating such a robust
> > software and application development framework.
> >
> > I have a business case where I want to achieve something as follows:
> >
> > 1. Create a Vendor Bill for Trucking Charges to transport my Product from
> > my supplier to my warehouse.  How can I associate this cost to my Product
> > Asset? This way, I know the exact cost of my product including the
> > miscellaneous expenses I have incurred for a product.
> >
> > Similarly,
> >
> > 2. Create a vendor bill for trucking charges to transport the product
> from
> > my warehouse to the Customer. How can I associate this trucking cost
> > against the Customer. In my case, the customer gets free shipping under
> > product promotion, but I incur this cost.
> >
> > Appreciate your expert technical advice to achieve this. Thanks for your
> > responses in advance.
> >  --
> > Best Regards,
> >
> > Sarang Deshpande
> >
>

--
Regards,

Sarang

[Pierre Smits]

Hi Sarang,

What aspect do you find unclear?

Regards,

Pierre Smits

*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com


On Wed, Jul 30, 2014 at 3:20 PM, Sarang Deshpande <[hidden email]>
wrote:

> Hi Pierre,
>
> Thanks for the prompt response. I am clear with the second advice you
> mentioned. My product COGS is not increased with the trucking cost when I
> selected Product in the AP invoice. You made my day.
>
> However, I am not clear with the first advice. Can you elaborate please?
>
> Thanks,
>
> Sarang
>
>
> On Wed, Jul 30, 2014 at 5:46 PM, Pierre Smits <[hidden email]>
> wrote:
>
> > Hi Sarang,
> >
> > First of all, OFBiz allows you to register such cost as trucking charges
> to
> > be associated with any cost carrier in the accounting module for spend
> > analysis.
> >
> > For purchase invoices the way to do this is to set the product ID in the
> > line item of the created purchase invoice.
> >
> > Regards,
> >
> >
> > Pierre Smits
> >
> > *ORRTIZ.COM <http://www.orrtiz.com>*
> > Services & Solutions for Cloud-
> > Based Manufacturing, Professional
> > Services and Retail & Trade
> > http://www.orrtiz.com
> >
> >
> > On Wed, Jul 30, 2014 at 1:58 PM, Sarang Deshpande <[hidden email]>
> > wrote:
> >
> > > Hello Community,
> > >
> > > First of all, thanks all the community members for creating such a
> robust
> > > software and application development framework.
> > >
> > > I have a business case where I want to achieve something as follows:
> > >
> > > 1. Create a Vendor Bill for Trucking Charges to transport my Product
> from
> > > my supplier to my warehouse.  How can I associate this cost to my
> Product
> > > Asset? This way, I know the exact cost of my product including the
> > > miscellaneous expenses I have incurred for a product.
> > >
> > > Similarly,
> > >
> > > 2. Create a vendor bill for trucking charges to transport the product
> > from
> > > my warehouse to the Customer. How can I associate this trucking cost
> > > against the Customer. In my case, the customer gets free shipping under
> > > product promotion, but I incur this cost.
> > >
> > > Appreciate your expert technical advice to achieve this. Thanks for
> your
> > > responses in advance.
> > >  --
> > > Best Regards,
> > >
> > > Sarang Deshpande
> > >
> >
>
>
>
> --
> Regards,
>
> Sarang
>

[sarangdj]

Hi Pierre,

I am not clear of the menu under accounting module you are referring to.
Sorry for my ignorance.

Sarang



On Wed, Jul 30, 2014 at 6:52 PM, Pierre Smits <[hidden email]>
wrote:

> Hi Sarang,
>
> What aspect do you find unclear?
>
> Regards,
>
> Pierre Smits
>
> *ORRTIZ.COM <http://www.orrtiz.com>*
> Services & Solutions for Cloud-
> Based Manufacturing, Professional
> Services and Retail & Trade
> http://www.orrtiz.com
>
>
> On Wed, Jul 30, 2014 at 3:20 PM, Sarang Deshpande <[hidden email]>
> wrote:
>
> > Hi Pierre,
> >
> > Thanks for the prompt response. I am clear with the second advice you
> > mentioned. My product COGS is not increased with the trucking cost when I
> > selected Product in the AP invoice. You made my day.
> >
> > However, I am not clear with the first advice. Can you elaborate please?
> >
> > Thanks,
> >
> > Sarang
> >
> >
> > On Wed, Jul 30, 2014 at 5:46 PM, Pierre Smits <[hidden email]>
> > wrote:
> >
> > > Hi Sarang,
> > >
> > > First of all, OFBiz allows you to register such cost as trucking
> charges
> > to
> > > be associated with any cost carrier in the accounting module for spend
> > > analysis.
> > >
> > > For purchase invoices the way to do this is to set the product ID in
> the
> > > line item of the created purchase invoice.
> > >
> > > Regards,
> > >
> > >
> > > Pierre Smits
> > >
> > > *ORRTIZ.COM <http://www.orrtiz.com>*
> > > Services & Solutions for Cloud-
> > > Based Manufacturing, Professional
> > > Services and Retail & Trade
> > > http://www.orrtiz.com
> > >
> > >
> > > On Wed, Jul 30, 2014 at 1:58 PM, Sarang Deshpande <[hidden email]>
> > > wrote:
> > >
> > > > Hello Community,
> > > >
> > > > First of all, thanks all the community members for creating such a
> > robust
> > > > software and application development framework.
> > > >
> > > > I have a business case where I want to achieve something as follows:
> > > >
> > > > 1. Create a Vendor Bill for Trucking Charges to transport my Product
> > from
> > > > my supplier to my warehouse.  How can I associate this cost to my
> > Product
> > > > Asset? This way, I know the exact cost of my product including the
> > > > miscellaneous expenses I have incurred for a product.
> > > >
> > > > Similarly,
> > > >
> > > > 2. Create a vendor bill for trucking charges to transport the product
> > > from
> > > > my warehouse to the Customer. How can I associate this trucking cost
> > > > against the Customer. In my case, the customer gets free shipping
> under
> > > > product promotion, but I incur this cost.
> > > >
> > > > Appreciate your expert technical advice to achieve this. Thanks for
> > your
> > > > responses in advance.
> > > >  --
> > > > Best Regards,
> > > >
> > > > Sarang Deshpande
> > > >
> > >
> >
> >
> >
> > --
> > Regards,
> >
> > Sarang
> >
>

--
Regards,

Sarang

[Pierre Smits]

Ahh. Ok.

When you reread my posting in this thread you'll find that I stated that
product ID can be assigned to line items in purchase invoices in the
accounting module.

And you have succeeded in doing so, as per your registration in the demo
environment
http://demo-stable-ofbiz.apache.org/accounting/control/listInvoiceItems?invoiceId=10001
(which I am surmising to be yours, if not: my apologies).

Purchase invoicing can be found as a reference on the Main Page of the
Accounting app, called Show Invoices Purchase Invoice. These can also be
found through:
http://demo-stable-ofbiz.apache.org/accounting/control/findInvoices

The assignment of productIDs to invoice line items helps with respect to
spend analysis. I did not state that such a functionality is included in
the feature set of OFBiz.

Regards,

Pierre Smits

*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com


On Wed, Jul 30, 2014 at 3:34 PM, Sarang Deshpande <[hidden email]>
wrote:

> Hi Pierre,
>
> I am not clear of the menu under accounting module you are referring to.
> Sorry for my ignorance.
>
> Sarang
>
>
>
> On Wed, Jul 30, 2014 at 6:52 PM, Pierre Smits <[hidden email]>
> wrote:
>
> > Hi Sarang,
> >
> > What aspect do you find unclear?
> >
> > Regards,
> >
> > Pierre Smits
> >
> > *ORRTIZ.COM <http://www.orrtiz.com>*
> > Services & Solutions for Cloud-
> > Based Manufacturing, Professional
> > Services and Retail & Trade
> > http://www.orrtiz.com
> >
> >
> > On Wed, Jul 30, 2014 at 3:20 PM, Sarang Deshpande <[hidden email]>
> > wrote:
> >
> > > Hi Pierre,
> > >
> > > Thanks for the prompt response. I am clear with the second advice you
> > > mentioned. My product COGS is not increased with the trucking cost
> when I
> > > selected Product in the AP invoice. You made my day.
> > >
> > > However, I am not clear with the first advice. Can you elaborate
> please?
> > >
> > > Thanks,
> > >
> > > Sarang
> > >
> > >
> > > On Wed, Jul 30, 2014 at 5:46 PM, Pierre Smits <[hidden email]>
> > > wrote:
> > >
> > > > Hi Sarang,
> > > >
> > > > First of all, OFBiz allows you to register such cost as trucking
> > charges
> > > to
> > > > be associated with any cost carrier in the accounting module for
> spend
> > > > analysis.
> > > >
> > > > For purchase invoices the way to do this is to set the product ID in
> > the
> > > > line item of the created purchase invoice.
> > > >
> > > > Regards,
> > > >
> > > >
> > > > Pierre Smits
> > > >
> > > > *ORRTIZ.COM <http://www.orrtiz.com>*
> > > > Services & Solutions for Cloud-
> > > > Based Manufacturing, Professional
> > > > Services and Retail & Trade
> > > > http://www.orrtiz.com
> > > >
> > > >
> > > > On Wed, Jul 30, 2014 at 1:58 PM, Sarang Deshpande <
> [hidden email]>
> > > > wrote:
> > > >
> > > > > Hello Community,
> > > > >
> > > > > First of all, thanks all the community members for creating such a
> > > robust
> > > > > software and application development framework.
> > > > >
> > > > > I have a business case where I want to achieve something as
> follows:
> > > > >
> > > > > 1. Create a Vendor Bill for Trucking Charges to transport my
> Product
> > > from
> > > > > my supplier to my warehouse.  How can I associate this cost to my
> > > Product
> > > > > Asset? This way, I know the exact cost of my product including the
> > > > > miscellaneous expenses I have incurred for a product.
> > > > >
> > > > > Similarly,
> > > > >
> > > > > 2. Create a vendor bill for trucking charges to transport the
> product
> > > > from
> > > > > my warehouse to the Customer. How can I associate this trucking
> cost
> > > > > against the Customer. In my case, the customer gets free shipping
> > under
> > > > > product promotion, but I incur this cost.
> > > > >
> > > > > Appreciate your expert technical advice to achieve this. Thanks for
> > > your
> > > > > responses in advance.
> > > > >  --
> > > > > Best Regards,
> > > > >
> > > > > Sarang Deshpande
> > > > >
> > > >
> > >
> > >
> > >
> > > --
> > > Regards,
> > >
> > > Sarang
> > >
> >
>
>
>
> --
> Regards,
>
> Sarang
>

[sarangdj]

Thanks once again Pierre,

I understood the mapping of Payable Shipping cost with the Product COGS. It
works fine.

Now coming to mapping the Payable Shipping cost with the Customer (without
affecting any other ledger), can I introduce a Customer drop down (just
like product mapping) and associate a customer with the shipping cost. Is
it advisable? am I affecting the system adversely?

Once I have the mapping, I can draw a report of indirect costs incurred for
a customer (this will be a managerial report as against an accounting
report).

What is your advice?

Thanks in advance.

Sarang


On Wed, Jul 30, 2014 at 7:14 PM, Pierre Smits <[hidden email]>
wrote:

> Ahh. Ok.
>
> When you reread my posting in this thread you'll find that I stated that
> product ID can be assigned to line items in purchase invoices in the
> accounting module.
>
> And you have succeeded in doing so, as per your registration in the demo
> environment
>
> http://demo-stable-ofbiz.apache.org/accounting/control/listInvoiceItems?invoiceId=10001
> (which I am surmising to be yours, if not: my apologies).
>
> Purchase invoicing can be found as a reference on the Main Page of the
> Accounting app, called Show Invoices Purchase Invoice. These can also be
> found through:
> http://demo-stable-ofbiz.apache.org/accounting/control/findInvoices
>
> The assignment of productIDs to invoice line items helps with respect to
> spend analysis. I did not state that such a functionality is included in
> the feature set of OFBiz.
>
> Regards,
>
> Pierre Smits
>
> *ORRTIZ.COM <http://www.orrtiz.com>*
> Services & Solutions for Cloud-
> Based Manufacturing, Professional
> Services and Retail & Trade
> http://www.orrtiz.com
>
>
> On Wed, Jul 30, 2014 at 3:34 PM, Sarang Deshpande <[hidden email]>
> wrote:
>
> > Hi Pierre,
> >
> > I am not clear of the menu under accounting module you are referring to.
> > Sorry for my ignorance.
> >
> > Sarang
> >
> >
> >
> > On Wed, Jul 30, 2014 at 6:52 PM, Pierre Smits <[hidden email]>
> > wrote:
> >
> > > Hi Sarang,
> > >
> > > What aspect do you find unclear?
> > >
> > > Regards,
> > >
> > > Pierre Smits
> > >
> > > *ORRTIZ.COM <http://www.orrtiz.com>*
> > > Services & Solutions for Cloud-
> > > Based Manufacturing, Professional
> > > Services and Retail & Trade
> > > http://www.orrtiz.com
> > >
> > >
> > > On Wed, Jul 30, 2014 at 3:20 PM, Sarang Deshpande <[hidden email]>
> > > wrote:
> > >
> > > > Hi Pierre,
> > > >
> > > > Thanks for the prompt response. I am clear with the second advice you
> > > > mentioned. My product COGS is not increased with the trucking cost
> > when I
> > > > selected Product in the AP invoice. You made my day.
> > > >
> > > > However, I am not clear with the first advice. Can you elaborate
> > please?
> > > >
> > > > Thanks,
> > > >
> > > > Sarang
> > > >
> > > >
> > > > On Wed, Jul 30, 2014 at 5:46 PM, Pierre Smits <
> [hidden email]>
> > > > wrote:
> > > >
> > > > > Hi Sarang,
> > > > >
> > > > > First of all, OFBiz allows you to register such cost as trucking
> > > charges
> > > > to
> > > > > be associated with any cost carrier in the accounting module for
> > spend
> > > > > analysis.
> > > > >
> > > > > For purchase invoices the way to do this is to set the product ID
> in
> > > the
> > > > > line item of the created purchase invoice.
> > > > >
> > > > > Regards,
> > > > >
> > > > >
> > > > > Pierre Smits
> > > > >
> > > > > *ORRTIZ.COM <http://www.orrtiz.com>*
> > > > > Services & Solutions for Cloud-
> > > > > Based Manufacturing, Professional
> > > > > Services and Retail & Trade
> > > > > http://www.orrtiz.com
> > > > >
> > > > >
> > > > > On Wed, Jul 30, 2014 at 1:58 PM, Sarang Deshpande <
> > [hidden email]>
> > > > > wrote:
> > > > >
> > > > > > Hello Community,
> > > > > >
> > > > > > First of all, thanks all the community members for creating such
> a
> > > > robust
> > > > > > software and application development framework.
> > > > > >
> > > > > > I have a business case where I want to achieve something as
> > follows:
> > > > > >
> > > > > > 1. Create a Vendor Bill for Trucking Charges to transport my
> > Product
> > > > from
> > > > > > my supplier to my warehouse.  How can I associate this cost to my
> > > > Product
> > > > > > Asset? This way, I know the exact cost of my product including
> the
> > > > > > miscellaneous expenses I have incurred for a product.
> > > > > >
> > > > > > Similarly,
> > > > > >
> > > > > > 2. Create a vendor bill for trucking charges to transport the
> > product
> > > > > from
> > > > > > my warehouse to the Customer. How can I associate this trucking
> > cost
> > > > > > against the Customer. In my case, the customer gets free shipping
> > > under
> > > > > > product promotion, but I incur this cost.
> > > > > >
> > > > > > Appreciate your expert technical advice to achieve this. Thanks
> for
> > > > your
> > > > > > responses in advance.
> > > > > >  --
> > > > > > Best Regards,
> > > > > >
> > > > > > Sarang Deshpande
> > > > > >
> > > > >
> > > >
> > > >
> > > >
> > > > --
> > > > Regards,
> > > >
> > > > Sarang
> > > >
> > >
> >
> >
> >
> > --
> > Regards,
> >
> > Sarang
> >
>

--
Regards,

Sarang

[Pierre Smits]

Sarang,

Making costs as transparently visible as possible is a good approach.
Showing cost of transportation (albeit forfaitairy) and waiving it adheres
to that. It is good for negotiations.

Regards,

Pierre Smits

*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com


On Wed, Jul 30, 2014 at 4:07 PM, Sarang Deshpande <[hidden email]>
wrote:

> Thanks once again Pierre,
>
> I understood the mapping of Payable Shipping cost with the Product COGS. It
> works fine.
>
> Now coming to mapping the Payable Shipping cost with the Customer (without
> affecting any other ledger), can I introduce a Customer drop down (just
> like product mapping) and associate a customer with the shipping cost. Is
> it advisable? am I affecting the system adversely?
>
> Once I have the mapping, I can draw a report of indirect costs incurred for
> a customer (this will be a managerial report as against an accounting
> report).
>
> What is your advice?
>
> Thanks in advance.
>
> Sarang
>
>
> On Wed, Jul 30, 2014 at 7:14 PM, Pierre Smits <[hidden email]>
> wrote:
>
> > Ahh. Ok.
> >
> > When you reread my posting in this thread you'll find that I stated that
> > product ID can be assigned to line items in purchase invoices in the
> > accounting module.
> >
> > And you have succeeded in doing so, as per your registration in the demo
> > environment
> >
> >
> http://demo-stable-ofbiz.apache.org/accounting/control/listInvoiceItems?invoiceId=10001
> > (which I am surmising to be yours, if not: my apologies).
> >
> > Purchase invoicing can be found as a reference on the Main Page of the
> > Accounting app, called Show Invoices Purchase Invoice. These can also be
> > found through:
> > http://demo-stable-ofbiz.apache.org/accounting/control/findInvoices
> >
> > The assignment of productIDs to invoice line items helps with respect to
> > spend analysis. I did not state that such a functionality is included in
> > the feature set of OFBiz.
> >
> > Regards,
> >
> > Pierre Smits
> >
> > *ORRTIZ.COM <http://www.orrtiz.com>*
> > Services & Solutions for Cloud-
> > Based Manufacturing, Professional
> > Services and Retail & Trade
> > http://www.orrtiz.com
> >
> >
> > On Wed, Jul 30, 2014 at 3:34 PM, Sarang Deshpande <[hidden email]>
> > wrote:
> >
> > > Hi Pierre,
> > >
> > > I am not clear of the menu under accounting module you are referring
> to.
> > > Sorry for my ignorance.
> > >
> > > Sarang
> > >
> > >
> > >
> > > On Wed, Jul 30, 2014 at 6:52 PM, Pierre Smits <[hidden email]>
> > > wrote:
> > >
> > > > Hi Sarang,
> > > >
> > > > What aspect do you find unclear?
> > > >
> > > > Regards,
> > > >
> > > > Pierre Smits
> > > >
> > > > *ORRTIZ.COM <http://www.orrtiz.com>*
> > > > Services & Solutions for Cloud-
> > > > Based Manufacturing, Professional
> > > > Services and Retail & Trade
> > > > http://www.orrtiz.com
> > > >
> > > >
> > > > On Wed, Jul 30, 2014 at 3:20 PM, Sarang Deshpande <
> [hidden email]>
> > > > wrote:
> > > >
> > > > > Hi Pierre,
> > > > >
> > > > > Thanks for the prompt response. I am clear with the second advice
> you
> > > > > mentioned. My product COGS is not increased with the trucking cost
> > > when I
> > > > > selected Product in the AP invoice. You made my day.
> > > > >
> > > > > However, I am not clear with the first advice. Can you elaborate
> > > please?
> > > > >
> > > > > Thanks,
> > > > >
> > > > > Sarang
> > > > >
> > > > >
> > > > > On Wed, Jul 30, 2014 at 5:46 PM, Pierre Smits <
> > [hidden email]>
> > > > > wrote:
> > > > >
> > > > > > Hi Sarang,
> > > > > >
> > > > > > First of all, OFBiz allows you to register such cost as trucking
> > > > charges
> > > > > to
> > > > > > be associated with any cost carrier in the accounting module for
> > > spend
> > > > > > analysis.
> > > > > >
> > > > > > For purchase invoices the way to do this is to set the product ID
> > in
> > > > the
> > > > > > line item of the created purchase invoice.
> > > > > >
> > > > > > Regards,
> > > > > >
> > > > > >
> > > > > > Pierre Smits
> > > > > >
> > > > > > *ORRTIZ.COM <http://www.orrtiz.com>*
> > > > > > Services & Solutions for Cloud-
> > > > > > Based Manufacturing, Professional
> > > > > > Services and Retail & Trade
> > > > > > http://www.orrtiz.com
> > > > > >
> > > > > >
> > > > > > On Wed, Jul 30, 2014 at 1:58 PM, Sarang Deshpande <
> > > [hidden email]>
> > > > > > wrote:
> > > > > >
> > > > > > > Hello Community,
> > > > > > >
> > > > > > > First of all, thanks all the community members for creating
> such
> > a
> > > > > robust
> > > > > > > software and application development framework.
> > > > > > >
> > > > > > > I have a business case where I want to achieve something as
> > > follows:
> > > > > > >
> > > > > > > 1. Create a Vendor Bill for Trucking Charges to transport my
> > > Product
> > > > > from
> > > > > > > my supplier to my warehouse.  How can I associate this cost to
> my
> > > > > Product
> > > > > > > Asset? This way, I know the exact cost of my product including
> > the
> > > > > > > miscellaneous expenses I have incurred for a product.
> > > > > > >
> > > > > > > Similarly,
> > > > > > >
> > > > > > > 2. Create a vendor bill for trucking charges to transport the
> > > product
> > > > > > from
> > > > > > > my warehouse to the Customer. How can I associate this trucking
> > > cost
> > > > > > > against the Customer. In my case, the customer gets free
> shipping
> > > > under
> > > > > > > product promotion, but I incur this cost.
> > > > > > >
> > > > > > > Appreciate your expert technical advice to achieve this. Thanks
> > for
> > > > > your
> > > > > > > responses in advance.
> > > > > > >  --
> > > > > > > Best Regards,
> > > > > > >
> > > > > > > Sarang Deshpande
> > > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > > Regards,
> > > > >
> > > > > Sarang
> > > > >
> > > >
> > >
> > >
> > >
> > > --
> > > Regards,
> > >
> > > Sarang
> > >
> >
>
>
>
> --
> Regards,
>
> Sarang
>

[sarangdj]

Thanks for all the help Pierre.

I understand your point of view. Sometimes the business requirements are
demanding. Anyways, I appreciate your guidance.

Take care,

Sarang



On Wed, Jul 30, 2014 at 7:48 PM, Pierre Smits <[hidden email]>
wrote:

> Sarang,
>
> Making costs as transparently visible as possible is a good approach.
> Showing cost of transportation (albeit forfaitairy) and waiving it adheres
> to that. It is good for negotiations.
>
> Regards,
>
> Pierre Smits
>
> *ORRTIZ.COM <http://www.orrtiz.com>*
> Services & Solutions for Cloud-
> Based Manufacturing, Professional
> Services and Retail & Trade
> http://www.orrtiz.com
>
>
> On Wed, Jul 30, 2014 at 4:07 PM, Sarang Deshpande <[hidden email]>
> wrote:
>
> > Thanks once again Pierre,
> >
> > I understood the mapping of Payable Shipping cost with the Product COGS.
> It
> > works fine.
> >
> > Now coming to mapping the Payable Shipping cost with the Customer
> (without
> > affecting any other ledger), can I introduce a Customer drop down (just
> > like product mapping) and associate a customer with the shipping cost. Is
> > it advisable? am I affecting the system adversely?
> >
> > Once I have the mapping, I can draw a report of indirect costs incurred
> for
> > a customer (this will be a managerial report as against an accounting
> > report).
> >
> > What is your advice?
> >
> > Thanks in advance.
> >
> > Sarang
> >
> >
> > On Wed, Jul 30, 2014 at 7:14 PM, Pierre Smits <[hidden email]>
> > wrote:
> >
> > > Ahh. Ok.
> > >
> > > When you reread my posting in this thread you'll find that I stated
> that
> > > product ID can be assigned to line items in purchase invoices in the
> > > accounting module.
> > >
> > > And you have succeeded in doing so, as per your registration in the
> demo
> > > environment
> > >
> > >
> >
> http://demo-stable-ofbiz.apache.org/accounting/control/listInvoiceItems?invoiceId=10001
> > > (which I am surmising to be yours, if not: my apologies).
> > >
> > > Purchase invoicing can be found as a reference on the Main Page of the
> > > Accounting app, called Show Invoices Purchase Invoice. These can also
> be
> > > found through:
> > > http://demo-stable-ofbiz.apache.org/accounting/control/findInvoices
> > >
> > > The assignment of productIDs to invoice line items helps with respect
> to
> > > spend analysis. I did not state that such a functionality is included
> in
> > > the feature set of OFBiz.
> > >
> > > Regards,
> > >
> > > Pierre Smits
> > >
> > > *ORRTIZ.COM <http://www.orrtiz.com>*
> > > Services & Solutions for Cloud-
> > > Based Manufacturing, Professional
> > > Services and Retail & Trade
> > > http://www.orrtiz.com
> > >
> > >
> > > On Wed, Jul 30, 2014 at 3:34 PM, Sarang Deshpande <[hidden email]>
> > > wrote:
> > >
> > > > Hi Pierre,
> > > >
> > > > I am not clear of the menu under accounting module you are referring
> > to.
> > > > Sorry for my ignorance.
> > > >
> > > > Sarang
> > > >
> > > >
> > > >
> > > > On Wed, Jul 30, 2014 at 6:52 PM, Pierre Smits <
> [hidden email]>
> > > > wrote:
> > > >
> > > > > Hi Sarang,
> > > > >
> > > > > What aspect do you find unclear?
> > > > >
> > > > > Regards,
> > > > >
> > > > > Pierre Smits
> > > > >
> > > > > *ORRTIZ.COM <http://www.orrtiz.com>*
> > > > > Services & Solutions for Cloud-
> > > > > Based Manufacturing, Professional
> > > > > Services and Retail & Trade
> > > > > http://www.orrtiz.com
> > > > >
> > > > >
> > > > > On Wed, Jul 30, 2014 at 3:20 PM, Sarang Deshpande <
> > [hidden email]>
> > > > > wrote:
> > > > >
> > > > > > Hi Pierre,
> > > > > >
> > > > > > Thanks for the prompt response. I am clear with the second advice
> > you
> > > > > > mentioned. My product COGS is not increased with the trucking
> cost
> > > > when I
> > > > > > selected Product in the AP invoice. You made my day.
> > > > > >
> > > > > > However, I am not clear with the first advice. Can you elaborate
> > > > please?
> > > > > >
> > > > > > Thanks,
> > > > > >
> > > > > > Sarang
> > > > > >
> > > > > >
> > > > > > On Wed, Jul 30, 2014 at 5:46 PM, Pierre Smits <
> > > [hidden email]>
> > > > > > wrote:
> > > > > >
> > > > > > > Hi Sarang,
> > > > > > >
> > > > > > > First of all, OFBiz allows you to register such cost as
> trucking
> > > > > charges
> > > > > > to
> > > > > > > be associated with any cost carrier in the accounting module
> for
> > > > spend
> > > > > > > analysis.
> > > > > > >
> > > > > > > For purchase invoices the way to do this is to set the product
> ID
> > > in
> > > > > the
> > > > > > > line item of the created purchase invoice.
> > > > > > >
> > > > > > > Regards,
> > > > > > >
> > > > > > >
> > > > > > > Pierre Smits
> > > > > > >
> > > > > > > *ORRTIZ.COM <http://www.orrtiz.com>*
> > > > > > > Services & Solutions for Cloud-
> > > > > > > Based Manufacturing, Professional
> > > > > > > Services and Retail & Trade
> > > > > > > http://www.orrtiz.com
> > > > > > >
> > > > > > >
> > > > > > > On Wed, Jul 30, 2014 at 1:58 PM, Sarang Deshpande <
> > > > [hidden email]>
> > > > > > > wrote:
> > > > > > >
> > > > > > > > Hello Community,
> > > > > > > >
> > > > > > > > First of all, thanks all the community members for creating
> > such
> > > a
> > > > > > robust
> > > > > > > > software and application development framework.
> > > > > > > >
> > > > > > > > I have a business case where I want to achieve something as
> > > > follows:
> > > > > > > >
> > > > > > > > 1. Create a Vendor Bill for Trucking Charges to transport my
> > > > Product
> > > > > > from
> > > > > > > > my supplier to my warehouse.  How can I associate this cost
> to
> > my
> > > > > > Product
> > > > > > > > Asset? This way, I know the exact cost of my product
> including
> > > the
> > > > > > > > miscellaneous expenses I have incurred for a product.
> > > > > > > >
> > > > > > > > Similarly,
> > > > > > > >
> > > > > > > > 2. Create a vendor bill for trucking charges to transport the
> > > > product
> > > > > > > from
> > > > > > > > my warehouse to the Customer. How can I associate this
> trucking
> > > > cost
> > > > > > > > against the Customer. In my case, the customer gets free
> > shipping
> > > > > under
> > > > > > > > product promotion, but I incur this cost.
> > > > > > > >
> > > > > > > > Appreciate your expert technical advice to achieve this.
> Thanks
> > > for
> > > > > > your
> > > > > > > > responses in advance.
> > > > > > > >  --
> > > > > > > > Best Regards,
> > > > > > > >
> > > > > > > > Sarang Deshpande
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > --
> > > > > > Regards,
> > > > > >
> > > > > > Sarang
> > > > > >
> > > > >
> > > >
> > > >
> > > >
> > > > --
> > > > Regards,
> > > >
> > > > Sarang
> > > >
> > >
> >
> >
> >
> > --
> > Regards,
> >
> > Sarang
> >
>

--
Regards,

Sarang

[Pierre Smits]

Sarang,

As you can see in
http://demo-stable-ofbiz.apache.org/accounting/control/listInvoiceItems?invoiceId=demo10002
there is not a field available to associate a line item to a party
(customer, employee or otherwise).

However, it is available on the gl transactions line item. Maybe you could
use that.

But as always, you could extend the enitity model for this and subsequently
screens, forms, services.

Regards,

Pierre Smits

*ORRTIZ.COM <http://www.orrtiz.com>*
Services & Solutions for Cloud-
Based Manufacturing, Professional
Services and Retail & Trade
http://www.orrtiz.com


On Wed, Jul 30, 2014 at 4:23 PM, Sarang Deshpande <[hidden email]>
wrote:

> Thanks for all the help Pierre.
>
> I understand your point of view. Sometimes the business requirements are
> demanding. Anyways, I appreciate your guidance.
>
> Take care,
>
> Sarang
>
>
>
> On Wed, Jul 30, 2014 at 7:48 PM, Pierre Smits <[hidden email]>
> wrote:
>
> > Sarang,
> >
> > Making costs as transparently visible as possible is a good approach.
> > Showing cost of transportation (albeit forfaitairy) and waiving it
> adheres
> > to that. It is good for negotiations.
> >
> > Regards,
> >
> > Pierre Smits
> >
> > *ORRTIZ.COM <http://www.orrtiz.com>*
> > Services & Solutions for Cloud-
> > Based Manufacturing, Professional
> > Services and Retail & Trade
> > http://www.orrtiz.com
> >
> >
> > On Wed, Jul 30, 2014 at 4:07 PM, Sarang Deshpande <[hidden email]>
> > wrote:
> >
> > > Thanks once again Pierre,
> > >
> > > I understood the mapping of Payable Shipping cost with the Product
> COGS.
> > It
> > > works fine.
> > >
> > > Now coming to mapping the Payable Shipping cost with the Customer
> > (without
> > > affecting any other ledger), can I introduce a Customer drop down (just
> > > like product mapping) and associate a customer with the shipping cost.
> Is
> > > it advisable? am I affecting the system adversely?
> > >
> > > Once I have the mapping, I can draw a report of indirect costs incurred
> > for
> > > a customer (this will be a managerial report as against an accounting
> > > report).
> > >
> > > What is your advice?
> > >
> > > Thanks in advance.
> > >
> > > Sarang
> > >
> > >
> > > On Wed, Jul 30, 2014 at 7:14 PM, Pierre Smits <[hidden email]>
> > > wrote:
> > >
> > > > Ahh. Ok.
> > > >
> > > > When you reread my posting in this thread you'll find that I stated
> > that
> > > > product ID can be assigned to line items in purchase invoices in the
> > > > accounting module.
> > > >
> > > > And you have succeeded in doing so, as per your registration in the
> > demo
> > > > environment
> > > >
> > > >
> > >
> >
> http://demo-stable-ofbiz.apache.org/accounting/control/listInvoiceItems?invoiceId=10001
> > > > (which I am surmising to be yours, if not: my apologies).
> > > >
> > > > Purchase invoicing can be found as a reference on the Main Page of
> the
> > > > Accounting app, called Show Invoices Purchase Invoice. These can also
> > be
> > > > found through:
> > > > http://demo-stable-ofbiz.apache.org/accounting/control/findInvoices
> > > >
> > > > The assignment of productIDs to invoice line items helps with respect
> > to
> > > > spend analysis. I did not state that such a functionality is included
> > in
> > > > the feature set of OFBiz.
> > > >
> > > > Regards,
> > > >
> > > > Pierre Smits
> > > >
> > > > *ORRTIZ.COM <http://www.orrtiz.com>*
> > > > Services & Solutions for Cloud-
> > > > Based Manufacturing, Professional
> > > > Services and Retail & Trade
> > > > http://www.orrtiz.com
> > > >
> > > >
> > > > On Wed, Jul 30, 2014 at 3:34 PM, Sarang Deshpande <
> [hidden email]>
> > > > wrote:
> > > >
> > > > > Hi Pierre,
> > > > >
> > > > > I am not clear of the menu under accounting module you are
> referring
> > > to.
> > > > > Sorry for my ignorance.
> > > > >
> > > > > Sarang
> > > > >
> > > > >
> > > > >
> > > > > On Wed, Jul 30, 2014 at 6:52 PM, Pierre Smits <
> > [hidden email]>
> > > > > wrote:
> > > > >
> > > > > > Hi Sarang,
> > > > > >
> > > > > > What aspect do you find unclear?
> > > > > >
> > > > > > Regards,
> > > > > >
> > > > > > Pierre Smits
> > > > > >
> > > > > > *ORRTIZ.COM <http://www.orrtiz.com>*
> > > > > > Services & Solutions for Cloud-
> > > > > > Based Manufacturing, Professional
> > > > > > Services and Retail & Trade
> > > > > > http://www.orrtiz.com
> > > > > >
> > > > > >
> > > > > > On Wed, Jul 30, 2014 at 3:20 PM, Sarang Deshpande <
> > > [hidden email]>
> > > > > > wrote:
> > > > > >
> > > > > > > Hi Pierre,
> > > > > > >
> > > > > > > Thanks for the prompt response. I am clear with the second
> advice
> > > you
> > > > > > > mentioned. My product COGS is not increased with the trucking
> > cost
> > > > > when I
> > > > > > > selected Product in the AP invoice. You made my day.
> > > > > > >
> > > > > > > However, I am not clear with the first advice. Can you
> elaborate
> > > > > please?
> > > > > > >
> > > > > > > Thanks,
> > > > > > >
> > > > > > > Sarang
> > > > > > >
> > > > > > >
> > > > > > > On Wed, Jul 30, 2014 at 5:46 PM, Pierre Smits <
> > > > [hidden email]>
> > > > > > > wrote:
> > > > > > >
> > > > > > > > Hi Sarang,
> > > > > > > >
> > > > > > > > First of all, OFBiz allows you to register such cost as
> > trucking
> > > > > > charges
> > > > > > > to
> > > > > > > > be associated with any cost carrier in the accounting module
> > for
> > > > > spend
> > > > > > > > analysis.
> > > > > > > >
> > > > > > > > For purchase invoices the way to do this is to set the
> product
> > ID
> > > > in
> > > > > > the
> > > > > > > > line item of the created purchase invoice.
> > > > > > > >
> > > > > > > > Regards,
> > > > > > > >
> > > > > > > >
> > > > > > > > Pierre Smits
> > > > > > > >
> > > > > > > > *ORRTIZ.COM <http://www.orrtiz.com>*
> > > > > > > > Services & Solutions for Cloud-
> > > > > > > > Based Manufacturing, Professional
> > > > > > > > Services and Retail & Trade
> > > > > > > > http://www.orrtiz.com
> > > > > > > >
> > > > > > > >
> > > > > > > > On Wed, Jul 30, 2014 at 1:58 PM, Sarang Deshpande <
> > > > > [hidden email]>
> > > > > > > > wrote:
> > > > > > > >
> > > > > > > > > Hello Community,
> > > > > > > > >
> > > > > > > > > First of all, thanks all the community members for creating
> > > such
> > > > a
> > > > > > > robust
> > > > > > > > > software and application development framework.
> > > > > > > > >
> > > > > > > > > I have a business case where I want to achieve something as
> > > > > follows:
> > > > > > > > >
> > > > > > > > > 1. Create a Vendor Bill for Trucking Charges to transport
> my
> > > > > Product
> > > > > > > from
> > > > > > > > > my supplier to my warehouse.  How can I associate this cost
> > to
> > > my
> > > > > > > Product
> > > > > > > > > Asset? This way, I know the exact cost of my product
> > including
> > > > the
> > > > > > > > > miscellaneous expenses I have incurred for a product.
> > > > > > > > >
> > > > > > > > > Similarly,
> > > > > > > > >
> > > > > > > > > 2. Create a vendor bill for trucking charges to transport
> the
> > > > > product
> > > > > > > > from
> > > > > > > > > my warehouse to the Customer. How can I associate this
> > trucking
> > > > > cost
> > > > > > > > > against the Customer. In my case, the customer gets free
> > > shipping
> > > > > > under
> > > > > > > > > product promotion, but I incur this cost.
> > > > > > > > >
> > > > > > > > > Appreciate your expert technical advice to achieve this.
> > Thanks
> > > > for
> > > > > > > your
> > > > > > > > > responses in advance.
> > > > > > > > >  --
> > > > > > > > > Best Regards,
> > > > > > > > >
> > > > > > > > > Sarang Deshpande
> > > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > --
> > > > > > > Regards,
> > > > > > >
> > > > > > > Sarang
> > > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > > Regards,
> > > > >
> > > > > Sarang
> > > > >
> > > >
> > >
> > >
> > >
> > > --
> > > Regards,
> > >
> > > Sarang
> > >
> >
>
>
>
> --
> Regards,
>
> Sarang
>