SBX - Search With Button

SBX - Forum Post Title

AP- Vendor Maintenance- Documents- Detail Viewing Option issue

Microsoft Dynamics SL Forum

NorK asked a question on 29 Apr 2019 12:53 PM
My Badges

Question Status

Unanswered

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?

Reply
Carolyn Froton responded on 29 Apr 2019 3:33 PM
My Badges

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

Reply

SBX - Two Col Forum

SBX - Migrated JS