ARIE- One-Step Invoice Entry

New features added, versions 7.5.1, 7.5.2, 7.5.3, 8.1, 7.5.4R4, 8.4R4, 8.5.2, 8.6R1

See Also Programs

Program ARIE, One-Step Invoice Entry, is used to enter customer invoices using the one-step method. This program is also used to maintain invoices until the invoicing is complete (order status: Invoiced) or the invoice has been canceled.

A one-step invoice is a sales order and an invoice in one document. The system assigns both an order number and an invoice number at the time the invoice is created, whereas a two-step invoice is originally a sales order that becomes an invoice when it is later confirmed as shipped. Once into the accounts receivable jobstream, the two types of invoices are identical.

To enter Accounts Receivable balances for existing customers after the installation of a new system, enter a debit note in program ARIE, One-Step Invoice Entry. After processing with program OESJ, Sales Orders End of Day and Journals, the debit note amount will appear as the customer's open accounts receivable balance in program CMCM, Customer Credit Maintenance. This prevents the system from removing any inventory from stock. If the General Ledger is interfaced, it may also be necessary to establish the appropriate general ledger accounts with program GLTM, Account Maintenance, and posting accounts with program GPTM, Posting Template Maintenance, for your log-in enterprise.

Be sure to view the Sales Order Entry Features section of the NDS Online Help for more information about features offered in program ARIE, One Step Invoice Entry.

You must press the [Invoice Complete] button on the Summary screen for the sales order to be able to be processed with program OESJ, Sales Order End of Day and Journals.

Hot keys in this program include:

Alt+C - Header Comments

Alt+S - Summary Block

Alt+K - Header Ok

Alt+D - Calc Discount

See Also

Sales Order Entry Parameters

Sales Order Entry Features

Location Defaults Feature

Restricting Customer / Item Purchases

Sales Restrictions by Low Stock Allocation

Sales Order Entry by Zip Code

Sales Order Entry by Phone Number

Taxing Procedure

Sellable Items

Sales Order Line Renumbering

Contract Prices

Debit and Credit Notes in Sales Analysis

Shipping Master Lots and Lot Control Number Ranges

Containers for One Step Invoices

Comments Lists of Values

Entering One Step Invoices

Containerizing Items on a One Step Invoice

Entering Sales Representative Commissions

Canceling Sales Orders

Entering Substitute and Supersede Items on a Sales Order

Entering Credit Notes and Debit Notes for Projects and Project Lines

Searching for Items

ARIE Action Buttons

Payflow Pro Payment Processing

Third Party Shipping Accounts for Shipping Interfaces

Clippership Interface and Connectship / WorldEase Interface

Contract Prices

If you want to use the contract price from program CMCP, Customer Contract Maintenance, in program ARIE, One-Step Invoice Entry, you must enter the unique identifier in the Unique ID field. You can enter multiple contract lines for the same item on the same customer contract by entering different unique ID's. When you enter a unique ID during sales order entry, the price for that ID will be displayed.

Debit and Credit Notes in Sales Analysis

If you want to have credit and debit notes recorded in sales analysis, the Allow Notes in Sales Analysis flag in program SPAP, System Parameters/Accounting Parameters, must be set to on.

Shipping Master Lots and Lot Control Number Ranges

Lot and serial control numbers can be set up with master lot control numbers. Master lots are used as an overall control number for which sub lots exist.

The master lot control designator entered in program SPMM, System Parameters/Default Maintenance, is used to determine what part of the control number is the master lot. For example, if the master lot designator is /, and the control number is ABC/123, the master control number is ABC, and the sub lot is 123.

Master lots can be received from purchase orders, issued to work orders, and shipped to customers with control number ranges.

Shipping lot ranges

When a control number is shipped to a customer using a control number range, the quantity shipped is divided by the number of control numbers in the range. This amount is shipped from each control number in the range. Any remaining quantity is shipped from the last control number in the range.

Containers for One Step Invoices

Containerizing items in program ARIE, One Step Invoice Entry, is different than containerizing items after they have been staged. Even though containerization in this program is similar to staging and containerization, you cannot maintain containers entered in this program with any of the staging programs.

You can put different quantities of items in different containers. More than one container can be used per order. Items with the same lot control number and shipping location can be shipped in different containers, as can non-controlled items.

Numbering and Renumbering Line Items

Sales order line numbers are assigned by the program as the line items are entered. You can enter them manually.

To enter a sales order line in between two other line items, place the cursor on the bottom sales order line. Press [New Record].

To renumber all line items, press the [Renumber Lines] image\ebx_518836331.gif button.

Comments Lists of Values

Comments displayed here are sorted according to the OE_COMMENT_SORT parameter in program MURM, Initialization Parameter Maintenance.

The setting of the COMMENT_LOV_ARIE parameter in program MURM, Initialization Parameter Maintenance, determines whether the boilerplate list of values or a field editor will be displayed when the user double-clicks in the comment text field in this program.

Entering One-Step Invoices

1. In the Cust No field, enter the customer number.

2. The Inv Type field defaults to INV - Invoice. You can change the invoice type to CM - Credit Memo, DM - Debit Memo, CN - Credit Note, or DN - Debit Note.

3. If you are entering a credit memo, credit note, debit memo, or debit note, you can apply the transaction to a regular invoice. To do this, enter the invoice number to which you wish to apply the transaction in the Apply to Inv field.

4When creating a credit note or credit memo, the user will be alerted when the shipvia on the original order has an associated miscellaneous code. User will be prompted on whether or not any miscellaneous codes from ShipVia should be added to the credit note or memo.

5. In the Inv No field, the program will assign an invoice number when the invoice is saved. You can enter an invoice number here, if desired.

6. In the Sale Rsn field, enter the sales reason for the invoice. The default is the sales reason code from the customer record, but it can be changed.

7. In the Location field, enter the sales location for this sales order.

8. In the PO No field, enter the customer's purchase order number for reference, if desired. If the PO required in POS flag is set to on for the customer in program CMMM, Customer Master Maintenance, a purchase order number must be entered here.

9. The Proj No field is used when the invoice is created from project billings in program PMBM, Project Billing. The field displays the project number for which the invoice was created. It cannot be entered or maintained.

10. The sales order number is assigned when the invoice is committed, or you can manually enter the sales order number in the Order No field.

11. In the Ship Date field, the ship date is the date on which the order is scheduled to be shipped. It becomes the default due date for the order lines.

12. If using the optional User Ref fields, enter the information for the User Ref fields.

13. Sales representatives can be assigned to an order using the [Sales Reps] button in the header. For more information on sales representative commissions, see the Entering Sales Representative Commissions section.  

14. Set the Print Invoice field to the desired setting. When this flag is set to on, an invoice can be printed with program ARIP, Invoice Print, for this sales order.

15. Order codes, including ship via, FOB, terms, freight and catalog ID, can be changed when you press the [Order Codes] button.

16. Addresses can be changed with the [Addresses] button.

17. To view sales order tracking information, press the [Tracking] button.

18. When you have completed entering the header, press the [Save] button.

19. The cursor is moved into the Item No field in the lower block. Enter the item number that is being ordered.

20. In the Qty Shipped field, enter the quantity shipped for non-controlled items.

21. For controlled items, the quantity shipped should be entered with the [Ship Details] button. If you use the [Ship Details] button for non-controlled items, you can ship the item from locations other than the default location for that item.

22. For modular items, use the [Configure] button.

23. For Kit items, or model items if you have the Models are Treated as Kits for OE Allocations flag set to on, see the following instructions.

A. Enter the quantity shipped for the kit.

B. Press the [Ship Details] button. This allows you to specify from which lots and control numbers the ship quantity will be taken.

C. Find the item for which you wish to maintain the ship details by scrolling through the kit components with the arrow keys or the scroll bar to the right of the items.

D. In the lower block, enter the stock area and bin location from which the quantity will be shipped. The List of Values displays the stock areas and bin locations in which control numbers for this item are located.

E. For lot controlled items, enter the lot control number. The List of Values displays control numbers that exist in the indicated stock area and bin location.

F. For serial controlled items, you can enter a range of serial control numbers for the shipped quantity.

G. Enter the quantity shipped from that location.

H. If you wish to containerize the order, see the Containerizing Items on a One Step Invoice section.

I. Press [Commit]. Return to the main screen. You can also maintain the shipping information for non-controlled items with the [Ship Details] screen.

24. In the Plant field, you can change the default ship from plant. This is the plant from which the inventory will be shipped.

25. Set the Override flag to the desired setting. When this flag is set to on, you can change the price in the Unit Price field.

26. In the User field, enter the user discount percentage for the sales order line.

27. In the Addtnl field, enter any additional discount percentage for the sales order line.

28. In the Flat Disc field, you can enter a flat discount, if desired.

29. You can change the extended price in the Ext Price field, if desired.

30. In the List Price field, a list price must be entered for non-stock items.

31. The cursor goes to the Unit Price field. The unit price defaults to the list price, and cannot be changed unless the Override flag is set to on.

32. In the Cost field, for non-stocked items, you can enter the unit cost.

33. The Taxable flag defaults to the flag setting for the item in program ICMM, Inventory Master Maintenance. You can change it here.

34. In the Contract ID field, enter the unique ID for the item and customer from program CMCP, Customer Contract Maintenance, for the customer to receive the contract price.

35. Press [Commit].

36. Repeat until all items are entered.

37. Press the [Other Details] button. The Other Details button has six tabs.

Pricing Tab
Tax/Cost/Flags Tab

If the item is a non-stock item or non-maintain on hand item, enter the unit cost.

The cost in the Unit Cost field may be able to be maintained or overridden for items other than non-stocked items. If the cost can be overridden, set the Override Cost flag to on and enter the desired cost in the Unit Cost field.

For stocked items, the unit cost will be displayed if the Show Unit Cost flag in program ARLM, Location Maintenance, is set to on. This cost is entered automatically from the cost record or from the purchase order if this is a drop ship invoice line.

If the cost is changed in the item cost record before the invoice is shipped, when the invoice is shipped, the unit cost will be updated to the current unit cost.

General Tab
Purch/WO/Pick Tab

Purchasing/Inventory Section

Work Orders Section

Wt/Frt/Surchg Tab
Misc Tab

38. To view the units of measure that can be used for the item, press the [Unit Conversions] button.

39. All pricing from the pricing matrix for the item can be viewed with the [Pricing] button.

40. To view buying and selling information for the item, press the [Positions] button.

41. The available to promise inventory information can be viewed with the [ATP] button.

42. Item quantities and locations can be viewed with the [Stock Status] button.

43. Items can be substituted or superseded. For more on superseding and substituting items, see the Entering Substitute and Supersede Items on a Sales Order section.

44. Sales representatives can be credited with a line item using the [Sales Reps] button in the lower block. For more on sales representative commissions, see the Entering Sales Representative Commissions section.

45. Press [Commit].

46. Press the [Summary] button in the order header.

47. In the Freight Charges field, enter the freight charges, if desired. You can also enter the freight cost in the Freight Cost field.

48. In the Tax ID field, enter the tax code, if desired.

49. In the Misc Charges section, enter miscellaneous codes and charges, if desired.

50. In the Disc Pct field, enter the discount percentage. If you enter a percentage here, the discount you enter will be taken from the order total.

51. In the Previous Payments (deposits) field, enter any deposit promised by the customer.

52. In the No. of Cartons field, enter the number of cartons for the order, if desired.

53. In the Carrier field, enter the freight vendor, if desired.

54. In the PRO No field, enter the Carrier PRO number, if appropriate.

55. Press [Commit].

56. The Order Weight field is calculated from the sales order line item weights. This information can be changed.

57. Set the Keep Inventory as Customer Owned FG flag to the desired setting. This flag setting determines whether the shipped inventory will be recorded and stored as customer owned.

58. You can enter payment information in the lower block of the Summary screen, if appropriate.

59. If items have been containerized or need to be containerized for this order, see the Containerizing Items for a One Step Invoice section for more information about features for containers available on the Summary screen.

60. When you have finished entering the information, press the [Invoice Complete] button. The order is now ready to be processed with program OESJ, Sales Orders End of Day & Journals.

Containerizing Items on a One Step Invoice

1. After you have entered the sales order, press the [Ship Details] button.

2. Enter the stock area and bin location from which you wish to ship the items.

3. Enter the control numbers that you are shipping in the container if this is a controlled item.

4. Enter the quantity to be shipped in the container.

5. In the Container field, enter the container in which the items will be shipped. You can enter numbers from 1 to 99 in this field.

6. Repeat until all items that you want to ship in containers have been entered with a container number.

7. When the [Summary] button is pressed, you can maintain the items entered for containers.

8. Press the [Maintain Container List] button.

9. Press the [Contents] button to view the contents of the selected container.

Entering Sales Representative Commissions

1. There are two types of sales representative commissions that can be entered - line item and sales order.

2. Enter the sales representative who will receive the commission. The sales representative assigned to the customer in program CMMM, Customer Master Maintenance, defaults as the sales representative in the header.

3. For sales representatives entered in the lower block, enter the commission code. The commission code you enter is used to determine the commission rate for the sales representative and line item.

4. Enter the commission value percent. The commission value percent does not have to equal one hundred. If there are five sales representatives assigned to the order or to an order line, each of them can have their commission calculated from one hundred percent of the order total.

5. Press [Commit].

Canceling Sales Orders

There are two ways to cancel a sales order in this program.

Entering Substitute and Supersede Items on a Sales Order

1. To substitute one item for another, put your cursor on the desired line item and press the [Substitute] button. Once a substituted item is committed, the item can not be changed. You must delete the item and re-enter it.

2. If an item has been superseded in program ICAM, Supersede/Substitute Maintenance, then when the item that has been superseded is entered, the program will return an alert box stating that the item has been superseded by another item. The item that supersedes the item that you entered will then be automatically inserted in the record. Once a superseded item is committed, the item cannot be changed. You must delete the item and re-enter it.

3. For information on entering supersede and substitute items into the system, see the Substituted and Superseded Items section.

Entering Credit Notes and Debit Notes for Projects and Project Lines

1. Follow the standard steps for entering an invoice header with the following exceptions.

2. In the Inv Type field, enter CN for Credit Note or DN for Debit Note.

3. In the Proj No field, enter the project number for which you are entering the credit or debit note.

4. Finish entering the header and press [Commit].

5. In the lower block, enter the line item information. Enter one line item for each project line.

6. When you have completed entering the line item information, press [Commit].

7. Press the [Other Details] button. This is where you will be entering the project lines to which the invoice lines are assigned. If you do not enter project lines, the information entered on the invoice will have no effect on the project.

8. Enter the project line for each invoice line. There is one project line per invoice line.

9. When you have completed entering the project lines, press [Commit].

10. The amount earned and amount billed for the project line will be updated with the extended price for the invoice line assigned to it.

11. The cost booked for the project line will be updated with the extended cost for the invoice line assigned to it.

12. The billing information for the invoice will be added to the detail billing information for the project line on the second page of program PMBM, Project Billing.

13. This information can also be viewed on the Invoicing Tab for the project line in program PMMM, Project Management Maintenance.

Searching for Items

1. Enter the desired search criteria in the fields in the upper block. Press the [Clear] button to clear any earlier searches.

2. Press the [Search] button to select the display the items that meet the entered criteria.

3. In the lower block, put your cursor in the Item field for the desired item.

4. Press the [Select] button to enter the selected items as a sales order line item. The plant will also be returned to the item line.

5. Press the [Return] button to return to the sales order entry screen without selecting an item.

ARIE Action Buttons

Addresses

Maintain the customer ship to, sold to, invoice to, and bill to addresses.

ATP

View available to promise information for the selected item.

Calc Discount

Press this button to apply the order level discount to all sales order lines, overwriting any user-entered discounts. For more information, see the Order Level Discounts section of the Sales Order Entry Features.

Cancel

Cancels the sales order.

Clippership

Press this button to copy information to the Clippership Interface or Connectship / WorldEase Interface. For more information, see Clippership Interface or Connectship / WorldEase Interface. The Clippership button cannot be pressed when the ship via code assigned to the sales order does not have the ClipperShip flag or WorldEase flag set to on in program SPSF, Ship Via Code Maintenance.

Configure

Press this button to configure the modular item. For more information about configuration of modular items, see the Modular Bill manual.

Contents

Press this button to view the contents of the selected container. This information includes the line number, item number, control number, quantity boxed, gross weight, length, width, height, and label number.

Header OK

Press this button to commit the header and move the cursor to the lower block for line item entry.

Invoice Complete

Press this button to indicate that the order is ready for sales order processing with program OESJ, Sales Orders End of Day & Journals. You must press this button for the sales order to be able to be selected in program OESJ, Sales Order End of Day and Journals, for processing.

Item Search image\ebx_-1955635254.gif

Press this button to display the item search screen. For more information, see the Searching for Items section

Location

Maintain the location information for the order, including financial enterprise, bank, manufacturing enterprise, and plant information.

Maintain Container List

Press this button to view the container information for the order. The information includes the container number, container ID, stock area, bin location, pack date, employee who containerized the order, gross weight, tare weight, and net weight. The net weight and container ID number can be maintained here.

Model Details

Press this button to view information about the component items of the selected model item.

Order Codes

Maintain the ship via, freight, FOB, terms, and hold codes for this order.

Other Details

Enter the project lines to which the invoice lines are assigned.

Positions

View buying or selling information for the item. This includes customer or vendor, quantity, price, and sales order number or purchase order number.

Pricing

View the pricing information for the selected item, including book, list, quantity, special, and contract prices.

Promotions

Press this button to view the promotional items for this customer and sales order line.

Renumber Line Items

Located under the [Renumber Lines] image\ebx_518836331.gif button, press this button to complete the renumbering process.

Renumber Lines image\ebx_518836331.gif

Press this button to renumber the line items. Enter the increment by which you wish to renumber the line items. Press the [Renumber Line Items] button, and the line items will be renumbered using the entered renumber increment.

Reprice image\ebx_-1954182126.gif

Press this button to re-calculate the pricing of the order lines according to the new catalog ID entered.

Sales Reps

In the upper block, press this button to assign sales representatives to the sales order. Sales representatives entered with this button should have a commission scheme of volume. The customer's sales representative from program CMMM, Customer Master Maintenance, is the default, but other sales representative's can be added. The commission code for the sales representative from program SMMM, Sales Representative Master Maintenance, is always used, no matter what commission code is entered here.

In the lower block, press this button to assign sales representatives to a line item. Sales representatives entered with this button should have a commission scheme of product. The commission code entered here is used to determine the commission rate for the sales representative and item entered for the line.

Save New Ship To image\ebx_527884913.gif

This button allows you to enter and update ship to codes for the customer from sales order entry. For more information, see the Ship To Code Updates section of the NDS Help.

Ship Details

For controlled items, indicate the lot and quantity to ship. For non-controlled items, indicate which location, other than the default, from which you wish to ship items.

Ship To image\ebx_956889131.gif

This button brightens when there are multiple ship to addresses for the customer. Press the button and a list of values is displayed from which you can pick the desired ship to code.

Stock Status

View stock status information, including on hand, available, and on order quantities for the selected item.

Substitutes

Press this button to substitute another item for the selected item. Substitute items are set up in program ICAM, Supersede/Substitute Maintenance.

Summary

Maintain the order summary information, including extra charges, deposits, discounts, and the shipping carrier. Indicate that the order has been completed by pressing the [Invoice Complete] button.

Telephone

Press this button to select the customer for the sales order according to telephone number. For more information see Sales Order Entry by Phone Number.

Unit Conversions

View the unit of measure conversions, stock and sales, for the selected item.

Update Card Info

On the Payflow Pro Response screen, press this button to update the credit card information for this customer in program CMCM, Customer Credit Maintenance, with this credit card, AVS Address, and AVS Zip.

Payflow Pro image\ebx_417883968.gif

Press this button to submit the payment to the Payflow Pro software for payment processing. Only payments for which the payment type is designated as Credit Card in program SPPT, Payment Type Maintenance, can be used. For more information see the Payflow Pro Payment Processing section.

Payflow Pro Response image\ebx_1398869658.gif

View the codes sent back from Payflow Pro when the credit card was authorized.

Zip Code image\ebx_-1248968499.gif

Press this button to select the customer by zip code. You must have entered your initials before you can press this button. For more information, see the Sales Order Entry by Zip Code section.