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 ...

• 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 ...

• CP0200 Customer Order Processing Print Pick/Pack Tickets and Ship Labels

  Print Pick/Pack Tickets & Ship Labels Application Overview Picking Tickets are documents that list all the items in the order that are eligible to be taken from stock (picked) and shipped from a particular warehouse. These items are listed in order ...

• Common Reasons Why Pick Ticket Does Not Print

  A - When I try to print a pick ticket, I keep on getting the message "Nothing in Range." I know the order number I specified is correct, and I can't find any reason why the pick ticket does not print. Please help. Q - In additional to the more ...

• An Example of Debugging NOTE_ORD_VIEW PSQL Expression Evaluation Error

  Q - When I try to access the NOTE_ORD_VIEW in the PSQL control center, I get this error: "[LNA][Pervasive][ODBC Engine Interface]Expression evaluation error." See sample screen below. It does not display any results, but it does display the create ...