View Single Post
  #3 (permalink)  
Old June 11th, 2007, 20:12
leo_glog leo_glog is offline
Junior Member
 
Join Date: Jun 2007
Location: Duesseldorf, Germany
Posts: 7
Thanks: 0
Thanked 1 Time in 1 Post
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
leo_glog is on a distinguished road
Send a message via Skype™ to leo_glog
Re: General Ledger codes

Hi Anita,

what exactly is the requirement?

do u want to setup Gl againSt order or shipment?

I guess its on shipment level buy site?

Basic requirement is the code must be unique. So in your case you need a buy side SHIPMENT GL LOOKUP KEY
with different key components. Lets work it out:

Simplest would be a code based on cost type A (ccessorial) or B (ase)

the system would allocate for A: zzzz
and for base cost : xxxxx, yyyyyy

So it's not unique. We need add another key component to dsitinguish between out and inbound

Can we use transport mode? i dont think so. It would suprise me if you design the solution with an out and inbound specific modes like TL OUT, TL IN.

Lets think about shipment_location as key component.
If you set it up you will be ask for D (estination) or S(ource) . We nned both

So now we defined 3 key components

cost type
source_location
dest_location

Assign them to the SHIPMENT GL LOOKUP KEY.

now we can create the gl codes

1) xxxxx (scenario we receiving goods from nyc or washington to philly)
cost type B, source loc is blanc, dest location is PHL

2) yyyyy
cost type B, source loc PHL, dest location is blanc

3)
cost type A, source loc blanc, dest blanc

..................
If you have a more complex network with a bunch of inbound location and even more outbound location or you shipping good from to US i would use
the key component involved_party instead of shipment location.

you setting up an agent which inserts an involved party qualifier maybe GLANNEX
with value of INBOUND and OUTBOUND, (if source country us....etc)

now your SHIPMENT GL LOOKUP KEY contains 2 key components
1) cost type
2) involved party..

create gl code..

xxxx
cost type B,
involved party value: INBOUND

yyyyy
cost type B,
involved party value: OTBOUND

zzzzz
cost type A,
involved party value blanc

Let me know if it works..

design is based on 5.0

Jens