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.
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.
Usage: The Daily Sales Register Update assigns usage to the ship warehouse only if the Replenish flag on the Main view of Warehouse/Item F/M (ICF920) is set to Y. If this Replenish setting is not Y, then program does not update the ship warehouse’s usage. As the program reads each line item, the update ship usage flag is set to true. Then, if the ship warehouse and initiating warehouse are not the same, the system reads the ICWHSE record for the initiating warehouse. If there is no record or the replenishment flag is not Yes, the update ship usage flag will remain unchanged. If the Replenish flag on the Main view of Warehouse/Item F/M (ICF920) is Yes, then the update ship usage flag will be changed to No indicating that the initiating warehouse usage is to be updated and not the ship warehouse usage. If the update ship usage flag remains unchanged (true) or Yes, then the program checks the Replenish flag for the shipping warehouse. If it is Yes, the usage is updated. If it is not Yes, then the ship warehouse usage is not updated.
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.
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 and SO 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 new fields will move into the past invoice header file.
1. Date
Enter the sales register date. Press Enter(CR) or
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.
5. Correct
Indicate whether or not this is the correct date and GL and SA period for the sales register to post.
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.