Purchasing & Inventory report showing total of all invoices exported in a time frame.

That is the first report we tried but the total of all invoices for the selected account is about half the amount of the receiving summary and PeopleSoft AP(what was actually received).

Hi @Dennis Robertson​ 

Thank you for raising your query

The Receiving summery report gives a summary of all receiving’s which includes Unbilled receiving, Invoiced but not exported and Exported Invoices as well.

Please use the Invoice log report to compare exported Invoices with your Finance system.

Please see below article on Invoice log report.

https://fc.force.com/customer/s/article/Purchasing-Inventory-Invoice-Log-Report

Thanks

Omar

Fourth

That is the first report we tried but the total of all invoices for the selected account is about half the amount of the receiving summary and PeopleSoft AP(what was actually received).

Hi @Dennis Robertson​ 

Thank you for raising your query

The Receiving summery report gives a summary of all receiving’s which includes Unbilled receiving, Invoiced but not exported and Exported Invoices as well.

Please use the Invoice log report to compare exported Invoices with your Finance system.

Please see below article on Invoice log report.

https://fc.force.com/customer/s/article/Purchasing-Inventory-Invoice-Log-Report

Thanks

Omar

Fourth

Hi {@005D000000AKFHiIAP}​ 

For this situation, we recommend the Invoice Log Report (using the 'Exported Invoice Log' criteria) which will show the total of all invoices exported in a time frame. We would also recommend comparing individual dates to determine where the discrepancies may be, rather than trying to compare an entire month, for example. I’ve included a link the Adaco: Invoice Log Report in my comment above for more details.

As mentioned, the Receiving Summary Report is not ideal for this situation as it does not include Manual Invoice Entry (in case you are using that option) hence not advisable to compare it with your AP system.

The Invoice Log Report should be showing all exported invoices – If the Invoice Log is not generating the correct data, this is a technical issue in your system. For technical issues, I recommend for you to Raise a Technical Case with our Technical Support team. To do this, you can either escalate to the member(s) of your business who are responsible for raising cases with Fourth. Or if you are this person, you can select your name on the top right of the Customer Community and select the 'Raise a Technical Case' from the dropdown options.

I hope the Invoice Log works out for you! Let us know how you get on.

Thanks,

Omar

Fourth

Hi {@005D000000AKFHiIAP}​ 

For this situation, we recommend the Invoice Log Report (using the 'Exported Invoice Log' criteria) which will show the total of all invoices exported in a time frame. We would also recommend comparing individual dates to determine where the discrepancies may be, rather than trying to compare an entire month, for example. I’ve included a link the Adaco: Invoice Log Report in my comment above for more details.

As mentioned, the Receiving Summary Report is not ideal for this situation as it does not include Manual Invoice Entry (in case you are using that option) hence not advisable to compare it with your AP system.

The Invoice Log Report should be showing all exported invoices – If the Invoice Log is not generating the correct data, this is a technical issue in your system. For technical issues, I recommend for you to Raise a Technical Case with our Technical Support team. To do this, you can either escalate to the member(s) of your business who are responsible for raising cases with Fourth. Or if you are this person, you can select your name on the top right of the Customer Community and select the 'Raise a Technical Case' from the dropdown options.

I hope the Invoice Log works out for you! Let us know how you get on.

Thanks,

Omar

Fourth