Manual Sales Count Back Import

Owned by Former user (Deleted)
Last updated: Mar 27, 2013 by Kristy Sherman
2 min read

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 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:

Manual Sales:
StandID: This is the ID of the store where the manual sale is taking place. (Mandatory)
RegisterID: This is the ID of the register where the manual sale is processed. (Mandatory)
EmployeeID: This is the ID of the employee who is processing the manual sale. (Mandatory)
Remark: This is where user enters the remarks/comments for the particular sale. (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 import of the manual sales details, a transaction number is generated and the user must note it down to proceed to the second step of the import.

STEP TWO:

Manual sales items:
Transaction#:  Enter the transaction number that was generated in the previous step (Mandatory)
ItemID#: Enter the Item ID of all of the items in the manual sales transaction (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 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 to go to the CAS and commit the manual sale with the payment mode and complete the transaction.