Pos3/5/FNB: Sync error Transaction IPHIST Member No.: Difference between revisions

From AutoCount Resource Center
Content added Content deleted
(Created page with "<u><b>Question :</b></u> I have a transaction can’t sync back to HQ account book. The error as shown below. Error Message: MemberNo* Foreign Key Error (Constraint Name=FK_IPHIST_MemberNo) (my sample SS-021496)* <u><b>Possible Reason :</b></u> User may already deleted or changed the member No. code. This action affected the system can’t update data inside IPHIST table. <u><b>Solution :</b></u> You will need to add back the deleted Member. 1a.On the POS Bac...")
 
No edit summary
 
Line 3: Line 3:
I have a transaction can’t sync back to HQ account book. The error as shown below.
I have a transaction can’t sync back to HQ account book. The error as shown below.


Error Message: MemberNo* Foreign Key Error (Constraint Name=FK_IPHIST_MemberNo)
<span style='color:blue'>Error Message: MemberNo* Foreign Key Error (Constraint Name=FK_IPHIST_MemberNo)</span>

(my sample SS-021496)*
(my sample SS-021496)*


[[File:000500-a.png|1000px]]




Line 18: Line 20:




1a.On the POS Backend / Accounting > Bonus Point > Member Maintenance > New > must fill in same Member No. > fill up others info if have > OK
1a. On the <span style='color:red'>POS Backend</span> / <span style='color:red'>Accounting</span> > <span style='color:red'>Bonus Point</span> > <span style='color:red'>Member Maintenance</span> > <span style='color:red'>New</span> > must fill in same <span style='color:red'>Member No.</span> > fill up others info if have > <span style='color:red'>OK</span>



[[File:000500-b.png]]




For the member which the member no had changed, you will have to change back to original member no.
<span style='color:blue'>For the member which the member no had changed</span>, you will have to change back to original member no.




1b.Tools > Change Code > Change Member No > click ‘+’ > select MemberNo > enter New MemberNo > Change > OK
1b. <span style='color:red'>Tools</span> > <span style='color:red'>Change Code</span> > <span style='color:red'>Change Member No</span> > click ‘<span style='color:red'>+</span>’ > select <span style='color:red'>MemberNo</span> > enter <span style='color:red'>New MemberNo</span> > <span style='color:red'>Change</span> > <span style='color:red'>OK</span>


[[File:000500-c.png]]




⚫
2.Go to <span style='color:red'>Point of Sale</span> > <span style='color:red'>Sync Monitor Status</span> > Select correct <span style='color:red'>Terminal ID</span> > <span style='color:red'>Resync Error Trans</span>




By: CK 20240606, Jacky 20260626 [000500]
⚫
2.Go to Point of Sale > Sync Monitor Status > Select correct Terminal ID >Resync Error Trans
By: Jacky 20200319 [000001]


{{NavigateForUser}}
{{NavigateForUser}}

Latest revision as of 01:49, 27 June 2024

Question :

I have a transaction can’t sync back to HQ account book. The error as shown below.

Error Message: MemberNo* Foreign Key Error (Constraint Name=FK_IPHIST_MemberNo)

(my sample SS-021496)*


Possible Reason :

User may already deleted or changed the member No. code. This action affected the system can’t update data inside IPHIST table.


Solution :

You will need to add back the deleted Member.


1a. On the POS Backend / Accounting > Bonus Point > Member Maintenance > New > must fill in same Member No. > fill up others info if have > OK


For the member which the member no had changed, you will have to change back to original member no.


1b. Tools > Change Code > Change Member No > click ‘+’ > select MemberNo > enter New MemberNo > Change > OK


2.Go to Point of Sale > Sync Monitor Status > Select correct Terminal ID > Resync Error Trans


By: CK 20240606, Jacky 20260626 [000500]


Go to menu

AutoCount Accounting 2.0 & 2.1


AutoCount Accounting 1.8 / 1.9
AutoCount Payroll
AutoCount POS


AutoCount On The Go
AutoCount Accounting Plug-In Documentations
Retrieved from "https://wiki.autocountsoft.com/wiki/Pos3/5/FNB:_Sync_error_Transaction_IPHIST_Member_No.?oldid=25651"