CP1101 Customer Order Processing Product Cat/Loc Acct File Maintenance

Product Cat/Loc Acct File Maintenance

Application Overview

 

This application allows you to assign sales and cost of goods sold account numbers to product categories by location.  In Customer Order Processing, sales account numbers and cost of goods sold account numbers are assigned to items by means of the items' product categories, rather than having a specific account number for each item.  When an item is sold, the sales credit is posted to the account number assigned to the item's product category, and that assignment is made in this application. If Post Cost of Goods Sold in COP Setup is Y, then the posting program uses this account to create a distribution record in Inventory Management.

 

The appearance of the account number is affected by two factors.  The Company file specifies how many digits are in the main profit center/department numbers and, indeed, whether profit center/ departments are used at all.  COP Setup specifies whether profit center/department, if used, are to be assigned to sales accounts at this time or during the posting of invoices.  If sub-accounts (profit centers) are to be associated with customer orders and assigned during the posting of invoices, they will not be entered at this time.  If sub-accounts are to be associated with product categories, you will enter the full account number in this application.  Refer to COP Setup section for more information on the subject.

If Post Cost Of Goods Sold is Y in COP Setup, you will be asked to enter a Cost of Goods Sold Account. This account will be used when posting invoices, along with the Inventory Asset account. The Inventory Asset account will be obtained from the Material Cost Type/Loc Acct file. If a Material Cost Type/Loc Acct record does not exist for this item, the default Inventory Asset account in Inventory Setup will be used.

 

If Post Cost of Goods Sold is N in COP Setup, the Cost of Goods Sold account will not appear and the default accounts in COP Setup will be used.

 

If profit centers or departments (if applicable) are not entered, the program cannot look up the account number in the A/R Account File or I/M Account File to see if the entry is valid, so care must be exercised to ensure that only valid main account numbers are entered.

 


Run Instructions

 

Select Prod Cat/Loc Acct File from the pull down COP Maintenance window.  The following screen will then be displayed:

 

 

Product Cat/Loc Acct File Maintenance Entry Screen

 

 

The following options are available:

    • Select the desired mode from the Prod Cat/Loc Acct File menu bar
    • Enter the data requested on the screen

     

    To return to the menu bar, press the ESC or F10 key. To leave this application, press X for EXIT when positioned at the menu bar.


    Entry Field Descriptions

     

    Name

    Type and Description

    1. Product Category

    3 alphanumeric characters.

    Enter the number of the product category.  This number may contain alphanumeric as well as purely numeric characters.

    Press the F7 key to search for Product Category.

    2. Location

    2 alphanumeric characters.

    Enter the location that will be used with this product category/location account record.

    Press the F7 key to search for Location.

    3. Sales Account No

    An account number in the standard account number format.

    Enter the digits of the main account number and press RETURN.

    If the Profit Center Usage Code in COP Setup was set to 0, only the above main account number can be entered.  However, if the Profit Center Usage Code is set to P, the full account number with main, profit center and departments (if applicable) are allowed.  A hyphen (‑) will automatically be displayed between the main account number and the entry field for the sub-account number and department.  When this occurs, press RETURN again.  If the full account number that is entered is on file in the Accounts Receivable Account file, a 30 character account description will be displayed.

    Press the F7 key to search for account by number or press the F8 key to search for account by description.

    4. Cost of Goods Sold Account      No

    An account number in the standard account number format.

    Enter the digits of the main account number and press RETURN.

    If the Profit Center Usage Code in COP Setup was set to 0, only the above main account number can be entered.

    Cost of Goods Sold Account No (continued)

    However, if the Profit Center Usage Code is set to P, the full account number with main, profit center and department (if applicable) numbers is allowed, and a hyphen (‑) will automatically be displayed between the main account number and the entry field for the profit center number and department. When this occurs, press RETURN again.  If the full account number that is entered is on file in the I/M Account file, a 30 character account description will be displayed.

    Press the F7 key to search for account by number or press the F8 key to search for account by description.

     

     

     

     

    Date filled out _______ by __________      ADD       CHANGE      DELETE

     

                               PROD CAT/LOC ACCT MAINTENANCE LOAD SHEET

         1.   Product Category    _ _ _

         2.   Location            _ _

         3.   Sales Account No    _ _ _ _ _ _ _ _ - _ _ _ _ _ _ _ _ - _ _ _ _ _ _ _ _

         4.   Cost of Goods

              Sold Account No     _ _ _ _ _ _ _ _ - _ _ _ _ _ _ _ _ - _ _ _ _ _ _ _ _

     

                                  *********************

         1.   Product Category    _ _ _

         2.   Location            _ _

         3.   Sales Account No    _ _ _ _ _ _ _ _ - _ _ _ _ _ _ _ _ - _ _ _ _ _ _ _ _

         4.   Cost of Goods

              Sold Account No     _ _ _ _ _ _ _ _ - _ _ _ _ _ _ _ _ - _ _ _ _ _ _ _ _

     

                                  *********************

         1.   Product Category    _ _ _

         2.   Location            _ _

         3.   Sales Account No    _ _ _ _ _ _ _ _ - _ _ _ _ _ _ _ _ - _ _ _ _ _ _ _ _

         4.   Cost of Goods

              Sold Account No     _ _ _ _ _ _ _ _ - _ _ _ _ _ _ _ _ - _ _ _ _ _ _ _ _

     

                                  *********************

     

    =======================================================================

      

    Date entered __________ by_________   Date verified ______ by _________

     

     

     

     



    Prod Cat/Loc Acct File Maintenance

     

     

     


     

    Prod Cat/Loc Acct List


     

     

     

    Run Date: Nov  2, 2001 -  9:01pm         Elliott Demonstration Company         Page    1

                                                                                                                                       

                            P R O D   C A T E G O R Y / L O C   A C C O U N T   F I L E  P R I N T - O U T                           

                                                                                                                                       

    Range: For All Categories                                                                                                      

                                                                                                                                       

      Prod    Location   Sales/Cgs         Description                                                                                 

    Category              Acct-No                                                                                                      

                                                                                                                                     

      AC1        LA     03120-10000-00000  Sales - Product Line F                                                                      

                        04000-10000-00000  *** Account Not On File ***                                                                 

                                                                                                                                     

      ACP        LA     03100-10000-00000  Sales - Product Line B                                                                      

                        04110-00000-00000  Cost Of Goods Sold - CPU                                                                    

                                                                                                                                      

      CH         LA     03120-10000-00000  Sales - Product Line F                                                                      

                        04040-00000-00000  Cost Of Goods Sold - Chemical                                                               

                                                                                                                                       

      CH1        LA     03120-00000-00000  Sales - Product Line E                                                                      

                        04130-00000-00000  Cost Of Goods Sold - I/O                                                                    

                                                                                                                                       

      CVD        LA     03110-10000-00000  Sales - Product Line                                                                        

                        04120-00000-00000  Cost Of Goods Sold - Video                                                                  

                                                                                                                                       

      DK1        LA     03100-00000-00000  Sales - Product Line A                                                                      

                        04110-00000-00000  Cost Of Goods Sold - CPU                                                                     

                                                                                                                                   

      DK2        LA     03100-10000-00000  Sales - Product Line B                                                                      

                        04110-10000-00000  *** Account Not On File ***                                                                 

                                                                                                                                       

      FG         LA     03100-00000-00000  Sales - Product Line A                                                                      

                        04000-00000-00000  Costs of Goods Sold                                                                         

                                                                                                                                       

      IOS        LA     03120-00000-00000  Sales - Product Line E                                                                      

                        04130-00000-00000  Cost Of Goods Sold - I/O                                                                    

                                                                                                                                       

      TB1        LA     03110-00000-00000  Sales - Product Line C                                                                      

                        04120-00000-00000  Cost Of Goods Sold - Video                                                                  

                                                                                                                                 

                                                                                                                                     

     10 Categories Printed                                                                                                              

                                                                                                                                  

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Customer Order Processing

    1. CP0000 Customer Order Processing Overview
    2. Common Reasons Why Pick Ticket Does Not Print
    3. How Do You Purge Quote Type Orders?
    4. Order Lookup by Customer and Ship-To
    5. Btrieve Error USE on COP Lock File
    6. How to Send Shipping Confirmation Email to Customer
    7. Order Inquiry Searching by Customer's PO (Purchase Order) Number
    8. Can We Turn Off the Ability for Users to Enter Orders for a Customer on Credit Hold?
    9. How Do I Remind Salesmen to Send Order Acknowledgment?
    10. Is There a Way to Export and Import Price Code Files?
    11. Can a Credit for Kits on an Order Return Components to Inventory?
    12. How to Add System Date and Time on Laser Pick Ticket
    13. What Triggers the Billing Edit List to Display an O/S Instead of Quantity in the Back Order Field?
    14. How to Subscribe to Add Order Event So I Only Receive E-mail When Credit Memo Is Created
    15. Manually Changed Sales Tax and Commission in Billing Screen Recalculates Again During Billing Selection
    16. Can Item Lead Time Be Added to the Sales Desk Screen?
    17. All of a Sudden COP Open Order Report Takes Forever to Complete
    18. Purge COP Sales Order with No Line Item
    19. The Top Barcode Will Not Scan on Pick Ticket
    20. Invoice Only Prints First 10 Characters of Purchase Order Number
    21. Why Would Invoice Balance Due Field Be a Credit?
    22. Open Order / Invoice History Inquiries GUI Windows Show No Column or Data
    23. Can the 'Design Your Own Picking Ticket' Feature Print in Pick Sequence?
    24. How to Lock a Sales Order from Being Changed
    25. What Do I Do With "Invoice Printed But Not OK" Orders?
    26. Warn Users When Entering COP Orders for Items Below a Certain Margin
    27. Can Elliott Support Gift Cards or Gift Certificates?
    28. How to Stop Changing Sales Order with Shipment Tracking (Starship) Note
    29. Received Message "Must Run COP Setup First"
    30. What Are CP3HSxxx.BTR Files? Can We Delete Them?
    31. Restrict User from Changing Price in COP Line Item Screen
    32. How to Determine Who Receives Shipping Confirmation Email
    33. How to Create Invoices and Credit Memos Without Updating Item Quantity through Phantom Invoice
    34. Feature - Print Outstanding Transfers Through Invoice Edit List
    35. Feature - Date Used to Determine Price When Adding Item to Existing Order
    36. Feature - Order Release Time by Warehouse Location
    37. Newly Received Items Inquiry Not Showing Proper Column as Labeled
    38. Credit Memo with Qty Return Will Reduce Qty Sold in Sales History
    39. Feature - Order Release Log File
    40. Feature - F7 to Print Duplicate Invoice in Invoice History Inquiry
    41. Feature - Receive COP Transfer Order Event
    42. Feature - Location Mask Added To Label File Name
    43. Feature - Support for Minimum Price Changes in Future Price Maintenance and Import
    44. Feature - Added Customer Type to Invoice Print Programs
    45. Feature - Order Acknowledgment Email Contacts
    46. How to Correct Wrong Invoice Date Once It is Posted
    47. Feature - Show Previous Qty OH in Newly Receive Inquiry
    48. Feature - Order Line Item Screen to Prompt WO Type, Buffer Days and Lead Time
    49. Feature - Add Selection Criteria to Print Duplicate Invoice Screen
    50. CP07S1 Customer Order Processing Backorder Audit Trail Report
    51. CP0102 Customer Order Processing Copy Order
    52. CP0308S1 Customer Order Processing Purge Invoice History
    53. CP0400M Customer Order Processing Order Inquiry
    54. CP0400V Customer Order Processing Void Invoice
    55. CP0406 Customer Order Processing Freight Calculation Inquiry
    56. CP0500 Customer Order Processing Sales History Processing
    57. CP0501 Customer Order Processing Sales History Trx Processing
    58. CP0502 Customer Order Processing Post/Purge Sales History Trx
    59. CP0200 Customer Order Processing Print Pick/Pack Tickets and Ship Labels
    60. CP0300 Customer Order Processing Order Billing
    61. CP0503 Customer Order Processing Sales History Reports
    62. CP0504 Customer Order Processing Sales Analysis Reports
    63. CP0507 Customer Order Processing Sales History Period File Maintenance
    64. CP0600 Customer Order Processing Order Status Reports
    65. CP0800 Customer Order Processing COP Setup
    66. CP0701 Customer Order Processing Fill Backorders
    67. CP0901 Customer Order Processing Price Code File Maintenance
    68. CP1001 Customer Order Processing Ship-To File Maintenance
    69. CP01012 Customer Order Processing Newly Received Item Inquiry
    70. CP1101 Customer Order Processing Product Cat/Loc Acct File Maintenance
    71. CP1200 Customer Order Processing Mass Price Change
    72. CP1400 Customer Order Processing Price List Report
    73. CP1600 Customer Order Processing Clear I/M & A/R Accumulators
    74. CP1700 Customer Order Processing Invoice History Inquiry
    75. CP1720 Customer Order Processing Invoice History Report
    76. CP1725S Customer Order Processing Print Duplicate Invoice
    77. CP1800S1 Customer Order Processing Purge Line Item Audit
    78. CP1900 Customer Order Processing Line Item Auditing Inquiry
    79. CP1920 Customer Order Processing Line Item Auditing Report
    80. CPCDPSCN Customer Order Processing Customer Delivery Performance Report
    81. CPCMSMNT Customer Order Processing Sales Commission File Maintenance
    82. CPCNLORD Customer Order Processing Cancel Order
    83. CPCNLPIC Customer Order Processing Cancel Picking Ticket
    84. CPCONMNT Customer Order Processing Contract Pricing
    85. CPCUSITM Customer Order Processing Customer Item File Maintenance
    86. CPCWLPSN Customer Order Processing Purge Customer Wish List
    87. CPCWLSCN Customer Order Processing Customer Wish List Report
    88. CPEXPMNU Customer Order Processing Sales Order Export
    89. CPFUTMNU Customer Order Processing Future Price File Maintenance
    90. CPIMPMNU Customer Order Processing Sales Order Input
    91. CPISSULS Customer Order Processing Issue Serial/Lot Component Items
    92. CPOLSMNT Customer Order Processing Order Serial/Lot File Maintenance
    93. CPOPNSSN Customer Order Processing Open Orders by Salesman Report
    94. CPPAYSCN Customer Order Processing Payment History Report
    95. CPPICMNU Customer Order Processing Pickup Processing
    96. CPPORGSN Customer Order Processing Generate P/O Reference
    97. CPPURSDQ Customer Order Processing Purge Sales Desk Quote
    98. CPQCMMNT Customer Order Processing Quotation Comment Maintenance
    99. CPR01MNT Customer Order Processing User-Defined Code Maintenance
    100. CPR02MNT Customer Order Processing User-Defined Code/Year File Maintenance
    101. CPR03MNT Customer Order Processing Customer User-Defined Code/Year File Maintenance
    102. CPRECMNU Customer Order Processing Recurring Order Processing
    103. CPRESORD Customer Order Processing Release Held Orders
    104. CPRMEMNU Customer Order Processing Print RMA Acknowledgement
    105. CPROIMNU Customer Order Processing Recurring Order Inquiry
    106. CPSBMENU Customer Order Processing Shipment Confirmation
    107. CPSETCUS Customer Order Processing Reset Customer Sales/Cost
    108. Feature - ACH Warning When Changing Order Terms
    109. CPSLSDSK Customer Order Processing Sales Desk
    110. CPFRMMNT Customer Order Processing Invoice Form Setup
    111. Feature - Transfer Qty On Order Status Reports
    112. Feature - Shipping Verification Item Event
    113. Why Does the Sales Order Date Not Match the Entered Date?
    114. Change – Add Salesman No. to Open Order Report by Customer, Change CSV Order of Fields
    115. Feature - Purge WMS Staging Batches
    116. Feature - Sales Order Import Line Item Event
    117. SCLAYOUT Sales Desk Change Customer Data Window
    118. SDLAYOUT Sales Desk Screen Layout
    119. XCP0352 Customer Order Processing Print Invoices
    120. Global Setup for Invoice Printing Time Release Flags
    121. Feature - Order Ship Status Auditing Report
    122. Feature - Check for Duplicate PO During Sales Order Import
    123. Feature - Print Staging Slip by Range Selection of Bin Numbers
    124. What's The Bar Code Symbology Used on Pick Ticket Heading Area?
    125. My Users Are Not Able to Void COP Invoice After Elliott Update
    126. Feature - Display Usage of Item Customer Usage from Inventory Transactions
    127. Feature - Sales Order Import To Warn If Sales or Weight Greater Than Certain Value
    128. Close Transfer Order Requires Resetting ATP and Qty. on Order
    129. Feature-Change EDI Flag in Order Entry
    130. Feature - Control Packing List Print Depending on Work Order Creation
    131. Feature - Sales Promotion Desk
    132. Feature - Staging Slip Ability to Select Only Order With or Without Work Order
    133. Feature - Stock Analysis Processing
    134. Feature - Cancel and Close Order Option Added to Cancel Pick Ticket Application
    135. Feature - Ability to Process Shipment Verification Over Multiple Days If Using Billing Selection
    136. Security Flag to Allow User to Change COP Incomplete Order to Complete
    137. Feature - Added Payment Inquiry Option to Order/Invoice Inquiry Applications
    138. Feature - Ability to Change EDI Import Path
    139. Feature - Two-Location Support In Sales Desk
    140. Feature - Print Packing List by Box Number
    141. What Do the Statuses Mean on the Order Inquiry Screen?
    142. Feature - Added “Show Customers with Pending Payment Only?” to Release Held Order with Filters
    143. Order Already Shipped. Cannot Be Cancelled Until Shipment Cancelled
    144. Feature - Auto Release Held Order Utility
    145. What Other Programs Can Update Order Date Picked Field?
    146. Feature - Added "Put Away Slip" Section to Staging Slip
    147. Feature - COP Custom Product Structure to Show Price & Cost
    148. Feature - Not Allowing All Customers When Printing Pick Ticket
    149. Feature - Restrict Access to the Open Credit Field in the Order Payment Window
    150. Feature - Add First Line Bin Number Sort to Picking Ticket
    151. In Order Line Item Screen, Got Message "Qty Available Had Changed While You Enter This Line Item"
    152. Feature - New Summary Area for Open Orders by Customer / Fill Back Orders by Customer Report
    153. Suggestion to Implement PDF PostOffice Invoice Based on Invoice History
    154. Why Order Taxable Flag Does Not Change After Customer Taxable Flag Is Changed
    155. How to Export Price Codes to CSV File
    156. How to Create Credit Memo from Invoice History
    157. Feature - Drop Ship Enhancement
    158. Feature - Negative Discount Percent Support

    Feedback and Knowledge Base