Best Of

Hi @LLG,

Thank you for sending the screenshots. 😊

Upon checking, the Location (internal ID: 2) is not associated with Subsidiaries (internal ID: 2 and 6). It is the Subsidiaries that are associated with the Location's Subsidiary which is not the same.

The Location (internal ID: 2) is only available for the Subsidiary selected in the Subsidiary field.

According to Subsidiary Field Help, if you have purchased the OneWorld upgrade for your NetSuite account, you can associate this location with one or more subsidiaries.

• If the Inventory feature is not enabled, a location can be associated with none, one, some, or all subsidiaries. To select multiple subsidiaries, press and hold the Ctrl key while selecting each subsidiary.
• If the Inventory feature is enabled, a location can be associated with only one subsidiary.

It seems that the Inventory feature is enabled on your end and only one subsidiary is available for the Location (internal ID: 2).

To be able to invoice the Sales Orders without the error, either you change the subsidiary of the Sales Orders based on Location (internal ID: 2) or change the Location of the Sales Orders applicable to Subsidiaries (internal ID: 2 and 6).

I hope this clarifies your concern! 😊

=======================

If you find this reply to your question as helpful, others with the same question might find it helpful as well. By marking “Yes” on the “Did this answer your question?”, you’ll be able to aid the community to find the solution much easier and faster without the need to read through all the replies, and you will also get closer to earning your next Answer Accepter badge.

Could you clarify if you only tried clicking Edit then Save without updating any fields? I have tested the above code and I do not encounter the same error. Also, are there any other scripts/workflow running while this script is enabled?

-Mikko

Hi @JohanvL , you may want to check the addList operation where you can add multiple records in one call or upsertList where you can add or update multiple records in one call as well.

For the second one, what operation are you using? Please take note that response from an add operation could not be modified.

-Mikko

Please note the following as well. Please check the Help page for Records Supporting LRCFM by Localization Assistant SuiteApp and note the other record types that can be affected. I found that Cash Sale definitely needed to be adjusted in the same manner in order to issue the Mexico Factura Electronica

Installed the newest CFDI 4.0 Mexico localization package this morning and most of the CFDI fields (Mexico tax authority required fields) went missing on sales forms. I could not find it but kudos to Support for finding a conflict with the NS Localization Assistant which is supposed to be used with Mexico.

The response from Support is as follows - Given that I doubt I would have found this on my own, and these are critical fields for Mexico, I'm sharing the fix here.

After investigating in our QA environment this is what I notice:

• Account [deleted] has Mexico Localization bundle version 2.09.0 upgraded 9/6/2022 11:03 am.
• Navigate to Invoice Record > CFDI Information tab > no information.
• Navigate to Customization > Scripting > Scripted Records > Edit Invoice
  • Undeployed following scripts under User Event Script:
    • LRC Field Manager User Event | Owner: Barbara J Brant
  • Save.
• Navigate to Invoice Record > CFDI Information tab > information is displayed.

Disabling this script in Customization > Scripting > Scripted Records the issue does not reproduce. For this reason, it is suggested that you refer to the creators of these scripts in order to review this behavior.

We use subprojects as well in our company and issue invoices for the subprojects. Here's how we manage it successfully in the UI:

On the Customer ('entity') field, we set the main customer record. (In CSV, it's the internal ID of the main customer.

On the Project, ('job') field, we set the subproject. (In CSV, it's the internal id of the subproject).

If this didn't work, you can try sending screenshots of how the customer and subproject is linked, and the CSV template you're using.

Hi @Kristoffer Viray-Oracle thank you for your reply,

in the end i figured it out what i had to do to achieve my required result. I had to create Custom column item and source the information from Custom item field

then, add that custom column item field on to sales order line items and it would appear as a condition in the workflow option

i have tested and the imported sales order transaction has location changed via workflow

sweet.

have a good one and thank you for yor help and time.

Tadas

Yes, if you use an item type of "Kit/Package" you can sell the set but fulfill using the individual inventory items