G/L Entry No. = Vendor Ledger Entry No.

Methos

Hi,

I heard somewhere that the G/L Entry No. and Vendor Ledger Entry No. will always be the same.

Can someone confirm this or was my source mistaken?

I tested the theory on a database , and it actually worked for random test cases. Maybe just coinsidance

nunomaia

There isn’t such relation between those entry numbers. You can try to mat it using document No. and posting date.

tinoruijs

I think it are not coinsidances. Because I noticed it too.
They correspond indeed.

Methos

I spoke to some other people,
And they agree that it is only coinsidance since, for auditing puposes, the Vendor, customer and gl entries has to be in sequince, and thus it will not be possible for all three to correspond.

Document No. is the lnk between theese entries

nunomaia

tinoruijs wrote:

I think it are not coinsidances. Because I noticed it too.
They correspond indeed.

If you are right. :oops:
G/L Entry matching vendor account number matches vendor ledger entry no.

But this shouldn’t be the way to link those records. I guess.

tinoruijs

nunomaia wrote:

tinoruijs wrote:

I think it are not coinsidances. Because I noticed it too.
They correspond indeed.

If you are right. :oops:
G/L Entry matching vendor account number matches vendor ledger entry no.

But this shouldn’t be the way to link those records. I guess.

I agree this isn't the way to link them. Document No. and Posting Date is the way.

I just noticed G/L Entry No. and Customer Ledger Entry No. also correspond. :-k

tinoruijs

Methos wrote:

I spoke to some other people,
And they agree that it is only coinsidance since, for auditing puposes, the Vendor, customer and gl entries has to be in sequince, and thus it will not be possible for all three to correspond.

What are auditing puposes? :?:

Methos

When the componies Books are audited,

tinoruijs

Methos wrote:

When the componies Books are audited,

Ok.
I think that vendor, customer and gl-entries do not have to be in sequence for auditing purposes.
Invoice numbers do, but entries don't.

bbrown

The combination of "Document No." and "Posting Date" is not unique in either Customer or Vendor Ledger.

The "Entry No." of Customer or Vendor Ledger will always match its corresponding G/L Entry No. for the AR or AP account.

nunomaia

bbrown wrote:

The combination of "Document No." and "Posting Date" is not unique in either Customer or Vendor Ledger.

I know that option doesn’t give 100% guarantees of matching G/L Entries, but it’s a possible solution.

bbrown wrote:

The "Entry No." of Customer or Vendor Ledger will always match its corresponding G/L Entry No. for the AR or AP account.

In posting routines those accounts are using the same G/L entry no.
I have noticed that with this post, always learning.
I wonder if this will be keep in future versions, since it’s a relation that isn’t documented, or I never have seent it documented.

nunomaia

bbrown wrote:

The combination of "Document No." and "Posting Date" is not unique in either Customer or Vendor Ledger.

I know that option doesn’t give 100% guarantees of matching G/L Entries, but it’s a possible solution.

bbrown wrote:

The "Entry No." of Customer or Vendor Ledger will always match its corresponding G/L Entry No. for the AR or AP account.

In posting routines those accounts are using the same G/L entry no.
I have noticed that with this post, always learning.
I wonder if this will be keep in future versions, since it’s a relation that isn’t documented, or I never have seent it documented.

Methos

The Document no. and posting date is used for the navigate filters, but it wont always give a one to one relation.

I went through the Gen journal posting routine, and this uses one global variable to store the next entry no., for all Ledger tables, this implies, it seems that the entry no. will have to correspond between these tables.

But how do I match a Single G/L entry to a vendor ledger entry. 1-1?

tinoruijs

bbrown wrote:

The combination of "Document No." and "Posting Date" is not unique in either Customer or Vendor Ledger.

It can be unique if you define the document numbers unique.
But you have to do that, otherwise you can delete form 344 Navigate.

tinoruijs

Methos wrote:

The Document no. and posting date is used for the navigate filters, but it wont always give a one to one relation.

I went through the Gen journal posting routine, and this uses one global variable to store the next entry no., for all Ledger tables, this implies, it seems that the entry no. will have to correspond between these tables.

But how do I match a Single G/L entry to a vendor ledger entry. 1-1?

I think you just gave the answer yourself; for all Ledger tables, this implies, it seems that the entry no. will have to correspond between these tables.

If you have a single g/l entry, just try a get to the vendor ledger entry with the same entry no.

Methos

Yes, this seems to be the solution.

But it seems there are some, confusion if this is correct. I think I will accept bbrowns explination since the code supports this.

Thank you all for your help.
=D>

tinoruijs

Methos wrote:

Yes, this seems to be the solution.

But it seems there are some, confusion if this is correct. I think I will accept bbrowns explination since the code supports this.

Thank you all for your help.
=D>

And thank you for you're input!
Like Nuno said; leared something again today!