AccPac Drilldown 2

[pellj001]

How do you drill down from the GLPost table to the AR or AP entry?
I am interested in drilling down receipts and payments only.


thanks

 

[ettienne]

GL Accounts, Transaction History. Find the transaction and double click to the GL Entry screen. Click the drill down button on the right of the Entry Number.

 

[pellj001]

Thanks, but it is not the way I intended.
I need a way to drill-down using the tables/queries in AccPac. I need to know what fields must be used or linked to get such a drill-down.

 

[ettienne]

GLPOST.DRILLAPP and GLPOST.DRILLDWNLK

 

[ettienne]

The GLPOST.DRILLDWNLK field is parsed as follows:
1st digit = width of posting sequence number
2nd digit = width of batch number
3rd & 4th digits = posting sequence (starting at position 3)
5th & 6th digits = batch number (starting after Posting Sequence)
Remaining digits = entry number