Prev
Next
Forums Financial Management Lawson S3 Financials

Budget Upload

 10 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
jjcyeshua
Veteran Member
Posts: 49
Veteran Member
5/9/2007 11:10 PM
    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
    Posts: 3353
    5/10/2007 12:00 AM
      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
      Posts: 49
      Veteran Member
      5/10/2007 2:56 PM
        Thanks again John.....
        Karl Kemp
        Basic Member
        Posts: 20
        Basic Member
        5/10/2007 7:55 PM
          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
          Posts: 49
          Veteran Member
          5/10/2007 10:02 PM
            Could you?.... i would really appreciate it... here's my email "JOrana@laup.net" .. Thank you so much Karl....
            k-rock
            Veteran Member
            Posts: 142
            Veteran Member
            5/21/2007 4:41 PM
              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
              Posts: 49
              Veteran Member
              5/21/2007 6:35 PM
                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
                Posts: 142
                Veteran Member
                5/22/2007 1:33 PM
                  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
                  Posts: 3353
                  5/22/2007 1:47 PM
                    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
                    Posts: 1
                    New Member
                    3/14/2013 3:02 PM
                      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
                      Posts: 1
                      New Member
                      1/7/2014 9:13 PM
                        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.