Sage 100

 View Only

  • 1.  VI import to A/P invoice with Jobs

    Posted 04-29-2020 14:02
    ​​I'm trying to create a VI import for AP invoices with Job Cost involved. Everything is working EXCEPT I am not able to pull the G/L Account related to the Job using File Assign. It let's me set it up, but no data is retrieved. The expense accounts are not in the Cost Code Detail table. I need to pull them from JC_JobTypeWIPAccounts. The data file has the job number and the cost code, and I am successfully retrieving the cost type with File Assign. I just can't find a way to get the G/L account to come in, even though it seems like all the pieces of the record key are accounted for. I don't have too many people using Job Cost, so I'm less familiar with the underlying data involved. Has anyone tackled this before?
    Thanks in advance!

    ------------------------------
    Kathryn White
    Schneider Downs & Co., Inc.
    Pittsburgh PA
    ------------------------------


  • 2.  RE: VI import to A/P invoice with Jobs

    Posted 04-30-2020 00:16
    Try using a calculated field and select the account field from the linked table list.
    Can't remember specifically which import i encountered a while back but it behaved the same way, file assign would fail but switching to calculated worked.

    ------------------------------
    David Speck II
    Tennessee Software Solutions
    ------------------------------



  • 3.  RE: VI import to A/P invoice with Jobs

    Posted 05-05-2020 16:33
    I was able to test this with the client today, and it seems to mostly work. Oddly, the VI log says that the lines passed with invalid fields and shows the G/L Account is missing/required; but when we go to Invoice Data Entry the correct account is pulling in and all of the information appears complete and accurate. Whereas with File Assign the records were failing outright. Thanks @David Speck II for the new idea!
    ​

    ------------------------------
    Kathryn White
    Schneider Downs & Co., Inc.
    Pittsburgh PA
    ------------------------------

    Original Message


Related Content