Prev
Next
Forums Financial Management Lawson M3 Financials

No Budget Upload?

 4 Replies
 0 Subscribed to this topic
 3 Subscribed to this forum
Sort:
Author
Messages
Jenny Kehr
Basic Member Send Private Message
Posts: 5
Basic Member
10/6/2009 9: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
Basic Member Send Private Message
Posts: 18
Basic Member
10/7/2009 7: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
Send Private Message
Posts: 3353
10/8/2009 11: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
Basic Member Send Private Message
Posts: 10
Basic Member
2/11/2010 10: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
Basic Member Send Private Message
Posts: 5
Basic Member
10/8/2010 4: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