Issue: When looking at an invoice, the values for the unit price and quantity are incorrect or missing, while the amount field is calculating correctly. Additionally, Clicking “Download as PDF” will show all the items with their correct unit price and quantity values.
Issue described in this article typically arises when a sales order transaction form is used as the website’s invoice form, but there is no invoice form linked within the “Linked Forms” tab of the sales order transaction form. See below for more details and steps to resolve.
- Navigate to the Checkout Preferences Section in the Website Record, located in the Shopping Tab (SuiteCommerce) or Registration and Payment (My Account) . Note the name of the form in the invoice form if the issue is on the invoice tab in My Account, or the credit card form if it is on the purchase history tab. This form may be the same for both fields.
- Navigate to Customization > Forms > Transaction Forms
- Edit the Form found in the website record which is used on the web store
- Toggle the Printing Type to “Basic”
- Doing so will show the Printing Fields tab. The values in the Printing Fields tab will effect the form even if you are using an “Advanced” printing type and the tab is hidden.
- Go to the Printing Fields tab > Columns subtab
- Check the PRINT/EMAIL checkbox besides “Qty“ and “Rate”
- Toggle the Printing Type back to its original value and Save.
- Check the site to see if this update worked. The change should update on the site almost immediately.
- If you find that the print/email checkbox is already set or the change did not work, we need to dig one level deeper and check a different transaction form. Go to the Linked Forms Tab on the Transaction Form and you should see a list like this.
- Navigate to the expected culprit form. So if you are seeing this issue on the site in the Invoice tab on My Account, navigate to the linked invoice transaction form.
- If there is NOT a form set for the transaction type in the linked forms tab, then we need to set a form. So, if the invoice form field is empty, pick the appropriate invoice form from the drop down list and save. Now we will navigate to the newly linked transaction form you set under the linked forms tab.
- Repeat Steps 4-8 for forms until you find that the issue is resolved in the site. The change should update on the site almost immediately.
Upon completion of these steps, the quantity and unit price fields are now correctly populating.