Query manager yellow arrow for docnum from QIPF

[Risky_Biscuits]

Hi,

I created a query on Query Manager, to pull DocNum from QIPF (Landed Costs).
Somehow the Yellow Arrow, when clicked always pointed to the document in the year 2017. 

So far I haven't encountered this issue for DocNum on Sales Orders or other documents.                  

Any clues or advice?

SAP Business One 

[SonTran]

Share your query, please

[SonTran · Accepted solution]

Hi,

The query is ok but you need to check document numbering for Landed Cost. You may defined same document number for multi period (restart numbering).

For example:

2017: 1 >>> 9999

2024: 1 >>> 9999

In this case, It is better to use Internal Number instead of Document Number for Drill Down.

Hope this helps,

SonTran

[Risky_Biscuits · Accepted solution]

Hi,

Now it makes sense why my other documents have no issue with it.
Yes, we do have the numbering reset for this document.

Guess nothing can be done via the query. It's just how the yellow arrow works.