Announcements
Hello,
We have 2 vendors that were paid on the same day in the current period. When looking at the AP- Vendor Maintenance- Documents tab- Detail Viewing option: Current Plus Open, One of the vendor shows the documents that were paid, whereas the other vendor does not. The 2nd vendor details of the documents can be seen when selecting All Documents.
Below are the definitions of the Viewing Options:
· Current Plus Open — Display any documents with a balance plus any documents entered and closed in the current period.
· Open Documents Only — Display only documents with a balance.
Are there other criteria that would cause the 2nd vendor to not appear in Current Plus Open?
*This post is locked for comments
Hello NorK
You can look at a trace and see what it may be passing
One of the parameters it passes doesn't find the document., could be company, doclass, perhaps the rlsed flag is not 1
IF (@parm4 = 'C') -- Current and open documents
DECLARE ApDocs_Cursor CURSOR STATIC FOR
SELECT RefNbr, DocType FROM APDoc
WHERE VendId = @parm1 AND CpnyID LIKE @parm6 AND DocClass = 'N' AND Rlsed = 1 AND (OpenDoc = 1 OR CurrentNbr = 1)
ORDER BY BatNbr, RefNbr
Let me know what you find, I don't see a bug for this issue.
Best Regards,
Jana MacDonald
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156