Micros Simphony - Create new guest check

[laura youssef]

System: Micros Simphony
version: 18.2.4.0

I need to create a new guest check directly from the Symphony DB.

I discovered that two tables were required to create new checks (CHECKS and CHECK DETAIL), but this resulted in numerous errors.
I need to understand what is going wrong with the process.

Steps
1. Create a new empty check

 INSERT INTO [DataStore].[dbo].[CHECKS] 
  (
  RevCtrID,CheckNumber,Guid,Covers,DiningTableID,EmployeeID,CashierID,WorkstationID,AutofireWorkstationID,CheckOpen,
  TableOpen,CheckClose,FirstPrint,Fire,AutofireRevCtrID,AutofireTendMedID,AutofirePrinterMask,AddedToRevCtrID,SplitFromRevCtrID,
  AddedToCheckNum,SplitFromCheckNum,ReopenedFromCheckNum,ReopenedToCheckNum,Status,ClosedSeat,PrintedSeat,ServingPeriodID,
  ServingPeriodTaxMask,GroupNum,OrdTypeID,AddedIn,SplitOut,LineFind,PageNumber,PrintCount,AlternateID,SubTotal,Tax,AutoGratuity,
  Other,Payment,Due,Deposit,MaxTotal,LastWorkstationID,LangID,CloseStatus,UserCustomData,CheckPostingTime,Version,KdsOrderID,
  BarcodeEditCount,GiftReceiptCount,TaxByCheck,TaxCollected,RoundNumber,RoundGuid,PostingServingPeriodID,ReopenedToCheckGuid,
  ReopenedFromCheckGuid,AddedToCheckGuid,SplitFromCheckGuid,PendingAutoDiscount,TransferToEmployeeID,LastEmployeeID,DetailCount,
  CheckDetailData,PrintedRoundNumber,ItemInclusiveTax,TeamID,PickupTime
)
values(7242,25,'',0,1796687,54188,NULL,12222,NULL,'2022-06-06 10:24:48.000','2022-06-05 12:00:22.403',NULL,NULL,NULL,NULL,NULL,
0000000000000000,NULL,NULL,NULL,NULL,NULL,NULL,'000000000100010000000000000000000000000000000000',0000000000000000000000000000000000000000000000000000000000000000,0000000000000000000000000000000000000000000000000000000000000000,
19980,'1111111111111111111111111111111111111111111111111111111111111111',2,20338,NULL,NULL,NULL,NULL,NULL,NULL,35.0000,NULL,NULL,NULL,NULL,35.0000,NULL,NULL,12222,0,0,NULL,'2022-06-06 10:28:58.377',
14,NULL,NULL,NULL,NULL,NULL,2,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,54188,NULL,NULL,0,NULL,NULL,'2022-06-06 10:28:55.957');]

The new check was created after this step, but I can't see it unless I create another one from Simphony.

2. Add check details
We got a null pointer exception as a result.

thanks in advance.

 

[Niko S]

Hi Bro,
You need to create empty check to guest_check_line_item and other tables as well.

 

[laura youssef]

Thank you for your reply.

Please can you specify table names?

 

[Niko S]

dbo.guest_check_line_item

 

[goodbody]

Hi
you can use simphony TSAPI to create guest check.