Query question

[GaryWilsonCPA]

I am a novice - building an accounts recivable program. I want to build a form that brings up a list of charges. I need those charges to be temporarily stored in a list so that the user can mark which charges are paid. Then I need to copy those charges paid to a payments file.

I am looking for some ideas on how to handle the temporary list of charges.

The idea is that the user brings up the list of charges and then decides which ones are paid and then marks them paid. the program needs to copy these to the payments file.

 

[SGLong]

Gary,

As an ex-CPA turned programmer I know what you're looking for. You should probably SQL select the unpaid charges from your file along with the '.F. as paid' in your select line. If you're using VFP 7 use the READWRITE option to make the cursor editable. If not, then you'll have to use the cursor under another alias to make it editable. In a grid include a check box control for the user to toggle the paid status. You can then scan thru the cursor for 'paid' and then post your updates.

Steve

 

[Mike Gagnon]

Maybe use an sql statement, and adding a logical field at the end (for selection a payment) and sending the resulting cursor to the payment file.

 

[ramani]

HI Gary,

1. I suggest you build a view for this purpose.
The view shall contain the Charge Document No, date, amount Due ( i.e. Charge-ReceivedALready), and an additional column for the anount now received/cleared.
2. Accept the last column data as User input under a grid. Also provide facility to accept on account receipt outside of the Grid.
3. Provide a TextBox for the total of all the receipts (above 1 and 2) for display purpose.

While updating data to payment file, make sure that the earlier status of the dues are not already changed by another user, since that could allow errors to creep in. In case you dont process a line items credit, then either you can ROLLBACK the whole document or add back this amount as unallocated on account for later processing.(That depends on your need).

Hope the above ides helps you ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com

 

[ramani]

HI Gary,

1. I suggest you build a view for this purpose.
The view shall contain the Charge Document No, date, amount Due ( i.e. Charge-ReceivedALready), and an additional column for the anount now received/cleared.
2. Accept the last column data as User input under a grid. Also provide facility to accept on account receipt outside of the Grid.
3. Provide a TextBox for the total of all the receipts (above 1 and 2) for display purpose.

While updating data to payment file, make sure that the earlier status of the dues are not already changed by another user, since that could allow errors to creep in. In case you dont process a line items credit, then either you can ROLLBACK the whole document or add back this amount as unallocated on account for later processing.(That depends on your need).

Hope the above idea helps you ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com