Skip to Content

When receiving large payments it is not practical to process them in one seating. I realized since we do it for usually for business partners and documents like invoices when implementing SAP business one setup why not try it in production with an incoming payment It is simple the only two items really required are the found in the templates folder for data migration under the incoming payment folder.

First the header details are required such as the amount paid.Which will be filled under the column of the method of payment and the account the payment is to be received. This is the template OCRT.

Second the line items in the RCT2 templat. This is usually straight forward in most cases it is the docentry of a document which is not the same as docnum. It could be found when making a query such as SELECT DOCENTRY FROM OINV WHERE DOCNUM = X. Then the sum applied is required. In most cases that is it. There are exceptions.

Of course the first column in the excel template have to match with the same number which SAP will override and assign its own number when posting the payment.

Once ran SAP will do all the calculation and spit out processed payment. There are times when more details are needed such as whether a document is an invoice. Fill in anything that may make it easier the software to determine what it may be.

import credit issue.png

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. Jiju Oommen

    Thanks for sharing, Mr.Brotto.

    Can you include more screenshots and template details?

    It would be good if you give more screenshots explaing the steps and dtw templates.

    Hoping to see more

    JO

    (0) 
    1. Jonathan Brotto Post author

      I will edit the blog shortly but for now use the ORCT table for the general details such as dates, RTC2 is the line items where you specify the invoices and credits using the docentry number and not the docnum which is on the upper right side of the AR invoice or credit window. Then the payment methods you have to select the correct table for cash, check, transfer, or credit cards. Each of these have their own table. Try to use the least amount of information as possible as SAP will do the calculations. Each line takes about a second to run. I manage to run 4,000 lines in about 3 minutes as our new server is SSD running on SQL 2012. Planning to test this with version 9.1 with SQL 2014 but it is an affordable way as it cuts down on labor costs and no need for additional hardware or software.

      (0) 

Leave a Reply