Net/Gross amount entry on AR invoices and AP bills respectively

Hello @shuang57,

The Net/Gross Entry Mode feature enabled on the Enable/Disable Features (CS100000) form, gives users the ability to specify the tax calculation mode, which the system will use for computing a tax amount in a document, when you enter a document in the system manually. Depending on the specified mode, you can enter either tax-inclusive amounts at the line level or the document level, or tax-exclusive amounts at the line level or the document level. You will also be able to activate the tax amount validation functionality in a document that you enter.

With this feature enabled, the Tax Calculation Mode field becomes available on document forms, such as Invoices and Memos (AR301000):

For more information, refer to the Managing Taxable Documents help page.

So that, as an option, a tax can be configured with the Exclusive calculation rule:

And on the Invoices and Memos form, the Tax Calculation Mode can be manually set to Gross, meaning that the tax amount is included in the item price.

In order not to manually assign the Tax Calculation Mode setting in each AR document, this setting can be configured on the Customers form, and this value will be defaulted in AR documents.

For newly created customers, the Tax Calculation Mode is transferred from the customer class.

Hi Julia

I am using the above setting for Purchases and make use of Gross for the supplier's that quote price with vat inclusive. When doing the PO receipt, Acumatica rights the full unit cost (incl Vat) into stock. That is wrong. It should strip out the Vat. This leads to overstating stock value. When you match the Bill it treats it correctly, but because of the mismatch between GRV value and Bill value, the difference goes to PPV.

Please let me know if I am missing something, or Houston do we have a problem?

Hi apretorius62,

We have the same issue about the Inventory cost on Purchase Receipt. I’d like to ask if you already have the answer for this?

Thank you!

Hi

Their last reply was that it is a bug and its under review. I will follow up.

Thank you. I appreciate your response.

You welcome, bug is "in development” with no ETA yet. 

Hello apretorius62,

May I ask what Acumatica version and build you were using when this issue arose?

Hi

23R2 build 6

Hi apretorius62,

Just to share you, we found out that in order to recognize the net of VAT in PR, you need to set the VAT in first row under Taxes Tab in PO. 

Thank you for the info.

I will try it.

I would like the system to apply that, since the PO contains it, and the PR is based on the PO.

Hi ​@apretorius62, did you ever get a resolution on this? i.e., did it ever come out of development?

Hi Brendan

It has been fixed if the transaction starts at PO level. But when you start the transaction at Receipt level, ie without a PO, then its still a problem. its with development.

Hi ​@apretorius62,

Do you have a link to the dev ticket that I can follow so I could keep up with it as well? Also do you know what version the fix was included in?

We also noticed that switching between the two tax calculation modes also impacts the total commitment shown on the Projects screen, i.e., if the supplier has a gross calculation mode that the project commitment goes through as VAT incl (not expected), but the transaction goes through as VAT excl (which we would expect). Is that issue on the dev ticket as well? 

Kind regards,

B