Unable to post the Customer payment Journal for the billed project invoice (Time and material Project)

(0) Share

Report

Posted on by Sandesh boloor

Hi,

I have created a simple Time and Material Project with no billing rules. In the first step, I created a customer advance payment and invoiced it (No payment journal posted). Then, posted the Hour,Expense, Fee and Item journal. Then did the Invoice proposal and was able to see all the posted entries (Hour,Expense, Fee and Item) and settle with the customer advance amount posted initially (deductions). So, I have two payments to receive now, One is the advance amount posted and later the other invoice for all the actual expense (Hour,Expense, Fee and Item) invoiced.

Now, I am trying to receive the payment from customer. In the first step, I tried to settle both the transaction i.e. the Advance amount and the actual Invoice. System didn't allow to post the transaction and just locked the journal batch number without any error log.

In the second step, I tried to post the payment journal only for the Advance payment using settlement functionality then system posted the transaction.

Now the problem is for the Invoiced amount, I am not able to post the payment journal using settlement functionality and system doesn't even show the error log, It just locks the journal batch number.

Please let me know is there any solution available.

Regards,

Sandesh

Categories:

Financial Management

All responses (4)

Answers (0)

Sort by

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Sandesh,

I am not 100% clear with the steps you made. What I got is the following:

1.) Post an on-account invoice

2.) Post hours, expenses, etc.

3.) Invoice the hours, expenses, etc. and deduct the on-account

=> Why do you deduct the on-account already if the customer has not made the payment?

4.) Post customer payment.

=> What payment do you post here? The payment of the on-account invoice from step 1 or the payment of the invoice from step 3?

It would be grat if you could provide more details on the payments that you have posted and settled or tried to settle.

Many thanks and best regards,

Ludwig
Sandesh boloor 88 on at

Like (0)

Report
Copy link

Link copied!

Hi Ludwig,

Thanks for your reply.

Yes, I am trying to post the payment journal for the Step 1 and Step 3. When tried to Settle both Step 1 and Step 3 at a time system won't allow to post. But when tried to settle only Step 1 system allows to post. But not for the Step 3.

Let me explain the steps I followed.

1. Created a Time and material project and assigned a Project contract (No billing rule defined).

2. Requested for a Customer Advance payment.

3. Posted the Invoice proposal for the above advance payment.

In on-account transactions form, we can see 2 Transaction types created after posting the Customer advance payment.

A. Transaction origin: Prepayment journal voucher, Invoice status is fully invoiced. (Customer balance has increased, but not posting the payment journal as of now and continuing to post the Expense,Fee,Hour Journal ).

B. Transaction origin: Deduction, Invoice status is Chargeable.

4. Posted Hour, Expense and Fee Journal.

5. Now executing the Invoice proposal.

In the above snapshot it sows all the expense transaction types.

In the above snapshot it shows the deductions, (Please note: I have not posted the payment journal for this amount)

So, Below is the Invoice proposal screen for which I am Posting the invoice and recognizing the revenue.

Below are the posted Transactions and its Invoiced Status:-

Now I am trying to post the Customer payment Journal and settling both the Invoice open:

Below are the Two open Invoice One is for the Customer Advance payment of 10,000$ and other is the Expense total 427,000$ :

While Posting Below is the Error "Operation canceled: Validating and Posting Journal" and eventually it Locks the Journal batch.

Now, I am trying to Unlock and select only the Customer Advance payment of 10,000$.

Here system allows to post the transaction without any error.

Now I am trying to Post the payment journal for the other Invoice 427,000$

Here is the Problem, I am unable to post the payment journal for this Invoice.

Am I missing something here.

Regards,

Sandesh
Monica Romano 10 on at

Like (0)

Report
Copy link

Link copied!

We are having the same issues so following post for an answer.
Ankit Pratik 102 on at

Like (0)

Report
Copy link

Link copied!

Hi Sandesh,

Greetings!!

Did you get a solution for this?

I am also facing similar issue.

Thanks & Regards

Ankit Pratik