Vendor Balances not matching with GL

[Former Member]

Hi All,

I am taking Vendor Balances period wise for Debit balances in S_ALR_87012802 and comparing the amounts posted to the corresponding GL a/c. The balances are not matching and there is a huge difference in the totals.

Kindly advise, as to how to go about the reconciliation and find where lies the difference. Is there some standard report which will provide some vital informationwhich could be used in reconciliation.

Thanks

Rosalyn

[Former Member]

Issue resolved

[Former Member]

Hi

Use T code FBL3N GL Line Item display and FBL1N Vendor Line Item display..check whether it is matching

for vendor Reports, Pls Use T code "SAP1" from SAP eassy Access screen........

[Former Member]

Go to transaction FBL1N and leave the vendor number blank, run the balances for all the vendor line items.

You need to restrict the balances to the reconciliation account in the selection parameters.

This will show you all the balances in your Trade accounts payables in your balance sheet account.

Usually there might be several reconciliation account created in the balance sheet for different vendor categories, i.e. inter co vendor, trade vendors, employee expenses, subcontractors etc.

Please choose which account you want to reconcile to the vendor balances. Usually companies choose default A/P Rec account as 200000 and will proceed to build up rec accounts in this series. Review your reconciliation accounts in the vendor master and use this information in the FBL1N transaction. Hope this helps.

Best - S

[former_member188028]

Please execute FAGLGVTR/F.16/F.07 for the previous fiscal years.

Rgds

Murali. N

[former_member191564]

Dear expert

The problem you are facing may be due to the Special GL transactions(may be Down Payments made to Vendors/Sundry Crs). The balance can be matched only after you have cleared the items in the Spl GL with the T-Code F-54 only after the bills get approved. The last entry will be clearing with T-Code F-44.

Hope this will solve your problem. Reply if you have any issue.

Regards

Ajeesh.s

[Former Member]

Hi,

Please find the following reports:

1) S_ALR_87012082 Vendor Balances in Local Currency

2) S_ALR_87012079 Transaction figures Account Balances

3) FBL1N Vendor Line Items

4) FBL3N G/L Line Items ( Here you can check the Vendor Recon A/c Balances)

Thanks & Regards,

S. Umamageshwaran

[vivek_srivastava12]

Dear,

Please check FBL3N GL Line Item display and FBL1N Vendor Line Item display..check whether it is matching..

Br,Vivek