Overview
The Manual Sales Count Back Import is used by the retailer when they has a special event or off site sales and need to account for the sales (they did not use a POS). This allows the temporary store to post the sales and inventory back after the event is completed. Physical quantity is the remaining count and not the units sold.
To import manual sales details into the database .This requires 2 steps, it is a two step process. First the transaction number must be generated using the manual sales import and then the actual manual sales item details must be processed. This two step process will only initiate the manual sale, an authorized user must commit the manual sale to complete the process. Make sure that the item you are selling is in the store that the transaction is being applied to. A common error is to check the venue warehouse balances for the item but not confirm that is in the store.
Note: Once successfully completed, the manual sale will be initiated. The user must now complete the transaction by committing the manual sale using the CAS Transaction>Inventory>sales>commit manual sales. Commit Manual Sales
STEP ONE:
Mandatory fieldsManual Sales:
Stand ID StandID: This is the ID of the store /virtual store where the manual sales sale is taking place. (Mandatory)
Register ID RegisterID: This is the ID of the register where the manual sales sale is processed. (Mandatory)
Employee ID EmployeeID: This is the ID of the employee who processes is processing the manual sales.
Transaction Status: This is always 1 which indicates manual sales.sale. (Mandatory)
Remark: This is where user can enter enters the remarks/comments for the particular salessale. (Mandatory)
TaxExempt: 0 is taxable, 1 is tax exempt
Date: MM/DD/YYYY (Effective date of the manual sale) (Mandatory)
Actions performed on successful import:
On Successful successful import of the manual sales details, a transaction number is generated and the user has to must note it down to proceed to the second step of the import.
STEP TWO:
Manual sales items:
Mandatory fields:
Transaction #: The Transaction#: Enter the transaction number that was generated in the previous step is entered in this field.
Item ID #:The (Mandatory)
ItemID#: Enter the Item ID of all of the items thats in the manual sales transaction .
Physical quantity: The physical quantity of the items thats going to be transacted is entered here. (the amount that wasn't sold)
Price Level(Mandatory)
PhysicalQty: The number of each item that REMAINS (NOT the number sold in the transaction) (Mandatory). Example being there are 100 units in stock, you sold 30. The physical quantity is 70 (which is the remaining quantity). If you enter a PhysicalQTY that is higher then the initial amount the CAS will treat this as a refund.
PriceLevel: This is the discount code ID if any that's attached to the item (if there is no discount cell can be left blank)
Actions performed on successful import:
On Successful successful import of the manual sales item details the sale is processed. These two steps will initiate the manual sale. The next step is for the user has to go to the CAS and find the transaction number and commit commit the manual sale with the payment mode and complete the transaction.