Sage 100

 View Only
  • 1.  Customer is on Sage 100 Advanced v4.3 -- question

    Posted 09-27-2012 16:59
    Customer is on Sage 100 Advanced v4.3 -- question is Customizing the Invoice Grid in Vendor Inquiry? - would like this grid to display the PO number for the invoice in question. They tell me they looked in Customizer a bit and it's not one of the fields you can add to this grid. Have they overlooked something? If so I'm guessing UDF and scripting but they're probably held back by being on v4.3? Thoughts?


  • 2.  RE: Customer is on Sage 100 Advanced v4.3 -- question

    Posted 09-27-2012 17:14
    I wonder if the same technique Alnoor gave us to add a field to the VI dictionary would work.


  • 3.  RE: Customer is on Sage 100 Advanced v4.3 -- question

    Posted 09-27-2012 17:17
    They ""forgot"" to add many fields to the data dictionaries. John, what is the technique in that Alnoor passed along?


  • 4.  RE: Customer is on Sage 100 Advanced v4.3 -- question

    Posted 09-27-2012 17:27
    In 4.4 you could add it to the AP_OpenInvoice via the PO_ReceiptRegisterUpdt, but since PO isn't in the Business Framework in 4.3...


  • 5.  RE: Customer is on Sage 100 Advanced v4.3 -- question

    Posted 09-27-2012 20:10
    Suggest they get current so they can do MANY things differentl and more efficiently.


  • 6.  RE: Customer is on Sage 100 Advanced v4.3 -- question

    Posted 09-28-2012 08:23
    @JeffSchwenk, I picked it out of a post that @ClarkWalliser commented on. He indicated Alnoor had helped him with it at one point. I searched for the post but could not find it; however, I found my the clip of Clark's notes from the post. I tried it and it worked for me although, I didn't need the third step (DFDM VI0XRF). VI picked it up on it's own. oClark Walliser These are the only notes I have: DFDM MAS90\providex.ddf Lookup by name to find the VI entity to modify - get the key ID. DFDM MAS90\providex.dde Search by Key. Find the field record you want to modify Edit field 20 (15,1) a zero is importable. a 1 is read only. DFDM VI0XRF.SOA (it's what exposes UDFs to V/I Data tab) (I don't know what came after this - I assume to make sure the field you want exists in this file)