Saturday, May 31, 2025

LS Central - Post Statement - Customer does Not Exist

 If the customer is not a real customer, you can remove it from the following tables to allow the statement to post


       select * FROM [Cronus].[dbo].[Cronus$Transaction Status$5ecfc871-5d82-43f1-9c54-59685e82318d]

  where [Transaction No_] = 188996 and [Statement No_] = 'S030010087'


  select * FROM [Cronus].[dbo].[Cronus$Transaction Status$5ecfc871-5d82-43f1-9c54-59685e82318d]

  where [Customer No_] >'' and [Statement No_] = 'S030010087'


    select * FROM [Cronus].[dbo].[Cronus$Transaction Status$5ecfc871-5d82-43f1-9c54-59685e82318d]

  where [Statement No_] = 'S030010087'



select [Customer No_], * FROM [Cronus].[dbo].[Cronus$Transaction Header$5ecfc871-5d82-43f1-9c54-59685e82318d]

  where [Transaction No_]=188996 and [Receipt No_] = '000030-003000189010'


    select * FROM [Cronus].[dbo].[Cronus$Trans_ Sales Entry$5ecfc871-5d82-43f1-9c54-59685e82318d]

  where [Transaction No_] = 188996 and [Receipt No_] = '000030-003000189010'


    select * FROM [Cronus].[dbo].[Cronus$Trans_ Payment Entry$5ecfc871-5d82-43f1-9c54-59685e82318d]

  where [Transaction No_] = 188996 and [Receipt No_] = '000030-003000189010'



    select [Customer No_],* FROM [Cronus].[dbo].[Cronus$Transaction Header$5ecfc871-5d82-43f1-9c54-59685e82318d]

  where Date >= '2025-05-28 00:00:00.000' and [Customer No_] not in (select [No_] FROM [Cronus].[dbo].[Cronus$Customer$5ecfc871-5d82-43f1-9c54-59685e82318d] )



    update [Cronus].[dbo].[Cronus$Transaction Header$5ecfc871-5d82-43f1-9c54-59685e82318d]

set [Customer No_] = '03', [To Account] = 0, [Amount to Account] = 0

where [Transaction No_] = 188996 and [Receipt No_] = '000030-003000189010'


         update [Cronus].[dbo].[Cronus$Transaction Status$5ecfc871-5d82-43f1-9c54-59685e82318d]

set [Customer No_] = ''

  where [Customer No_]='21647'


    update [Cronus].[dbo].[Cronus$Trans_ Sales Entry$5ecfc871-5d82-43f1-9c54-59685e82318d]

set [Customer No_] = ''

  where [Customer No_]='21647'


  Delete and Recalculate statement