Small and medium business | Business Central, N...

Unable to Post Deposits - Sales Invoice Header Issue

(0) Share

Report

Posted on by Cromwewc

Hi,

We just went into production and have successfully posted two deposits - however, when doing a 3rd one (a week later) we are getting an error stating the sales invoice number doesn't exist. Its as if its mixing up payment document number to be invoice document number now. Any ideas?

There are two new customers in this batch but I took them out and the error still came up.

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hello,

Need a little more detail. So you are on a Cash Receipts Journal or Deposits page, you enter the Customer No. and Check Number, and you click Apply Entries and select those documents, for the Customer, to apply too. Are these your steps? Or are you click Applies-to Document Type = Invoice and then drilling into the Document No. field to locate the document? Note that the Apply to documents are posted invoices or credit memos. They are not open records unposted.

Invoice document Numbers are unique with BC and relate to the Customer it was posted against. A Payment Type Document No., like Check No., is unique to the Customer/Payment Type and the Document No. itself might duplicate but you should not have the issue you are noting.

Please email back more information.

Thanks,

Steve

Was this reply helpful? Yes No
Cromwewc on at

Like (0)

Report
Copy link

Link copied!

Hey thanks,

I am on Deposit page -

Selecting Account type - Customer (and then entering customer info)

Document Type - Payment

Document Number - (entering the) Check Number

Not entering anything regarding applies to at all - just the payment

Trying to post the deposit and that error comes up as if its conflating payment document number with a sales order number that doesn't exist

Was this reply helpful? Yes No
Cromwewc on at

Like (0)

Report
Copy link

Link copied!

A little more info:

This issue is happening on the Deposits page, Cash Receipts Journal, and General Journal.

Ultimately, we are trying to record receiving money from a customer WITHOUT having to apply it to an existing Sales Document in the system. In other words, we want to add an open/unapplied entry to the Customer Ledger that we can apply to one or more invoices at a future date.

The exact error message is: The Sales Invoice Header does not exist. Identification fields and values: No.='45689' ; Context: Gen. Journal Line: CASHRCPT,CHECKING,10000

No. =’45689’ is referring to the document number we enter and is intended to refer to the check number that is on the check we received from the customer.

And we have previously successfully posted 2 deposits with the same manner (not applying to any document)

It also says the table (DEFAULT) table ID doesn’t match on the deposit

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hello,

OK, so I create a Deposit and want to leave the payment on-account and not apply. You get an error when try to post. Here is my test in CRONUS. BTW - please test in CRONUS you get the same thing to rule out any customizations.

Here is a screen shot that the Document No. is a real document under the Customer or any Customer:

I am NOT applying the payment to anything. and click Post and it posted.

The Document No. field does not look at Posted Documents (i.e. Invoices). I would test in CRONUS but it seems you have either a customization or something else causing the issue. If this works in CRONUS, I would contact your Partner to debug and resolve.

Thanks,

Steve

Was this reply helpful? Yes No
Cromwewc on at

Like (0)

Report
Copy link

Link copied!

Unfortunately its also happening in Cronus

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hello,

May I ask on the Deposit Line, what is your Document Type? Is it Payment?

Thanks,

Steve

Was this reply helpful? Yes No
Cromwewc on at

Like (0)

Report
Copy link

Link copied!

Yes - Payment

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hello,

Wow, this is utterly strange. I cannot make this happen in my CRONUS play company. I would recommend that you contact your Partner to debug the issue and resolve.

Thanks,

Steve

Was this reply helpful? Yes No