Vendor Invoice line distribution and Vendor Payable issue

(0) Share

Report

Posted on by Community Member

I have created an invoice from PO. There is 1 invoice line with value 66,000. But the distribution went wrong and the amount doubled to 132,000/- Also the vendor balance is incorrect. I have attached 3 screen shots showing the invoice, its distribution and the voucher. Please help me in investigation the issue that how it was possible to post such entries.

3021.1.PNG

4186.2.PNG

7711.3.PNG

*This post is locked for comments

I have the same question (0)

All responses (32)

Answers (2)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Mudassar Hassan,

Is this the first time you experience this?

Can you replicate it in a demo machine?

Do you have any additional information on the PO, item, etc. that was purchased?

Best regards,

Ludwig

Was this reply helpful? Yes No

Community Member on at

Like (0)

Report

No, I find the same behavior in all Invoices generated from PO with items which are stocked and are fixed assets. Please see the below voucher transactions against an invoice for the demonstration of the subledger entries generated for an invoice with Purchase Order and the line items where stocked and fixed assets. The Material is also received against the PO. The vendor balance (payable) against this invoice is 190,600.00 and is shown correctly in the vendor transaction however if I view the voucher transactions details in the subledger shows the payable account to be 381,200 (which is 190600 * 2 )

Can you help me in understanding these transactions. ???

Journal number	Ledger account	Currency	Amount in transaction currency	Amount	Posting layer	Description	Posting type
IPA-022907	57041008-Intech PK-005-800000000-301-407-2004	USD	0.00	-0.01	Current	Vendor invoice	Penny difference in accounting currency
IPA-022907	57041007-Intech PK-005-800000000-301-407-2004	USD	0.00	0.00	Current	Vendor invoice	Penny difference in reporting currency
IPA-022907	35310010-Intech PK-005-800000000-301-407-1665	PKR	96,800.00	926.76	Current	Vendor invoice	Purchase, accrual
IPA-022907	35310010-Intech PK-005-800000000-301-408-1792	PKR	93,800.00	898.04	Current	Vendor invoice	Purchase, accrual
IPA-022907	11200001-Intech PK-005-800000000-301-407-1665	USD	-926.76	-926.76	Current	Vendor invoice	Product receipt
IPA-022907	11200001-Intech PK-005-800000000-301-408-1792	USD	-898.04	-898.04	Current	Vendor invoice	Product receipt
IPA-022907	35010001-Intech PK-005-800000000-301-407-2004	PKR	-381,200.00	-3,649.59	Current	Vendor invoice	Vendor balance
IPA-022907	11060001-Intech PK-005-800000000-301-407-1665	USD	1,853.52	1,853.52	Current	Vendor invoice	Fixed assets, debit
IPA-022907	11060001-Intech PK-005-800000000-301-407-1665	USD	1,853.52	1,853.52	Current	Vendor invoice	Purchase, inventory receipt
IPA-022907	11060001-Intech PK-005-800000000-301-407-1665	USD	-1,853.52	-1,853.52	Current	Vendor invoice	Purchase expenditure for product
IPA-022907	11060001-Intech PK-005-800000000-301-407-1665	USD	-1,853.52	-1,853.52	Current	Vendor invoice	Fixed asset issue
IPA-022907	11060001-Intech PK-005-800000000-301-407-1665	PKR	193,600.00	1,853.52	Current	Vendor invoice	Purchase expenditure for product
IPA-022907	11060001-Intech PK-005-800000000-301-408-1792	USD	1,796.08	1,796.08	Current	Vendor invoice	Fixed assets, debit
IPA-022907	11060001-Intech PK-005-800000000-301-408-1792	USD	1,796.08	1,796.08	Current	Vendor invoice	Purchase, inventory receipt
IPA-022907	11060001-Intech PK-005-800000000-301-408-1792	USD	-1,796.08	-1,796.08	Current	Vendor invoice	Purchase expenditure for product
IPA-022907	11060001-Intech PK-005-800000000-301-408-1792	USD	-1,796.08	-1,796.08	Current	Vendor invoice	Fixed asset issue
IPA-022907	11060001-Intech PK-005-800000000-301-408-1792	PKR	187,600.00	1,796.08	Current	Vendor invoice	Purchase expenditure for product

Was this reply helpful? Yes No

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Mudassar Hassan,

What do you mean by items that are stocked and that are fixed assets?

The standard fixed asset module has only a basic but not a comprehensive integration into inventory.

Do you make use of an ISV solution?

Can you explain a bit more about those stocked & fixed asset items and the process flow?

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I mean the items being procured in this PO have item modal as (stocked). These items were also checked as Fixed Asset in PO.

No there is no ISV solution. Its default AX with no customization.

The only issue with me is the voucher entries being generated automatically. They are duplicated and even setting the vendor balance doubled as shown in the transaction details shared above

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

Like (0)

Report

Hello Mudassar Hassan,

The voucher that you posted (ending 22907) does not match with the screenprints you showed above.

Can you also post some screenprints of the PO to which voucher ...22907 belongs to?

In addition, do you know if more than a single value model is used?

I would also be interested in your Accounting currency and the currency that is used for the PO to which voucher ...22907 belongs to.

Many thanks,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Please see the screen shots of the invoice. Single modal group is used in this PO. The last image shows the configuration of item modal setup for the item used.

In addition, I have read some blogs and internet, Isn't it due to some accrued purchase expenditure, uninvoiced etc. ???

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

Like (0)

Report

Hi,

From the voucher and PO that you showed above, I cannot identify a problem.

For a better understanding I highlighted your voucher lines as follows

* Grey: They offset each other and can be ignored (except for the 0.01 rounding difference)

* Yellow: Those lines offset the packing slip transactions. If you check your packing slip voucher in addition, the total Balance on those accounts should be $0.

* Green: The green lines represent the receipt and issue of the item in your inventory. The item goes 'in' and directly 'out' to your fixed assets

* White: What remains are the white lines, which debit your fixed asset and credit your vendor. From an analysis of the USD amounts, I cannot see an issue.

What about the PO with the $66000 that you mentioned in the very beginning? Can you try to analyze it the same way and share the complete screenshots if you see a problem?

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Yes it is the same case.

But still I am confused why the vendor balance is 381,200 PKR, it should be 190600, as you can see in the screenshots showing the total PO and Invoice amount to be 190600

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Mudassar Hassan,

What I can see is that the first computer is purchased for 1853.52 USD or 193600 PKR.

The second one must be purchased for 1796.08 USD or 187600 PKR.

If you add up the PKR amounts, you arrive at the 381200 PKR.

What I can't tell you if an exchange rate of 104.45PKR/USD is correct but from a system perspective, I cannot see a problem.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thats the problem, everyline is doubled somehow. see the attached PO lines. The first computer is 93,800 PKR and second is 96800 PKR

Was this reply helpful? Yes No