Check they're not Inactive in PL / Purchase Accounts / Amend Account Status

Hi Geoff,

Yes, they are active in Purchase Ledger/Purchase Accounts/Amend Account Status

I have now managed to find them but only if I scroll up the list - they don't appear when scrolling down!?!

Thank you for your help

Guy

That's really weird!  Are they just alpha-numeric account codes or do they have other characters? Are you entering the 1st char or anything, and using F4, the "down arrow" button or just tab to get the list? And does a similar thing happen if you look up using the short name?

Finally are you automatically generating supplier numbers?

Has the site got customisation present? it is possible that the supplier table has been extended & there's som missing records in the corresponding 'X' table, or possible some customisation has been made the the supplier lookup to restrict displayed records

No, as far as I know there is no customisation

I think I'd be inclined to run the SQL profiler t see what Sage is asking for when the Supplier list is called, then run the profiler again then you use the supplier lookup. That'll give you the SQL request & from that you can work out why the expected data isn't being returned, i.e. some missing related data. That's quite a lengthy task do though. I take it you have tried checking the database, rebuilding the indexes just incase it's something related to that?

Database?  Nobody told me anything about a database!

Unless you are using Sage 200 Standard or the Education variant I'd suggest talking to your business partner