Navigation Message

navuser1

Dear Sir,

I’m getting a message “This combination of document number and posting date has been more than once”
When navigating a Posted Purchase Invoice…

What is the reason behind it? Kindly reply.

ssingla

Check all the entries posted with the invoice. There must be multiple transaction numbers with it meaning either there is some bad customization or somebody have posted some manual transaction with same document number.

navuser1

How to segregate Posted Invoice data & manual transaction data (If any) ?? :-k :-k

ssingla

Transaction Number.

navuser1

Thanks.
Can you tell How to Segregate by the Transaction number ???

ssingla

Its a field in G/L Entry. You can also refer to G/L Register with the entry numbers to check whether they have been created in a single posting or otherwise.

navuser1

That's mean Single Posting creates Single Transaction No. Am I right ?

navuser1

Dear Sir,
I have varified that Transaction Made by a Single Posting (Purchase Invoive).

Plz see navigated Result in GL Entry of a Posted Purchase Invoice

ssingla

Where is transaction number field? Also why document type is not same in all the entries? Why more than 1 Vendor Payable account entries are created by the posting?
Also try using Debugger to identify why and where Navigate generates the duplicate message. AFAIK if 2 vendors/customers are posted in same document number it generates the messages.

navuser1

ssingla wrote:

Where is transaction number field? Also why document type is not same in all the entries? Why more than 1 Vendor Payable account entries are created by the posting?
Also try using Debugger to identify why and where Navigate generates the duplicate message. AFAIK if 2 vendors/customers are posted in same document number it generates the messages.

Plz see these


Debugger Screen

ssingla

The behavious shown by your system is not standard behaviour. You have applied/unapplied some transaction and standard db does not create message due to this.

navuser1 wrote:

Debugger Screen

Attachment:

IF DocExists THEN BEGIN
  IF (NoOfRecords(DATABASE::"Cust. Ledger Entry") + NoOfRecords(DATABASE::"Vendor Ledger Entry") <= 1) AND
     (NoOfRecords(DATABASE::"Sales Invoice Header") + NoOfRecords(DATABASE::"Sales Cr.Memo Header") +
      NoOfRecords(DATABASE::"Sales Shipment Header") + NoOfRecords(DATABASE::"Issued Reminder Header") +
      NoOfRecords(DATABASE::"Issued Fin. Charge Memo Header") + NoOfRecords(DATABASE::"Purch. Inv. Header") +
      NoOfRecords(DATABASE::"Return Shipment Header") + NoOfRecords(DATABASE::"Return Receipt Header") +
      NoOfRecords(DATABASE::"Purch. Cr. Memo Hdr.") + NoOfRecords(DATABASE::"Purch. Rcpt. Header") +
      NoOfRecords(DATABASE::"Service Invoice Header") + NoOfRecords(DATABASE::"Service Cr.Memo Header") +
      NoOfRecords(DATABASE::"Service Shipment Header") +
      NoOfRecords(DATABASE::"Transfer Shipment Header") + NoOfRecords(DATABASE::"Transfer Receipt Header") <= 1)
  THEN BEGIN

You should have looked why this condition is not fulfilled and the message is appearing.

navuser1

ssingla wrote:

The behavious shown by your system is not standard behaviour. You have applied/unapplied some transaction and standard db does not create message due to this.

navuser1 wrote:

Debugger Screen

Attachment:

IF DocExists THEN BEGIN
  IF (NoOfRecords(DATABASE::"Cust. Ledger Entry") + NoOfRecords(DATABASE::"Vendor Ledger Entry") <= 1) AND
     (NoOfRecords(DATABASE::"Sales Invoice Header") + NoOfRecords(DATABASE::"Sales Cr.Memo Header") +
      NoOfRecords(DATABASE::"Sales Shipment Header") + NoOfRecords(DATABASE::"Issued Reminder Header") +
      NoOfRecords(DATABASE::"Issued Fin. Charge Memo Header") + NoOfRecords(DATABASE::"Purch. Inv. Header") +
      NoOfRecords(DATABASE::"Return Shipment Header") + NoOfRecords(DATABASE::"Return Receipt Header") +
      NoOfRecords(DATABASE::"Purch. Cr. Memo Hdr.") + NoOfRecords(DATABASE::"Purch. Rcpt. Header") +
      NoOfRecords(DATABASE::"Service Invoice Header") + NoOfRecords(DATABASE::"Service Cr.Memo Header") +
      NoOfRecords(DATABASE::"Service Shipment Header") +
      NoOfRecords(DATABASE::"Transfer Shipment Header") + NoOfRecords(DATABASE::"Transfer Receipt Header") <= 1)
  THEN BEGIN

You should have looked why this condition is not fulfilled and the message is appearing.

Because NoOfRecords(DATABASE::"Vendor Ledger Entry") = 5.
There is so many customization in the DB