Knowledgebase: Tutorials
[QODBC Online] How to insert data into the VendorCredit table
Posted by Rajendra Dewani (QODBC Support) on 14 December 2022 02:36 PM

[QODBC Online] How to insert data into the VendorCredit table

Problem Description:

How to insert data into the VendorCredit table

Solution: 

 

Open the "QODBC Online Test tool" from the start menu.

 

Click on the "Connect" button.

 

Used the below SQL statement to insert data into the VendorCredit table

Insert into VendorCreditItemLine(RefNumber,VendorRefListID,APAccountRefListID,TxnDate,PrivateNote,ItemLineItemRefListID,ItemLineMemo,ItemLineQuantity,ItemLineRate,ItemLineAccountRefListID,ItemLineCustomerRefListID,FQSaveToCache)
Values('TestRef','98','165',{d'2021-11-01'},'New building','36','Installation',15,100,'231','59',0)

 

 

 

(0 vote(s))
Helpful
Not helpful
Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).