Transaction Import Receipt/Invoice Screen

(0) Share

Report

Posted on by Mark Schurmann

I am working on an Transaction Import for the Receipt/Invoice Screen in the PO module. It largely works except for one glitch: the Duplicate Invoice screen pops and leaves the import in a suspended state. This should happen when an invoice number is entered on the Invoice Information screen and the invoice number entered matches one previously entered for the vendor. In this case however, none of the invoice numbers are duplicates. I've tried it several times with very unique invoice numbers and the Duplicate Invoice screen always pops.

Interestingly, the import seems to work. No matter how many documents I have in the data file, all are created by the transaction import, but it will not complete because of the Duplicate Invoice dialog. This indicates that it always happens on the last document record regardless of the invoice number.

Any suggestions on how to resolve this?

*This post is locked for comments

All responses (4)

Answers (0)

Mark Schurmann on at

Like (0)

Report

Re: Re: Transaction Import Receipt/Invoice Screen

No. I receive no errors, however the import seems a bit unstable and will sometimes throw errors for fields like Lot/Serial Nbr that don't even matter.
George Sagen 1,005 on at

Like (0)

Report

Re: Transaction Import Receipt/Invoice Screen

Any clues in the Log file?
Mark Schurmann on at

Like (0)

Report

Re: Re: Transaction Import Receipt/Invoice Screen

Yes, I did try adding a button push at the end. I then get a vb error.

I am using change mode and it seems to work fine. I am afraid I can't give you much advise here because I only have one row in the detail so I haven't encountered a problem advancing within the table.

Thanks for the reply.

Mark
Community Member Microsoft Employee on at

Like (0)

Report

Re: Transaction Import Receipt/Invoice Screen

Hi Mark,

Have you tried to put a Button press code in your TI control file, right after invoice number import line?

Also, I have a question for you, have you tried this screen TI in a Change mode, I mean to edit existing records?

Because what I have is a problem of navigating through the grid.