markbell10 · Solution Architect · Gold Medal

@Vishnu M I believe, because the invoice was created first, then you assigned the package to the customer, the necessary hidden field "e document package" on the transaction is not populated. If you were to create a new invoice, this hidden field is set and should allow you to select the template.

Hi @User_BVQ19 how are you processing these payments? Is it using the electronic bank payments feature, or otherwise?

Was the edoc package added to your customer before you created the invoice? The field in your image filters based on the edoc package matching an edoc package field on the transaction (sourced from customer), the transaction type and the subsidiary.

Check that the edoc template is exposed to the same subsidiary & transaction as your image.

@User_64PY4 you can do a CSV import for Vendor Payment that allows you to allocate the journal balance to the vendor bill.

could you update your item record to use a defined cost estimate that’s the same as your standard cost revision? Then use the Est Unit Cost field?

@ESmith2014 @Gavrah Rabba the only suggestion I can make is to try a saved search with an email schedule. The search isn’t available through the menu however, if you add a list portlet to your home page, and choose Bank Statement Import. Once it loads, hover over the 3 dots on the top right of the portlet and select…

@emcee_uk the answer that @Shiela Marie Villaluz-Oracle has given will cover your first request. The replacing invoice will likely need to be achieved with a customisation. I’d suggest adding a field on the new invoice that points to the original invoice. Add a filter to only show invoices, if possible only for the…

@User_IJB6M theres a few options, but what is the tax nexus that you’re accounting for? As the options may change depending on this. Without the tax knowledge, you could, set the quantity of line 1 to be the same as the quantity on the PO, but have the amount be different (16000) as you have in your example. It’s the…

Ah ok! In this case it will only be determined by the data that was imported. Click on Metodo Depreciacion Test. This record will have the opening values which must have been calculated manually. The open balance of assets isn’t directly tied to the ledger. It’s just a starting point for NetSuite to calculate depreciation.…

@emcee_uk ive seen this before with legacy tax in netsuite for a lot of EU transactions. Can you confirm your tax nexus? NetSuite has both accounting and tax periods that need to be closed off. This means that if you’ve back dated transactions you can account for them in a new accounting and tax period but age them based…

check the source transaction. It will have a GL impact on both books and if there’s a currency exchange it will be defined there. In your secondary book it will need to convert Peso to USD as the base value on that date.

@dle_35705 roles that are assigned the Center Type of, Customer Center Employee Center Vendor Center Partner Center Are all restricted roles, meaning the permissions you can give are limited. You can still assign global permissions if you’ve that feature enabled. I checked the employee center and couldn’t see the…

Hi @Narayan Sharma , yes at any point the accounting team can approve an expense report without a supervisor approval - assuming you're not using a workflow for the approval process. Standard functionality will route to the supervisor, or the named expense approver subject to the approval limits, before it goes for…

the employee centre is a special role type in NetSuite, that whilst you can customise it, it’s heavily restricted. This role type is for self service of employee data - time, expenses, leave etc, depending on the modules you have on your account. It can therefore not access the customer record.

Your accounting team can approve them at the same time, but the accounting approval will supersede the supervisor approval - ie post to the ledger.

Hello, no - invoices are to the child customer level, but the consolidated payment feature will allow the invoice to be paid by the parent customer.

assuming you’ve created the bill from the PO, line 1 on your bill will be linked to the PO line, and will show as 0.8 of 1 being billed. The second line on your bill, if added manually isn’t linked to the PO document, so doesn’t count towards the fully billed. im not sure what region you’re in and the applicable tax…

Edited - please scroll down further on the list you’ve posted an image of. Customer/project fields is one of the joins to the bottom of the list. Failing this - if that isn’t there, check if Customer has been renamed.

@User_7ANL6 - You can modify the fulfilment only to account for the stock not received in Location B. This needs to be done anyway to account for the inventory in transit. You don't need to modify the quantity on the T/O, but once the total fulfilled = total received, if less than the quantity on the T/O, you can close the…

I tried this with the use of a sales order as the source document for the revenue arrangement. Unfortunately I couldn’t get the sales rep breakdown on the revenue report. I will check again.

Hi @User_44UPO is this for reporting? The country of origin would be derived from the purchase transactions when you've sourced the item - for example, international tax reports for reporting the movement of goods uses the vendor bill to determine the country of origin.

can you share the body of the xml soap request made into Netsuite that creates the record?

It’s possible to modify the Revenue by Customer report and use the Transaction Dimension - Primary Sales Rep - Name (Groupped). Then move this to the left of your report columns. I didn’t see a way to get info about sales team members.

You’ll likely need to modify the PDF layout by adding a custom element and referencing the body field you want to display. Note that customisation is quite limited with PDF layouts. There’s a greater level of flexibility with the Advanced PDFs, however they’re not as simple to configure.

Personally I’d split this into separate work orders to plan each as required. Do you know the batch size that need to be built in advance for your customer? If so it could be cleaner to have these as separate lines on a sales order to create demand, and plan work orders to meet each draw down with their own dates for…

check the time and expenses tab of the accounting preferences page. there are two checkboxes, one to default expenses as billable and one to default items as billable. You’ll want to disable either of these, depending on the sublist in your screenshot.

To add to Jam's comment above, the only place that the EXW/DAP impacts the GL is on fulfil/receive of transfer orders. Otherwise, you need to complete the transfer of ownership to generate the GiT posting.

D

it’s still there and should be available with the advanced inventory module I believe.