We are experimenting with Advanced Payments but are having a problem:

1. A new supplier is added and an advanced payment of GBP 100 is made and reconciled.
2. The supplier sends us the "real" invoice for GBP 100, which is registered as a normal invoice.
3. We run "Select invoices for payment". The "real" invoice is selected for payment even though we have already paid it with the advanced payment.

I can understand that this may be correct, because the invoice received from the supplier could be for something totally different. I also can see that we should review all our advanced/unallocated payments and try to allocate them to "real" invoices before every payment run.

But, what is the easiest way to see all advanced/unallocated (anticipated) payments? Running an aging analysis for every supplier selected for payment will take too long. I can't see any easy way!

Hi,

Go to the session "ttadv2100m000" and select the session "tfacp2421m000" (copy this session to current VRC) and then on the 2nd page click on "Reports" which takes you to the sub-session "Maintain Reports" and select the 1st report "tfacp242111000" and copy the same to new report in your current VRC and the following changes.

In the session "Maintain Reports" click on the button "Edit Script" and the report script will open. Here you find "Detail.1" and "before layout" some codes that is already written. Just add the following to that section of the code;

if tfacp200.tpay = tfacp.tpay.unallocated or
tfacp200.tpay = tfacp.tpay.advance then
lattr.print = true
else
lattr.print = false
endif

Now save and complie the report and then attach this report to the session. This new report will give you output of all the unallocated and advance payments made to supplier that is not yet allocated.

Try the above. I hope this will be of help.....

Regards,
John.

Thanks for the information. I have copied the standard report and added the extra code as suggested. It actually needed a little more:

if tfacp200.tpay = tfacp.tpay.unallocated or
tfacp200.tpay = tfacp.tpay.unallocated.ant or
tfacp200.tpay = tfacp.tpay.advance or
tfacp200.tpay = tfacp.tpay.advance.ant then
....

I was hoping that there was a standard report to provide this information, but it seems not to be the case.

If Bank and cash transaction types are created in series (like B01,B02 ...) , you may use from to transaction type specification on tfacp2421m000 to get the results u wish.

This will eliminate the need to customize.