Hi,
I was running a view and under Doc Key received an expected result:
1POxxxxxxxx
2RCxxxxxxxx
4AJxxxxxxxx
and then got 4RCxxxxxxxx which was unexpected. I thought the first number was the document type number and then the next two were the actual kind of document. Why would there be 4RC when 4 normally is invoices and adjustments? I had a quick look at the Data Flow and didn't notice anything.
Thanks

Hi Mike,

I think you're going to have to tell us what table you were working with. There are a lot of them in Adagio!

Hi Mike,

The first digit is the document type (which is an invoice or adjustment, as you correctly indicated). The rest is the document number - does this have the same 'RC' number. When posting any PO document, you can over-ride any part of the number, including the prefix. Thus it is possible to have posted an invoice with any characters in the document.

Ensure that the company setup didn't get acidentally changed (Order receipts defaults) - not likely but have to check everything.

We're not aware of any reasons why the wrong document number/prefix would have been applied to an invoice.

Andrew
The table was I/R Details Master.

The PO was one of the first we did so it is possible that the prefix was changed manually - most likely scenario. I won't worry about it then.

Thanks

Mike:

A document type 4AJ (Ajustment/Invoice)is just the 4RC (Receipt) converted from a Delivery Note to an Invoice.