If we create new table for PDC contains all the postdated checks information.
Is it possible ?.......
When the due date of the check in PDC is equal to work date then that check is shifted from PDC table to Payment journal automatically for posting purpose.
How can we do this?
0
Answers
Make a report that they can run from the payment journal that fills out the lines. Since they have to check and post the lines anyway there is no need to create some fancy workaround to get it to work automaticly(will only take a couple of seconds to run the report).
Now I a trying to insert the Postdated checks from PDC table to test table
For this I write the following code ,
But I will not execute the IF statement.Any body tell me where is the mistake? ](*,) ](*,) How can I solve this mistake? :-k
http://ssdynamics.co.in
A few pointers.
Start by finding the data, then assign, then insert.
To keep track of your line no.(to fill out your primary key i suppose) use a variable, NextLineNo
And please do not code this on the form/button etc.
I learned very much from u.
Thanks Its work now.It is now shifted from PDC to payment journal.
But how to to delete that shifted entry from PDC?
1. after you run the whole thing use PDC.deleteall // be VERY carefull that you have a filter on, else it will delete all records
2. in the bottom of your repeat-until code just do a pdc.delete // when deleting in a loop it is always a good idea to create a new variable, find the same record, and delete that instead.
But I got one more problem.
after shifteing that line it will take the line no randomly like
My code is below,
Will u tell me where is the peoblem.
It is your responsibility to control what line nos you want to insert, meaning f.ex. to find the last existing line no and insert after that.
But what is its purpose? :-k
No.
Im just used to using a variable when modifying primary keys/deleting records within loops, because if you are not carefull the loop will terminate. You probably wont need it here though(was just show you what to be aware of).
Thanks \:D/
I learned very much from u. \:D/
Thanks again. \:D/
:whistle:
Can you explain why?
I am also trying to do the PDC for vendor and customer.
I am doing this by sorting the vendor ledger entry and customer ledger entry usng a PDC header which i created.
The filters are vendor or customer No and Open Entry in the vendor or customer ledger entry.
Then i push the appropriate fields to a new table. I am doing this so that i can calculate the balance depending up on the check amount i have entered . Then using a boolean Mark posting the Record. I am little doubtful about the table to which i should enter these data so that it can affect the G/L. ](*,)
Currently i am using different form to do the PDC for customer and vendor. Can i do this on one form by giving an option? payable and recevable.
Please Give me All the Information and Ideas :idea: Regarding to this [-o<
i am technical person so i dont know whether i am correct or not but as per my suggession u can do that in one table with filter as payble and receivable.
One thing postdated check are posted when the work date = pdc date.
So u should maintain those checks in pDC table when today = pdc date(any payble/receivable) then that check will automatically or by click on button should be moved in Gen. jnl. or u can do this if the chek under payble then that check will move in bank payment journal and if the check is under receivable then that check will move to bank receipt journal.
Afterposting through these journal the effect will always correct.
best luck.