i try to do step by step but some account does not show in "Process External Bankstatement " window do't know what i miss by the way this vedio very useful thank you
Love how you showed the financial overview in the background. Our sapb1 doesnt have it? Any idea on how to turn it on? Thanks! Love the vids btw clear and helpful
Hi Lin, do you mean the view of the ledger transactions in the bank rec module? If so, it should be there. If you can't find it, we'd recommend reaching out to your B1 partner.
Hello, Just wanted to know if I would lose any other modules or functionality if I turned on "Install Bank Statement Processing"? I am a little worried since it is irreversible if it will affect functionality and hurt our processes? Thank you!
Hi, I have a question regarding the copy-paste process. At 18:15 of this video, you paste back to SAP some excel lines. However, when am trying the same am getting the below error message, as the system does not allow me to go to the next line without confirmed the changes first (Click on Update button). How did you overcome this? "The target table cannot add new rows automatically. Contents below row '1' were not copied."
Hi @Georgakopoulou Polina. Assuming that you are on a version of SAP Business One that supports this, it should be possible. The most common source of pasting errors occur when the columns of the external data source do not match the columns of what's in the SAP UI grid. You may have to modify form settings to match, or vice-versa. Beyond this, paste will fail to execute of certain data does not match what's in your system. For instance, if you attempt to paste a GL code that isn't known to the system, it won't work. Some data cells are free-form, some require validation (such as an account code field). If the problem still persists, we recommend reaching out to your SAP partner of record for assistance. If you are a ProjectLine customer, please follow this link: pls.zendesk.com/hc/en-us
hI..Please share your opinion on this query. I am working in SAP environment where 90 % bank transactions are through RtGS (Electronic media) and hardly 5% in check. I constantly feel that only check transactions should be routed through reconciliation process and online transactions should directly hit main bank. I find this most pragmatic and it can avoid multiple entries. Am I wrong? Or you also think that for every transaction reconciliation route is safe and hence recommended. Thanks for this forum and its active participants.
Hi Madan, This is a difficult question for us to answer, as it feels a bit more like an accounting question, and not a technical one. If we understand correctly, you prefer doing 1 big summary transaction for the electronic cash transactions? We suspect the answer to this lies more in what's legally possible in your jurisdiction, as well, what's acceptable audit practice at your company. Perhaps we missed the technical question?
@@ProjectlineCa .. Thanks for your reply: My question can be well understood by SAP functional expert..I learnt you are connected with technical aspect, but still nicely attended my query....But if any other faculty from your group can answer my query, I will be really obliged....
Hi, could you please help me in a scenario where client is using only one bank i.e, main bank for doing all incoming and outgoing payment...how will bank reconciliation happen in such case. All though all three bank GLs are maintained in the system .
Hi Prerna. The smart people tell me that you can handle both incoming and outgoing with the same bank account, but there is a 1 to 1 relationship between bank accounts and GL accounts. I think the suggestion is to use one GL account to handle both incoming and outgoing payments. Does that make sense? It sounds like using a separate account for incoming and outgoing makes reconciliation very difficult.
Hi, nice tutorial. If you can clarrify on this one issue: given that there is a duplication in the system is the automatic recon smart enought to see that there is a duplicate transaction as it might reconcile the wrong one.
Sorry, we can't answer that question. I believe you might be referring to automating external reconciliations (via bank statement processing)? If so, my understanding is that this module has some logic to match transactions. However, it's a feature which has only recently been supported in the North American localisations where we are based. You could try the help portal? help.sap.com/viewer/68a2e87fb29941b5bf959a184d9c6727/9.3/en-US/cffa4754626341d883c1254fd851c6d9.html - hope this helps!
Hi, Thanks for the video. I have a question I am using sap bo 9.2 but I haven´t the manual reconciliation activated. Do you know how I can active this part ? for me is very important to have this active but at this time I can´t use
The manual reconciliation is active by default (found under Banking > Bank Statements and External Reconciliations in the menu). There are a number of potential reasons that you aren't seeing this (system authorizations, form settings, etc.). We recommend reaching out to one of the super users in your organization or your partner to explore further.
ProjectLine Solutions
Nice tutorial i really like big thanks for your shared.
Thank you very much ~ SG
No worries!
i try to do step by step but some account does not show in "Process External Bankstatement " window do't know what i miss by the way this vedio very useful thank you
Hi, do you know why the account code does not appear when i want to click in the bank reconciliation report window ?
How do i access your PowerPoint presentation
Love how you showed the financial overview in the background. Our sapb1 doesnt have it? Any idea on how to turn it on? Thanks! Love the vids btw clear and helpful
Hi Lin, do you mean the view of the ledger transactions in the bank rec module? If so, it should be there. If you can't find it, we'd recommend reaching out to your B1 partner.
Hello, Just wanted to know if I would lose any other modules or functionality if I turned on "Install Bank Statement Processing"? I am a little worried since it is irreversible if it will affect functionality and hurt our processes?
Thank you!
Hi, I have a question regarding the copy-paste process. At 18:15 of this video, you paste back to SAP some excel lines. However, when am trying the same am getting the below error message, as the system does not allow me to go to the next line without confirmed the changes first (Click on Update button). How did you overcome this?
"The target table cannot add new rows automatically. Contents below row '1' were not copied."
Hi @Georgakopoulou Polina. Assuming that you are on a version of SAP Business One that supports this, it should be possible. The most common source of pasting errors occur when the columns of the external data source do not match the columns of what's in the SAP UI grid. You may have to modify form settings to match, or vice-versa. Beyond this, paste will fail to execute of certain data does not match what's in your system. For instance, if you attempt to paste a GL code that isn't known to the system, it won't work. Some data cells are free-form, some require validation (such as an account code field). If the problem still persists, we recommend reaching out to your SAP partner of record for assistance. If you are a ProjectLine customer, please follow this link: pls.zendesk.com/hc/en-us
between sap business one vendor how to reconcilation with supplier statement
hI..Please share your opinion on this query. I am working in SAP environment where 90 % bank transactions are through RtGS (Electronic media) and hardly 5% in check. I constantly feel that only check transactions should be routed through reconciliation process and online transactions should directly hit main bank. I find this most pragmatic and it can avoid multiple
entries. Am I wrong? Or you also think that for every transaction reconciliation route is safe and hence recommended. Thanks for this forum and its active participants.
Hi Madan, This is a difficult question for us to answer, as it feels a bit more like an accounting question, and not a technical one. If we understand correctly, you prefer doing 1 big summary transaction for the electronic cash transactions? We suspect the answer to this lies more in what's legally possible in your jurisdiction, as well, what's acceptable audit practice at your company. Perhaps we missed the technical question?
@@ProjectlineCa .. Thanks for your reply: My question can be well understood by SAP functional expert..I learnt you are connected with technical aspect, but still nicely attended my query....But if any other faculty from your group can answer my query, I will be really obliged....
How to check the bulk figures entered in line item in feban
Hi Vinanti, can you clarify the question?
hai sir i have doubt that is
Hi, could you please help me in a scenario where client is using only one bank i.e, main bank for doing all incoming and outgoing payment...how will bank reconciliation happen in such case. All though all three bank GLs are maintained in the system .
Hi Prerna. The smart people tell me that you can handle both incoming and outgoing with the same bank account, but there is a 1 to 1 relationship between bank accounts and GL accounts. I think the suggestion is to use one GL account to handle both incoming and outgoing payments. Does that make sense? It sounds like using a separate account for incoming and outgoing makes reconciliation very difficult.
how to reconcilation with sap business vendor ledger and supplier statement please give me the details urgently
have you figure out the answers? can you share? Thanks!
Can you please share the Excel sheet for this?
Hey Arslan, not sure we have an excel sheet for that one ATM. Did you end up finding one?
Hi, nice tutorial. If you can clarrify on this one issue: given that there is a duplication in the system is the automatic recon smart enought to see that there is a duplicate transaction as it might reconcile the wrong one.
Sorry, we can't answer that question. I believe you might be referring to automating external reconciliations (via bank statement processing)? If so, my understanding is that this module has some logic to match transactions. However, it's a feature which has only recently been supported in the North American localisations where we are based. You could try the help portal? help.sap.com/viewer/68a2e87fb29941b5bf959a184d9c6727/9.3/en-US/cffa4754626341d883c1254fd851c6d9.html - hope this helps!
Hi, Thanks for the video. I have a question I am using sap bo 9.2 but I haven´t the manual reconciliation activated. Do you know how I can active this part ? for me is very important to have this active but at this time I can´t use
The manual reconciliation is active by default (found under Banking > Bank Statements and External Reconciliations in the menu). There are a number of potential reasons that you aren't seeing this (system authorizations, form settings, etc.). We recommend reaching out to one of the super users in your organization or your partner to explore further.