Use the Daily Sales Register (DSR) program to:
Summary information includes invoice number, date, terms code, initiating warehouse, salesperson/territory, department, document number, customer number and name, sales cost, margin, tax, freight, discount and total.
Detail information includes summary information plus, for each line-item, line number, item number, description, quantity, selling unit of measure, shipping warehouse, cost, costing unit of measure, price, pricing unit of measure, extension, margin, item class, taxable flag, miscellaneous sales flag, Temporary flag, return or allowance flag, GL table flag and commission percent.
Returned Goods Credit Memo Processing
As the return goods credit memo is processed through the DSR it will change the status flags for the vendor returns so the Buyer’s Control Center can then process the returns to the vendor and create the negative PO. The Buyer’s Control Center will also be aware of any vendor replacements that are indicated by a customer return and create the replacement PO. These will update back to the CRS files.
For Returned Goods Credit Memo (allowance for credit dollars) there is no updating to inventory quantities. For a Returned Goods Credit Memo (return), the inventory quantities for return warehouse will be updated and usage for the credit warehouse will be updated. The returned goods status is updated to complete.
If the vendor return status is N/A the and the return action is return to vendor for credit (dollars) or item return and the return warehouse is same as consolidation warehouse, change vendor return status to Ready for return to vendor (Transfer has been updated through the Receiving Register or return warehouse is same as consolidation warehouse).
If the vendor return status is N/A and the return action is return to vendor for credit (dollars) or item return and the return warehouse different from consolidation warehouse, the DSR will create a suggested transfer to the consolidation warehouse and change vendor return status to N/A. If this is also the Returned (for Credit) Credit Memo, the DSR also changes the returned credit status to complete and the Customer Replacement SO is changed to a customer replacement status of complete.
Usage Updates for Returns from the Daily Sales Register:
If Update Usage field in Customer Returns Entry (SOE810) is set to No (unchecked) then usage will not be updated. If Update Usage is Yes (selected) and the Usage Period is blank then the current period usage will be updated and set to the current period. If Update Usage is Yes and the Usage Period is not blank then the usage for the indicated period will be updated.
Usage: The Daily Sales Register Update assigns usage based on settings in Replenishment Parameter Maintenance and Warehouse/Item F/M (ICF920) for the specified item and warehouse.
Subtotals are included for cash and AR totals. Register totals include the total number of invoices and the average invoice amount along with the total sales, cost, margin, tax, freight and overall total.
The DSR prints recaps by terminal, warehouse, salesperson and terms code if configured to do so in the SO Static Control F/M. If the DSR Recap MTD flag is set to Y in the SO Static Control Record, information in the Sales Register Recap F/M program is used to print the Period Sales Register and the period-to-date information on the Daily Sales Register. For remote orders (R-Origin), the DSR shows a section for "Origin" with breakouts for "Remote", "Non-Remote", and "Web" order details.
The DSR prints an asterisk beside the document number (as indicated in the legend) if the document was edited after the invoice was printed. If printing the DSR in summary, no additional information will be printed. If printing in detail, each individual occurrence of a change will be printed, including the user code, terminal ID, date and time.
Additionally, the DSR also indicates the user code, terminal ID, date and time for each deleted document.
You can elect to build a general ledger distribution, according to one of three formats, or skip the distribution altogether. The GL distribution information includes GL account number, description, customer number, name, ship-to number, invoice number and the amount to be debited or credited.
The Daily Sales Register updates:
Over Commitment of serial/lot items: The over-commitment of serial/lot items is not allowed in Order Entry and Confirmation Entry. If the OE Serial/Lot# Entry flag in SO Static Control is set to "M" or "N" then you can under commit serial/lot items. In the Daily Sales Register, if the Serial/Lot shipped amount doesn't match the order's shipped amount the system now displays a message and return to the menu and no longer displays an error 40. The system also displays a message if the Serial/Lot committed amount is greater than the order's committed amount and returns to the menu. Refer to the Over Commitment of Serial/Lot Items topic for more information.
Invoice Processing for Overpayments or Remaining Deposits
You cannot exit an invoice without indicating what is to be done with any overpayment or remaining deposit. Overpayments or remaining deposits can be applied on account, refunded, transferred to another document, and so forth. If the invoice print process detects an overpayment remaining on an invoice, "deposit held" or "applied on account "prints on the invoice, based on processing in the Daily Sales Register (SOR310) program. If the Daily Sales Register (SOR310) processing detects an overpayment, it will determine whether there will be a backorder generated for this document. If there is a backorder, the overpayment will be converted to a deposit on the document. If no backorder will be created, the overpayment will be applied on account. If the Daily Sales Register (SOR310) detects a deposit remaining on a completed document, the deposit will be applied on account. Payments applied on account from Sales Orders, via the Daily Sales Register (SOR310), now update the last payment date in the customer master record.
The Daily Sales Register (SOR310) program removes records from the sales order companion file and write them to the past invoice companion file. It also clears the ledger files that hold the "XC" records sent back from Radio Beacon.
When the invoice information is being written to SOPINA, for web orders the customer name and address will come from SORSOA instead of ARCUST. The email address will also be written to SOPINA data table.
In Order Entry, Confirmation Entry and Direct Invoice Entry, FACTS provides automatic freight calculations using freight schedules or quoted freight, based on control settings in Ship Via F/M, AR Customer Maintenance andSO Static Control F/M (SOF980 ).
The document freight method cannot be changed once the document has been run through the Daily Sales Register.
Note: Quoted freight is on the header of the order not on the warehouse level. If not all of the items from an order ship, the backorder’s quoted freight will reflect the amount of the freight originally quoted minus the amount that was billed on the first invoice.
Freight Method
If freight method is quoted
The system adds Invoice Billed Freight Amount adds into Previously Billed Freight Amount and the Invoice Calculated Freight Amount into Previously Calculated Freight Amount in the SORSOH record.
Then, the Order Quoted Freight Amount is reduced by the Invoice Billed Amount and the Order Calculated Freight Amount is recalculated based on new order quantity.
If the SO to GL Posting F/M has freight set to post by ship via, the ship via of the initiating warehouse is used to get the GL number. If post by branch is set, this would be the branch of the initiating warehouse. Quoted freight does not post by shipping warehouse like calculated freight.
If freight method is calculated
The system adds the Invoice Calculated Freight Amount into the Previously Calculated Freight Amount in the SORSOH record and recalculates the Order Calculated Freight Amount gets recalculated based on new order quantity if the Default Freight flag is Sales Order Static F/M is set to "yes".
The fields will move into the past invoice header file.
1. Date
Enter the sales register date. Press Enter(CR) to default to the system date. This displays the date and the current SO and GL periods. The period the sales register posts to in SA is the same as the period that it posts to in GL and is based on the register date that you enter here.
2. Warehouse
Enter up to 20 two-character warehouse codes side by side to indicate the warehouse(s) for which register is to print. The codes must already be set up in Warehouse F/M on the IC Infrequent File Maintenance menu. The program defaults to the warehouse assigned to the terminal. F2 allows a search. F3 defaults to ALL.
3. Department
Enter as many GL department numbers as will fit in the field for which the register is to print. (GL department length is user-defined in the SM Company Control F/M.
The field length is 40, so if the department length is two, enter up to 20 department numbers; if it’s three, enter up to 13; or if it’s four, enter up to 10. Department numbers must be on record in the GL Department F/M. F2 allows a search. F3 defaults to ALL.
4. Scope
Enter whether to print S-summary or D-detail information. The program defaults to Summary.
The Daily Sales Register prints by reading through the Ready-For-Register File. Information about each document prints as the General Ledger Distribution File is built.
If you print the GL distribution, the following field displays:
Check register. OK to print GL distribution?
After printing the Daily Sales Register, verify the printout. If there is a correction to be made, exit the program and make the necessary corrections. After the correction is made, the register can be rerun. If everything is correct, print the GL distribution. Once the GL distribution prints, proceed to:
Check GL distribution. OK to update?
After printing the GL distribution, verify the printout. If everything is correct, enter YES to continue. The program proceeds with the update. If there is a correction to be made, enter N to exit the program. After the correction is made, the entire register process begins again.
If you do not print the GL distribution, the following field is displayed:
Check register. OK to update?
After printing the Daily Sales Register, verify the printout. If there is a correction to be made, exit the program and make the necessary corrections. After the correction is made, the register can be rerun. If everything is correct, proceed with the register update.