GL accounts with no postings are appearing in Trial Balance

Advertisement
Hi Experts,
When the Trial balance is run by selecting the below parameters in 'Trial Balance Report Selection Criteria':
1. 'Hide Accounts with No postings'
2. 'OB from Start of Company Activity'
The G\L Accounts having no postings in the posting date selected and having transactions entered before this period are displayed in the Report.
However, in the General Ledger Report with similar selection criteria, the same G\L Accounts are not displayed in the Report.
As stated in note 1632198, the system checks for the data from the beginning of the company activity and doesn't take into account the posting dates selected in the selection criteria. It is also stated that this behavior is the current system definition.
So, please I would like that SAP changes this behavior and I believe that it will make more sense that the system considers the specific year selected in the posting date.
Thank you in advance.
Nadia.
Advertisement

Replay

Hi,
The system logic is different for the General Ledger and the Trial Balance. Both the reports have different reporting requirements, Trial Balance being the display of the balances and opening and closing while Trial balance being the detailed output of the transactions happening during the F.Y. selected.
For having the zero balanced accounts not appearing in the Trial Balance, check whether selecting 'OB from start of Fiscal Year' helps you any way.
Kind Regards,
Jitin
SAP Business One Forum Team

Raw materials with valuation category are appearing as a missing parts

Hi All, I am converting planned order to production order which is having ten raw materials. Some of them are having valuation category u2018Ru2019. All raw materials are in stock. While procuring raw materials which are having valuation category, we

Fully Paid invoice is  appearing in "Accounts payable  trial balance"

Hi all, i have proble with AP trial balance report.. there is one invoice which is fully paid and accounted. but still that invoice is appearing in trial balance report. invoice amount is 0000000 rmaing amount is (9856568) note: negatinve amoun.. any

Missing last GL account code in system Trial Balance report

Hi, Customer is using 2005A PL23. They are using standard Trial Balance report in system to display Trial balance. Example, there is 10 GL account codes display on screen but when print preview, the report only show 9 GL account codes instead of 10.

ASKBN - Postings to G/L accounts with open item management are not permitte

Hi All! I have a problem: I run the transaction ASKBN (periodic asset postings) and receive the message about error: "Postings to G/L accounts with open item management are not permitted". Please let me know how correctly run the transaction? Th

Postings to G/L accounts with open item management are not permitted Messag

HI All, Me activiated New GL. and when I am trying to post the document, I am getting the below error. The GL used 200100 is Cash A/c (40) Cr Eq Share Capital A/c (50) As Cash A/c requires Clearing, I have activated "Open Item Management". Can y

Error- Postings to G/L accounts with open item management are not permitted

Hi, Can't we post to a GL, which is open item managed, in a non-leading ledger (statutory ledger)? We get this error when we try to post an entry, in the statutory ledger, to a GL that is open item managed. Can anybody explain this, please? Regards,

Sunday, I downloaded iTunes app on to my new PC.  Songs purchased over the years were present but all of the albums I loaded from CD's are not present.  How do I resore my iTunes account with all of my albums, playlists, etc.?

Sunday, I downloaded iTunes app on to my new PC.  Songs purchased over the years were present but all of the albums I loaded from CD's are not present.  How do I resore my iTunes account with all of my albums, playlists, etc.?  I have not attempted t

I'm in iPhone 5.  I transfer photos to a Windows 7 PC, using the USB cable.  Lately, the photos are appearing in Windows Explorer within monthly folders, with gibberish titles.  The folder names will be 8 random letters and numeric characters.  I ten

I'm in iPhone 5.  I transfer photos to a Windows 7 PC, using the USB cable.  Lately, the photos are appearing in Windows Explorer within monthly folders, with gibberish titles.  The folder names will be 8 random letters and numeric characters.  I ten

Photos are there but the videos are appearing as blank icons with an error message after the upgrade to Yosemite

I bought myself a new MacBook Pro and migrated everything from a Time Capsule/Time Machine migration.  My previous computer was slowly dying so I had backed it up although it was running Mavericks.  I migrated everything to the new computer from a Ti

All my accounts with Apple are set for the US. However when I order an I book it charges me in £. How do I change this to US currency?

All my accounts with Apple are set fot the US. However, when I attempt to order an iPhoto book it charges me in £ and charges VAT. The book is being sent to an address in the US and I am US citizen. How do I change the account to a US account?iPhoto

I have been sharing my iTunes account with my kids...now they are getting older and want to have their own accounts, how do I share the songs I purchased for them on my account with them on their new accounts?

I have been sharing my iTunes account with my kids...now they are getting older and want to have their own accounts, how do I share the songs I purchased for them on my account with them on their new accounts?  Is there a way to transer from my main

Newly created "managed account" with parental controls isn't logging in?

I tried to set up a managed account for my son to use over the weekend, but we are not able to get it to log-in. Each time I log out of my Admin account and we attempt to log-in to my son's account, the username and password appear to be accepted but

How can I download everything on my Ipod to an account with a new name?

How can I download everything on my Ipod to an account with a new name?  (my wife has been putting songs and books on her Ipod using my account, and she now would like to setup an account using her name)Hello stephencadmaster, While you cannot transf

Every time I create an account with iCloud then try to open it I get wrong ID or password. Even when I enter my birth date I am told it is incorrect. I have done this several times with the same results.

Every time I create an account with iCloud then try to open it I get an error message: wrong ID or password. Also when I enter my birth date I am told it is incorrect. I have done this several times with the same results.Oldcameraman Please do not du

How do you establish multiple users and accounts with TM?

I"ve had great success with TM. I have a Macbook Pro and an iMAC which are working well with TM, but recntly bought my wife a Macbook and want to also connect it to TM. How do you establish unique logins from each MAC to TM so users only have access

I use 1 Icloud account with 2 devise but the other devise arrest out mine, than my devise was not able to connect to itune anymore. My devise still can swich on but it always restart after afew seconds. So can it fix ?

I use 1 Icloud account with 2 devise but the other devise arrest out my devise throue find my iphone, than my devise was not able to connect to itune anymore. My devise still can swich on but it always restart after afew seconds. So can it fix ?Looki

Can I have 2 accounts with separate Apple-Id on 1 iMac? I share an iMac with my spouse.

We are two people with one iMac 27. We have our own iPhones with separate Apple accounts and A-Id`s.Yes, just enter your respective ID's in System Preferences > iCloud while logged into your account.  These preferences are unique to each user. Regard

Natures of classes of accounts for posted document are not balanced

Hi Can anyone help me with this error: "Natures of classes of accounts for posted document are not balanced" I am getting this error while doing GR(posting goods) using 561 movement type for a material. While I am able to post Goods with another

Can i change or have a new account with my iphone?

i would like to have a new account with my iphone,because i have a new ipod and all im writting on one or other are duplicating.duplicates might occuring because you might be syncing the devices with itunes and icloud , if you referring to having a n