If you are running the N-jobs to move over data to the POS, and following error occurs in the store connect
IDispatch error #3119:Violation of PRIMARY KEY constraint 'I_20137STAFFIDX'. Cannot insert duplicate
key in object 'dbo.RBOSTAFFTABLE'. 2011-08-16
07:34:53.000
N-1060
The cause is that in the Transfer field list:
(Retail Scheduler/Subjobs/Setup/Transfer Field List)
The Field Type on all To Fields are set to = None
How it suppose to look is illustrated below:
If you read the fields with store connect from the menu
(Retail Scheduler/Distribution location/Functions)
Then all field types are restored to the correct values.
This blog is very nice for article about inventory software.
ReplyDeleteretail sales
gift shop
pharmacy software
Cash Registers
newsagent