Prev
Next
Forums User Experience Lawson Add-Ins for Microsoft Office

Uploading Budgets (FB20.1) using Add-Inns

 7 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages


Saurabh











Veteran Member



Posts: 94




Veteran Member



5/19/2010 10:45 AM
    All
    I am trying to create an upload routine to be allow the end users to Upload the Budget directly.
    Have been able to creat the Budget Header, but when trying to load the Budget detail (simulating FB20.1) keep getting "Field Is Required" errors. Have tried to look for any hidden fields etc but no luck.

    Has anybody tried to upload Budgets using Add-Inns and if so are willing to share/provide tips on same.

    We are on LSF9.0.0.4, 8.1 MSP5 on Win2003R2 with SQL back end.

    Regards
    Saurabh


    Tom Keller











    Advanced Member



    Posts: 42




    Advanced Member



    5/19/2010 12:38 PM
      To find what field is required chose "View the last Upload Query Sent" It is the icon at the top of the upload wizard that looks like a page with a magnifying glass. Copy the and paste the string into an open browser and scroll to the bottom of the code and the required fields will be listed.


      Saurabh











      Veteran Member



      Posts: 94




      Veteran Member



      5/19/2010 1:10 PM
        Hi Tom
        Thanks for the Tip. Wasnt aware of the functionality of that Icon. Will use that to debug the error
        regards
        Saurabh


        Saurabh











        Veteran Member



        Posts: 94




        Veteran Member



        5/20/2010 12:34 PM
          Found the issue using the Tip above.
          Had missed the "Fiscal Year" field for the budget.
          The budget has now loaded.
          Many thanks to everyone who responded
          regards
          Saurabh


          Tom Keller











          Advanced Member



          Posts: 42




          Advanced Member



          5/20/2010 12:38 PM
            WooHoo


            TDB











            New Member



            Posts: 2




            New Member



            1/9/2012 8:26 PM
              Hi,
              I am having a similar problem.  This is the string that I am having trouble with


              Transaction/Erp?_PDL=PROD&_TKN=AM30.1&_EVT=ADD&_RTN=DATA&_TDS=IGNORE&FC=Add&_ADDINS=TRUE&_f1=A&_f5=40571&_f10=&_f13=&_f14=F&_f39=200&_f43=&_f44=&_f45=200%2D155&_f47=&_f48=&_f49=&_f50=200%2D01&_f72=FF%2DAND%2DE&_f73=DOCK%20TRK&_f75=STANDARD&_f77=121550001&_f79=12155&_OUT=XML&_EOT=TRUE

              From what you posted previously would I be correct in saying that everytime there is an '&' symbol it is signifying another required field?  And if this is true then does that mean that my upload will not work unless all of these fields are filled in with some sort of values?
              Thanks



              Saurabh











              Veteran Member



              Posts: 94




              Veteran Member



              1/10/2012 8:44 AM
                You will need all the mandatory fields to be in the upload string. Its possible you are missing a field which is causing your script to fail.


                Lorraine











                Basic Member



                Posts: 4




                Basic Member



                1/16/2014 4:19 PM
                  HI we are also trying to do the same thing but stumbling at the uwf file because there are insufficient fields for the amount of columns I need! How do we add extra fields on an addin generally? Have tried to google this so far to no avail...