cancel
Showing results for 
Search instead for 
Did you mean: 

Query manager yellow arrow for docnum from QIPF

Risky_Biscuits
Explorer
0 Kudos
235

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.                  
Screenshot 2024-09-19 155714.jpg

 

 

 





Any clues or advice?

SAP Business One 

SonTran
Active Contributor
0 Kudos
Share your query, please
View Entire Topic
SonTran
Active Contributor

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
Explorer
0 Kudos

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.