How to Automatically Credit Check Order at Time of Pick Ticket

Modified Date: 07/16/20

QWe have some type O orders that we enter and ship off of during the year. For example, we have an order entered as credit card terms and have it set to Hold When Enter Order. The order will go on hold when originally entered and must be released after we receive the credit card payment. We have found that after the order has line items filled, it does not go back on credit hold to be released again. This is a problem if the terms are a prepay method.  We also have the situation where when a partially shipped order is filled before the back order is filled, the second shipment of the order is not put on hold even though it exceeds the credit limit.  How do we handle situations like these?

A - The short answer is we can't automatically perform a credit check when you fill a back order.  But we can check during the pick ticket time.  In the past, Elliott Business Software performed a credit check of an order at the time of order entry and placed the order on hold if necessary.  That may work if you intend to ship that order right away (the same day as you take the order.) But this method does not work well if you intend to ship the order sometime in the future.  The back order process exacerbates the situation.  In between the time of order entry and shipment, you may ship additional orders to customers and they can make additional payments as well. This will affect the account balance and make the credit situation different between the time of order entry and the time of shipping.  

In our view, the universal way to perform credit checking of an order should take place at the time of pick ticket (shipping.)  So new features have been added to Elliott to allow users to set up whether to perform credit checking at the time of order entry or at the time of pick ticket.  We keep the credit checking at time of order entry an option for backward compatibility. In our opinion, performing credit checking at the time of pick ticket is a better method and we recommend it.

Global Setup Flags

If you go to Global Setup -> COP-Ctl -> Credit Check and Release, go to the first field, "1. Auto Hold Order/Warning For Credit Problem?"  The value should be a "Y." Press Enter on that field, and you should see a popup window.  There are two flags that are very important:

  • Check in Order Entry - The possible values are Y, N or W(Warning) 
  • Check in Pick Ticket - The possible values are Y or N 

You currently have the first flag set to “Y” and the second flag set to “N.”  See the screen below. 


If you start to back order for your customers, or if you don't always ship the order right away, then you may consider setting the first flag to “N” or “W” and the second flag to “Y.”  You don’t want to set both flags to “Y” because your credit department won't want to release a customer's order when it is added, and then a few hours later  release it again when it is printed with the pick ticket. Since the salesperson may need to know if the customer has a credit problem during order entry, we introduced the “warning” option during order entry.

The reason you may want to set "Check in Order Entry" to "W" and "Check in Pick Ticket" to "Y" is that when the order is taken, even though the order will not be put on hold, the salesman will be warned if the customer has a credit issue. The salesman can then advise the customer accordingly before the pick ticket is printed.  Of course, you can relieve the salesman from such a duty and have your credit manager talk to the customer about the payment issue.  In that case, you will set "Check in Order Entry" to "N" and "Check in Pick Ticket" to "Y."

Again, performing a credit check at the time of the pick ticket process is a universal solution. This will cover all conditions, such as  if an order is changed later on, partially shipped, and/or any timing issue.

Terms Code Hold Flags

In addition to Global Setup, we also have two similar flags in Terms Code file maintenance. It is possible for certain terms codes (e.g., Credit Card), that you may want to put orders "ALWAYS" on hold.  In the Terms Code, you can find the following two flags: 
     11. Hold When Enter Order
     12. Hold When Pick Ticket
For example, you may want to let the credit department charge the credit card on file when you are ready to ship (printing the pick ticket). If you have such a scenario, then set flag 11 to "N" and flag 12 to “Y.” If you want the credit manager to process the credit card at the time of order entry instead, then you will set flag 11 to "Y" and flag 12 to "N." See sample screen below.


Just to further clarify, for open terms codes like Net 30 or Net 60, it would not make sense to set flag 11 or 12 to "Y." Normally, you will leave flag 11 and 12 in Terms Code as "N."

To summarize the difference of the Terms Code “hold” flag vs. the Global Setup “check” flag, the Terms Code “hold” flag is for “always” warning or holding orders regardless of the credit condition. The Global Setup “check” flag is "conditional" based on the customer's credit condition.  

EMK

Accounts Receivable

  1. ARMENU Accounts Receivable Package Overview
  2. Feature - Elliott AR ACH Processing
  3. How to Automatically Credit Check Order at Time of Pick Ticket
  4. Fine-Tuning Customer File Maintenance Security
  5. I Receive "No Open Item on File" Message When I Try to Reapply Open Credit or Payment in AR
  6. Can I Reapply a Payment to a Different Customer in AR?
  7. AR Aging Report - What's the Difference Between Py and Px Payment Type ?
  8. Avg Days Pay YTD in Customer File Calculation Issue
  9. Opn Ord Pick/Inv Amt Calculation Issue
  10. Auto Assigned Sales Tax Code by State and County
  11. How to Handle Sales Tax for Single Item with Caps Amount
  12. How to Subscribe a Customer Event by Salesman?
  13. Arizona Cities Not in Elliott for Sales Tax Code Auto Assign
  14. AR0111 Accounts Receivable Carrier File Maintenance
  15. AR0112 Accounts Receivable Carrier Mode Maintenance
  16. AR0113 Accounts Receivable Freight Rate File Maintenance
  17. AR0114 Accounts Receivable Freight Zone File Maintenance
  18. AR0120 Accounts Receivable State Table File Maintenance
  19. ARACTINQ Accounts Receivable Customer Account Inquiry
  20. ARACTMNT Accounts Receivable Account File Maintenance
  21. ARACTSUM Accounts Receivable Customer Account Summary Inquiry
  22. ARADJAUD Accounts Receivable Adjustment Auditing Inquiry
  23. ARADJSCN Accounts Receivable Adjustment Auditing Report
  24. ARAGEBAL Accounts Receivable Age Customer Accounts
  25. ARAGEMNU Accounts Receivable Aging Reports
  26. ARAPLYCR Accounts Receivable Re-Apply CR/DR Memos
  27. ARCALFCH Accounts Receivable Finance Charges Processing
  28. ARCNTMNT Accounts Receivable County Tax Code File Maintenance
  29. ARCRCMNT Accounts Receivable Credit Card Transacting Handling
  30. ARCRDSCN Accounts Receivable Credit Card Log Report
  31. ARCSHENT Accounts Receivable Cash Receipts Processing
  32. ARCSHSCN Accounts Receivable Cash Projection Report
  33. ARCTLMNT Accounts Receivable A/R Setup
  34. ARDBEXPS Accounts Receivable Export D&B Customer File
  35. ARDISSCN Accounts Receivable A/R Distribution to G/L Report
  36. ARECIMNT Accounts Receivable Customers and Contacts Import Utility
  37. ARHSTMNU Accounts Receivable A/R History Report
  38. ARINVSCN Accounts Receivable Print Service Invoices
  39. ARJBASCN Accounts Receivable Job Analysis Report
  40. ARJOBMNT Accounts Receivable Job Code File Maintenance
  41. I Can Only Enter A/R Cash Receipt for Cash or Check
  42. ARCUSMNT Accounts Receivable Customer File Maintenance
  43. ARLTRMNT Accounts Receivable Customer Mail Merge
  44. Feature - Prompt ACH Deposit Effective Date to Avoid Non-Business Day
  45. AROLOAD Accounts Receivable A/R Open Item File Maintenance
  46. ARPRDEND Accounts Receivable Clear A/R Accumulators
  47. ARPRGSCN Accounts Receivable Purge Closed Open Items
  48. ARRECENT Accounts Receivable Recurring Sales Processing
  49. ARSAMENU Accounts Receivable Sales Analysis Report
  50. ARSETBAL Accounts Receivable Set Customer Account Balances
  51. ARSHPMNT Accounts Receivable Ship Via Code File Maintenance
  52. ARSLMMNT Accounts Receivable Salesman File Maintenance
  53. ARSLSENT Accounts Receivable Sales and CR/DR Memo Processing
  54. ARSRCMNT Accounts Receivable Payment Source File
  55. ARSRVENT Accounts Receivable Service Invoice Processing
  56. ARSRVMNT Accounts Receivable Service File Maintenance
  57. ARSTMSCN Accounts Receivable Print Statements
  58. ARTAXMNT Accounts Receivable Tax Code File Maintenance
  59. ARTRMMNT Accounts Receivable Terms Code File Maintenance
  60. ARTYPMNT Accounts Receivable Customer Type File Maintenance
  61. ARSTLSCN Accounts Receivable Sales Tax Liability Report
  62. Incorrect Opn Ord Pick/Inv Amount in Customer File
  63. Feature - Customer Account Inquiry Reference Search
  64. Feature - Tax Freight Setup User Messages in COP Setup and Tax Code Maintenance
  65. ARFRMMNT Accounts Receivable Invoice Form Setup
  66. Feature - Customer Highest Balance YTD, Last Year, and Year Before Last Year
  67. Feature - Ship Via Group Support
  68. Feature - Scheduling ACH Payments
  69. How to Print A/R Aging Report by Salesman
  70. Feature - A/R Expanded Aging Report - Add "Show Open Items Only" Option
  71. Refund customer open credit / overpaid
  72. Feature - Add Acct Name to ACH Account Detail Screen
  73. Feature - ACH Add and Change Event
  74. Feature - Import A/R Cash Receipt Detail -- Add Ability to Process Multiple Customers for One Check
  75. Feature - A/R Commissions Due Reports - Additional Fields and CSV Support
  76. Feature - Age Customer Accounts When Cash Receipts Are Posted
  77. Feature - Validate Collector Against Salesman File
  78. NSCTLMN2 Accounts Receivable Global Setup 1
  79. NSCTLMN2 Accounts Receivable Global Setup 2
  80. NSCTLMN2 Accounts Receivable Global Setup 3
  81. NSCTLMN2 Accounts Payable Global Setup 1
  82. NSCTLMN2 Accounts Payable Global Setup 2
  83. NSCTLMN2 Accounts Payable Global Setup 3
  84. NSCTLMN2 Accounts Payable Global Setup 4
  85. NSCTLMN2 Accounts Payable Global Setup 5
  86. NSCTLMN2 Accounts Payable Global Setup 6
  87. NSCTLMN2 Accounting Global Setup: Index
  88. Accounts Receivable Cash Receipts Reports That Show Check Deposits for a Period of Time
  89. What Does the Asterisk Mean in A/R Account Inquiry?
  90. Refund Customer for Open Credit or Over Payment
  91. Feature - Defer Cash Receipts with Wildcard Batch Entry
  92. Feature - Exclude Debit Memos from Updating Customer Sales Ptd/Ytd
  93. Change - Sync Order Addresses in Customer Change Program
  94. Feature - Append Re-Apply Cr/Dr Memos Info To Log File
  95. Feature - Zone Breakdown Method by Freight Pay Code and State
  96. Feature - Enter Customer in Maintenance and Inquiry Event
  97. Feature - Added Phantom Locking to Customer File Maintenance
  98. How Do I Start to Collect Sales Tax for Other States?
  99. How Does Elliott Determine Sales Tax Codes?
  100. Why Are Customer Last Aging Date and Amounts Not Updated?
  101. Feature - Added a Generic Utility to Mass Update Customer by CSV
  102. Feature - Ship-to Special Function Support in Customer Maintenance/Inquiry
  103. Feature - Aging Reports to Default to Previous "Detail or Summary" Value
  104. Feature - Allow to Reapply a Check to an Invoice that was Applied to Before
  105. Feature - Add Support Customer Finance Charge Flag to the Mass Change Customer CSV Import
  106. Feature - Add Support for Customer Tax Codes to the Mass Change Customer CSV Import
  107. Feature - Payment History Inquiry
  108. Feature - Custom Receipt Comments in On-Line Credit Card Processing

Feedback and Knowledge Base