Purchase invoices going to incorrect supply ominal code

Hi All

Has anyone experienced or have any ideas re the following:

End user ran PL Transfer as part of month end procedure for August, on checking it found around 40 transactions that have gone to the wrong nominal code. They are all from purchase invoices matched to purchase orders within pop and would have been different supply codes (supply codes for stock are not the same as the nominal code but linked correctly). Where they have gone wrong they have all ended up in the same nominal code

The analysis of the purchase invoice shows the incorrect coding, tracking back to the original order they still show the correct supply code - although if you change at the time of raising the invoice it doesn't change the order but the user is adamant she never changes as they are correct from the stock record

They were upgraded to 2.81.60 around 23rd July but the remainder of July invoices posted after this were all correct. It wasn't picked up until part way into September when doing August month end. Have started September and we've checked the transfer file and the same thing is happening

We can't recreate off site

Kerry

Find more posts tagged with

Accepted answers

All comments

Legacy Contributor

Hi Kerry, They may have a default supply code set against the Purchase Account under analysis. If you create a PO and select a stock item, it does pick up the code from the item. However when you come to match the invoice it defaults to the one set against the Purchase Ledger account.

kerryh

Hi Mark

Many Thanks for the update

I have tested this on demodata and can't replicate the problem if there is a supply code against the supplier. I've raised a PO with multiple lines all going to different supply codes to the one set on the supplier and when the invoice has been posted it has held these codes and not used the one on the supplier at all

Have rechecked the customer data and they have a mix of suppliers with and without supply code and the problem has arisen whether there is a supply code or not, sometimes there are multiple lines and just one has gone to the incorrect supply code

We have tried the registry amendment which has previously fixed a variety of problems within Opera to see if this made a difference but on checking a few days later it has still happened

It is always the same supply code being used when it goes wrong and as there are no default codes set the only place this stands out is the first stock record when going into processing has this code set against it

Kind Regards

Kerry

richardd

Hi Kerry, is the supply code the first of last one by any chance? Check for blank records and run a UDS re-building the indexes logged in as ADMIN. This rebuilds the indexes and fixes any ID number issues. Assume you've asked Pegasus, had a strange issue recently with Opera not finding stock serial number which Pegasus knew about surprisingly

kerryh

Hi Richard

No, there are a number of supply codes and about a third of the way in. Also checked various tables to see if anything odd there such as blank lines

Have logged with Pegasus who have asked if we have tested off site and to send the data in with steps to replicate, but I can't replicate to see what may be going wrong

UDS and re-index worth a shot on site, will try this

Many Thanks

Kerry

Legacy Contributor

Are any Cost Codes used with the N/L account associated with the Supply Code? I've certainly seen transactions go to a suspense account if the appropriate N/L+CC account doesn't exist.

kerryh

Cost Centres not enabled on the system

Kind Regards

Kerry

Copyright © 2025 Infor. All rights reserved.