Pos3/5/FNB: Sync error Transaction IPHIST Member No.: Difference between revisions
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]] |
|||
⚫ | |||
By: CK 20240606, Jacky 20260626 [000500] |
|||
⚫ | |||
By: Jacky 20200319 [000001] |
|||
{{NavigateForUser}} |
{{NavigateForUser}} |