Container Landed Cost and tracking

Yahoo Archive
1
Hi Greg,



Yes - accounting would. I was addressing your handling of the shipment
status. This would allow you to invoice at time of shipment, enter the
shipment info into the container, have the visibility and not have to
"be creative" with your receiving process. I'd recommend trying to use
the system as intended and focus your efforts on how to make the
entry/matching process more efficient.



Good luck!



John A. Hatcher

Manager of IS

Versa Products Co., Inc.

(201) 843-2400 x4148

(201) 843-2931 fax



[Non-text portions of this message have been removed]
2
We're trying to use this in 9.05.607 in a bit of an unusual way I guess and wonder if anyone else has the same problem.

Basically, we're not yet using the landed cost stuff yet (just went live 2 months ago) but we need to see by container what's "on the water' (we have 5 suppliers in China) and what's actually here.

Setting up a container and looking at the standard reports for the ststus of shipped, arrived, and received gives us all the info we need but won't work for us because of one small detail. We need to pay for the material when it ships from China.

That means we must receive it for accounting to pay the invoice. Unfortunately, that messes up the status of shipped (left China but not yet here) and physically received at our plant as everything will then show as received.

There are lots of line items on these containers so making a misc. invoice and then matching it up later line by line is too cumbersome. Production Control needs an easy way to see, by container, what parts are inside so they can prioritize unloading them, etc. Receiving needs a list of everything in the container to check off everything as they unload it.

I was going to 'receive' containers into the Inspection Queue and assign everything to be inspected by a specific inspector (eg:"CHINA"). That way I could print a standard Inspection Pending Report by Inspector to see everything 'On The Water". I'd just have to add a UD field with the container number to that report.

Unfortunately, while I can mark a particular supplier to be "Inspection Required", I cannot also assign a default inspector by supplier. That then also makes for a tedious line by line data entry task. We also tried receiving to a virtual warehouse called INTRANSIT but doing the line by line transfers to the main warehouse when they arrive was also burdonsome.

The Container Landed Cost thing would work great if only it would allow me to pay the invoice while the container status was just SHIPPED. Anybody have a work around here or other method or ideas?
3
Have you looked as advanced billing on the AP side? I believe this is
different than a misc invoice.

You can kind of think of it as the vendor wants payment before sending
goods...



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of greg_clauser
Sent: Tuesday, January 24, 2012 1:36 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Container Landed Cost and tracking





We're trying to use this in 9.05.607 in a bit of an unusual way I guess
and wonder if anyone else has the same problem.

Basically, we're not yet using the landed cost stuff yet (just went live
2 months ago) but we need to see by container what's "on the water' (we
have 5 suppliers in China) and what's actually here.

Setting up a container and looking at the standard reports for the
ststus of shipped, arrived, and received gives us all the info we need
but won't work for us because of one small detail. We need to pay for
the material when it ships from China.

That means we must receive it for accounting to pay the invoice.
Unfortunately, that messes up the status of shipped (left China but not
yet here) and physically received at our plant as everything will then
show as received.

There are lots of line items on these containers so making a misc.
invoice and then matching it up later line by line is too cumbersome.
Production Control needs an easy way to see, by container, what parts
are inside so they can prioritize unloading them, etc. Receiving needs a
list of everything in the container to check off everything as they
unload it.

I was going to 'receive' containers into the Inspection Queue and assign
everything to be inspected by a specific inspector (eg:"CHINA"). That
way I could print a standard Inspection Pending Report by Inspector to
see everything 'On The Water". I'd just have to add a UD field with the
container number to that report.

Unfortunately, while I can mark a particular supplier to be "Inspection
Required", I cannot also assign a default inspector by supplier. That
then also makes for a tedious line by line data entry task. We also
tried receiving to a virtual warehouse called INTRANSIT but doing the
line by line transfers to the main warehouse when they arrive was also
burdonsome.

The Container Landed Cost thing would work great if only it would allow
me to pay the invoice while the container status was just SHIPPED.
Anybody have a work around here or other method or ideas?





[Non-text portions of this message have been removed]
4
We are on Vantage 803 409A but have been exploring the container
functionality of late.



There is an AP function that allows entry of invoice for unreceived
PO's. There is a separate application available to use when the receipt
occurs to then tie the invoice lines to the specific receipts.



The only down side is the system requires posting the invoice. This
stopped us from using it since we wouldn't want to perform adjustment
entries for every price/qty variance that may come to light later. I'm
responding to your posting since you are using Epicor 9 and may not be
subject to this same problem.



John A. Hatcher

Manager of IS

Versa Products Co., Inc.

(201) 843-2400 x4148

(201) 843-2931 fax



[Non-text portions of this message have been removed]
5
Thanks for the input but I think accounting would still have to process the something line by line no?


--- In vantage@yahoogroups.com, Joe Rojas <jrojas@...> wrote:
>
> Have you looked as advanced billing on the AP side? I believe this is
> different than a misc invoice.
>
> You can kind of think of it as the vendor wants payment before sending
> goods...
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of greg_clauser
> Sent: Tuesday, January 24, 2012 1:36 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Container Landed Cost and tracking
>
>
>
>
>
> We're trying to use this in 9.05.607 in a bit of an unusual way I guess
> and wonder if anyone else has the same problem.
>
> Basically, we're not yet using the landed cost stuff yet (just went live
> 2 months ago) but we need to see by container what's "on the water' (we
> have 5 suppliers in China) and what's actually here.
>
> Setting up a container and looking at the standard reports for the
> ststus of shipped, arrived, and received gives us all the info we need
> but won't work for us because of one small detail. We need to pay for
> the material when it ships from China.
>
> That means we must receive it for accounting to pay the invoice.
> Unfortunately, that messes up the status of shipped (left China but not
> yet here) and physically received at our plant as everything will then
> show as received.
>
> There are lots of line items on these containers so making a misc.
> invoice and then matching it up later line by line is too cumbersome.
> Production Control needs an easy way to see, by container, what parts
> are inside so they can prioritize unloading them, etc. Receiving needs a
> list of everything in the container to check off everything as they
> unload it.
>
> I was going to 'receive' containers into the Inspection Queue and assign
> everything to be inspected by a specific inspector (eg:"CHINA"). That
> way I could print a standard Inspection Pending Report by Inspector to
> see everything 'On The Water". I'd just have to add a UD field with the
> container number to that report.
>
> Unfortunately, while I can mark a particular supplier to be "Inspection
> Required", I cannot also assign a default inspector by supplier. That
> then also makes for a tedious line by line data entry task. We also
> tried receiving to a virtual warehouse called INTRANSIT but doing the
> line by line transfers to the main warehouse when they arrive was also
> burdonsome.
>
> The Container Landed Cost thing would work great if only it would allow
> me to pay the invoice while the container status was just SHIPPED.
> Anybody have a work around here or other method or ideas?
>
>
>
>
>
> [Non-text portions of this message have been removed]
>