Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
Entering Checknumber using ReceivePaymentLine Table... |
Author |
Message |
|
Posted : 2006-04-25 10:06:45 |
When I am entering a payment to the ReceivePaymentLine Table is there a way to assign a check number ? Which field would that be?
You can assign a check number from QB in the Customer Payment window.
Thank you |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-04-25 17:59:13 |
Simply include the RefNumber in the insert:
INSERT INTO ReceivePaymentLine (CustomerRefListID, DepositToAccountRefListID, RefNumber, TotalAmount, AppliedToTxnTxnID, AppliedToTxnPaymentAmount, AppliedToTxnSetCreditCreditTxnID, AppliedToTxnSetCreditAppliedAmount, TxnDate, FQSaveToCache) Values ('790000-1071511999', '80000-933270541', 'Check00001', 129.30, '4909-1071512260', 129.30, '5540-1197772280', 10.03, {d'2007-12-15'}, 0)
See: Customers>Receive Payment for field mappings and How do I create a new Customer, invoice them and mark the invoice as paid? for a complete example.
See also: How to I handle Customer credits on account? for more information on the procedure for receiving the payment before the Invoice.
|
|
|
|
|