RE: Consolidated Invoicing

Doug, 

Consolidated Invoicing was designed to allow customers to consolidate
all available shipments by customer that have matching currencies across
multiple warehouses.  This was especially handy for export invoices that
had to match letters of credit filed with customer's banks.  You can set
up warehouse security in IM.  However, I can't remember if we ever tied
the selection of invoices to that warehouse security in IM.  You need to
do a little testing - I would do it for you, but I don't have access to
a MAPICS environment or an AS/400 for that matter right now.

Set up the necessary security by warehouse in IM in your test
environment.
You may need to check in CAS to see if there is any additional security
that needs to be turned on specificall for invoicing for your test user.
Enter an order with more than one warehouse on a customer marked as a
consoliated customer, then ship them as two separate shipments selected
by warehouse.
Then attempt to select shipments for invoices the tester does not have
authority to in IM.  
Generate the consolidated invoice to see which items it picks up and see
if it does cross warehouses.

If it does not generate separate consolidated invoices by the warehouse
code the user is authorized to use, then your only other recourse is to
use the invoice user exit and change the way the consolidated invoices
are generated.  This could be quite an involved task so do your research
first before tackling it.  How many consolidated invoices do you have
the potential of creating on a monthly basis?  If only a couple, it is
not worth the effort.  It would be easier to write your invoices to a
separate file as they are generated and create a consolidated invoice
using a home grown program that would match totals to your financials.
The biggest risk is generating invoices outside of MAPICS that do not
match what was sent to the AR financials.  Your auditors may have a
problem with that suggestion.  

Hope this was helpful.
Paola Groeber
770-591-1497 (Home Office)
770-490-3297 (Cell)


-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Morrison, Doug
Sent: Friday, September 17, 2004 3:39 PM
To: MAPICS-L@xxxxxxxxxxxx
Cc: Sargent, Daniel
Subject: 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

 

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post
a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.