Showing posts with label Postman. Show all posts
Showing posts with label Postman. Show all posts

Thursday, August 29, 2013

Delete Duplicate Query

For Speednet
use pospcc
UPDATE  DeliveryReturns
SET     RemarkCode='1'

For Postman
USE POSTMAN
UPDATE      RegDeliveryMaster
SET             DeliveryOrDespatchDate =TransDate
UPDATE       RegDeliveryReturns
SET              Action ='0',ReasonCode='1'

USE POSTMAN
UPDATE      ParDeliveryMaster
SET             DeliveryOrDespatchDate =TransDate
UPDATE       ParDeliveryReturns
SET              Action ='0',ReasonCode='1'

USE POSTMAN
UPDATE      MoDeliveryMaster
SET             DeliveryOrDespatchDate =TransDate
UPDATE       MoDeliveryReturns
SET              Action ='0',ReasonCode='1'
-------------------------------------------------------------------
For Speednet
use pospcc
UPDATE  DeliveryMaster
SET          DeliveryOrDespatchDate=Transdate
WHERE   (DeliveryOrDespatchDate IS NULL)
 
For Postman
USE POSTMAN
UPDATE      RegDeliveryMaster
SET             DeliveryOrDespatchDate =TransDate
UPDATE       RegDeliveryReturns
SET              [Action] ='0',REASONSCODE='1'

Tuesday, February 7, 2012

MEGHDOOT 7 UPDATE 1 -EVPP RETURNS ERROR.

WHILE TAKING THE RETURNS OF EVPP ARTICLES, IF AN ERROR COMES,
"No Reasons Found in the List" Pl. run the following 2 queries ,after taking the backup of database.

http://www.mediafire.com/?eh5tja07prae2e6

MEGHDOOT 7 UPDATE 1 POSTMAN DAY END ERROR SOLUTION





PLEASE DOWNLOAD THE SAME FROM

http://www.mediafire.com/?vd63q0gxv5uqugr

Monday, November 28, 2011

Postman Day End Error


In C class office,if you are planning installing of ePayment at a later date,you may uncheck ePayment in Special Services window of POS configuration.

But This will lead to above error while doing day end in Postman. ePayment database is needed for Postman module. Hence,do not forget to select ePayment while configuring POS.