Sage 100

 View Only

  • 1.  4.5 VI Import into A/P Invoice Data Entry - out-of

    Posted 07-24-2012 11:55
    4.5 VI Import into A/P Invoice Data Entry - out-of-balance invoices With 4.5, it appears that out-of-balance invoices now ""fail"" during the import, whereas in 4.30 they would still be imported. Has anyone else come across this? Apparently the client's source data ($$) will sometimes go past 2 decimal places.


  • 2.  RE: 4.5 VI Import into A/P Invoice Data Entry - out-of

    Posted 07-24-2012 12:15
    I know of a GL journal import that now requires the Accept Out of Balance Entries field to be set to Yes in order for out of balance entries to not fail but I don't think there's anything like that in AP - sorry!


  • 3.  RE: 4.5 VI Import into A/P Invoice Data Entry - out-of

    Posted 07-24-2012 12:19
    Well, you could import the distribution amount into a temp field and then do a PRC formula on the temp field so that it rounds properly to two decimals. Unfortunately, this still may not help when adding the distribution lines to the header total. You may also suggest to the client that they clean up their source data..................


  • 4.  RE: 4.5 VI Import into A/P Invoice Data Entry - out-of

    Posted 07-24-2012 14:08
    Thought that might be a possibility, @JeffSchwenk, but had the same thought about possibly still having an issue with the sum of the lines not equalling the header/invoice amount. Ideally I'd like them to fix their ongoing source data file.


  • 5.  RE: 4.5 VI Import into A/P Invoice Data Entry - out-of

    Posted 07-24-2012 14:25
    Best bet is to clean the data. Any idea why it is exporting more than two decimals? Try the PRC formula. It won't hurt. It may actually help.


Related Content