Sage 100

 View Only
Expand all | Collapse all

I am trying to create an import to reverse AP chec

Jane Cavanaugh

Jane Cavanaugh02-04-2016 12:01

Jane Cavanaugh

Jane Cavanaugh02-04-2016 14:27

Jane Cavanaugh

Jane Cavanaugh02-04-2016 15:18

  • 1.  I am trying to create an import to reverse AP chec

    Posted 02-04-2016 10:32
    I am trying to create an import to reverse AP checks. How do I get the import the answer to the question ""Do you want to recall original invoices? I need the answer to be yes. TIA.


  • 2.  RE: I am trying to create an import to reverse AP chec

    Posted 02-04-2016 10:41
    Populate the InvoiceNo, InvoiceDate, InvoiceAmt (negative amount) fields in AP_ManualCheckDetail


  • 3.  RE: I am trying to create an import to reverse AP chec

    Posted 02-04-2016 10:49
    That is what I was hoping not to have to do by being able to answer the question! But thank you.


  • 4.  RE: I am trying to create an import to reverse AP chec

    Posted 02-04-2016 11:09
    Here is a thread to my issue a year ago. https://90minds-com.socialcast.com/messages/22327827?ref=stream Doesn't appear to be an EASY way.....


  • 5.  RE: I am trying to create an import to reverse AP chec

    Posted 02-04-2016 12:01
    Thanks Jeff.


  • 6.  RE: I am trying to create an import to reverse AP chec

    Posted 02-04-2016 12:27
    I think you'd always have to provide details, as it's possible to cut same check # to multiple vendors, and you'd have to specify which vendor's check you're trying to reverse.


  • 7.  RE: I am trying to create an import to reverse AP chec

    Posted 02-04-2016 14:23
    I defined everything for the header file but was hoping not to have to do the detail file. I am recalling invoices and when you recall in Manual Check Entry and reply Yes, the program adds all the invoices to the detail record.


  • 8.  RE: I am trying to create an import to reverse AP chec

    Posted 02-04-2016 14:24
    That would be a nice (and easy enhancement) for Sage. Too bad snowballs have better chances in hell...


  • 9.  RE: I am trying to create an import to reverse AP chec

    Posted 02-04-2016 14:27
    Sad, but true.


  • 10.  RE: I am trying to create an import to reverse AP chec

    Posted 02-04-2016 14:56
    The program prompts for a ""yes"" to recall original invoices. If the response is yes then the program populates the fields for you. The ""yes"" data is a variable used only in memory and used by the program. The ""yes"" data isn't written to a table. It would be nice if Sage had the foresight to allow the user to assign a ""yes"" in the VI program so the business object would populate the fields for you. Dreamer, were nothing but a dreamer (Supertramp).


  • 11.  RE: I am trying to create an import to reverse AP chec

    Posted 02-04-2016 15:14
    Do you get the prompt in the VI job? I'm not getting it.


  • 12.  RE: I am trying to create an import to reverse AP chec

    Posted 02-04-2016 15:16
    No, sorry for the unclear communication. I am referring to the prompt in manual check entry. I was trying to explain why the prompt isn't available in VI.


  • 13.  RE: I am trying to create an import to reverse AP chec

    Posted 02-04-2016 15:17
    You had me after ""It would be nice if Sage""......


  • 14.  RE: I am trying to create an import to reverse AP chec

    Posted 02-04-2016 15:18
    Sorry - I'm a little dense these days!


  • 15.  RE: I am trying to create an import to reverse AP chec

    Posted 02-05-2016 09:11
    Wonder if perform logic can help here. Have you tried contacting Sage? Sometimes they give me PL for these workarounds.