Budget Upload

 10 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
jjcyeshua
Veteran Member Send Private Message
Posts: 49
Veteran Member
Hello!... lawson people.... I'm in the process of uploading a budget from excel spreadsheet to FBDETAIL, but i can't seem to find the form that would let me add new budget. Knowledge Search in Lawson.com says that i have to use budget interface to convert the new budget data that i have, but when i access FB165 its only generating report. Where should i start the process of uploading the budget and how?.. Thanks again in advance
John Henley
Send Private Message
Posts: 3351
You can enter the budget "online" via FB20. If you want to upload, you need to get your budget data into FBUDGETREL. To do that you have several options: - import via SQL - importdb from CSV file - upload via Excel addins to FB65 - enter directly via FB65 Once you have the data into FBUDGETREL, you can use FB165 to load it into FBDETAIL.
Thanks for using the LawsonGuru.com forums!
John
jjcyeshua
Veteran Member Send Private Message
Posts: 49
Veteran Member
Thanks again John.....
Karl Kemp
Basic Member Send Private Message
Posts: 20
Basic Member
I did that a few months ago and it was pretty easy. If you need any help let me know and I'll share my notes with you.
jjcyeshua
Veteran Member Send Private Message
Posts: 49
Veteran Member
Could you?.... i would really appreciate it... here's my email "JOrana@laup.net" .. Thank you so much Karl....
k-rock
Veteran Member Send Private Message
Posts: 142
Veteran Member
If you guys are still looking into this, I have a template that I built in Excel that can be used with FBUDGETREL.
jjcyeshua
Veteran Member Send Private Message
Posts: 49
Veteran Member
Hi! Kelly.... yes I need all the help that i could get. Is it possible for you to forward it to me.. Thanks.. my email is jorana@laup.net
thank you!!!!
k-rock
Veteran Member Send Private Message
Posts: 142
Veteran Member
I sent it to you. For anybody else that wants it, I'm posting it in the Source Exchange at www.lgug.net along with instructions.
John Henley
Send Private Message
Posts: 3351
You can also post here if you'd like by attaching it to this message.
Use the 'reply' feature (not the 'quick reply' at the bottom of the topic).
Thanks for using the LawsonGuru.com forums!
John
Dawn
New Member Send Private Message
Posts: 1
New Member
Could I get those instructions or can someone point me in the right direction. I couldn't find them posted where it was referred to above. Thanks.
Tester
New Member Send Private Message
Posts: 1
New Member
Hi,..

While trying to upload budget i am getting error as "Accounting unit does not exist" and "budget details does not exist" for number of accounting units. At the same time it is being uploaded for rest of the Accounting units.

On checking it is found that these Accounting units for which query throws errors do exist in system and are active.

Can anyone help me on this.