Sage 100

 View Only
  • 1.  Has anyone written a VI import for JC Billing Entr

    Posted 05-24-2017 21:40
    Has anyone written a VI import for JC Billing Entry? (Sage 100 2015) Since it is not in the new framework, it seems to me it will need a script to pull in and complete all the required fields. The client does simple percent compete billing so entry is very limited. TIA.


  • 2.  RE: Has anyone written a VI import for JC Billing Entr

    Posted 05-24-2017 22:35
      |   view attached
    Attached is a VI job in import format for record type 1 (costs). It can be easily modified for billings (record type 2) by changing the transaction type to ""2"" and swapping the cost and units fields for the billing field.

    Attachment(s)

    EXP
    JobCostPosting_JC6_JC7.EXP   90 KB 1 version


  • 3.  RE: Has anyone written a VI import for JC Billing Entr

    Posted 05-25-2017 06:56
    Thanks @DougHiggs will test it today.