Customer Summary On Order Amount (onordamt)

(0) Share

Report

Posted on by Community Member

Customer Summary On Order Amount (onordamt), We have some funny numbers is this field, negatives for example or a number that doesn't seem to match anything. We have run the customer reconcile and it fixed some but not all. Does anyone know what the source of this field is, what is being summed to populated it during a reconcile or what it tallys under normal circumstances? Thank you

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Community Member on at

Like (0)

Report

RE: Customer Summary On Order Amount (onordamt)

NancyCoss, On Order Amount is the sum of all the sales order amount in the system. Can you cross check with sales order processing document inquiry window for that particular customer (Sales >> Inquiry >> Sales Documents), by selecting order in the document filter as "by document type". Do you have any integrations in place?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Customer Summary On Order Amount (onordamt)

We did import some sales orders which seems to be the problem, the remaining amount keeps going negative, which in turn messes up the summary amount in on order amount. I feel that during the import of the sales orders something was not set, other the the sop10100 and sop10200 do you know of any other table that gets populated when a sales order is put in? I've compared records in sop10100 and sop10200 which behave properly against those that don't (the ones I imported) and cannot find any differences which is why I thought there might be another table. Thanks for any thoughts you have on this. Nancy

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,619 Super User 2025 Season 2 on at

Like (0)

Report

RE: Customer Summary On Order Amount (onordamt)

Nancy, what are you using to import orders? The ONORDAMT is a column in the RM00103 table that gets updated when a new order is entered and saved. Perhaps your integration is bypassing the logic that updates this field.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Customer Summary On Order Amount (onordamt)

Just SQL insert, I think you are right however I have since or thought I have fixed this by resetting the Remamount on the sales order itself, then I reconcile the customer which sets the onoramt correctly but what keeps happening it the remamt on the sales order keeps going neg (and it turn messes up the onordamt when they do something on these orders), and it goes negative by the amount that has been fulfill/sent/processed whatever you call it so it seems to keep starting from zero and subtracting, that is why I keep thinking there is another field to set/consider in the import or at least in my 'fixing'. Maybe I'm misunderstanding how it is all linked together, I'd like to get it resolved finally but if I have to keep 'resetting' everything til these orders finish, but of course would like to learn what I did wrong to begin with. Any additional thoughts?

Was this reply helpful? Yes No
Suggested answer

Frank Hamelly | MVP... 46,619 Super User 2025 Season 2 on at

Like (0)

Report

RE: Customer Summary On Order Amount (onordamt)

SQL Insert is bypassing ALL logic related to entering Sales Orders. You should look at using Integration Manager, eConnect, or some other integration tool to do this.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Customer Summary On Order Amount (onordamt)

Nancy, I suggest not to direct SQL insert into tables for GP. You may need to look into GP SDK for additional tables structures and information. you can also look into integration tools as suggested by Frank for you integration purpose.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Customer Summary On Order Amount (onordamt)

Yes seems so, I certainly will not do this again. Do you think I can 'fix' it or will just have to deal with the consequences til these orders naturally finish up?

Was this reply helpful? Yes No
Suggested answer

Bill Campbell 12 on at

Like (0)

Report

RE: Customer Summary On Order Amount (onordamt)

Nancy is there any reason that you are not using Integration Manager to bring in the Sales Transactions?

Are these going to be ongoing SOP transactions or is this a one time or short time event?

In Franks note he mentions the logic that you might be bypassing - it is that reason I suggest you look at using the Integration Manager tool. It knows all the logic and when it enters the data, all the correct points are touched and updated.

If you are not familar with IM - you might want to reach out to the partner and get more details, it is a great tool.

Hope this helps

Was this reply helpful? Yes No
Suggested answer

Frank Hamelly | MVP... 46,619 Super User 2025 Season 2 on at

Like (0)

Report

RE: Customer Summary On Order Amount (onordamt)

You should be able to fix it. The question is, is it worth the time it might require to do so? Depends on how many orders you've inserted and over what time period.

Was this reply helpful? Yes No