Vendor payments not appearing in the payment journal

Information  

• Products: Sparkrock 365, Sparkrock 2016
• Summary: Vendor payments not appearing in the payment journal 

Details  

As part of the Finance process, users need to process vendor payments through the payment journals. Sometimes users will notice that there are some vendor payments that are not appearing in the payment journal, this can happen for different reasons. 

One of the reasons could be that the payments were in the journal at some point but were removed, doing this kept the missing payments already applied to a journal, causing them not to appear after suggesting payments. 

Resolution  

To resolve this the user needs to clear the apply to id field from the payments, to do it follow the steps below: 

1. Go to any empty payment journal. 
2. Go to Prepare > Suggest Vendor Payments. 
3. In the Filter section filter using the Vendor No with the vendor which payments are missing. 
4. On the journal lines look for one line with 0 amount, if there isn’t one add a new line. 
5. For that line, in the vendor No field select the vendor missing. 
6. Also enter any number in the Document No column. 
7. Now with that line selected go to Actions > Functions > Apply Entries. 
8. The new window will show all the lines for that vendor that are applied to a journal. 
9. Locate the line with the corresponding amount that is missing from the payment journal. 
10. Select that line and go to Process > Set Applies-to ID 
11. Notice that when this is done the value of the Applies-to ID column for the selected line is removed. 
12. Click Ok 
13. Delete all the lines from the Journal and try the Suggest Vendor Payments process again but this time without the vendor filter to bring all the vendor payments that are needed in that journal. 

Impact / Risks  

Not Applicable

Workaround  

Not Applicable

Related Information

Not Applicable

Update History  

Attachment  

Not Applicable