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:
Stand ID: This is the ID of the store/virtual store where the manual sale is taking place. (Mandatory)
Register ID: This is the ID of the register where the manual sale is processed. (Mandatory)
Employee ID: This is the ID of the employee who is processing the manual sale. (Mandatory)
Transaction Status: This is always 1 which indicates manual sales. (Mandatory)
Remark: This is where user enters the remarks/comments for the particular sale. (Mandatory)
Tax Exempt: 0 is taxable, 1 is tax exempt
Date: YYYY-MM-DD (Effective date of the manual sale) (Mandatory)
...
Manual sales items:
Transaction #: Enter the transaction number that was generated in the previous step (Mandatory)
Item ID #: Enter the Item ID of all of the items in the manual sales transaction (Mandatory)
Physical quantity: The number of each item that was 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)
Price Level: This is the discount code ID if any that's attached to the item (0 if none)
...