xl reporter shows different result before and after Period-End Closing.

[former_member347817]

Hi SAP experts,

We have an issue with XL Reporter. When we ran Period-End closing and ran XL - PL Period & YTD (with the same parameters), XLR shows nil in the Actual YTD column and the monthly figures are out by a big difference (example pre-rollover it was $110K after rollover it shows negative $12M).

This happens on 2 different clients running 2 different SAP B1 (2007A PL 42 and 8.8 PL 13) on the same XL Reporter which is possibly the default XL report that comes with the installation.

I don't have any idea why the XLR is running 2 different figures altogether when running the same XLR using the same parameter before and after rolling the year over. The default SAP B1 P&L report stays the same before and after the rollover, I would have expect that the same would happen with the XLR.

Please advise.

Regards,

Didy Arfiono

[Former Member]

There is a transaction type for closing entries which you should exclude from your P & L reports. The purpose of the PEC is to zero all the P & L accounts to create the retained earnings to carry forward

[former_member347817]

Hi Julie,

Thanks for the reply. I'm not entirely sure what you mean by excluding a certain transaction for closing entries as this would defeat the whole purpose of PEC which as you stated was to transfer P&L balances to retained earnings account to be carried forward.

I've check at some guides including one from Orchestra Team (http://www.youtube.com/watch?v=e4tUo774eXg) and so far the process that I've done is exactly what it is.

Regards,

Didy

[Former Member]

Hi Didy,

If you open your definition & in the report default choose the original journal item, find the Closing Balance item & set as <>.

Run the report & you should get the results you want.

When you include the closing balance, the full financial year values will always be nil for the P & L. The standard system reports will be excluding these values. The profit in a P & L is a calculated value

[former_member347817]

Thanks Julie, I've tried your solution however it still gives me the same result. I'll log this issue with SAP to see what they may come up with.

[Former Member]

Hi Didy, that orcehstra stream video is too simplistic. There are lot more steps to year end closing depending upon situation.

Please refer to this how to guide "Tip for Year end closing" and "Additional Tips for Year end closing" mostly for release 6.5 or 2005 etc. But much of it must be same for 2007.

https://websmp101.sap-ag.de/~form/sapnet?_SHORTKEY=01100035870000678769&_SCENARIO=011000358700000001...;

[former_member347817]

Hi Syed,

Thanks, we've tried the checklist before.The video link is just an indication of last step we performed for Period-End Closing.

Didy

[Former Member]

OK go ahead and open an issue with SAP/Partner. They will ask you for lots of data and queries to be run. You could refer to this thread in there also. Goodluck.

Also, try to do a trial balance and see if any account has that huge negative number.

Try trial balance with various combinations of accounts to isolate the problem.