Best Of

Hello @User_MC441.

Pls check the below reasons why the New link is not appear

1. Intercompany netting supports only matched and linked intercompany transactions with the same amounts on the payable and receivable sides of the general ledger.
2. Intercompany Journal Entries – There must be only one AP and AR line for each subsidiary-subsidiary-currency to ensure that the lines are nettable.
3. Intercompany Invoice and Intercompany Bill – These transactions are linked through their related purchase order and sales order (arm’s length process inventory transfers). However, these transactions must be matched by having only one invoice and one bill for the same amount, and both must have intercompany entities.
4. Multiple invoices linked to one bill, and multiple bills linked to one invoice appear on the Main subtab but are not nettable. These transactions appear only when the Nettable box is clear. These transactions do not have a related transaction in the Pair column.

Hi @Patrick Fresnosa-Oracle,

I am trying to get the Retained Earnings for the previous month Apr 2022 and it is per Subsidiary.

Below are the details :

Prior Fiscal Year - 6/1/2020 to 05/31/2021

Current Fiscal Year - 6/1/2021 to 05/31/2022

I am trying to reconcile the values first so I will have an idea of how to build the saved search.

Using Answer Id: 89156 -- Retained Earnings Computation as guide, I got the below:

Expected Result : Trial Balance value for Retained Earnings as of previous month for Subsidiary= X,

Apr 2022 =  -12,136,130.39

or start of current fiscal year

Jun 2021 =  -12,136,130.39

Solution :

1. Get the Trial Balance for the end of prior fiscal Year (Subsidiary = X).

Per TB May 2021 =  -8,370,863.85

2. Check if there is a manual journal entry posted on Retained Earnings account for the whole fiscal year.

Transaction Search with the below Criteria:

Posting = T

Period = This Fiscal Year

Account...Type = Equity

Account = Retained Earnings Account showing in Trial Balance

Results

Setting - Consolidated Exchange Rate = None

Actual Result : -5,593,824.54

3. Check the Net Income for the prior fiscal year.

Run Standard Income Statement Report

Period = Custom, From Jun 2020 To May 2021

Subsidiary = X

Net Profit/Loss 3,765,266.54

Calculation :

Per TB May 2021              = -8,370,863.85

Manual JEs          = -5,593,824.54

Net Profit/Loss From Jun 2020 To May 2021 = 3,765,266.54

I just realized the current fiscal year's retained earnings seems to be just the TB May 2021 and Net Profit/Loss From Jun 2020 To May 2021

-8,370,863.85 + - 3,765,266.54 = -12,136,130.39

Will try to check if the same is true for other subsidiaries

Hello @User_75YL8,

Thank you for posting a new thread!

Please allow some time for the members/gurus to check on your concern and get back with more information.

To our members, please feel free to share your thoughts on the thread.

Thank you!

Hello @OliverK,

I have tried the code on my test account and it works on my end. We need customize the Sales Order form and show the Committed field under Sublist fields. Kindly check the steps below:

1. Open the Sales Order
2. Navigate to Customize > Customize Form
3. Click Sublist Fields
4. Mark the checkbox beside Committed
5. Click Save

Please let me know if this solved the issue.

Hello @Hormese Paul ,

Unfortunately, it seems to be a limitation of our system. Please, find below the Enhancement request created for this functionality:

# 76554 Sales Order > Items tab > Line Items > Set Billing Schedule Start Date and End Date.

Currently the Billing Schedule Start Date cannot be set per line level, the only possibility is to create separate Billing Schedule for each line or use Recurrence Frequency.

You may vote for this enhancement through SuiteIdeas to increase its points and have it possibly included on NetSuite's future releases.

Thank you for your understanding.

“Kindly click "Yes" on "Did this answer the question?" if you find the reply on your thread helpful. This will aid the others with the same question to easily find the correct answer. Thank you!

Hello @User_75YL8,

Good day! ?

Upon checking, there's no standard way to hide certain fields on the Lead form depending on the Type selected. However, I was able to create a Workflow that gave me the desired result. You can check this on your end as well.

Note: The Workflow below will hide the Sales Rep field on the Lead form when the Type is set to Individual. You can change the field as necessary.

1. Navigate to Customization > Workflow > Workflows > New
2. Set the following fields on the Basic Information:
   1. Name = set the name of the Workflow as preferred
   2. Record Type = Customer
   3. Sub Types = Lead
   4. Execute As Admin = checked
3. Set Initiation = Event Based
4. Under Event Definition, set the following :
   1. On Create = checked
   2. On View or Update = checked
   3. Note: Check the 'On View or Update' box if you would like to run the Workflow on existing records
   4. Trigger Type = ALL
5. Click Save
6. Click on the State 1 box
7. At the right-side of the page, click on the New Action link
8. Select Set Field Display Type
   1. Note: This action would set the Sales Rep field to hidden when Individual is selected.
9. Set the following fields:
   1. Trigger On = After Field Edit
   2. Triggering Client Fields = Is Person
10. Set Condition as below:
    1. Field = Is Person
    2. Compare Type = checked
11. Under the Parameters section:
    1. Select Sales Rep on the Field drop-down
    2. Display Type = Hidden
12. Click Save

I hope this helps and will work on your end. It would be best to reach out to your in-house developers to further discuss if you have other business requirements.

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.

Hi @Patrick Fresnosa-Oracle , Thank you for your great details

Hello@User_XQ321

Additional Point for Allow transactions outside of the posting period having Override period restrictions:

Make sure that you should enable the Accounting preferences under General for " Allow Transaction date outside of posting period. There are three options Disallow, Warn and Allow.

If you select Disallow: users are not allowed to save a transaction unless the transaction date is within the date range for the posting period selected.

Warn: Users are warned when a transaction date is not within the date range for the posting period selected, but they can click Ok on the warning and save it anyway

Allow: Users can enter a transaction even if the date is not within the date range for the posting period selected. No warning is given to the user before the transaction is saved.

The above scenario is for normal transactions. For the FAM scenario if you enable the below checkboxes under the FAM setup. Automatically system will post the transactions to the next open period even though you have override period restriction permission.

A date will be the previous month-end date and the posting period is the current period

Hi @Amjad Kasem,

Thanks for creating another post here in our community! ?

I checked on your concern and it seems that there is no standard/native NS transaction that caters specifically for this one.

The closest I can think of is the use of Drop Shipment or Special Orders. However, I think that these will still require you to create Bills and Invoices, but you have the option to Close the orders

Another one I can suggest is to use Inventory Adjustments to add and remove the items from your warehouse. Note that this will have impact in your inventory.

Another option would be to create Custom Records in order to track these transactions.

As for the service charge, we do have Service Items and Other Charge Items which you can use in Bills or Invoices.

Since this is a specialized process, I think that you would need to also create your own internal process or workflows for handling these transactions. I linked the SuiteAnswers articles so you can review related information.

Hope this information helps.

To other members, feel free to comment your insights and suggestions about this process as well.

Hello @CharleneJ

Currently, Users only have the capability to edit the name of the report. To modify the subsidiary context and edit the details in the title is still a system limitation. It is logged as Enhancement #133607.

Hi Patrick:

Just voted for the idea. There are only 86 votes on it, so it doesn't look like a priority issue.

As for changing the currency, I think it should be possible if literally nothing else is done in the system afterwards. I am saying this because I found an suite answer that says if there are no transactions, you should be able to change the currency.

The problem was that I created a few more entities. Though these are not transactions, of course, they may have interfered with the process, I believe.

But, luckily, deleting worked.

Thanks!