PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 10/08/2010 12:38 PM by  Jenny Kehr
No Budget Upload?
 4 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Jenny Kehr
Private
Private
Basic Member
(11 points)
Basic Member
Posts:5


Send Message:

--
10/06/2009 5:29 PM
    We're in the process of implementing Lawson 9.0.2.14 (M3) and I am attempting to get the GL current year budget and prior year history loaded.  I am using the GLS850 for the history and thought it would be the same format for budget.  I have been told I have to hand key the budget (5,000 lines) into Lawson using BUS100 because we have FP6 (fix pack 6) and not FP7.  Can this really be true?  I cannot believe it.  Is there any other way to get the GL budget data into Lawson?  PLEASE!  HELP! 
    brainet
    Private
    Private
    Basic Member
    (48 points)
    Basic Member
    Posts:18


    Send Message:

    --
    10/07/2009 3:45 PM
    We always upload a new budget every year. We do that by doing a importdb from a csv file into FBUDBETREL. We then run FB165 and this creates a new budget. We are not on 9.0.2 yet but are running 9.0.0 apps and enviroment.
    John Henley
    Private
    Private
    Senior Member
    (9629 points)
    Senior Member
    Posts:3227


    Send Message:

    --
    10/08/2009 7:32 AM
    Posted By Jenny Kehr on 10/06/2009 05:29 PM
    We're in the process of implementing Lawson 9.0.2.14 (M3) 


    She's referring to M3, not S3...so FB165 is not applicable...

    Thanks for using the LawsonGuru.com forums!
    John
    Mallikarjuna Ponde
    Private
    Private
    Basic Member
    (18 points)
    Basic Member
    Posts:10


    Send Message:

    --
    02/11/2010 5:39 AM

     

    Dear Jenny,

    Good Afternoon.

    Yeah, you can upload budget using .csv file from program BUS100/E (Import Budget) to BUS101/B1 (Blank Budget Created for import) to BUS150/E (Import transfer Template) there you will find doc name (i.e .csv file for budget upload) Folder name (i.e folder path where you have save your .csv file)

    I hope this will give a thought.

    have a great day ahead.

    Thanks & Regards

    Mallikarjuna Ponde

    Lawson M3 - Finance Consultant
    Jenny Kehr
    Private
    Private
    Basic Member
    (11 points)
    Basic Member
    Posts:5


    Send Message:

    --
    10/08/2010 12:38 PM

    Thank you so much. I have my .csv file ready to go but, when I load it...it isn't loading correctly. I have extra characters loading into the DIM1 field, it duplicates the first digit 4 times in front of the account and drops the last character. Strangely, all of my other fields are in their proper places. Do I need to do some special formatting or something? I'm using Excel 7 and then saving it as a .csv file.
    Jenny
    You are not authorized to post a reply.

    Forums Financial Management Lawson M3 Financials