Already delivered/charge only orders applies to the following orders.
Normal order
In case of normal order, the posting to the customer balances occurs immediately but only if selected values such as ISBN and customer codes are valid. There is no validation made on item prices, quantities or available stock on hand. This process is same as explained in Normal order entry via picking.
Charge only with no stock movement
The charge only for no stock movement program generates a charge only invoice for goods already delivered and adjusted out of the stock or for a service performed. Services performed include labour charge or freight charge. This does not update any stock report but only updates the debtors.
Convert free to sale
This type of order caters for those instances where a free ISBN has been issued which is now to be charged, such as ISBNs sent on approval which are accepted by the customer, or the approval period has expired. This type of order allows for a negative quantity to be entered, which is required to negate the original transaction. Then a positive quantity is entered for the same ISBN, which retrieves the relevant price and discount. This is part of already delivered/charge only orders.
- In the menu, expand Distribution > Order Processing & Billing > Order Processing > Order Entry > Already Delivered/Charge Only > Order Types and then double-click AD Convert Free to Sale Entry. DSE005A AD Convert Free to Sale Entry panel appears.
- Enter all the order header details.
- Click OK to proceed to the order line details panel. DSE005A Free to Sales – Already Delivered line details panel.
- Key in the item which is to be converted to sales with first entry being negative quantity and second line entry being same but positive quantity.
- Click OK to complete the process.
External sales upload
This is to record sales from exhibitions where books are taken by customers and payments are completed using cash or credit cards. The sales are then uploaded via an excel file to update the system. The system will update the external warehouse with stock adjustment and create sales and payment transactions. The upload is via Iptor IP1 supplied template DSE330.xlsx. The defaults for the external sales are maintained in control file TMSDS/ES-DFT. Payment types for the external sale needs to be setup in TMSDS/OM-PAYTL.
- In the menu, expand Distribution > Order Processing & Billing > Order Processing > Order Entry > Already Delivered/Charge Only > Order Types and then double-click External Sales Upload. DSE330 External Sales Upload panel appears.
- Enter the following details for the sales transaction.
Field | Description |
Customer | IP1 Customer account for the customer that the exhibition sale was made to. The sales transaction will be made against this customer. |
Shipto | Shipto address of the above customer for reference. |
Customer ref | Customer reference for the sales transaction. |
Warehouse | Logical warehouse for the sale; default warehouse is maintained in control file TMSDS/ES-DFT. |
Payment type | Payment type used to pay for the sale; default payment type is maintained in control file TMSDS/ES-DFT. |
Payment amount | The actual amount that was paid for the sale. |
Invoice amount | This is a display only field; it will be updated with the total invoice amount from the excel file. |
Difference | The difference between the Payment amount and the Invoice amount will be displayed in this field. The tolerance for the difference is specified in control file TMSDS/ES-DFT; any amount greater than the tolerance amount will give an error. |
Location | Network address of the location for the sales file for upload. |
Filename | Name of the sales file for the upload. The file must reside in the location specified above. |
- You can use function Excel to view the excel file and fix any errors before upload.
- Click function Upload. DSI120 Transaction Inquiry will display the transaction details.
- Click OK and select Yes to complete the upload or No to cancel. On upload ARE210A Bank Reference will display to update any of the bank reference details.
- Enter any required bank reference details.
- Click OK and the process number will display with the message “Successfully Updated“.