how can we separate On-Account invoice number sequence from original invoice number sequence

(0) Share

Report

Posted on by SMAQ

Dear Experts,

We need to book the Accrued revenue for partially completed projects. We are using on-account transaction for transaction type prepayment journal voucher in Time & Material project to record accrued revenue & post it from Invoice Proposal to effect it in our accrued sales revenue account.

At the time of actual invoicing to the customer the same we are reversing the accrued revenue transaction by selecting Credit note. Then posting the actual invoice from Invoice Proposal

My question is whenever I am passing the entry for on-account transaction, system is not generating the number sequence from On-Account invoice nor Credit note from On-Account Credit Invoice. But generating it from original Invoice number sequence.

Can you please let me know how can we separate On-Account invoice number sequence from original invoice number sequence

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Suggested answer

SMAQ 17 on at

Like (0)

Report
Copy link

Link copied!

how can we separate On-Account invoice number sequence from original invoice number sequence

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi SMAQ,

Why is it that you post accured revenue through an on-account transaction.

Can you share the transactions that you post / expect to have posted?

Most companies I dealt with post the on-account transactions on balance sheet accounts and decuct the on-accounts made with the final invoice.

Would be great if you could specify more details of your business requirement and share the transactions you expect to see.

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
SMAQ 17 on at

Like (0)

Report
Copy link

Link copied!

Dear Dr. Ludwig,
Thanks for the reply, our business requirement is to record revenue before we actual invoice to the customer because of two reasons firstly we have many job in one project and sometimes we need to outsource some jobs to which we cannot delay the payment to our vendors and secondly our management want to see Project wise monthly profit & loss statement. For these reasons we are trying to adopt this on-account transaction feature of Dynamics AX. But in this case we are not getting the number sequence from on-account invoice nor on-account credit number sequence. Please let us how & when system will generate on-account number sequence.
Also, I would appreciate if you have any better suggestion other than this.
Thanks & Regards,

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi SMAQ,

If you really want to have a separate number sequence then you will end up with a system modification.

I do not consider this as necessary especially if you use separate accounts for your on-account transactions.

Another and possbily easier functionality is the accrue revenue functionality that allows you getting accrued revenue posted at the time costs are posted.

As an example, you record $500 project expense and $800 accrued revenue is posted.

The $800 depend on the sales price.

At the time the invoice is posted the accrued revenue is reversed and replaced with the realized revenue, which is posted on a different account.

to realize this, you have to enable the accrued revenue parameters in the line property form and setup the respective accounts in the posting form.

Would be great if you could test this setup and let us know if this works for you.

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

OsmanIstanbul 2,818 on at

Like (0)

Report
Copy link

Link copied!

Hello SMAQ

Can you check 'use same number as' field on project parameters / number sequence setup. If there is a number sequence id on on account row, clean it.

Best regards.

Osman.

Was this reply helpful? Yes No
SMAQ 17 on at

Like (0)

Report
Copy link

Link copied!

Dear Dr. Ludwig,

Thanks for the reply, I tried both the scenarios in both the scenarios we need to have separate number sequence. Can you please let us know purpose of On-Account Serial number and how and when it is used. because even I am generating On-account Invoice, it is taking Serial number sequence from Invoice but not On-account invoice. If this gets solved, I will have my solution

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

The number sequences that end with ... voucher are used for generating internal voucher numbers that allow accountants a reference to this posting.

This is similar to what you might be used to from GL journals where a voucher number is created for each transaction entered in a GL journal.

The other number sequences highlighted are for the documents.

In your case the on-account invoice / credit note document that is printed and that can be send to the customer.

Tipp:

Just try to setup all possible number sequences in a test/demo environment to verify what number sequences are used in your processes and where you might need an additional / different sequence.

Best regards,

Ludwig

Was this reply helpful? Yes No