Dual posting of invoices in GL for Fixed Assets.

(0) Share

Report

Posted on by ERP Doctor

Dear All,

When fixed asset is acquired through purchase order and invoice of such purchase order is posted it shows twice in GL Account. Upon scrutinizing further I have found that same GL Account is debiting twice one time with Fixed Assets, debit and one time with Purchase, Inventory Receipt. Image is also attached here.

Need solution how to rectify this for future and also what should be done for transactions already posted.

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (2)

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Hi Abbas, Can you show us a screenshot of your voucher that has been created? Especially the Transaction origin form would be great to see. Thanks, Ludwig

Was this reply helpful? Yes No
ERP Doctor 42 on at

Like (0)

Report

Hi Ludwig, Thankful for your reply.

Below are images.

1) Transaction Origin 2) Account Statement (GL) 3) Purchase Configuration

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Hello Abas,

The first screenprint shows that the fixed asset has been acquired once :-)

What astonishes me is the tranaction on the account 9999999... What account is that? An error account?

In addition, your second screenshot says "books" but I cannot identify those books. Can you click on the value model tab of your fixed asset and let us know whether more than one value model (book) is used?

Can you also please check the Setup of your value models and identify whether there is something Setup in the derived value model tab?

Ludwig

Was this reply helpful? Yes No
ERP Doctor 42 on at

Like (0)

Report

Thankful for your such nice support in figuring out why twice invoices are being posted in GL Account for Books.

Following are screen shots to take further guidance from you.

Screen Shot 1. 99999999 is configured in inventory Issuance Account, Is this correctly configured ?

Screen Shot 2. Value Model, I think it is correctly configured. What is your opinion. I have now Removed this (acquisition) shown in derived as well.

Waiting Guidance....

How we can remove this dual posted effect ?

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

Like (1)

Report

Good morning Abbas,

One more question; the purchase order that was created for the purchase of the fixed asset, what did it include in the lines? A Service item, an ordinary stocked item or a procurement category. Can you find out and let us know how the inventory model Group for the item is setup?

Ludwig

Was this reply helpful? Yes No
ERP Doctor 42 on at

Like (0)

Report

Good Morning !

It included a Procurement Category i.e. Books

It is a Weighted Average (Item Model Group)

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Hello Abbas,

I replicated your process with a similar setup item that I purchased through a purchase order. Based on that process and the postings created I think that your postings might be correct. Probably try to compare your transactions with the followings that I got genereated. Hint: include and compare the transaction type and posting type.

Here the invoice voucher:

Here the Transaction origin

Another hint: Export the packing slip voucher and the invoice voucher to Excel and take a look at the transactions created. In my example, I highlighted the packing slip voucher transactions that get reversed when the invoice is posted in Grey Color. The invoice receipt and issue transaction is highlighted in yellow. All lines that have a Color Offset each other and Balance to 0,00 $.

What remains in my example is a transaction that debits my fixed asset account and credits the vendor balance.

Please double check with your transaction. I believe they might be correct.

Would be great hearing back again from you.

Best regards,

Ludwig

Was this reply helpful? Yes No
ERP Doctor 42 on at

Like (0)

Report

Hello My Mentor,

It is really appreciating, the way you are trying to solve my problem. Bundles of Thanks Brother.

According to guided steps I have thoroughly investigated every thing seems fine but still not figuring out why GL Account for BOOKS is showing Double Entries with same Amount.

Sending you images having Posting Type, if we see complete voucher it identifies that my GL Account 40101010009 is hitting twice which is only configured for Fixed Asset(Debit) but here is also used in Purchase(Inventory Receipt) so GL Account showing dual debit... ?

I am sending three images below for more clarity. 1) Voucher including Posting Type 2) Configuration showing separate account for Inventory Receipt and Fixed Asset Receipt3) Ledger Account Statement showing dual debits from Vendor Invoice everything in these both are same if we open voucher and go to transaction origin.

Have you also generated GL main account report for your Main Account and verified entries are hitting twice in it like mine, is this correct ?

Lot of good wishes,

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Hello Abbas,

Can you check and test one more thing in the inventory module under setup-posting-posting.

The ledger account that you setup in the purchase tab for the fixed asset purchase transaction and the ledger account in the inventory tab in the fixed asset issue section, are those the same accounts?

They should be identical in my opinion.

If you have different accounts Setup there can you test changing that and use a briging account that is not included in your fixed asset posting profile?

Ludwig

Was this reply helpful? Yes No
ERP Doctor 42 on at

Like (0)

Report

Bravo !

Thanks Brother, following result achieved. Now also need your guidance, how to rectify previously posted countless entries who have only their twice debits ? Any clues ?

Was this reply helpful? Yes No