Error posting product receipt - transactions on voucher do not balance

(0) Share

Report

Posted on by Community Member

When attempting to product receipt a Purchase Order, an error appears - "The transaction on voucher do not balance as per [date] (accounting currency: xxx - reporting currency: xxx).

I confirmed the order, but when attempting to receive the items via the Product Receipt feature, the error appears.

ProductReceiptPostingError_2D00_VoucherTransactionDoNotBalance.PNG

Checks made in the General Ledger > Periodic > Currency Conversions > Ledger accounting currency conversion as well as Ledger reporting currency conversion shows that the same currency is used.

Also, checks in the General Ledger > Set Up > Ledger also shows the same currency.

I am not certain if I am in the right place to try to resolve. Can someone guide me on a possible solution?

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

André Arnaud de Cal... 301,049 Super User 2025 Season 2 on at

Like (0)

Report

Hi tntc,

When the currency is the same, you don't have to setup the reporting currency. Can you check if the correct posting setup has been made for inventory posting and accounts payable? Is this amount the full PO amount, or just related to one item or probably sales tax?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

Is this the first PO that you record and where you see this error?

Sometimes the AP posting profile is not setup/changed in the AP parameters form. Please check this setup to ensure that it is not wrong/missing.

In addition, please check the things Andre mentioned.

If nothing else seems to help, have a look at LCS to ensure that this is not caused by a bug for which a hotfix has been released.

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Regarding the currency. The system does not allow me to edit the reporting currency (so I cannot remove it). Inventory posting is set up. I am not certain where in Accounts Payable the inventory has to be set up again (any guidance?). I've created just one PO (which was automatically created from the Purchase Requisition Workflow), with one line item. I confirm the PO, but when I attempt to Product Receipt that PO, the error appears.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Just to confirm, in Accounts Payable, the "Post product receipt in ledger" is checked

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Yes. I've posted Product Receipts before and received no error. Now that I am attempting to post the item on the PO line into Inventory, this error appears.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

Does the PO have a posting profile selected in the PO header?

If so, can you also check that a summary account has been created for your vendor/group?

Do you see the same problem in a different demo or test environment?

Best regards

Ludwig

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Thanks Andre. You pointed me into the right direction. The Sales Tax was missing in the product definition. When I added the Sales Tax to the product, the error was gone. Most importantly, I was able to see the product updated in the Inventory!

Was this reply helpful? Yes No