Supplier Ledger Inquiry Gross Amount Total incorrect

[jennyf]

When inquiring on all suppliers for the completed financial year using G/L Date and All entries as the selection criteria have noticed that the Gross Amt. total is incorrect.
If you export the supplier no. and Gross Amt. fields taking all the grid lines (44318) to excel and using Pivot Table total the Gross Amt. (having 44318 lines in excel) the amount does not balance to the P0411 Supplier Ledger Inquiry program. If you use SQL to sum the amounts from the F0411 based on Fiscal Year you get the same figure as the excel program.
Has any one else experienced this ?

Kind Regards
Jenny
ERP 8 SP23 HP

 

[clmates]

Hi.


[ QUOTE ]
When inquiring on all suppliers for the completed financial year using G/L Date and All entries as the selection criteria have noticed that the Gross Amt. total is incorrect.
If you export the supplier no. and Gross Amt. fields taking all the grid lines (44318) to excel and using Pivot Table total the Gross Amt. (having 44318 lines in excel) the amount does not balance to the P0411 Supplier Ledger Inquiry program. If you use SQL to sum the amounts from the F0411 based on Fiscal Year you get the same figure as the excel program.
Has any one else experienced this ?



[/ QUOTE ]

Yes, you should exclude the Voided Invoices (you can locate them by the DCTA field not equal to PE

Greetings

 

[jennyf]

Thank you that has worked perfectly. Kind Regards Jenny