PO Invoice Import

[iwells]

Hi,

I can't see an "Import" option for Invoices in the PO module. I see on older posts that doesn't appear to by a system functionality and wanted to confirm with others that it doesn't exist in versions after 5.6?

 

[ettienne]

Import them under PO Receipts - you apply the invoice to the receipt.

 

[iwells]

I'm trying to get this working, without much luck at the moment, but I just want to make sure I clearly described what I'm trying to do.

I have existing RCPs that might have been in the system for anywhere from 1 day to 1 year and I want to import an invoice against them ... that's what you're describing?

I've found where to import the record at the moment, but I'm getting an error message stating the record already exists.

(Description: Receipt. Record already exists.
Source: 16:13:27)

I'll play around with fields and see what I'm missing, but it doesn't appear to be updating and on the import screen I'm only getting the "Insert" option when I had assumed it would be update.

Keep in mind I'm still learning the system ... 4 months on the job ... getting better but still far from a pro.

Ian

 

[ettienne]

Sorry you can't do that - you can only insert new receipts, not update existing receipts.
If you were importing new receipts then sure, that will work.
Write a macro.

 

[iwells]

Darn ... the issue is we have offices where we have lots of receipts that aren't invoiced, they go to a clearing account, but they want the invoices removed off the report. Well to do that: 1) we need to automate a way they can select receipts, have invoices and reversing entries created or 2) they can do.

Guess which way it has been decided ... Any thoughts on a way to do this without a Macro/VB?

 

[iwells]

I guess the reason it has been assigned to us is because they leave it go so long ... for example a branch I'm examining now has 300+ PO receipts not invoiced (we call it PORNI) and we need those receipts closed and reversed out of POAAPC.

 

[ettienne]

How to without VBA: PO Transactions, Invoice Entry... start entering invoices. Life is tough, employ a temp to do it.
Otherwise write a macro or pay someone to write a macro.
There's only one way to get those receipts cleared and off the report, and that's by matching an invoice against it.