Sage 100

Any anyone been asked or know where I can start with a VI import into cash receipts using the PO number instead of the invoice number on the detail record?

The CSV file has PO number, not invoice number. We had been doing a vlookup in Excel to return the Sage invoice number, but this has become time consuming and open/ closing Excel is opening up the possibility of data corruption.

As anyone done anything in VI or C/O scripting that would take the PO number and return the actual Sage invoice number?

Thank you,
Michael

------------------------------
Michael Davis
Warren Averett Technology Group
Birmingham, AL
------------------------------

I'm working on something similar (finding invoice# from an SO#)... using a VBScript and ODBC for the lookup to create a NEW file, with the lookup value.


------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

@Marcos DeLuna helped me do that quite a few versions ago​

------------------------------
Beth Bowers
Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
Beth Bowers
269-445-1625
------------------------------

Thanks, @Beth Bowers.  @Michael Davis  I created PERFORM logic like Beth mentioned that will search the AR_OPENINVOICE table by PO# to get the customer invoice number.  I have also written a Cash Receipt V/I job that will create the ​​deposit, customer, header, and detail records all at once.  Normally, you would have to create a couple of jobs to do it.  I'm booked the rest of the week but if you want we can discuss more on Monday.

------------------------------
Marcos DeLuna
Deluna Consulting
------------------------------