Location On Hand is the Quantity currently stocked, including Quantity Committed. This includes the item quantity in the transactions. If the back-ordered item in a sales order is fulfilled, then the same item quantity will be decreased from the “Location on Hand” quantity. So even if the SO is fulfilled and billed, the quantity difference… Continue reading Location On Hand Quantity shows negative value even if all the related sales orders are in “Billed” status.
Author: Anila George
Status of Closed Purchase Orders
Scenario 1: The Purchase Order contains Expenses only Navigate to Transactions > Purchases > Enter Purchase Orders > ListClick View by the Expense-only Purchase OrderClick Close buttonPurchase Order Status: Fully Billed Scenario 2: The Purchase Order contains Items only Click View by the Items-only Purchase OrderClick ClosePurchase Order Status: ClosedNote: If the Purchase Order is… Continue reading Status of Closed Purchase Orders
Error Message: “Invalid account reference key 548 for subsidiary 12” on Journal Import
During journal import, may get this type of error message. This is due to the subsidiary specified in the error message does not include in the account. Locate the COA with the specified internal ID Edit the COA record. add the subsidiary in the subsidiary selection box. Then import the journal
Dealing with the error message: ‘The Subsidiary in the first line is restricted to From Subsidiary’
When trying to create an advanced intercompany journal entry, may encounter an error message like “’The Subsidiary in the first line is restricted to From Subsidiary’”. Using an advanced intercompany journal entry, you can specify the originating subsidiary and multiple receiving subsidiaries for the journal entry. That is, we can include multiple To Subsidiaries. Then… Continue reading Dealing with the error message: ‘The Subsidiary in the first line is restricted to From Subsidiary’
CSV Import error – The Due To/From Subsidiary for the From Subsidiary lines must be one of the other subsidiaries used in the transaction.
When importing advanced Intercompany Journal Entries, the user may get this error message. While importing Advanced Intercompany Journals, include a column “Eliminate” in the Import file. This Eliminate column should be populated as either “YES” or “NO”. For the Intercompany accounts at the line level, we should select the “Eliminate” checkbox as “Yes”. Then in… Continue reading CSV Import error – The Due To/From Subsidiary for the From Subsidiary lines must be one of the other subsidiaries used in the transaction.
Replace transaction sublist via CSV Import
Scenario: The requirement was to completely update the transaction expense/item lines as it was created with incorrect data.Solution:– Prepared CSV import file with the correct expense line data.– Add a column for Line ID.And fill the column starting from 1 for each line that belongsto one record. That is if one record has 3 item… Continue reading Replace transaction sublist via CSV Import
Not shows some Tax Codes in Transaction Item lines
In transaction records, we can select tax codes at the item line level. These tax codes come from the entity of the transaction. For example, in a sales order, the tax code depends on the customer record. To be precise, it depends on the country of the customer address. That is the Tax code is… Continue reading Not shows some Tax Codes in Transaction Item lines
The Item Subsidiary is not able to Update
An error message shows when the item subsidiary edits to set parent-subsidiary and marks the “Include Children” checkbox as True or sets multiple subsidiaries. The error message looks like this – “The subsidiary restrictions on this record are incompatible with those defined for the location. Subsidiary access on this record must be a subset of… Continue reading The Item Subsidiary is not able to Update
Inline Editing Not works for Transaction Saved Search
Issue: Inline editing does not work for transaction saved search even after the feature is enabled in the account. Possible reason: NetSuite supports only inline editing for saved searches with only one transaction type. If the user has 2 or more types selected, NetSuite will not allow the user to do Inline Editing. Select only one… Continue reading Inline Editing Not works for Transaction Saved Search
Add QR Code in Advanced PDF Template
codetype = qrcode Sample – <barcode codetype=”qrcode” height=”100px” showtext=”true” value=”Company Name:${subsidiary.name};VAT Number:${record.vatregnum};VAT Amount:${record.taxtotal};Grand Total:${record.total}”/> The data in the “Value” part will display when scanning the QR code. We can also give static values to the QR Code.