Opn Ord Pick/Inv Amt Calculation Issue

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 invoice, since that amount will soon become part of the  Acct Balance.  In Global Setup -> cop-Ctl -> Credit Check & Release, you'll find the following flag:
    9. Include Pic/Inv Amount In Credit Check



If this flag is set to "Y," then the Avail Credit is calculated as:
    Avail Credit = Credit Limit - Acct Balance - Pick/Inv Amt
...where Pick/Inv Amt comes from field "76. Open Ord Pic/Inv Amt," as in the next example.



There is a utility in A/R -> Processing -> Age Customer Accounts, where the user may answer "Y" to "6. Set Customer Pic/Inv Amount?"  This will cause the utility to recalculate "76. Open Ord Pick/Inv Amt" in the customer file.

Recently, there was a report that in some situations the pick ticket amount is calculated incorrectly.  In this scenario, a particular order has two line items, but only one line was printed on the pick ticket due to a different promise date existing for each of these two line items.  The field "76. Opn Ord Pick/Inv Amt" was updated correctly when the pick ticket was printed.  However, when the "Age Customer Accounts" utility was run, both line items on the pick ticket were included.  This scenario is confirmed and considered to be a limitation of the utility.

The main reason we have this limitation is because when the system tries to recalculate the pick ticket amount, there is no clear indication which line item was on the pick ticket and which one was not.  Luckily, this limitation is usually not a problem because once a pick ticket is printed, it should be processed for billing selection, invoice printing and posting.  As long as the utility is run after billing selection, invoice printing or posting, this should not be an issue.  We typically suggest that users run "Age Customer Accounts" overnight using the deferred processing feature after invoice posting, so this will not be a problem.
 





    • Related Articles

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

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

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

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

    • Avg Days Pay YTD in Customer File Calculation Issue

      It is a known issue that the "Avg Days Pay YTD" field in the customer file may not be correct. There are various reasons for the average days pay not to calculate correctly. One reason is that this field, as it was originally designed, does not ...