jennyf
Member
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
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