Full invoice numbers for BACS remittance

[KerryRopddy]

Is there a way to show full invoice numbers on the BACS remittance report? Inputting shows both the full invoice number and a shortened one, but the shortened one is used for the BACS report. Is there a way to access the form design to show the full number instead?

 

(My apologies if this question is duplicated. I am sure I posted this question but now cannot find it).

 

Thank you

Kerry

[Bev]

We are also having this issue, particularly with Amazon invoices. I'd love to know if you have found a solution?

[KerryRopddy]

No Bev, we've never solved this in FMS (but we're moving to Access Education Finance in April )

I have set up FMS to send remittances when we process a BACS, so all suppliers get their remittance advice automatically emailed but we have to download a report from Amazon into CSV and reconcile it manually after every BACS run

[Bev]

Do you email amazon with the reconciliation? Or is there a way to do it on the Amazon website? I have emailed them but it seems to take a long time to update the payment against the invoices. Edited November 3, 2022 by Bev

[KerryRopddy]

Yes we email them and no, can't be done automatically. When you do the BACS run in FMS, set the Amazon one to print and use that to reconcile against the CSV report from Amazon. It's quick enough if you sort it by Payment amount.

 

We don't find Amazon takes long to reconcile, are you using the correct report to reconcile?

 

Amazon Remittance Format

1. Select Business Analytics

2. Select the Reports tab (the other tab is Home) - from the dropdown, select 'Your reports'

3. On the right hand side, under Actions select 'View report'

4. Under 'Time period' select however long you need to (past 4 weeks is usually good to catch the stragglers)

5. Download CSV