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

From AutoCount Resource Center
Revision as of 08:41, 26 June 2024 by PeterT (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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: Jacky 20200319 [000001]


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