Showing results for 
Search instead for 
Did you mean: 

SAP B1: how to link a Sales order and an AR down payment invoice

0 Kudos


I'm trying to get a link between the Sales order and AR down payment invoice.

I made up a Query for ORDR table using fields:





T0.[PaidDpmS], but all those columns are empty (null or 0.00) for every Sales order.

They are empty even, if the AR dowm payment invoice was posted as "copied from" the Sales order and paid.

Due to this mistake, the Due amount is not correct for Open Sales order, because there are no links between Sales order and AR down payment invoice.

Is there any settings i should set up to fill those columns?

Thank you in advance for help!

Community Manager
Community Manager
0 Kudos

Hello Olga,

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with, as it provides tips for preparing questions that draw responses from our members.

Feel free to take our Q&A tutorial at as well, as that will also help you when preparing questions for the community.

By adding a picture to your profile you encourage your readers to respond.

Kind regards,

0 Kudos


I see that the SAP help portal couldn't help me with the issue below. Ok.

I have just 2 questions:

1) has been this problem resolved for version 10 SAP B1?

2) after registering here (on SAP help portal) I started getting the phishing emails to my inbox. Are you selling our data? Or do you have troubles with information security?

Thank you for reply!

View Entire Topic
0 Kudos

Hello, is this for SAP Business One or SAP ERP?