National Account w/ thousands of customers...?

Hi, 

We are having a big issue in which we are receiving thousands of transactions from website customers from different sites including amazon.com. One problem is that every transaction is creating a new customer number, so we are receiving thousands of order on a monthly basis. These transactions thaa are auto generated in our system as SO and later posted and made into invoices, seems to be working fine until now.

One BIG problem comes with we try to apply the payments to these invoices, there are too many and is taking our department forever to catch up with all of these transactions.

(Currently, our department is applying the cash receipts individually to each customers; imagine that? it's taking the whole month just to apply the cash receipts to each customers)

In an effort to correct the problem, I created a National account in which we can apply all the payments (as one BIG payment) directly to the Parent customer (ex. AMAZON Orders), the  problem STILL is that there are TOO many (I'm talking about thousands and thousands) child customers to be entered under the Parent customer and everytime and order comes in, it creates a new customer regardless if the customer purchased before.

Creating the National account helps just a little bit, as we now just need to add the child customers to the Parent customer, but it's still thousands of customers on a daily basis and to make things worse, the system recreate each customer as NEW even when the customers had purchased before...CRAZY!

Can anyone suggest us anything to help us here, that will be really appreciatted. Oh, we are under 7.4 for now....comtemplating switching to INFOR LX.

I hope I explained the issue clear enough.

Thanks in advance.

  • 0
    Hi Teo,

    Can you provide more information on the type of transactions you are importing into Sage 500 and what you are using to create them? Are you using standard Sage 500 Data Migrator processes or something else? Are you using a standard Sage 500 eCommerce solution or add-in such as from RKL, or is this something created internally?

    Based on your post, this sounds like something you should be working with your reseller to try and correct. If your reseller is not an authorized Sage 500 Developer partner, they can reach out to us at E2b Teknologies (http://e2btek.com/) for assistance or any of the other Sage 500 development partners available with experience in building integrations to Sage 500.