Order Entry has an option to allow warehouse/division to be specified at the line item level.  This can be used for "Cross warehouse selling" of all item types, both material and labor.  This can be particularly useful when services are performed by multiple divisions, within your company, on a single order.  It makes for easy & accurate recording of who performed various work functions on a given order and for appropriate sales credit on the accounting side without having to do interdivision transfer orders.  In situations where interdivision work is marked up or sales credit is shared on a given line item then the standard inter-company transfer order procedures should still be used so you have more granular control of the resulting data.  If you are just transferring inventory from one warehouse to another, the standard inter-company transfer order procedures are also used.

Order Processing (Module 6):

The ability to sell line items from different warehouses on the same order/invoice is available via a parameter.  Go to:

• Order Processing (Module 6)
  • System Management Functions (Task 32)
    • ​Modify Parameter Files (Sub-task22)
      • ​O/E – General (Option 1)

Look for the parameter   CROSS’WHS’SELLING=YS                     

1^ST digit: Y/N  Allow selling individual line items directly from a different warehouse. 

2^nd digit: A/S  A=ask on entry,  S=skip (from quantity ordered field use the left arrow key to return to the ‘skipped’ division field) 

3^RD digit Y/N  Distribution line item revenue & cost to the line item warehouse/div rather than the order's selling division/whs.  Y/blank (default), N-for just the warehouse quantity to be based on the line item warehouse/div so you have stock tracking by warehouse but not financial reporting.

4^th digit O/T   Start with line item warehouse set based on user Table (default) or the Order division.  Note: the terminal/warehouse combination default is found in Task 6, Sub-task 32, Option 17, Selection 7 – “Default Terminal Whse/Dept”. 

Setting Situation:  When the first digit of this parameter is Y, second digit is S, third digit Y, fourth digit O:

Ø              On the line item screen type in the item number. Because the 4^th digit in the parameter is set to O the default warehouse is the warehouse # on the first screen of the order.

Ø              The cursor will move to the “Quantity” ordered column.

Ø              The column between “Item #” and “Quan” will be “Whs”.  To change the warehouse on the line item press the left arrow key, the cursor will move to the “Whs” column.

Ø              Type in the warehouse number from where the item is coming from, or the warehouse doing the service.

·        If the item is a material item, the bottom of the screen will change.  The bottom of the screen shows the quantity available, on/order, on-hand and etc… from this warehouse.  As the warehouse number is changed these numbers change to reflect the warehouse.  Material items MUST be in the warehouse that is on the line item. 

·        If the line item is a dimensional item, the system will prompt for the Sets first, then press the left arrow key to move the cursor to the “Whs” column.  The cursor will then go back to the Sets, Originals, Width & Height. 

·       Because the third digit is set to Y, the revenue & cost of goods sold for the line items will reflect the line item warehouse #.

Setting Situation:  When the first digit of the parameter is Y, and the second digit is A, third digit is N, fourth digit is T:

·       On the line item screen type in the item number. Because the 4^th digit in the parameter is set to T the default warehouse is the warehouse # the terminal is set to in the table, NOT the first screen warehouse #.

·       When at the line item of an order, after typing in the item number, the cursor will automatically stop at the column “Whs”.

·       Because the third digit is set to N, the revenue & cost of goods sold for the line items will reflect the first screen warehouse # NOT the line item warehouse.

Invoiced Order Holding File (Task #2):

Print Invoice Order Edit List (Sub-task 4).  If an edit list or posting is generated for one division at a time, the division on the front screen of the order is the division edit list and posting register the order will appear on.

·        The G/L account number distribution will divide the sale into the separate divisions.  For example:  you have a sale for $300.00.  The line items were $100.00 for division 01 and $200.00 for division 02.  The G/L distribution will be 541-00-01 = $100.00 and 541-00-02 = $200.00.

Reports:

Item history reports will break out the sale according to the line item division.  These reports can be found in Task #15 – Special Item History – in the Order Processing module.

Inventory Control (Module 5)

Task # 19 (Warehouse Master):  The quantities sold to the customers come from the line item warehouse not the front screen warehouse of the invoice.

Accounts Receivable (Module 2)

·        System Management Functions (Task 32)

o        Generate A/R to G/L interface (Subtask 3)

The G/L account number for the sales and cost-of-goods sold accounts follow the line item division of the invoice.