Sage 200 Database table for matching allocated payments to invoices

Sage 200 Database table for matching allocated...

Didn't find your answer?

Hi,

could anyone please tell me how I can look for the "Payments" allocated to invoices in Sage 200.

I am trying to do a bank reconcilliation and are trying to match off the payments that were entered by people who make payments on our behalf (and who have access to our Sage 200 system) and the specific invoices they have tried to allocate those payments to and to match off what went through the bank statement .

I use SQL queries to download data from Sage so we can get allocated invoices and the date they were allocated but cant get the Unique Resource Number of the Payment that was allocated to come through on a query.

this may be possible if we knew the table this is stored in so that we can done if I could join that table to the invoices paid table.

Thanks

Replies (1)

Please login or register to join the discussion.

avatar
By Vidpark
26th Jun 2012 08:52

Have a look at these

SLAllocationHeader and SLAllocationTran in conjunction with SLPostedCustomerTran and SLAllocationType

Thanks (0)