Overview
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.
The manual sales function is often used by the retailer when they has a special event or off site sales where they did not use a POS. This allows the temporary store to post the sales and inventory back after the event is completed. That is why physical quantity is the remaining count and not the units sold.
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/virtual 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)
TransactionStatus: This is always 1 which indicates manual sales. (Mandatory)
Remark: This is where user enters the remarks/comments for the particular sale. (Mandatory)
TaxExempt: 0 is taxable, 1 is tax exempt
Date: YYYY-MM-DD (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)
PriceLevel: This is the discount code ID if any that's attached to the item (0 if none).
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.