Get ready to define your bank statement format for Business One 2007 - Part III, Mapping
Recall that in the first post we reviewed the history of bank statement processing solutions in different Business One versions and the advantage of introducing a mapping tool to cover the flexibility and diversity of variant bank formats in the world. In the second post, we took a closer look at the file importing solution by a case study of an imaginary bank statement format, which is invented purely for the case study and contains all the necessary fields in real plain-text bank statements but simple enough for demonstration. Especially in that post, we focus on describing the format structure in the tool. In this third post, we go on to demonstrate how the mapping from bank statement to Business One fields is done. By the way, I'm planning to devote the last post in this series to CSV bank statement handling and use of regular expression in the tool. Dec. 20, 2009
Comments: 5   Rank: 12649   Page Views: 1696 (Stats updated nightly)

Get ready to define your bank statement format for Business One 2007 - Part II, a case study
Recall that in the first post we reviewed the history of bank statement processing solutions in different Business One versions and the advantage of introducing a mapping tool to cover the flexibility and diversity of variant bank formats in the world. In this and next post, we will take a closer look at the file importing solution by a case study of an imaginary bank statement format, which is invented purely for the case study and contains all the necessary fields in real plain-text bank statements but simple enough for demonstration. Especially in this post, we focus on describing the format structure in the tool. In the next post, we go on to demonstrate how the mapping from bank statement to Business One object is done. Aug. 4, 2009
Comments: 0   Rank: 11416   Page Views: 2041 (Stats updated nightly)

Get ready to define your bank statement format for Business One 2007 - Part I
There is a new feature called bank statement processing (BSP) in SAP Business One 2007 which greately enhances the matching and reconciliation functionalities against previous solutions. Together with manual bank statement key-in, SAP also provides an automatic solution for customers to import their bank statements into Business One. In this solution, a brand new Add-on named Format Definition is introduced. It helps you to describe the structure of statement files and define its mapping to Business One. In this series of blogs, I will guide you through all the features of this new tool.  Mar. 2, 2009
Comments: 0   Rank: 5668   Page Views: 4056 (Stats updated nightly)