David,
I think I understand what you mean, but following your suggestion will
require to define special types for orderItemTypeId as well (and maybe
it is a good idea); and then create a mapping between the (drop
shipment) orderItemTypeId and the (drop shipment) invoiceItemTypeId.
This means definitely a cleaner approach but also a lot of new types and
type mappings (for orders, invoices, returns...).
What is the best way to go?
Jacopo
David E Jones wrote:
The best way to do this would be to use the parent type pattern and have
a parent type for all of the InvoiceItemType Ids that are used for drop
shipped order, and that is easy to apply to other things as well (and
code can be written pretty easily to look at it).
-David
On Jan 25, 2008, at 4:52 AM, Jacopo Cappellato wrote:
I've moved this thread to from the user to the dev list.
I did some research on how to implement this (i.e. assign specific
invoice item types for purchase invoices for drop shipped items) and
maybe the easiest way is to define a new InvoiceItemType for each of
the existing ones with DS_ prefix (or similar).
The algoritm would be:
1) using the InvoiceItemTypeMap find the invoiceItemTypeId associated
to the orderItemTypeId (as is now)
2) if it is a drop shipment, add the prefix DS_: "DS_" +
invoiceItemTypeId
What do you think?
Jacopo
Dave Tenerowicz wrote:
# 2 is a good suggestion - I'll try that and let the ml know the
results. Option 1 would not work because the same product could be
drop shipped, or shipped from the company warehouse.
-Dave
Jacopo Cappellato wrote:
As a first shot I'd say that:
1) you can try to use GL mappings for ProductCategories (and group
your products in different product categories) or
2) we have to generate invoice items for drop shipped products with
special invoiceItemTypes and use the Gl mappings for
invoiceItemTypes to route them to the right accounts
Just my 2 cents
Jacopo
Dave Tenerowicz wrote:
Does anyone have any experience setting up OfBiz accounting so that
the default GL accounts used varies according to the type of
Purchase (for example purchases to replenish stock, vs purchases
that are drop shipped?)
For example, if a PO/Purchase Invoice is for goods for stock, use
one AP account and a corresponding cost of goods. However, if the
PO/Purchase Invoice is for product that was drop shipped, then use
a different AP account and a different purchase COG account. And
finally, if a PO/Purchase Invoice is for trans shipped goods, use a
different pair of accounts. (Trans ship means one company
organization issues the PO, the goods are received at a warehouse
owned by another internal organization and then shipped from that
warehouse to the end customer)
After an hour of experimentation, I cannot find a way to get the
proper results. Has anyone solved a problem like this before?