Consolidated Invoicing

Hello group,

 

We are running MAPICS XAR6 and are interested in doing consolidated
invoicing, but don't want to cross warehouses.  We have many shipping
locations which are represented by warehouses in MAPICS.  Any given COM
order could order product from multiple warehouses and it is likely that
more than one warehouse may ship the product the same day.  We want to
consolidate the invoices to the same customer for a warehouse.   Here is
an example:

 

CO 111

Item1  warehouse 1

Item2  warehouse 1

Item3  warehouse 2

Item4  warehouse 3

Item5  warehouse 3

 

Assuming we produced five pick lists for this order, because of
different warehouses and location within a warehouse.  Lets also assume
that all five pick lists get shipped on the same day.  Right now we
would produce 5 invoices for the customer.  If we use invoice
consolidation MAPICS would produce one invoice but would combine the
shipments from all three warehouse.  What we would like to do it produce
3 invoices, 1 for the items that shipped from warehouse 1, one for the
item that shipped from warehouse 2, and one for the items that shipped
from warehouse 3.

 

Has anyone done a MAPICS modification like this?  Or does anyone know of
an add on product that could do this?

 

Any information or thoughts would be greatly appreciated.

 

Thanks

Doug