Sage 100

 View Only
  • 1.  Before I start asking why this isn't working as ex

    Posted 02-11-2016 06:13
    Before I start asking why this isn't working as expected, maybe I need to ask: Can it be done? Trying to pass a UDF from AP Invoice Line and write it to GL_DetailPosting. It looks like everything is set up in Custom Office, but the values for the UDF are consistently inaccurate on the GL side. I'm not seeing a clean link from AP Invoice History Detail to GL History if the invoice is posted in detail (not summary) with multiple lines to the same GL account for the same amount on a single invoice. Am I just missing it?


  • 2.  RE: Before I start asking why this isn't working as ex

    Posted 02-11-2016 06:28
    Well, I WAS going to say of course it can until I read the part about posting in summary. Now I don't know. I tend to lean toward doubting it now. Really depends on how the summarization works. One would think that it would record the value of the last UDF read. Are you trying to summarize the values of the UDF? I know the values pass properly when posting by detail. I use it to track entries with a UDF that stores client company codes which allows me to track profitability by client in the gL


  • 3.  RE: Before I start asking why this isn't working as ex

    Posted 02-12-2016 06:05
      |   view attached
    Thanks for the thoughts, Jeff. They are posting in detail, but where the GL account key and dollar amount are the same on the lines for a single invoice the UDF values are coming through inaccurately. I've attached an example invoice where just under 50% of the UDF values made it properly into GL_DetailPosting. Let it be known that there is a third-party add-on in the posting mix. They have DSD's multi-company for AP. I wouldn't think this would be the culprit, but maybe?

    Attachment(s)

    xlsx
    UDF.xlsx   10 KB 1 version