• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

G/L J09110MAP - Journal Uploads

steven_lawrence

Active Member
** High Priority **

Dear List

We are attemping to upload a multi-line Fixed Assets journal into G/L from spreadsheet to JDE. The problem we are having is that the "Item Number" field does not appear to be a field you can map using the upload template (J09110MAP) as the ASII data item is not in the list of available fields.

Any ideas ?

We are running World A7.3 cum 10 on an AS/400 620 box.

Steve.


++++++++++++++++++++++++++++++
Steven Lawrence
Finance Systems Manager
Coral Eurobet plc
Glebe House, Vicarage Drive,
Barking, Essex, IG11 7NS, UK
Tel: +44 (0)20 8591 5151
Fax: +44 (0)20 8591 8647
website: www.coral.co.uk
e-mail: steven.lawrence@coral.co.uk

++++++++++++++++++++++++++++++
 

Eric_Holm

Active Member
Steve:

J0911MAP looks very similar to JGLCNVSST (and corresponding JCNV0911) which
does have a field to map the FA number. There are found on menu MUPLD0911.
JGLCNVSST is the mapping DW that is used by the upload program JCNV0911
I hope this helps

JDEdwards A7.3.10

Eric.

Eric M. Holm

CGI Information Systems & Management Consultants, Inc.
600 Federal Street
Andover, MA 01810
Direct: 978-946-3269
Main: 978-946-3000
Fax 978-687-4305
 

ShippS

Member
We populate one of the reference fields and then use Worldwriter to populate
ASID in the f0911z1. The origin is a several thousand line spreadsheet

It works fine for us.

Steve
 
To All: WE are on A73 Cum 9 and are in the process of implementing FA as
well but I do not find these programs or menu. Are these specific to Cum 10
or am I missing something.
Thanks,
Liz Abernathy
Manager of IT
Smith Fibercast
 

TGreene

Active Member
Steven,

We recently did a "one-time" upload of assets into G/L. I made a one
line program change to P09110. The Asset ID field exists in the F0911Z1,
but does not get mapped to in P09110. I mapped the reference 1 field
($LR1) to the Asset ID field in the F0911Z1 (VNASID). Left the program
in place long enough to do the mass upload, then removed the mod. Worked
like a charm. I would think the WW idea would work fine, too.

Hope this helps,
Teri Greene


** High Priority **

Dear List

We are attemping to upload a multi-line Fixed Assets journal into G/L
from spreadsheet to JDE. The problem we are having is that the "Item
Number" field does not appear to be a field you can map using the upload
template (J09110MAP) as the ASII data item is not in the list of
available fields.

Any ideas ?

We are running World A7.3 cum 10 on an AS/400 620 box.

Steve.


++++++++++++++++++++++++++++++
Steven Lawrence
Finance Systems Manager
Coral Eurobet plc
Glebe House, Vicarage Drive,
Barking, Essex, IG11 7NS, UK
Tel: +44 (0)20 8591 5151
Fax: +44 (0)20 8591 8647
website: www.coral.co.uk
e-mail: steven.lawrence@coral.co.uk

++++++++++++++++++++++++++++++




--------------------------
 
Top