Friends,
I have uploaded a DB, LTFTest.zip where I need some help. If you open the StartDateEndDate form and use 7/1/14 as the start date and 7/31/2014 as the end date and click the License Transfer fee button, you will preview a report that summarizes a T account with the activity that occured during the month. The beginning balance is correct for this time period, however you will notice that the ending balance is $100 off if you add the debits and subtract the credits to the beginning balance. That is because the trailer that has unit number 311-3705 has come back to us a 2nd time for refurbishing and the record is showing correctly in the detail of the report but not in the Ending Balance which is a sub report. Nor will it pick up in the beginning balance of the report if you use 8/1/2014 and 8/31/2014 as the start and end dates. The report is based on 2 tables. The first is tblLTF where trailers are recorded when received and their book value at the time of receipt. The other table is the VINMaster table that has all the VIN's in it. The PK of this table is the serial number. The PK of tblLTF is the Old Number. I did this thinking I would be able to link the tables is such a way that when a trailer came back again which does happen, I could record it again and still link it to the VINMaster table. What I need help with is figuring out how to make the beginning and ending balance sub reports correctly pick up trailers when they come back for a second or thrid time for refurbishing.
Doyce
Posted by: winberry.doyce@roadsysinc.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar