Sage 100

 View Only
  • 1.  I'm trying to set up a UDF in SO invoice data entr

    Posted 12-17-2014 18:18
      |   view attached
    I'm trying to set up a UDF in SO invoice data entry - detail, not header - to flow it through to invoice history. I already set it up in SO entry and it works fine. When I try to add it to the invoice table, I don't see the SO detail table to pull from. I get the same results in Sage 2013 and Sage 2014 and on my system and theirs. What am I missing?


  • 2.  RE: I'm trying to set up a UDF in SO invoice data entr

    Posted 12-17-2014 18:21
    I think once you set it up with what appears, you can go into the edit mode and add the line so invoice. I know it is something weird and counter intuitive but it is doable.


  • 3.  RE: I'm trying to set up a UDF in SO invoice data entr

    Posted 12-17-2014 18:21
    Select 'Item Code' as the data table and see if the UDF shows in the Column dropdown (at the bottom)


  • 4.  RE: I'm trying to set up a UDF in SO invoice data entr

    Posted 12-17-2014 18:25
      |   view attached
    Set it to manual instead of business object, then go to the data sources tab.


  • 5.  RE: I'm trying to set up a UDF in SO invoice data entr

    Posted 12-17-2014 18:27
    There it is. How to get to the data sources tab....


  • 6.  RE: I'm trying to set up a UDF in SO invoice data entr

    Posted 12-17-2014 18:28
    I believe you need to setup the uDF in the transaction psoting table first, and then to the SO_InvoiceDetail


  • 7.  RE: I'm trying to set up a UDF in SO invoice data entr

    Posted 12-17-2014 18:29
    Transaction posting table is the step between invoice entry and invoice history.


  • 8.  RE: I'm trying to set up a UDF in SO invoice data entr

    Posted 12-17-2014 18:31
    Setting it to manual was the trick. Thanks, Phil!


  • 9.  RE: I'm trying to set up a UDF in SO invoice data entr

    Posted 12-18-2014 07:43
    Just an FYI for anyone else - you only have to put HEADER UDFs in the Transaction Posting file. Details can go straight through. Because consistency is NOT our name.


  • 10.  RE: I'm trying to set up a UDF in SO invoice data entr

    Posted 12-18-2014 19:39
    Consistency?? What is that??? Do you mean the right hand knows what the left is doing??