Re: COM Invoicing for Selvaraj from Mike Ellis / ISI -- MAPICS-L

Selvaraj,

I think alot depends on how you need to track these items financially.   I 
can help figure something out, if you'd like to discuss with me, feel free 
to contact me on e-mail.   I'll give you my cell phone number (which I 
don't want to post here).

My questions revolve around:
1)  When do you really want to record the revenue? 
2)  What happens if the shipment to the hub overlaps a month-end before 
the shipment to the real destination?
3)  What do you do about scrap or other inventory loss in the HUB ?   Who 
is responsible for it?
4)  What paperwork is required in that location for the shipment?   Is it 
your truck or someone elses that does the movement?
5)  What transactions is your staff WILLING to do?  I mean, some companies 
have a horrifying aversion to touching a keyboard, even to get what they 
want.  If yours is like that, we have to think diffferently about it.

Anwyay, if you want to talk about it for a bit, drop me a note.

Michael G. Ellis
Information Systems International, Inc.
A Global ERP Consulting Firm
815-398-1670 x23
 
Choose ISI consultants to ensure consistently top quality implementation 
services at all levels of your organization.

"Look at a day when you are supremely satisfied at the end; 
                it is not a day when you lounge around doing nothing, 
                it's a day when you've had everything to do and you've 
done it!" 
                                        - Margaret Thatcher


message: 4
date: Wed, 18 May 2005 17:01:50 +0800
from: Selvaraj Pillai <selvaraj.pillai@xxxxxxxxxxx>
subject: COM Invoicing

Hello Group,

We are on MAPICS XA R6 PTF 5788. We use mainly COM, MRP, PUR, IM, EPDM, 
PCC, PMC, IFM etc and all these modules are interfaced each other. I have 
a question to post to our valuable group. We have a location (factory) in 
Thailand, which is in an export zone. As per the local government 
regulations any shipment moved out of the factory should be recognized as 
revenue. But, we have some overseas customers who have got HUB location in 

Thailand outside of this export zone.

As per the agreements with our Customer who has got HUB location, we can 
only invoice them when they pull the stock out of HUB, until such time the 

stock in the HUB belongs to us and we need to track the inventory.

In the past and now, we used manual Invoice to move the shipment to the 
customers HUB location and manually create AR invoice in IFM. Once the 
customer pull the stock from HUB, we create shipment (Process Item ready 
for Shipping), which will pass the SA transaction (Sales Shipment) to 
reduce the inventory and send the AR invoices to IFM through the COM G/L 
interface. Subsequently we will reverse the manual invoice posted earlier.

We track the inventory by creating a specific location to indicate the HUB 

of each customer, and define this location as staging when we print the 
pick list, so that Pick Confirmation will move the stock to this location 
by TW transactions.

Now, we are trying to eliminate the process of manual invoice, manual AR 
posting and reversing with an automated process within COM in MAPICS. Is 
there any one in the group encountered such requirements or any other 
suggestions to automate this process, please provide your thoughts.

Regards,

S.P. Selvaraj
Senior I.T. Specialist, Asia Pacific
Tel. Dir (65) 6586-8009, Mobile (65) 9653-4048, IP Phone 4368