Incorrect Opn Ord Pick/Inv Amount in Customer File

Q - In Customer File Maintenance/Inquiry, it shows this customer has an open order in the amount $18,400.00. (See below.)



But in COP Order Inquiry or any open order report, I can't find this amount.  What can cause this to happen?

A - We have seen this situation on occasion when field "76. Opn Ord Pick/Inv Amt" shows incorrect value. The solution is to run a utility to recalculate that number. You can go to A/R -> Processing -> Age Customer Account, answer "Y" to question "6. Set Customer Pic/Inv Amount ?" See sample screen below:

The default value for this flag is "N."  You should age your customer account aging period 1 - 4 on a daily basis; otherwise they will not be useful to you.  Therefore, we suggest that you run "Age Customer Account" every day with this flag set to "Y."  That will kill two birds with one stone.

If you have a deferred processing routine in place to run every night, then you should choose "Y" to flag "7. Print To Report ?" Then this process can be run every night through deferred processing so you don't need to manually run this routine.

EMK

• Related Articles

• Opn Ord Pick/Inv Amt Calculation Issue

  The traditional way of determining a customer's available credit is by using the following calculation: Avail Credit = Credit Limit - Acct Balance A more accurate way is to consider the order amount that has been printed with a pick ticket or ...

• CP0400M Customer Order Processing Order Inquiry

  Inquiry Order Inquiry Application Overview This function gives you fast and easy access to all the necessary information to provide customer service for open or posted orders on file for a customer. It allows you to quickly access and display a ...

• ARCUSMNT Accounts Receivable Customer File Maintenance

  Customer File Maintenance Application Overview The Customer File is a very important file. It stores the basic information about every customer you do business with. Almost every major application in the A/R package uses the Customer file to ensure ...

• I Receive "No Open Item on File" Message When I Try to Reapply Open Credit or Payment in AR

  Q: When I run my AR Aging Report, it shows that we have open items. But we aren't able to reapply some of them. When trying to reapply, users get the error "No Open Item on File." Why is that? A: The most likely reason is because this open credit or ...

• Feature - Calculate Order Total Sales Amount for Open Non-Picked Orders

  Release Date - 2/20/19 This feature gives the user the ability to calculate the Order Total Sales Amount. This ability has been added to the Order Integrity Check utility program. It is available from Global Setup-> Utilities-> COP Utilities-> ...